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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

TSalesforceOutput "Reject" not working

Hope someone can help me!
I have added a screenshot below of the job I have set up. The file has 88 rows in it (as this is test data but will be uploading much more than that when it comes to live data).
If I set up the batch size to 1, it captures all the errors and puts them into the "Redbox_exception__c" table, but if I have the batch size set to 200, then it just ignores the error and says all was inserted corrected (even though I only have 87 records in the Account table).
0683p000009MDM6.png

These are my settings, which do not save the error in the system, but if I change commit level to 1, it does save it.
0683p000009MDHg.png
Surely for me to capture the rejected rows I shouldnt have to be inserting 1 at a time!
Thank you!
Labels (2)
2 Replies
TRF
Champion II
Champion II

What if you uncheck Extend Insert?
Anonymous
Not applicable
Author

What if you uncheck Extend Insert?

TRF
If I do that, it removes the ability to set the batch size and just inserts 1 at a time.