Skip to main content
Nintex Community Menu Bar

How to fix reconfigure issue on K2 5.5 March CU

  • February 16, 2021
  • 0 replies
  • 153 views

Forum|alt.badge.img+4
 

Known Issue: How to run a secondary runtime site

KB003695

PRODUCT
K2 Five
BASED ON
K2 Five

Issue

Performing a reconfigure on K2 5.5 Mar 2022 CU FP1and pointing the setup manager to a new DB, causes the setup manager to fail.

Error Code

Error: System.Data.SqlClient.SqlException (0x80131904): Error %d, Level %d, State %d, Procedure %s, Line %dCannot insert duplicate key row in object 'Form.ActionItem' with unique index 'UX_Form_ActionItem_ID'. The duplicate key value is ()

Resolution

Use one of the options below to resolve the issue.

Scenario 1

  1. Install K2 5.5 with the March CU and relevant fixpack.
  2. Reconfigure K2 from the start menu, and on the database panel, enter a new name for the database. 
  3. The setup will then run into the blocking error around the duplicate key issue with Management_Update5.kspx:
    Error: Cannot insert duplicate key row in object 'Form.ActionItem' with unique index 'UX_Form_ActionItem_ID'. The duplicate key value is xxxxx
  4. Run the script attached: Script to fix Reconfig issue for new DB.sql on the relevant K2 DB.
  5. Run the K2 Setup Manager from the Start Menu or the [INSTALLDIR]K2SetupSetup.exe if the K2 Setup is not available in the Start Menu, then run the recover option (This should be the only option available).
  6. The installation will now run through without any blocking errors.

Scenario 2

  1. Install K2 5.5 with the March CU and relevant fixpack before fixpack 4.
  2. Run the following script on the K2 DB:
    DELETE FROM [Hostserver].[HostserverSetting]
    WHERE [Name] like '%.kspx%'
    or [Name] like 'Register_Control_%'
    GO
  3. Run a Reconfig or Update option from the start menu for the K2 Setup Manager.
  4. The setup will then run into the blocking error around the duplicate key issue with Management_Update5.kspx:
    Error: Cannot insert duplicate key row in object 'Form.ActionItem' with unique index 'UX_Form_ActionItem_ID'. The duplicate key value is xxxxx
  5. Run the script attached: Script to fix the Reconfig issue for new DB.sql on the K2 DB.
  6. Run the K2 Setup Manager from the Start Menu or the [INSTALLDIR]K2SetupSetup.exe if the K2 Setup is not available in the Start Menu, then run the recover option (This should be the only option available).
  7. The installation will now run through without any blocking errors.

 

Translate
Did this topic help you find an answer to your question?

Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie Settings