My Oracle Support Banner

EM 13c: ORA-01422 Errors Reported when Applying Monitoring Templates with Corrective Actions (Doc ID 2565838.1)

Last updated on JANUARY 19, 2023

Applies to:

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

Symptoms

When applying a monitoring template which includes at least a corrective action, the following error may appear(there can be several different errors):

Error stack 1
-------------
ORA-1422: exact fetch returns more than requested number of rows
ORA-6512: at "SYSMAN.MGMT_JOB_ENGINE", line 11218
ORA-6512: at "SYSMAN.EM_POLICY", line 2894
ORA-6512: at "SYSMAN.EM_POLICY", line 1660
ORA-6512: at "SYSMAN.MGMT_TEMPLATE", line 4395
ORA-6512: at line 1
Error stack 2
-------------
ORA-1422: exact  fetch returns more than requested number of rows
ORA-6512: at "SYSMAN.MGMT_JOB_ENGINE", line 11218
ORA-6512: at "SYSMAN.EM_POLICY", line 2894
ORA-6512: at "SYSMAN.EM_POLICY", line 1755
ORA-6512: at "SYSMAN.MGMT_TEMPLATE", line 4395
ORA-6512: at line 1


Error stack 3
-------------
ORA-1422: exact fetch returns more than requested number of rows
ORA-6512: at "SYSMAN.MGMT_JOB_ENGINE", line 11207
ORA-6512: at "SYSMAN.EM_POLICY", line 2893
ORA-6512: at "SYSMAN.EM_POLICY", line 1754
ORA-6512: at "SYSMAN.EM_POLICY", line 1659
ORA-6512: at "SYSMAN.MGMT_TEMPLATE", line 3734
ORA-6512: at "SYSMAN.MGMT_TEMPLATE", line 4395
ORA-6512: at line 1

Cause

To view full details, sign in with your My Oracle Support account.

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

In this Document
Symptoms
Cause
Solution
References


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