Salesforce Bulk Update Issue

Anonymous — Sat, 16 Nov 2024 11:59:33 GMT

Hi,
We have been using Talend Integration Suite as one of our batch integration tool for the past couple of months and for the most part, it is very good and efficient. However, we have couple of jobs that updates the salesforce objects that fails almost every day with the below error message.
==========================================================================
Exception in component tSalesforceBulkExec_2
java.lang.IllegalArgumentException: input stream can not be null
at com.sforce.ws.parser.MXParser.setInput(MXParser.java:528)
at com.sforce.ws.parser.XmlInputStream.setInput(XmlInputStream.java:64)
at com.sforce.async.BulkConnection.parseAndThrowException(BulkConnection.java:107)
at com.sforce.async.BulkConnection.doHttpGet(BulkConnection.java:472)
at com.sforce.async.BulkConnection.getBatchInfoList(BulkConnection.java:309)
at org.talend.salesforceBulk.SalesforceBulkAPI.awaitCompletion(SalesforceBulkAPI.java:302)
at org.talend.salesforceBulk.SalesforceBulkAPI.executeBulk(SalesforceBulkAPI.java:113)
at omsleoprd.leo_batch_order_fulfillment_response_process_0_1.LEO_BATCH_ORDER_FULFILLMENT_RESPONSE_PROCESS.tSalesforceBulkExec_2Process(LEO_BATCH_ORDER_FULFILLMENT_RESPONSE_PROCESS.java:7739)
at omsleoprd.leo_batch_order_fulfillment_response_process_0_1.LEO_BATCH_ORDER_FULFILLMENT_RESPONSE_PROCESS.tSalesforceInput_1Process(LEO_BATCH_ORDER_FULFILLMENT_RESPONSE_PROCESS.java:5536)
at omsleoprd.leo_batch_order_fulfillment_response_process_0_1.LEO_BATCH_ORDER_FULFILLMENT_RESPONSE_PROCESS.tFileExist_1Process(LEO_BATCH_ORDER_FULFILLMENT_RESPONSE_PROCESS.java:18119)
at omsleoprd.leo_batch_order_fulfillment_response_process_0_1.LEO_BATCH_ORDER_FULFILLMENT_RESPONSE_PROCESS.tSalesforceInput_2Process(LEO_BATCH_ORDER_FULFILLMENT_RESPONSE_PROCESS.java:19588)
at omsleoprd.leo_batch_order_fulfillment_response_process_0_1.LEO_BATCH_ORDER_FULFILLMENT_RESPONSE_PROCESS.runJobInTOS(LEO_BATCH_ORDER_FULFILLMENT_RESPONSE_PROCESS.java:20738)
at omsleoprd.leo_batch_order_fulfillment_response_process_0_1.LEO_BATCH_ORDER_FULFILLMENT_RESPONSE_PROCESS.main(LEO_BATCH_ORDER_FULFILLMENT_RESPONSE_PROCESS.java:20427)
Exception in component tJava_2
java.lang.NullPointerException
at omsleoprd.leo_batch_order_fulfillment_response_process_0_1.LEO_BATCH_ORDER_FULFILLMENT_RESPONSE_PROCESS.tJava_2Process(LEO_BATCH_ORDER_FULFILLMENT_RESPONSE_PROCESS.java:20283)
at omsleoprd.leo_batch_order_fulfillment_response_process_0_1.LEO_BATCH_ORDER_FULFILLMENT_RESPONSE_PROCESS.tFileArchive_2Process(LEO_BATCH_ORDER_FULFILLMENT_RESPONSE_PROCESS.java:20224)
at omsleoprd.leo_batch_order_fulfillment_response_process_0_1.LEO_BATCH_ORDER_FULFILLMENT_RESPONSE_PROCESS.tFileArchive_1Process(LEO_BATCH_ORDER_FULFILLMENT_RESPONSE_PROCESS.java:20050)
at omsleoprd.leo_batch_order_fulfillment_response_process_0_1.LEO_BATCH_ORDER_FULFILLMENT_RESPONSE_PROCESS.tPostjob_1Process(LEO_BATCH_ORDER_FULFILLMENT_RESPONSE_PROCESS.java:19865)
at omsleoprd.leo_batch_order_fulfillment_response_process_0_1.LEO_BATCH_ORDER_FULFILLMENT_RESPONSE_PROCESS.runJobInTOS(LEO_BATCH_ORDER_FULFILLMENT_RESPONSE_PROCESS.java:20751)
at omsleoprd.leo_batch_order_fulfillment_response_process_0_1.LEO_BATCH_ORDER_FULFILLMENT_RESPONSE_PROCESS.main(LEO_BATCH_ORDER_FULFILLMENT_RESPONSE_PROCESS.java:20427)
==========================================================================
We could see that the bulk update job is submitted to salesforce and when salesforce is performing the updates, the talend job fails with the above error message. When there are 3 bulk updates that need to be performed in the job and when we receive the above error message with the first update, the talend job aborts and we have to manually process the remaining bulk update or re-run part of the talend job to re-create new bulk update files for salesforce.
Can some one help?
Thanks,
Balaji.

Re: Salesforce Bulk Update Issue

Anonymous — Tue, 18 Jun 2013 03:11:55 GMT

Hi,
Is there any error log which is located in <Talend Studio installation path>/workspace/.metadata/.log . Could you please upload your workflow screenshot into forum so that we can address your issue quickly.
Best regards
Sabrina

Re: Salesforce Bulk Update Issue

Anonymous — Wed, 19 Jun 2013 17:05:20 GMT

Hi,
Thanks for your response. Talend is not installed in our production server. We do development under a SVN project and deploy the job using talend jobserver. The jobs are getting deployed into the production server under the directory /talend/jobserver/TalendJobServersFiles/repository folder. So, I don't have a .metadata/.log file anywhere in our production server.
Thanks,
Balaji.

topic Salesforce Bulk Update Issue in Talend Studio

Salesforce Bulk Update Issue

Re: Salesforce Bulk Update Issue

Re: Salesforce Bulk Update Issue