Code Fix: Unable to upgrade to K2 Five (5.1) when the K2 database has data integrity issues
KB002432
PRODUCT
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
- Ensure you have K2 (5.1) installed.
- Get the K2 Five (5.1) FP1 from Regional Support.
- 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.