Error: Data could not be saved. Violation of PRIMARY KEY constraint 'PK_SHOPPINGCARTSETTINGS'. When creating/editing a Payment 2.0 part

When attempting to create or edit a Payment 2.0 part in BBIS the following error is generated:

"Data could not be saved. Violation of PRIMARY KEY constraint 'PK_SHOPPINGCARTSETTINGS'. Cannot insert duplicate key in object 'dbo.SHOPPINGCARTSETTINGS'. The duplicate key value is (xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx)."
This issue occurred in an environment where the Testconfig page showed a mismatched SQL CLR component test.  (test showed version 4.0.5.0, while CRM and BBIS components showed 4.0.5.13)  Issue was not duplicated with the same database in a different environment whose components matched.  Upon repairing the original environment, the issue was addressed. 

To address: 
1. Run a repair of the web components
2. Re-run database revisions to register the updated DLL

Steps to Duplicate

  1. Login to BBIS site as a Supervisor
  2. Go to Site Explorer > Parts
  3. Create a Payment 2.0 part
  4. Save the Part
  5. Edit the part and attempt to add a value in the “Days to keep anonymous carts” text box
  6. Click Save
  7. The following error is received: "Data could not be saved. Violation of PRIMARY KEY constraint 'PK_SHOPPINGCARTSETTINGS'. Cannot insert duplicate key in object 'dbo.SHOPPINGCARTSETTINGS'. The duplicate key value is (xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx)."

Environment

 Blackbaud Internet Solutions
 4.0

Was this article helpful?