Troubleshooting
Problem
Using Burst mode with the IBM Transformation Extender (ITX) MongoDB Adapter and delete/insert in the same map does not work as expected
Symptom
Using Burst mode with the ITX MongoDB Adapter and delete/insert in the same map does not work as expected.
The records from the last burst are inserted only.
Cause
When using burst all the output cards get executed per burst.
For Example :
If you are processing 6 records and burst is to 4 then 4 records will be read, 4 deleted and 4 inserted.
For the next burst, 2 records will be read then all the records will be deleted and 2 records inserted.
Environment
Using the ITX MongoDB with Burst mode.
The first output card is configured to delete records from the MongoDB Database.
The second output card is configured to insert records into the MongoDB Database.
The issue would happen when using other ITX database adapters too.
Diagnosing The Problem
If there are 6 records and burst is set to 4 there are only 2 records inserted into the MongoDB Database.
Resolving The Problem
Perform the delete from the MongoDB Database in a different map when using burst.
Was this topic helpful?
Document Information
Modified date:
28 September 2018
UID
ibm10730035