My Oracle Support Banner

EM 12c, 13c: Monitoring Template Apply Operation Fails With 'ORA-06533: Subscript Beyond Count ORA-06512: at SYSMAN.MGMT_TEMPLATE' (Doc ID 2634695.1)

Last updated on SEPTEMBER 06, 2021

Applies to:

Enterprise Manager for Oracle Database - Version 12.1.0.5.0 and later
Information in this document applies to any platform.

Symptoms

When trying to apply monitoring template from Enterprise > Monitoring > Monitoring Template > Select the template and apply > Add > Select the target type >  No target displayed (or the intended target not displayed). 

 

Or the monitoring template apply operation fails with error ORA-06533: Subscript beyond count ORA-06512: at "SYSMAN.MGMT_TEMPLATE", line 1348 ORA-06512: at line 1. 

<EM_INSTANCE_BASE>/gc_inst/em/EMGC_OMS1/sysman/log/emoms.trc or emoms_pbs.trc

2020-01-07 16:12:32,917 [RemoteJobWorker 26269] ERROR em.jobs applyTemplate.2384 - PropagateMetricsData: applyTemplate :: Sql Exception
Error : ORA-06533: Subscript beyond count
ORA-06512: at "SYSMAN.MGMT_TEMPLATE", line 4879
ORA-06512: at line 1
java.sql.SQLException: ORA-06533: Subscript beyond count
ORA-06512: at "SYSMAN.MGMT_TEMPLATE", line 4879
ORA-06512: at line 1
       at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:457)
       at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:405)
       at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:889)
       at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:476)
       at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:213)
       at oracle.jdbc.driver.T4CCallableStatement.executeForRows(T4CCallableStatement.java:1075)

 

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


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