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: