topic Re: Error when Inserting data to Salesforce using Talend Open Studio Version: 7.1.1 in Talend Studio

Error when Inserting data to Salesforce using Talend Open Studio Version: 7.1.1

Anonymous — Sat, 16 Nov 2024 06:48:44 GMT

Hi All,

We are trying to upload SQL table’s data rows which is in MSSQL database to salesforce object and I have done the mappings correctly. Previously I have extracted(retrive) the bulk data to SQL from Salesforce using tSalesForce Input ellement in Talend Open Studio. But I'm getting below error when insert data to Salesforce using SalesForce Output element in Talend Open Studio. I have tested this same process with third party repository(kingswaysoft-SISS Integration Toolkit for Salesforce) in Microsoft SSIS and inserted data are reflected in salesforce correctly.

Please find the below error which generated by Talend Open Studio.

[statistics] connecting to socket on port 3520

[statistics] connected

Exception in component tSalesforceOutput_2 (AdvancedPOC)

java.io.IOException: Unable to create/update fields: IsDeleted. Please check the security settings of this field and verify that it is read/write for your profile or permission set.

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

at org.talend.components.salesforce.runtime.SalesforceWriter.doInsert(SalesforceWriter.java:353)

at org.talend.components.salesforce.runtime.SalesforceWriter.logout(SalesforceWriter.java:675)

at org.talend.components.salesforce.runtime.SalesforceWriter.close(SalesforceWriter.java:662)

at org.talend.components.salesforce.runtime.SalesforceWriter.close(SalesforceWriter.java:66)

at nextgenrfsmigration3.advancedpoc_0_1.AdvancedPOC.tDBInput_2Process(AdvancedPOC.java:3041)

at nextgenrfsmigration3.advancedpoc_0_1.AdvancedPOC.runJobInTOS(AdvancedPOC.java:4846)

at nextgenrfsmigration3.advancedpoc_0_1.AdvancedPOC.main(AdvancedPOC.java:3249)

[statistics] disconnected

Job AdvancedPOC ended at 13:59 18/01/2019. [exit code=1]

There is no API attribute field called IsDeleted inside object that Im inserting into salesforce and im not sending IsDeleted column values. So how does this error message came?
Is SalesforceWriter is supported for Talend Open Studio. I have seen limitation in Talend Open Studio saying Complex SOQL queries in Salesforce not supported for Open Studio. Is this is case of this error message occurs?

https://help.talend.com/reader/xVkdIonzSPLD~DZ85Z0A_w/eKytsgXaM4Lqu~1VxH28dw

Could me tell me how to overcome above error?

Re: Error when Inserting data to Salesforce using Talend Open Studio Version: 7.1.1

Anonymous — Tue, 22 Jan 2019 09:38:12 GMT

Hello,

Is there any system fields from your schema/mapping? Have you tried to remove it to see if it works?

Best regards

Sabrina

Re: Error when Inserting data to Salesforce using Talend Open Studio Version: 7.1.1

Anonymous — Tue, 22 Jan 2019 10:41:43 GMT

We have created a custom object and we tried to insert values for only Name, Description two fields via tSalesForce Input ellement in Talend Open Studio. Name is a Standard field in Salesforce and we need to provide values for that field when inserting data to salesforce. I have tested this same process with third party repository(kingswaysoft-SISS Integration Toolkit for Salesforce) in Microsoft SSIS and inserted data are reflected in salesforce correctly. So could you please tell me how to overcome above error?

Re: Error when Inserting data to Salesforce using Talend Open Studio Version: 7.1.1

Morpheus — Fri, 25 Jan 2019 14:01:24 GMT

@xdshi can you please provide any support links related to the same?

Re: Error when Inserting data to Salesforce using Talend Open Studio Version: 7.1.1

Anonymous — Mon, 28 Jan 2019 03:24:37 GMT

Hello,

Here exists a new jira issue on bug tracker.

https://jira.talendforge.org/browse/TUP-10235

Let us know if it is what you are looking for.

Best regards

Sabrina