topic Re: Error while inserting custom object records to Salesforce in Talend Studio

Error while inserting custom object records to Salesforce

BlueOcean_ProvePharm — Fri, 15 Nov 2024 22:18:47 GMT

Team.,

I am trying to insert custom object records from an Excel file to Salesforce and I am getting the below error , please help:

Exception in component tSalesforceOutput_1 (ContractsIntegration)

java.io.IOException: [InvalidSObjectFault [ApiQueryFault [ApiFault exceptionCode='INVALID_TYPE'

exceptionMessage='sObject type '' is not supported. If you are attempting to use a custom object, be sure to append the '__c' after the entity name. Please reference your WSDL or the describe call for the appropriate names.'

extendedErrorDetails='{[0]}'

]

row='-1'

column='-1'

]

at org.talend.components.salesforce.runtime.SalesforceSourceOrSink.getSchema(SalesforceSourceOrSink.java:451)

at org.talend.components.salesforce.runtime.SalesforceWriter.open(SalesforceWriter.java:153)

at salesforce_integration_project.contractsintegration_0_1.ContractsIntegration.tFileInputExcel_1Process(ContractsIntegration.java:1119)

at salesforce_integration_project.contractsintegration_0_1.ContractsIntegration.runJobInTOS(ContractsIntegration.java:2063)

at salesforce_integration_project.contractsintegration_0_1.ContractsIntegration.main(ContractsIntegration.java:1901)

Caused by: [InvalidSObjectFault [ApiQueryFault [ApiFault exceptionCode='INVALID_TYPE'

extendedErrorDetails='{[0]}'

]

row='-1'

column='-1'

]

at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)

at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)

at java.base/jdk.internal.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)

at java.base/java.lang.reflect.Constructor.newInstance(Constructor.java:490)

at java.base/java.lang.Class.newInstance(Class.java:584)

at com.sforce.ws.bind.TypeMapper.readSingle(TypeMapper.java:721)

at com.sforce.ws.bind.TypeMapper.readObject(TypeMapper.java:593)

at com.sforce.ws.transport.SoapConnection.parseDetail(SoapConnection.java:250)

at com.sforce.ws.transport.SoapConnection.createException(SoapConnection.java:224)

at com.sforce.ws.transport.SoapConnection.receive(SoapConnection.java:163)

at com.sforce.ws.transport.SoapConnection.send(SoapConnection.java:108)

at com.sforce.soap.partner.PartnerConnection.describeSObjects(PartnerConnection.java:1266)

at org.talend.components.salesforce.runtime.SalesforceSourceOrSink.getSchema(SalesforceSourceOrSink.java:448)

... 4 more

Re: Error while inserting custom object records to Salesforce

Anonymous — Thu, 01 Dec 2022 09:25:46 GMT

Hello,

Could you please verify your custom object does exist in the Salesforce account? If not, then request customer to set it.

Best regards

Sabrina

Re: Error while inserting custom object records to Salesforce

BlueOcean_ProvePharm — Thu, 01 Dec 2022 11:30:53 GMT

@Xiaodi Shi The custom object does exist in Salesforce and I was able to create mapping for the same , but I am running the job I am getting the error.

Re: Error while inserting custom object records to Salesforce

Anonymous — Thu, 01 Dec 2022 13:17:01 GMT

Which Salesforce table are you loading this to and what is the column name (which is set as an Object)? Is it a standard column/field or a bespoke one? Object is a base class for both Java and Apex. But they will need to be able to be cast to their expected type when used by a system. I suspect that the problem here may well be that the class that is expected to be used is not compatible with the Object you are trying to send.

Re: Error while inserting custom object records to Salesforce

BlueOcean_ProvePharm — Fri, 02 Dec 2022 05:28:53 GMT

I am trying to insert records into 'Contract' custom object and inserting data in to the standard and custom fields. It's a straight forward use case , so not sure what is the issue.

Re: Error while inserting custom object records to Salesforce

Anonymous — Fri, 02 Dec 2022 08:59:32 GMT

The Salesforce error is telling you what Salesforce thinks is wrong. Unfortunately, since I cannot see your environment I am having to guess at what you are doing.

I Googled the Salesforce error ....

[InvalidSObjectFault [ApiQueryFault [ApiFault exceptionCode='INVALID_TYPE'

extendedErrorDetails='{[0]}'

.... and came up with this link....

https://developer.salesforce.com/forums/?id=906F0000000BaJrIAK

It seems to suggest that a WSDL update is required. This could be because your Salesforce object has been updated.

Re: Error while inserting custom object records to Salesforce

BlueOcean_ProvePharm — Fri, 02 Dec 2022 13:12:00 GMT

I created a new job and surprisingly this insert operation worked , thanks.