Orchestrator Upgrade with Insight Feature Enabled in Version 20.10

[system]

How can you resolve issues encountered during the Orchestrator upgrade when the Insight feature is enabled in version 20.10?

Issue Description:

During the upgrade of Orchestrator to version 2021.10.x, if the Insight feature is enabled in the 20.10 version, you might encounter issues due to incompatibility. Specifically, you may see errors related to incorrect syntax near $.machineName.

System.Exception: Migration failed: Incorrect syntax near '$.machineName'." Microsoft.Data.SqlClient.SqlException (0x80131904): Incorrect syntax near '$.machineName'.at Microsoft.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseIHow can you resolve issues encountered during the Orchestrator upgrade when the Insight feature is enabled in version 20.10?nAction) at Microsoft.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)

Root Cause:

Orchestrator 2021.10.x + is incompatible with the older version of Insight.

Resolution:

1. Disable the Feature: Before starting the upgrade, disable the feature to prevent migration issues and avoid crashing the installation.

2. Upgrade Orchestrator: Perform the Orchestrator upgrade.

3. Install Looker Insights: After completing the Orchestrator upgrade, proceed with installing Looker Insights to re-enable the feature.

4. Considerations for Reinstallation: For guidance on uninstalling and reinstalling Insights, refer to the "Considerations When Uninstalling and Reinstalling Insights" documentation: Considerations When Uninstalling And Reinstalling Insights.
   

Note: A fresh installation of Looker Insights will create a new database. You will need to refer to the old dashboard to recreate any necessary formulas in the new dashboard.