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
bServerLog].LPriority] IX UX_ServerLog_Priority_Id
bServerLog].LProcInstAudit] IX IX_ServerLog_ProcInstAudit_ProcInstID_INC_User_Date
bServerLog].LProcInstData] IX IX_ServerLog_ProcInstData_ProcInstID_Name
bServerLog].LProcSet] 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.