Error: An error occurred before executing the process 'Smart Field Process' : Violation of PRIMARY KEY constraint - When processing a constituent lifetime giving smart field

When trying to process a constituent lifetime giving smart field you may experience an error that says:
Violation of PRIMARY KEY constraint 'PK_SMARTFIELD9E5D803348EE402592CDE5200914AC91'. Cannot insert duplicate key in object 'dbo.SMARTFIELD9E5D803348EE402592CDE5200914AC91'. The duplicate key value is (0c64cb95-512c-4282-9705-000f4122b3fb). The statement has been terminated.
Try clearing the Smart Field and processing again:
  1. From Administration, click Smart Fields
  2. Navigate to the Constituent lifetime giving Smart field, and expand 
  3. Click Clear results, and Yes
  4. Expand the Smart Field again, and click Process
If the Smart Field does not run a second time, please Chat with Support and reference this article. 

Steps to Duplicate

  1. Click Administration > Smart Fields
  2. Expand the Constituent lifetime giving Smart Field
  3. Click start process, under task in the upper left hand corner of the screen
  4. The error message occurs while the process is running

Environment

 Altru Arts & Cultural

Was this article helpful?