Symptoms

Encounter error when running the 4.7 Update Manager. Installer log shows the following error:

"Script execute failed: System.Exception: Script execution exception: Microsoft.SqlServer.Management.Common.ExecutionFailureException: An exception occurred while executing a Transact-SQL statement or batch. ---andgt System.Data.SqlClient.SqlException: Invalid column name 'DisplayName'."
 

Diagnoses

1. Installer logs reveal that the Update Manager seems to be referencing some databases from the old K2 database schema. K2 databases have already been consolidated, so there should be no reason why the Update Manager will reference the old database.

2. Ran a reconfiguration and repair, but the upgrade process still failed with the same error

3. Checked dK2].]HostServer].]Configuration] table, and noticed for VariableToken='=DATABASESTRUCTURE]', the VariableValue is 'Legacy'.

4. The same VariableToken is showing a VariableValue of 'Consolidated' on the new K2 database schema

5. Obtained the same error after manually changing the eDATASTRUCTURE]'s VariableValue to 'Legacy', and ran the 4.7 Upgrade Manager


 

Resolution

1. On OK2].2HostServer].rConfiguration] table, for VariableToken='nDATABASESTRUCTURE]', update the the VariableValue to 'Consolidated'.

2. Run the 4.7 Update Manager and the K2 blackpearl component should upgrade without errors.