Symptoms
We are in the middle of an K2 upgrade 4.6.6 --> 4.6.11
The configuration analysis tool gives us a warning on the Database Rebuild Indexes node
Trying to run the stored procedures manually, but gives us the following error:
Executing: K2ServerLog.Upgrade_DropArtifacts
Executing: K2ServerLog.Upgrade_ConvertDeprecatedTypes
Executing: K2ServerLog.Upgrade_DropArtifacts
Executing: K2ServerLog.Upgrade_ConvertDeprecatedTypes
Executing: K2ServerLog.Upgrade_DropArtifacts
Executing: K2ServerLog.Upgrade_ConvertDeprecatedTypes
Executing: K2ServerLog.Upgrade_DropArtifacts
Executing: K2ServerLog.Upgrade_ConvertDeprecatedTypes
Executing: K2ServerLog.Upgrade_DropArtifacts
Executing: K2ServerLog.Upgrade_ConvertDeprecatedTypes
Msg 208, Level 16, State 1, Procedure DatabaseRebuildIndexes, Line 2084
Invalid object name 'ServerLog.LogBatch'.
Diagnoses
The DatabaseCheckIndexes says:
table_name item_type item_name
[ServerLog].[Priority] IX UX_ServerLog_Priority_Id
[ServerLog].[ProcInstAudit] IX IX_ServerLog_ProcInstAudit_ProcInstID_INC_User_Date
[ServerLog].[ProcInstData] IX IX_ServerLog_ProcInstData_ProcInstID_Name
[ServerLog].[ProcSet] IX IX_ServerLog_ProcSet_ID_INC_FullName
Resolution
This was resolved by running the DB Consolidation tool BEFORE upgrading to 4.6.11 from 4.6.6.
After which, upgrading the single database did not throw any warning from the configuration tool.
