IBM Support

No Azure Synapse Analytics Dedicated SQL pools discovered

General Page

After adding the Azure Service Principal (SP) target correctly, resource groups and VMs entities are being discovered, but the Dedicated SQL pools are not.

Descriptions:

Although there is no error shown on the UI against Azure SP target, looking at the rsyslog, we can see following error traces suggesting the discovery on Azure Dedicated SQL pools (within Synapse Analytics Workspace) has failed:

log.txt_20241223_013854.xz:mediation-azure-7cc854fcb4-g929f 2024-12-23 00:03:38,129 ERROR [azure-discovery-709f967b-ccfe-4fc5-91f0-d44c093bb38d] [AzureDiscoveryTaskExecutor]	: Failed to execute discovery task: SynapseSqlPoolDiscoveryTask (Synapse SQL Pool Discovery)
log.txt_20241223_013854.xz:mediation-azure-7cc854fcb4-g929f 		at com.azure.resourcemanager.synapse.implementation.Utils$PagedIterableImpl.stream(Utils.java:111)
log.txt_20241223_013854.xz:mediation-azure-7cc854fcb4-g929f 		at com.vmturbo.mediation.azure.queryengine.SynapseSqlPoolQueryEngine.query(SynapseSqlPoolQueryEngine.java:48)
log.txt_20241223_013854.xz:mediation-azure-7cc854fcb4-g929f 		at com.vmturbo.mediation.azure.SynapseSqlPoolDiscoveryTask.createSqlPoolEntities(SynapseSqlPoolDiscoveryTask.java:71)
log.txt_20241223_013854.xz:mediation-azure-7cc854fcb4-g929f 		at com.vmturbo.mediation.azure.SynapseSqlPoolDiscoveryTask.doExecute(SynapseSqlPoolDiscoveryTask.java:56)

mediation-azure-7cc854fcb4-g929f com.azure.core.management.exception.ManagementException: Status code 409, "{"error":{"code":"UnsupportedOperation","message":"For the workspace dev-martech-paas-sqlserver-ne, this is an unsupported operation as it is a Connected workspace."}}": For the workspace dev-martech-paas-sqlserver-ne, this is an unsupported operation as it is a Connected workspace.
Notes: Turbonomic only discover Dedicated SQL pool resources exist within a Synapse workspace.

Solution:

We have identified the root cause for this issue. Azure published a new feature - "Synapse Link" which creates new Synapse workspaces along with new dedicated SQL pools given an existing Azure SQL Server or SQL database. As of now, Turbonomic does not discover and optimise these Synapse resources. We will decide when or if in the future we will add support to these resources. For now we have released a fix in 8.14.6 to make sure that Turbonomic will continue discovering Synapse resources, which are not created using Synapse Link, without interruption.

Currently, Turbonomic only support the Synapse Workspace with Normal type. If a Synapse Workspace is created using Synapse Link, it will have workspace type as Connected, and we don’t support it yet. In addition, once Turbo discover one Connected Type Synapse Workspace, it will stop the entire discovery process, therefore even there may be some Normal type Synapse Workspaces, Turbonomic will not be able to discover them. However, this issue has now be addressed in release 8.14.6, which makes sure the discovery to proceed until the entire environment discovery completes.

We can verify the Workspace type by following below steps:

  1. Log into Azure portal
  2. Go to "Azure Synapse Analytics" service
  3. Go to any workspace, which opens the "Overview" page for this workspace. Under the "Essential" panel, click the "JSON view" next to the "Essential" title, and look for "WorkspaceType" there.

[{"Type":"MASTER","Line of Business":{"code":"LOB67","label":"IT Automation \u0026 App Modernization"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSFV9Z","label":"IBM Turbonomic Application Resource Management"},"ARM Category":[{"code":"a8m3p000000PCRUAA4","label":"Target"}],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Versions"}]

Document Information

Modified date:
14 January 2025

UID

ibm17180903

Page Feedback