MSSQL Extension fails to load metrics -ImproperlyFormattedMetricNameException:

Products

• CA Application Performance Management SaaS

Issue/Introduction

Testing new Windows Infrastructure Agent v21.4.0.26 and the MS SQL Extension. Extension fails to load metrics and returns errors:

 

 [ERROR] [IntroscopeAgent.DBMonitor] 
com.wily.introscope.agent.api.ImproperlyFormattedMetricNameException: "SQL SERVER Databases|SVR.test.BRCM.com||Databases|WebCheck" is not a legal Metric name.

Environment

Release : SAAS

Component : Integration with APM

Cause

The double pipe in the metric name seems to be the cause.

Resolution

Try setting this value in the bundle.properties

introscope.agent.dbmonitor.sqlserver.profiles.db1.instanceName=default