'COLUMNSTORE' Is Not Supported In This Service Tier Of The Database --Error During Orchestrator Installation

News Knowledge Base
1

Migration failed error during the Orchestrator installation with insights enabled?

Getting an error "System.Exception: Migration failed: 'COLUMNSTORE' is not supported in this service tier of the database. See Books Online for more details on feature support in different service tiers of Windows Azure SQL Database" while enabling the insights during the Orchestrator installation.

Root cause: SQL server without columnstore support (or Azure SQL with tier < S3)

Resolution:

If considering installing Insights, make sure that the database supports both columnstore indexes and JSON functions.

Points To Remember:

  1. Insights requires the SQL Server to have support for columnstore index and .json functions.
  2. For Azure SQL, ensure the database is S3 tier or above.
  3. Make sure the compatibility level for Insights database is set to 150 or higher ("SELECT compatibility_level from sys.databases WHERE name = '{dbName}'). In most cases, the default settings meet this requirement. For more information, refer to View or Change the Compatibility level of a Database - SQL Server.

Note: Orchestrator with Insights enabled need to have database that supports both columnstore indexes and JSON functions. This is mentioned under SQL Server(last point).

Read more on Orchestrator Prerequisites For Installation: SQL Server .

Make the suggested changes with the help of local database team if required. For more info please refer below docs,