Skip to main content

Duplicate value found: duplicates value on record with id: <unknown>.

System.DmlException: Insert failed. First exception on row 0; first error: DUPLICATE_VALUE, duplicate value found: <unknown> duplicates value on record with id: <unknown>.

The above error is triggered in the database layer and caused by a trigger or workflow outside of your main code of block that is bubbling this exception. This is rather difficult to track down especially if you are unfamiliar with the code, I am sharing my procedure in the hopes this saves you time - if you find this helpful drop me a line or follow me on twitter @danielsokolows.

This error is caused by unique field constraint on the object, so the first step is to examine the object and locate the API names of all unique fieds. You can do this through SF direclty 'Setup < Customize < <object being inserted> < Fields' or by downloading the `src/objects` metadata information and searching for <unique>; I preffer the latter and actually download ALL matadata information for projects I take over.

Next step is to take the field api names and go over triggers and workflows to find where it is referenced and how, this can be time consuming if there are a lot of entries so I preffer to just search within `src/workflows` and `src/triggers` metadata.

In the final step you need to examine the code and figure out which unique field is being populated and how and in effect understand how the duplicate value found error is being triggered. In my situation it turned out to be rather straighforward:

Be great


  1. I have created a external id field and made it to unique and is having combined text by concatenating OppertunityId and PricebookId; I have .csv file with PriceBookID, Oppotunity Id and other required fields; on the first run of Apex data loader (via command line) was doing fine but when tried to run the UPSERT with same file again (assuming nothing will happen) Data loader is splitting the following error : duplicate value found: unknown duplicates value on record with id: <<>>

    Trace from dataloder: client.PartnerClient processResult ( - Errors were found on item133 client.PartnerClient processResult ( - Error code is:DUPLICATE_VALUE client.PartnerClient processResult ( - Error message:duplicate value found: unknown duplicates value on record with id: <<>>

    Any help is appreciated. (with out any external id (unique) UPSERT is creating duplicate opportunitylineitem records which is not desired)

  2. Thanks Daniel! very helpful post!

  3. Thank you, Daniel. Your post helps me think through duplicate value created with one of my workflows. I want to warn people when we create workflows in the Prod Org, it will be hard to troubleshoot if you don't create a clear sandbox with the current copy of Prod. Think through if the workflow creates a duplicate unique field, in my case a duplicate unique external ID is created.

    Again thank you, Daniel, for posting!


Post a Comment

Popular posts from this blog

Softeher 'Error occurred. (Error code: 2)' sollution

Protocol error occurred. Error was returned from the destination server.The Softether server by default to run on port 443, if you server also hosts normal https then 443 is already taken and so Softether can't bind to it. When you run `vpncmd` it attempts to connect, find an active port, but of course fails with 'Protocol error occurred. Error was returned from the destination server.' because it's not actually connecting to the vpn server. By default Softether also listens on 992, 1194, and 5555 so the sollution is to modify specify `localhost:5555` when executing the `vpncmnd`. If this has helped you feel free to comment or follow me on twitter @danielsokolows.

Storing passwords in PuTTY

How to save SSH username/password for auto login in PuTTy The answer is you can't do least in plain PuTTy. However there is an awesome fork with that let's you store the username and password and other additional features called KiTTy.

So grab yourself a copy and +1 this if you do, thanks.