Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Writing to Salesforce

Hi. I'm new using Talend so I'm still playing around with a few aspects and I'm having some problems. I'm trying to write to Salesforce, either from a csv file or from one Salesforce instance to another. I successfully connected to both instances and created the map, but when I run it, I get the following error: (I'm just trying to copy a few accounts from one instance to the other. Nothing fancy)
Starting job SFtoSF at 11:02 17/08/2010.
connecting to socket on port 3375
connected
Exception in component tSalesforceOutputBulkExec_1_tSBE

at com.sforce.async.RestConnection.parseAndThrowException(RestConnection.java:109)
at com.sforce.async.RestConnection.doHttpGet(RestConnection.java:279)
at com.sforce.async.RestConnection.getBatchResultStream(RestConnection.java:247)
at org.talend.salesforceBulk.SalesforceBulkAPI.getBatchLog(SalesforceBulkAPI.java:291)
at testsftosf.sftosf_0_1.SFtoSF.tSalesforceInput_1Process(SFtoSF.java:2552)
at testsftosf.sftosf_0_1.SFtoSF.runJobInTOS(SFtoSF.java:2778)
at testsftosf.sftosf_0_1.SFtoSF.main(SFtoSF.java:2652)
disconnected
Job SFtoSF ended at 11:02 17/08/2010.
Now I'm using the tSalesforceOutputBulkExec as the component that connects to the instance being written to. Is this correct? I've been able to write from SF to a file, but am having trouble writing back to Salesforce. If anyone could tell me or point me to a good tutorial, I'd really appreciate it.
Thank you in advance!
Labels (5)
4 Replies
Anonymous
Not applicable
Author

Hi
Which version of TOS do you use?
Best regards
Shong
Anonymous
Not applicable
Author

Hi.
I'm using TOS 4.1.0.M3_r46036. Any help would be greatly appreciated?
Thanks!
Anonymous
Not applicable
Author

I've just had the same message and corrected the error. It was simply that I had the wrong field name in the schema, so salesforce couldn't load the data.
I had a field called "AccountName" that should have just been "Name". I changed the field name and it ran fine.
Hope this helps
Rick
Anonymous
Not applicable
Author

Hi
Which version of TOS do you use?
Best regards
Shong

I'm using 4.1.1r50363