function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
RonVRonV 

Trap Errors in Batch Apex Data Loader

Each nght, we run a DOS batch process which uses the Batch Apex Data Loader to query an iSeries database and upload the data to Salesforce. This is a multi-step process, with each step dependent on the previous steps completing correctly. Most times this rus fine. However, recently the process failed when the connection timed out. The job continued, but the data loaded was incomplete, so I had to rerun the process manually the next day.

My question is: Is there some way of detecting the error in the .bat file so that we can stop at the point where the error occurs, rather than proceeding with the rest of the process. SOmething along the lines of using ERRORLEVEL in the bat file. It doesn't have to be sophisticated, I just want to stop processing.

Thanks

Ron Ventura
Richard Jimenez 9Richard Jimenez 9
Hi Ron,

I've not played with this, but here are some things to try:

Can you checked the error log csv for records?
Can you pipe the messages outputted from the process.bat to a file and check that for errors?

See:  https://help.salesforce.com/apex/HTViewHelpDoc?id=command_line_import_data.htm&language=en_US

Thanks,
Richard
Mahesh DMahesh D
Hi Ron,

Please check the below posts on the same topic:

https://developer.salesforce.com/forums/?id=906F00000008kveIAA

http://www.jitendrazaa.com/blog/salesforce/tutorial-of-command-line-dataloader-salesforce/

Please do let me know if it helps you.

Regards,
Mahesh