EM 13c: Applying Monitoring Template Fails With ORA-01422 : exact fetch returns more than the requested number of rows (Doc ID 2334608.1)

Last updated on APRIL 19, 2023

Applies to:

Symptoms

Attempting to apply monitoring templates with CA to database instance targets, fails with:

ORA-01422: exact fetch returns more than requested number of rows

-  The <gc_inst>/em/EMGC_OMS1/sysman/log/emoms.trc reports:

2017-11-29 13:21:22,377 [RJob Step 4564631] ERROR applicationModule.ApplyTemplateAMImpl logp.251 - ApplyTemplateAMImpl: applyTemplate :: Sql Exception Error : 
ORA-01422: exact fetch returns more than requested number of rows
ORA-06512: at "SYSMAN.MGMT_JOB_ENGINE", line 11086
ORA-06512: at "SYSMAN.EM_POLICY", line 2887
ORA-06512: at "SYSMAN.EM_POLICY", line 1753
ORA-06512: at "SYSMAN.EM_POLICY", line 1659
ORA-06512: at "SYSMAN.MGMT_TEMPLATE", line 3727
ORA-06512: at "SYSMAN.MGMT_TEMPLATE", line 4388
ORA-06512: at line 1

java.sql.SQLException: ORA-01422: exact fetch returns more than requested number of rows
ORA-06512: at "SYSMAN.MGMT_JOB_ENGINE", line 11086
ORA-06512: at "SYSMAN.EM_POLICY", line 2887
ORA-06512: at "SYSMAN.EM_POLICY", line 1753
ORA-06512: at "SYSMAN.EM_POLICY", line 1659
ORA-06512: at "SYSMAN.MGMT_TEMPLATE", line 3727
ORA-06512: at "SYSMAN.MGMT_TEMPLATE", line 4388
ORA-06512: at line 1

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:466)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:407)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1113)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:546)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:269)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:603)
at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:228)
at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:49)
...............

-  Details of the template shows that the same CA was used for both Warning and Critical thresholds, for some of the metrics in the template.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.