Upsert with no external ID

[GoogleCodeExporter]

What steps will reproduce the problem?
1. Running an upsert
2.
3.

What is the expected output? What do you see instead?
Upsert records (29000)

error telling me external id filed name provided does not match an external id 
for workflow1

I upsert data into this object with another process with no issues.

What version of the product are you using? On what operating system?

The latest 2.1.1
Please provide any additional information below.

Original issue reported on code.google.com by franksco...@gmail.com on 16 Nov 2011 at 10:03

[GoogleCodeExporter]

Original comment by franksco...@gmail.com on 16 Nov 2011 at 10:25

Attachments:

• [sdl log workflow1.txt](https://storage.googleapis.com/google-code-attachments/dataloadercliq/issue-42/comment-1/sdl log workflow1.txt)

[GoogleCodeExporter]

Can you upload your process-conf.xml?  (remove the password fields)
The field specified as an external id in process-conf.xml must not be an 
External ID in Salesforce.

Original comment by vijay.swamidass@gmail.com on 16 Nov 2011 at 11:47

[GoogleCodeExporter]

Original comment by franksco...@gmail.com on 17 Nov 2011 at 12:16

Attachments:

• process-conf.xlm

[GoogleCodeExporter]

I have attached the requested file.

Original comment by franksco...@gmail.com on 17 Nov 2011 at 12:16

[GoogleCodeExporter]

I found the issue. The external ID line of code was missing. Even though it 
gets populated with the actual record ID.  Seams strange, but the other process 
I have running on the same object had the line of code.  Copied it and it works 
fine.

Is it normal that the build process the cliq would not add the line of code?

Thanks for the help.

Original comment by franksco...@gmail.com on 17 Nov 2011 at 4:09

[GoogleCodeExporter]

When you went through the CLIq wizard, did you enter a value when prompted for 
External Id?  That is the only way the external id would be missing, as far as 
i know.

If you can reproduce the problem, please let me know.

Original comment by vijay.swamidass@gmail.com on 17 Nov 2011 at 5:45

• Changed state: Accepted

[GoogleCodeExporter]

I was able to reproduce the problem 4 times.  As the process indicates tat the 
external ID is optional (and I am not really using an external ID) I left the 
field blank.  I did not try to build it indicating that the external ID was the 
ID.  I will try that later this afternoon, but after adding the line of code, 
it works fine.  Just something I have in my notes to remember if it happens 
again.

Original comment by franksco...@gmail.com on 17 Nov 2011 at 6:03

[GoogleCodeExporter]

So you added this line to your config?
<entry key="sfdc.externalIdField" value="Id"/>

I can look at making that the default.

Original comment by vijay.swamidass@gmail.com on 18 Nov 2011 at 3:26