How to fix reconfigure issue on K2 5.5 March CU

  • 16 February 2021
  • 0 replies
  • 96 views

Badge +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.

 


0 replies

Be the first to reply!

Reply