"SQL invalid metric name errors" are filling up the Java agent log.

Document ID:  TEC603766
Last Modified Date:  08/02/2017
{{active ? 'Hide' : 'Show'}} Technical Document Details

Products

  • CA Application Performance Management
  • CA Introscope

Releases

  • CA Introscope:Release:9.1
  • CA Application Performance Management:Release:10.0
  • CA Application Performance Management:Release:10.1
  • CA Application Performance Management:Release:10.2
  • CA Application Performance Management:Release:10.3
  • CA Application Performance Management:Release:10.5
  • CA Application Performance Management:Release:10.5.1
  • CA Application Performance Management:Release:10.5.2
  • CA Application Performance Management:Release:CA APM 9.6
  • CA Application Performance Management:Release:CA APM 9.7

Components

  • INTROSCOPE:INTSCP
Introduction:

 Java Agent logs are being filled up with this message:

[ERROR] [IntroscopeAgent.Agent] Attempted to create a metric with the invalid metric name "Backends|ABCDlxyz ab1cdef-1234 (SOME
DB)|SQL|Dynamic|Update|UPDATE cc_systemparameter SET Value='abcd6efGhijk3lMNo9pqr0sTUVWXxyz18=' WHERE LOWER(Name) =
'chksum_up_st:loadupdatestatisticsSELECT:Responses Per Interval".

Question:

 What does the above message error over Agent log mean? Can it be disabled?

Environment:
All supported APM releases.
Answer:

This error is generated because the input SQL String contains an extra colon which is not a valid character for a metric name.

The input SQL String contains an extra colon in the string ('chksum_dm_pl:loadupdatestatisticsSELECT), which is not a valid character for a metric name. Also like ('%' || ? || '%'):

These and other invalid characters are automatically removed by the Default SQL Normalizer that is built into the SQL Agent extension.

However, when a custom normalizer is enabled in the Agent's.profile, this default normalizer is turned off.

Please configure following property inside your Agent profile:

introscope.agent.sqlagent.normalizer.extension.runPredefinedScheme=true


Please help us improve!

Will this information enable you to resolve your issue?

Please tell us what we can do better.

{{feedbackText.length ? feedbackText.length : '0'}}/255

{{status}}

Not what you were looking for?

Search Again >

Product Information

Support by Product >

Communities

Join a Community >