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

Document ID : KB000011141
Last Modified Date : 14/02/2018
Show Technical Document Details
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