Known Issue: How to run a secondary runtime site
KB003695
PRODUCTK2 Five
BASED ONK2 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
- Install K2 5.5 with the March CU and relevant fixpack.
- Reconfigure K2 from the start menu, and on the database panel, enter a new name for the database.
- 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
- Run the script attached: Script to fix Reconfig issue for new DB.sql on the relevant K2 DB.
- 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).
- The installation will now run through without any blocking errors.
Scenario 2
- Install K2 5.5 with the March CU and relevant fixpack before fixpack 4.
- Run the following script on the K2 DB:DELETE FROM [Hostserver].[HostserverSetting]
WHERE [Name] like '%.kspx%'
or [Name] like 'Register_Control_%'
GO - Run a Reconfig or Update option from the start menu for the K2 Setup Manager.
- 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
- Run the script attached: Script to fix the Reconfig issue for new DB.sql on the K2 DB.
- 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).
- The installation will now run through without any blocking errors.