Hey all,
Long time reader and first time poster to these boards! I looked around quite extensively and did not see anyone having the exact problem that I am (though, I'm happy to be wrong).
Basically, I'm testing data loads to a new SFDC deployment that we are migrating too... as part of that, I was testing inserts (works without issue) and then deleting the data that I've entered as part of the many iterations it will likely take to complete this process (insert, have users validate, blow the data away, try again).
On the delete, I'm getting these errors -
Error: Salesforce Output (1): Tool #94: Error trying to add batch(es) to the job. HTTP/1.1 400 Bad Request ... Data from server: <?xml version="1.0" encoding="UTF-8"?><error xmlns="http://www.force.com/2009/06/asyncapi/dataload">
<exceptionCode>InvalidJob</exceptionCode> <exceptionMessage>Failed to parse job</exceptionMessage> </error>
Error: Salesforce Output (1): Tool #95: Error trying to close the job. HTTP/1.1 400 Bad Request ... Data from server: <?xml version="1.0" encoding="UTF-8"?> <error xmlns="http://www.force.com/2009/06/asyncapi/dataload"> <exceptionCode>InvalidJob</exceptionCode> <exceptionMessage>State cannot be specified </exceptionMessage> </error>
Error: Salesforce Output (1): Tool #90: Iteration #114: Tool #20: iterate error HTTP/1.1 400 Bad Request ... Data from server: <?xml version="1.0" encoding="UTF-8"?><error xmlns="http://www.force.com/2009/06/asyncapi/dataload"> <exceptionCode>InvalidJob</exceptionCode> <exceptionMessage>Invalid job id: batch</exceptionMessage> </error>
This you should know -
I'm pulling the entire object down into our Datawarehouse (Sql-Server), doing a data input from that exact table and only selecting only the ID column to pass back to the data output which has delete selected as the action to perform. The error above is raised if I attempt to delete one record or many, it makes no difference on the amount.
Also -
I'm able to run this functionality in other SFDC environments that we have however, this new one we are connecting is "Lightening" and I'm wondering if there is some setting I need to enable or change to allow for this type of action to be performed.
Alteryx Version - 2018.4.5.55178
