Page 1 of 1

Querying bulk load status(Salesforce Connector) in Datastage

Posted: Mon May 06, 2019 7:13 am
by nikita.bandekar
I have a question regarding Querying bulk load status (Salesforce Connector) in IBM Infosphere Datatstage. The query job is returning me duplicate records of my Salesoforce job. Basically returning records x4 times as there are total 4 batches in my job. I have 13 records (4 batches) processed in my job in salesforce, but the query job is returning me 52 records (13*4).

I have used example3 query job from the BulkLoadStatusCheckingExample.dsx project file.

Is there any settings that i need to change in my sandbox or in Datastage?

I would expect 13 records in total, instead I am getting 52 records.

Posted: Mon May 06, 2019 10:28 am
by nikita.bandekar
I checked with a different Job id. Again the records are x4 times.
I noticed in SalesForce that there multiple logins when i executed the job.
I believe its logging in multiple times, getting the job id and returning me the records.

Posted: Mon May 06, 2019 11:20 am
by chulett
Partitioning, I would assume... you are running the job on four nodes, yes?

Posted: Tue May 07, 2019 7:52 am
by nikita.bandekar
Hey Craig,

Yes you were right!! It was running on 4 nodes. Changed it to 1 and its working fine now.
Thank you so much :D