Using Underscores in SQL Query state of CA APM Alert.

book

Article ID: 14954

calendar_today

Updated On:

Products

APP PERF MANAGEMENT CA Application Performance Management Agent (APM / Wily / Introscope) CUSTOMER EXPERIENCE MANAGER INTROSCOPE

Issue/Introduction

  What to do about the the underscores in the SQL Query state of a CA APM Alert. These includes special characters in the metric name and need to be replaced with "_".

 



Here are some examples of underscores in a SQL Query state of a CA APM Alert.

<Please see attached file for image>

unknow_underscore.png

Environment

APM 10.x

Resolution

APM Agent does not allow certain characters in the metric name. Also if agent uses some special characters like "|", ":" (pipe and colon) as separators , these are also not allowed in metric name.


SQLAgent tracers also do not allow these special characters in metric name and  must be replaced with "_".

Attachments

1558709345195000014954_sktwi1f5rjvs16rfs.png get_app