Error Salesforce - OwnerId

Mr_Pancake — Fri, 15 Nov 2024 21:55:21 GMT

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.

Re: Error Salesforce - OwnerId

Anonymous — Fri, 07 Apr 2023 01:20:23 GMT

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

Re: Error Salesforce - OwnerId

Mr_Pancake — Fri, 07 Apr 2023 06:43:51 GMT

Perfect! Thank you very much!

topic Re: Error Salesforce - OwnerId in Talend Studio

Error Salesforce - OwnerId

Re: Error Salesforce - OwnerId

Re: Error Salesforce - OwnerId