0

I'm getting below error while loading contact using data loader springframwork

https://github.com/forcedotcom/dataloader

I'm loading data using spring framework and "sfdc.useBulkApi" value="false" THIS IS GIVE ME ERROR

If I load data using bulkapi THIS IS working FINE "sfdc.useBulkApi" value="true"

Please help

 <entry key="sfdc.timeoutSecs" value="600"/>
                <entry key="sfdc.debugMessages" value="true"/>  
                <entry key="sfdc.insertNulls" value="true"/>
                <entry key="sfdc.useBulkApi" value="false"/> 
                <entry key="sfdc.loadBatchSize" value="200"/>
                <entry key="sfdc.externalIdField" value="APPGUID__c"/>
                <entry key="sfdc.entity" value="Contact"/>
                <entry key="process.operation" value="upsert"/>

mapping file

Account=Account\:OCPGUID__c
Address__c=Address__r\:POBPGUID__c
Admin__c=Admin__c
Alternate_Email__c=Alternate_Email__c
APPGUID__c=APPGUID__c
Bar_Membership__c=Bar_Membership__c
Business_Unit__c=Business_Unit__c
Contact_Status__c=Contact_Status__c
DS_Last_Verified_Date__c=DS_Last_Verified_Date__c
Department__c=Department__c
Email=Email
End_Date__c=End_Date__c

Caused by: [InvalidFieldFault [ApiQueryFault [ApiFault exceptionCode='INVALID_FIELD' exceptionMessage='No such column 'Address__r:POBPGUID__c' on entity 'Contact'. If you are attempting to use a custom field, be sure to append the '__c' after the custom field name. Please reference your WSDL or the describe call for the appropriate names.' 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.upsert(PartnerConnection.java:1176)
    at com.salesforce.dataloader.client.PartnerClient$3.run(PartnerClient.java:116)
    at com.salesforce.dataloader.client.PartnerClient$3.run(PartnerClient.java:108)
    at com.salesforce.dataloader.client.PartnerClient.runOperation(PartnerClient.java:345)
    at com.salesforce.dataloader.client.PartnerClient.loadUpserts(PartnerClient.java:267)
    at com.salesforce.dataloader.action.visitor.UpsertVisitor.executeClientAction(UpsertVisitor.java:52)
    at com.salesforce.dataloader.action.visitor.PartnerLoadVisitor.loadBatch(PartnerLoadVisitor.java:66)
    ... 7 more
1
  • Look up field exist in the object. if I use data using bulk api its working fine "sfdc.useBulkApi" value="True" – Gaurang Patel Nov 30 '20 at 13:49

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.