EM 12c: Enterprise Manager 12c Cloud Control SQL Metric Extension Deployment Fails with Error: ORA-20241: ORA-06502: PL/SQL: numeric or value error: character to number conversion error(store_metric_data_new) (Doc ID 2279667.1)

Last updated on JUNE 30, 2017

Applies to:

Enterprise Manager Base Platform - Version 12.1.0.1.0 and later
Information in this document applies to any platform.

Symptoms

Enterprise Manager (EM) 12.1.0.5 Cloud Control

The following repository database query succeeds:

SELECT
  t.target_guid,
  round(m.value,1) Instance_CPU_Usage_pct
FROM
  mgmt$metric_current m
  JOIN
      mgmt$target t
  ON
      m.target_guid = t.target_guid
WHERE
  t.target_name = 'tname_tname1'
AND
  t.target_type = 'oracle_database'
AND
  metric_guid = 'CADFA1BF3907CA34D1CD1DE4D3E46B9B'


When this query is deployed as a SQL Metric Extension (ME), the test run succeeds, but deployed it gives following error:

JBO-29000: Unexpected exception caught: java.sql.SQLException, msg=ORA-20241: ORA-20241: ORA-06502: PL/SQL: numeric or value error: character to number conversion error(store_metric_data_new)
ORA-06512: at "SYSMAN.MGMT_COLLECTION", line 580
ORA-06512: at line 1
oracle.jbo.JboException: JBO-29000: Unexpected exception caught: java.sql.SQLException, msg=ORA-20241: ORA-20241: ORA-06502: PL/SQL: numeric or value error: character to number conversion error(store_metric_data_new)
ORA-06512: at "SYSMAN.MGMT_COLLECTION", line 580
ORA-06512: at line 1



Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms