Error Salesforce - OwnerId

[Mr_Pancake]

Hello,

I'm trying to load some data using Talend Open Studio to Salesforce and when trying to upload contacts I see error:

failed to release the resource in tSalesforceOutput_1 :Owner ID: owner cannot be blank

Exception in component tSalesforceOutput_1 (dev)

java.io.IOException: Owner ID: owner cannot be blank

at org.talend.components.salesforce.runtime.SalesforceWriter.handleReject(SalesforceWriter.java:536)

at org.talend.components.salesforce.runtime.SalesforceWriter.doUpsert(SalesforceWriter.java:454)

at org.talend.components.salesforce.runtime.SalesforceWriter.upsert(SalesforceWriter.java:418)

at org.talend.components.salesforce.runtime.SalesforceWriter.write(SalesforceWriter.java:191)

at volksbunddev.dev_0_1.dev.tFileInputDelimited_1Process(dev.java:11408)

at volksbunddev.dev_0_1.dev.runJobInTOS(dev.java:11875)

at volksbunddev.dev_0_1.dev.main(dev.java:11713)

I believe Owner for Contact should be the user which has created given contact. How can I provide a proper user id or generate some mapping to make it possible to transfer this data?

I'm just learning Talend integration with Salesforce so I will be very grateful for any hint.

[Anonymous · Accepted solution]

Hello,

Regarding to the error log, the problem is that the OwnerId field is empty while inserting to Contact in tSalesforceOutput.

You can get the OwnerId value from the User by the query like Select Id from User in tSalesforceInput

then pass it to the OwnerId field of Contact in tSalesforceOutput component.

Best regards

Aiming

[Mr_Pancake]

Perfect! Thank you very much!