Network Management

"You are attempting to use an unsupported configuration/tier of Azure SQL Database which doesn't support columnstore indexes." when running configuration wizard with Azure SQL

This article provides information about an issue where the configuration wizard is unable to get to proceed due to DTU tier being below S3. In some scenarios, this message may appear in other logs if Azure SQL is downgraded below S3.

First published date

6/4/2020 5:30 AM

Last published date

2/25/2025 10:39 PM

Overview

In the SolarWinds log, the following error message may appear:

ERROR SolarWinds.Netflow.Processing.Workflow.FlushManager - Flushing flows chunk failed. Chunk with 6 flows is dropped.
System.InvalidOperationException: Cannot access destination table 'dbo.NetFlowFlows'. ---> System.Data.SqlClient.SqlException: Table 'dbo.NetFlowFlows' uses a clustered columnstore index. Columnstore indexes are 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.

 

This message is related to a NTA problem when running the configuration wizard:

Product section

Netflow Traffic Analyzer

Cause

This issue occurs due to columnstore indexes are available in the following versions:

  • Azure SQL Database DTU Premium tiers,
  • DTU Standard tiers - S3 and above
  • All vCore tiers

For more information, please reference the following Microsoft document.

Resolution

To resolve the issue, please upgrade to a SQL version (listed above) that supports columnstore indexes.

For more information, please refer to the system requirements for SolarWinds Platform database using Azure SQL Database managed instance.