1

We have a DOS Batch job which runs a multi-step process to:

  1. Delete all records from salesforce for a specific object (download IDs and then delete them using Data Loader)
  2. Deletes all records from a database table which mirrors the Salesforce data.
  3. Extracts data from a database and uploads the data to the Salesforce objects using Data Loader.
  4. Downloads the Salesforce data into the database table.

Recently, the first step has been failing with a QUERY-TIMEOUT error. If I rerun the process, it generally works OK without any other changes. This is being investigated, but is not my question.

My question is: How can I detect when step 1 (which uses Data Loader) in the batch file fails? If this fails, I do not want to proceed with the rest of the process, as this deletes the database data which is used elsewhere for reporting.

Does the Apex Loader set an ERRORLEVEL if it fails? How else can I determine that there was a failure?

Thanks.

Ron Ventura

Ron Ventura
  • 21
  • 4

1 Answers1

0

Please to view more detail refer to the link below. Basically is to check for the log file that the data loader generates when there was an error, so if no errors where found the log files are empty, If the pass is 100% successful, the error log will have a header line and no rows.

https://www.nimbleuser.com/blog/failing-safe-with-the-apex-data-loader-for-salesforce-crm

And also you can refer to this answer. https://salesforce.stackexchange.com/questions/14466/availability-of-apex-data-loader-error-file-from-local-pc-to-salesforce

Regards.

Fischer Jemison
  • 3
  • 2
user021205
  • 74
  • 1
  • 7