Skip to main content


 

Symptoms


Adding a form rule that calls a view throws:
Error 2601, Level 14, State 1, Procedure aDeploy, Line 880Cannot insert duplicate key row in object 'Form.Event_Design' with unique index 'UX_Form_Event_Design_ID_ContextID'. The duplicate key value is (4b5fdad8-de91-47da-a22f-0415134da9f6, 37a06419-a73c-44d7-b827-5cd72ce3a2c9).

The version is 4.6.10.2
 

Diagnoses


A TFS item _571169 exists for this item and it has been resolved in 4.6.11.

 

Resolution

Upgrading to 4.6.11




 

This can be very annoying if you have made a number of changes. I would run the following command in SQL on the K2 database.

 

SELECT * FROM Form]..Event_Design]
WHERE ContextID='4b5fdad8-de91-47da-a22f-0415134da9f6'

 

(Can't remember if it's ContextId or Id that you need to put in the where, but it's whatever one returns data)

 

Then use the SourceName and Name to remove or undo the single control that was creating issues, at least you can save the rest of the changes.

Reply


View our Community Site Map

Nintex Community Sitemap
Terms & ConditionsCookie settings