One Star

[resolved] Salesforce Upsert Problem

Hello!
I am new to Talend Open Studio and cannot get a "simple" upsert to a custom Salesforce object to work.  Using the "upsert" action, I have attempted to insert and update records and I am receiving the same error on both.  The error is:
java.lang.Exception: java.lang.Exception: P21_Quote_Number__c not specified


The map is set up as follows:

MSSQL input --> tMap --> tSalesforceOutput
                    |--> tLogRow


The salesforce custom object is named Quote__c and has P21_Quote_Number__c set up as an external ID. (Our current Boomi integration is working okay, so the salesforce set up should be okay.)
The tLogRow output shows that data for P21_Quote_Number__c is populated.
In Talend on the basic settings tab I have set the "Upsert Key Column" to P21_Quote_Number__c.
I have also tried setting up the Relationship mappings on the advance settings tab and I still get the same message.
What am I doing wrong?

Thanks in advance for your help!
1 ACCEPTED SOLUTION

Accepted Solutions
One Star

Re: [resolved] Salesforce Upsert Problem

RESOLVED - The schema for the salesforce object included fields that were not mapped for the upsert operation.  I deleted the unused fields using the tMap component and the upsert is now working.
Thank you for your help!!
12 REPLIES
Employee

Re: [resolved] Salesforce Upsert Problem

Which Talend version is this and what is the Salesforce URL that you are using?
Thomas Steinborn
VP Product Management
One Star

Re: [resolved] Salesforce Upsert Problem

I am using Talend Open Studio for Data Integration version 6.0 (6.0.0).
The tSalesforceOutput has the Salesforce WebService URL set to:
""
One Star

Re: [resolved] Salesforce Upsert Problem

""
One Star

Re: [resolved] Salesforce Upsert Problem

The URL is being blocked.  The URL with the slashes turned to dashes is:
https: -- www.salesforce.com - services - Soap - u - 25.0
Employee

Re: [resolved] Salesforce Upsert Problem

This sounds all correct. Can you post the job here (after removing all sensitive information like passwords) or at least show a screenshot with the settings.
Thomas Steinborn
VP Product Management
One Star

Re: [resolved] Salesforce Upsert Problem

I am new to the software and I am not sure hot to obtain a postable version of the job.  Here are some screen shots.
One Star

Re: [resolved] Salesforce Upsert Problem

I am unable to upload images or insert images because I am new to the forum.  You requested that I post the job. -- Are you asking for .java file ?  This file is 2000+ lines.  Since I cannot upload the file, may I post all of the lines?
Or... here are the screen shot URLs with the slashes changed to dashes:
http:--s19.postimage.org-6rv69a9hb-mssql_input.jpg
http:--s19.postimage.org-memfmnn9b-t_Map.jpg
http:--s19.postimage.org-iwafq9mdb-t_Salesforce_Output_Basic_Settings.jpg
http:--s19.postimage.org-u9wz1gwvz-Error_Message.jpg
Thank you for your help.
One Star

Re: [resolved] Salesforce Upsert Problem

http:--postimage.org-image-6rv69a9hb/
http:--postimage.org-image-memfmnn9b/
http:--postimage.org-image-iwafq9mdb/
http:--postimage.org-image-u9wz1gwvz/
One Star

Re: [resolved] Salesforce Upsert Problem

RESOLVED - The schema for the salesforce object included fields that were not mapped for the upsert operation.  I deleted the unused fields using the tMap component and the upsert is now working.
Thank you for your help!!
Employee

Re: [resolved] Salesforce Upsert Problem

You don't need a tMap to remove the entries.
Just click the Edit Schema button and remove the fields that you don't need.
The export jobs you right click on it and choose Export Items...
Glad your issue is resolved.
Thomas Steinborn
VP Product Management
One Star

Re: [resolved] Salesforce Upsert Problem

Hi, there,
I have a job in which data is coming from an input file and is being loaded in Salesforce through DataMap.
There is an Upsert operation on a custom object named Recurring Donation which has a lookup for Account and Contact.
Object: Recurring_Donation__c
Lookup Account: Organization__c
Lookup Contact: Primary_Contact__c
In Advance setting of tSalesforceOutputBulkExec component,
I have specified the fields from drop down menu, and in Lookup Relationship Field name I have written Organization__r and Primary_Contact__r and specified their External_IDs.
It is giving me an error of Invalid Batch Found.
Please help me out.
Thanks,
Stuti
One Star

Re: [resolved] Salesforce Upsert Problem

Hi,
Are you using tSalesforceBulk? If yes, go on Salesforce side you'll retrieve the complete error