1

I'm trying to Upsert the data to Account object using an external tool, Everything works fine but Salesforce is throwing error for few records when upserting.

I was doing the upsertion process using the external id field. Except external id field no other field is having a unique constraint.

I'm getting the following error -

SF_ERROR: DUPLICATE_VALUE

OBJ: Account - duplicate value found: unknown duplicates value on record with id: 001***********

Please help me to solve the issue.

Billal Begueradj
  • 20,717
  • 43
  • 112
  • 130
Santhosh
  • 189
  • 2
  • 3
  • 7
  • Do you try to update same record in your import source? Imagine telling Salesforce to "update record 123 some value = 7" and few lines below in the import file - "update record 123 with some value = 5". It will have no idea which value should "win" and so it'll throw an error back at you. Alternatively - are you really upserting by that ext. id field? You have to explicitly use it in the mapping or by default it'll try to upsert by Id. Are the updates that succeed really hitting the old rows or are they creating new ones? – eyescream Jul 04 '14 at 07:45
  • make sure your external id is unique and in the data you are getting the field which is mapped to external id does not have repeated values.. – Dinesh Jul 04 '14 at 23:13
  • Hi @eyescream, I'm usperting with the external id field and it unique too. And the source does'nt have any duplicates on External id. – Santhosh Jul 07 '14 at 05:58
  • What do you get if you search your import file (database, whatever) for whatever is the value of that ext. id field on the Account from the error? And is there any chance you have triggers or workflow rules that modify these ext. ids during insert? – eyescream Jul 07 '14 at 08:06
  • this is happening because your trying to create Salesforce contact multiple times with same email and data – vamsee.vella Apr 24 '18 at 04:49

2 Answers2

1

This is happening because your trying to create Salesforce contact multiple times with same email and data

Billal Begueradj
  • 20,717
  • 43
  • 112
  • 130
vamsee.vella
  • 11
  • 2
0

It's silly but this was happening to me because SFDC considers 'NULL' as a unique value... Mostly because Excel converted 'NULL' to text and was trying to bring in the literal word 'NULL'.

mttyd
  • 37
  • 7