Code Fix: Unable to upgrade to K2 Five (5.1) when the K2 database has data integrity issue

  • 16 February 2021
  • 0 replies
  • 5 views

Badge +5
 

Code Fix: Unable to upgrade to K2 Five (5.1) when the K2 database has data integrity issues

KB002432

PRODUCT
K2 Five 5.1
K2 Five (5.1) Fix Pack 1

 

Issue Description

When upgrading to K2 Five (5.1) on an environment where the K2 database has data integrity issues before upgrading, the upgrade will fail on the creation of the UX_Authorization_Object_ClassID_Hash_IsClassObject index in the Authorization.Object table.

Resolution

  1. Ensure you have K2 (5.1) installed.
  2. Get the K2 Five (5.1) FP1 from Regional Support.
  3. Install the K2 Five (5.1) FP1 to apply the fix.

Considerations

The UX_Authorization_Object_ClassID_Hash_IsClassObject index in the Authorization.Object table will now be removed after successful creation to prevent any future upgrade failures.

It might be necessary to refresh the Authorization.Object table to reflect the correct indexes.

 


0 replies

Be the first to reply!

Reply