Error when Inserting data to Salesforce using Talend Open Studio Version: 7.1.1
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?
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?
