Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
jdope
Contributor III
Contributor III

tFlowMeter not reporting correct results

I would like to use tflowMeter in some subjobs to log the outcome of some events, however it does not appear to be working.  In the example below I am inserting 2 records into salesforce.  I have a tFlowMeter on both the "Rejected" and "Main" flows out of the tSalesforceOutput.  In the example below you can see that both reject and main report 0, but 2 records are inserted into salesforce.  I have other examples with larger datasets where the number reported in the tFlowMeter is not accurate.  I assume this is a bug...

0683p000009MFwb.png

Records are created in salesforce:
0683p000009MFuS.png

Labels (2)
3 Replies
jdope
Contributor III
Contributor III
Author

Looks like the images didn't upload for the original post:
jdope
Contributor III
Contributor III
Author

I did some more testing on this and this seems related to the "Commit Level" setting on the tSalesforceOutput component...
Same job run multiple times with the "Commit Level" modified:
<!--tSalesforceOutput Advanced Settings > Commit Level: 200-->
2016-11-02 10:17:55;bND2Oq;bND2Oq;bND2Oq;2968;MOE;HandlePlans;_sgaNUKD-EeaFyvKFkReFAw;0.1;Default;tFlowMeter_17;PlanRTypes_To_Update;37;;
2016-11-02 10:17:56;bND2Oq;bND2Oq;bND2Oq;2968;MOE;HandlePlans;_sgaNUKD-EeaFyvKFkReFAw;0.1;Default;tFlowMeter_19;UpdatePlanRtypes_Success;0;; ----> this reports 0, however all 37 were successful.
2016-11-02 10:17:56;bND2Oq;bND2Oq;bND2Oq;2968;MOE;HandlePlans;_sgaNUKD-EeaFyvKFkReFAw;0.1;Default;tFlowMeter_18;UpdatePlanRtypes_Rejected;0;;

<!--tSalesforceOutput Advanced Settings > Commit Level: 5-->
2016-11-02 10:15:31;kEVER4;kEVER4;kEVER4;9660;MOE;HandlePlans;_sgaNUKD-EeaFyvKFkReFAw;0.1;Default;tFlowMeter_17;PlanRTypes_To_Update;37;;
2016-11-02 10:15:31;kEVER4;kEVER4;kEVER4;9660;MOE;HandlePlans;_sgaNUKD-EeaFyvKFkReFAw;0.1;Default;tFlowMeter_19;UpdatePlanRtypes_Success;33;; ----> this reports 33, however all 37 were successful.
2016-11-02 10:15:31;kEVER4;kEVER4;kEVER4;9660;MOE;HandlePlans;_sgaNUKD-EeaFyvKFkReFAw;0.1;Default;tFlowMeter_18;UpdatePlanRtypes_Rejected;0;;
jdope
Contributor III
Contributor III
Author

images:
0683p000009MFuz.png 0683p000009MFwu.png