I am running a job where it upserts data in one object using tSalesforceOutputbulkExec component but every time job is getting fail with the below error while running in prod server but while running in dev server with same credentials it runs fine, can someone suggest on it.
AsyncApiException exceptionCode='ClientInputError' exceptionMessage='Failed to create batch'
Usually this error occurs when you try to access an field that doesn't existe or for which you don't have visibllity on. To know the field name, connect to salesforce, go to Setup > Jobs > Bulk Data Load Jobs then move the mouse pointer on the right side of the job list over the message 'Failed to create batch'. This will display the complete message with the field on error.
Thanks but nothing is coming as failed in Bulk Load jobs screen, That particular object coming in In progress and in the job Id, it's showing Status as Open, Completed batches 1729, Records processed 345,800, failed batches zero. Could you please suggest on it.
Difficult to say without hands on the environment. If I understand your last message, a part of the operation works fine (1729 completed batchs) before it fails. Right? If so, maybe the file associated to thé tSalesforceOutputBulkExec is corrupted. You should check that.
Thanks, but it seems like it's server's configuration error. As Idescribed earlier that it's running fine in dev server and creating issue in prod server. I will update on this.
