Salesforce Bulk Update Issue

One Star

Salesforce Bulk Update Issue

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.
Moderator

Re: Salesforce Bulk Update Issue

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
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
One Star

Re: Salesforce Bulk Update Issue

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.