Skip to main content
Nintex Community Menu Bar

Error when adding a rule on a smartform actioning a view control - Cannot insert duplicate key

  • February 16, 2017
  • 0 replies
  • 20 views



 

Symptoms


Issue:
"I receive below error message, if I try to add a rule for a control on a view."

Error 2601, Level 14, State 1, Procedure aDeploy, Line 917Cannot insert duplicate key row in object 'Form.Event_Design' with unique index 'UX_Form_Event_Design_ContextID_SourceID_SourceTypeID_TypeID_Name'. The duplicate key value is (4b99ee41-942f-4b7c-969f-cf14e9b64e37, 73a47167-b4bf-a357-a928-174873c915c8, 3, 1, OnClick).
 

Diagnoses


Diagnosis:
We have seen this issue in many tickets before, we tried the various workaround suggested in these tickets, however it did not work
 

Resolution

Resolution:
The developers provided the client with a codefix which resolved their issue.