[resolved] Salesforce Upsert Problem

[Anonymous]

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!

[Anonymous]

Which Talend version is this and what is the Salesforce URL that you are using?

[Anonymous]

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

[Anonymous]

""

[Anonymous]

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

[Anonymous]

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.

[Anonymous]

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.

[Anonymous]

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.

[Anonymous]

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

[Anonymous · Accepted solution]

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!!