Skip to main content
Nintex Community Menu Bar

Error when adding a rule on a smartform actioning a view control

  • October 6, 2015
  • 1 reply
  • 15 views
Forum|alt.badge.img+6


 

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




 

    1 reply

    NigelStratton
    Forum|alt.badge.img+5

    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.

    Sidebar Buttons
    Nintex Community Home Contact Nintex Support Email Nintex Community Check Nintex Status
    Terms & ConditionsAccessibility statement