Using Underscores in SQL Query state of CA APM Alert.

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>

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 "_".