Orchestrator upgrade to 23.4 or 23.10 fails with CO_ASSESSMENT_META_JSON related error

News Knowledge Base
, , , , , , , , , , , , , ,
1

How to fix the error "Migration failed: The statement failed. Column 'CO_ASSESSMENT_META_JSON' has a data type that cannot participate in a columnstore index. Omit column 'CO_ASSESSMENT_META_JSON'"

While performing an upgrade to Orchestrator version 23.4 or 23.10, the installer fails with the below error:

System.Exception: Migration failed: The statement failed. Column 'CO_ASSESSMENT_META_JSON' has a data type that cannot participate in a columnstore index. Omit column 'CO_ASSESSMENT_META_JSON'.

Microsoft.Data.SqlClient.SqlException (0x80131904): The statement failed. Column 'CO_ASSESSMENT_META_JSON' has a data type that cannot participate in a columnstore index. Omit column 'CO_ASSESSMENT_META_JSON'.

The cause of this error is related to the Insights functionality, as for the newer versions, SQL Server 2019 is a mandatory requirement. The error appears when the Orchestrator database is stored on an SQL Server with versions lower than 2019.

To fix this, there are two ways:

  1. Upgrade the SQL Server to 2019 and retry the upgrade.
  2. Remove the Insights integration if it's not used (the error will appear even if there is no Insights database present, just the integration).