topic Re: [resolved] Salesforce Upsert Problem in Talend Studio

[resolved] Salesforce Upsert Problem

Anonymous — Sat, 16 Nov 2024 11:02:01 GMT

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!

Re: [resolved] Salesforce Upsert Problem

Anonymous — Fri, 25 Sep 2015 09:37:38 GMT

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

Re: [resolved] Salesforce Upsert Problem

Anonymous — Fri, 25 Sep 2015 17:24:49 GMT

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

Re: [resolved] Salesforce Upsert Problem

Anonymous — Fri, 25 Sep 2015 17:26:57 GMT

""

Re: [resolved] Salesforce Upsert Problem

Anonymous — Fri, 25 Sep 2015 17:29:23 GMT

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

Re: [resolved] Salesforce Upsert Problem

Anonymous — Fri, 25 Sep 2015 17:39:34 GMT

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.

Re: [resolved] Salesforce Upsert Problem

Anonymous — Fri, 25 Sep 2015 18:21:18 GMT

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.

Re: [resolved] Salesforce Upsert Problem

Anonymous — Fri, 25 Sep 2015 20:10:29 GMT

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.

Re: [resolved] Salesforce Upsert Problem

Anonymous — Fri, 25 Sep 2015 20:14:57 GMT

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

Re: [resolved] Salesforce Upsert Problem

Anonymous — Sat, 26 Sep 2015 02:28:52 GMT

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

Re: [resolved] Salesforce Upsert Problem

Anonymous — Sat, 26 Sep 2015 17:03:22 GMT

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.

Re: [resolved] Salesforce Upsert Problem

Anonymous — Fri, 10 Mar 2017 10:14:44 GMT

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

Re: [resolved] Salesforce Upsert Problem

TRF — Fri, 10 Mar 2017 11:29:12 GMT

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