Error: An error occurred before executing the process 'Smart Field Process' : Violation of PRIMARY KEY constraint 'PK_SMARTFIELD7CD94DE442B84FB08181D99000A5921C'. Cannot insert duplicate key in object 'dbo.SMARTFIELD7CD94DE442B84FB08181D99000A5921C'. Th

We're getting the following violation of primary key errors when processing some of our smart fields.  Depending on which smart field errors out the duplicate key value changes

Violation of PRIMARY KEY constraint 'PK_SMARTFIELDF6EAC6EE9DA64301826944835693F9
14'. Cannot insert duplicate key in object 'dbo.SMARTFIELDF6EAC6EE9DA64301826944835693F
914'. The duplicate key value is (192499).Changes per error
The statement has been terminated.
 

Download and install the latest patch, which contains all fixes from previous patches. If you are running an older version, download and install the latest version and then the patch. 

Environment

 3.0.516, patch 34
 3.0.516, Service Pack 9

Was this article helpful?