My Oracle Support Banner

EM 13c: Applying Monitoring Template in Enterprise Manager 13c Cloud Control Fails with Error: ORA-20410: execution_hours must be between 0 and 23 (Doc ID 2767415.1)

Last updated on MARCH 08, 2022

Applies to:

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

Symptoms

Enterprise Manager 13.4 Cloud Control

Applying a Monitoring Template on a database target fails with this error:

ORA-20410: execution_hours must be between 0 and 23

Errors in <EM_INSTANCE>/em/EMGC_OMS<n>/sysman/log/emoms.trc:

2021-04-06 18:40:18,277 [RJob Step 15818182] ERROR applicationModule.ApplyTemplateAMImpl logp.251 - ApplyTemplateAMImpl: applyTemplate :: Sql Exception Error : ORA-20410: execution_hours must be between 0 and 23
ORA-06512: at "SYSMAN.MGMT_TEMPLATE", line 5393
ORA-06512: at "SYSMAN.EM_COLL_UTIL", line 1534
ORA-06512: at "SYSMAN.EM_TASK", line 700
ORA-06512: at "SYSMAN.EM_COLL_UTIL", line 647
ORA-06512: at "SYSMAN.EM_TASK", line 603
ORA-06512: at "SYSMAN.EM_COLL_UTIL", line 1511
ORA-06512: at "SYSMAN.EM_COLL_UTIL", line 5119
ORA-06512: at "SYSMAN.MGMT_MONITORING", line 188
ORA-06512: at "SYSMAN.MGMT_TEMPLATE", line 5280
ORA-06512: at line 1
java.sql.SQLException: ORA-20410: execution_hours must be between 0 and 23
ORA-06512: at "SYSMAN.MGMT_TEMPLATE", line 5393
ORA-06512: at "SYSMAN.EM_COLL_UTIL", line 1534
ORA-06512: at "SYSMAN.EM_TASK", line 700
ORA-06512: at "SYSMAN.EM_COLL_UTIL", line 647
ORA-06512: at "SYSMAN.EM_TASK", line 603
ORA-06512: at "SYSMAN.EM_COLL_UTIL", line 1511
ORA-06512: at "SYSMAN.EM_COLL_UTIL", line 5119
ORA-06512: at "SYSMAN.MGMT_MONITORING", line 188
ORA-06512: at "SYSMAN.MGMT_TEMPLATE", line 5280
ORA-06512: at line 1
at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:495)
at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:447)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1055)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:624)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:253)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:613)
at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:224)
at weblogic.work.SelfTuningWorkManagerImpl.runWorkUnderContext(SelfTuningWorkManagerImpl.java:652)
at weblogic.work.ExecuteThread.execute(ExecuteThread.java:420)
at weblogic.work.ExecuteThread.run(ExecuteThread.java:360)
Caused by: Error : 20410, Position : 0, Sql = begin mgmt_template.save_template_copy_to_target(:1 ,:2 ); end; , OriginalSql = begin mgmt_template.save_template_copy_to_target(?,?); end; , Error Msg = ORA-20410: execution_hours must be between 0 and 23
ORA-06512: at "SYSMAN.MGMT_TEMPLATE", line 5393
ORA-06512: at "SYSMAN.EM_COLL_UTIL", line 1534
ORA-06512: at "SYSMAN.EM_TASK", line 700
ORA-06512: at "SYSMAN.EM_COLL_UTIL", line 647
ORA-06512: at "SYSMAN.EM_TASK", line 603
ORA-06512: at "SYSMAN.EM_COLL_UTIL", line 1511
ORA-06512: at "SYSMAN.EM_COLL_UTIL", line 5119
ORA-06512: at "SYSMAN.MGMT_MONITORING", line 188
ORA-06512: at "SYSMAN.MGMT_TEMPLATE", line 5280
ORA-06512: at line 1
at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:499)
2021-04-06 19:08:15,572 [RJob Step 15816596] WARN applicationModule.ApplyTemplateAMImpl logp.251 - ApplyTemplateAMImpl: applyTemplate operation will be retried :: Sql Exception : ORA-20778: Apply Template failed since Response Metric is not yet associated with target having target_guid = <target guid>
ORA-06512: at "SYSMAN.MGMT_TEMPLATE", line 2963
ORA-06512: at "SYSMAN.MGMT_TEMPLATE", line 4504
ORA-06512: at line 1
java.sql.SQLException: ORA-20778: Apply Template failed since Response Metric is not yet associated with target having target_guid = <target guid>
ORA-06512: at "SYSMAN.MGMT_TEMPLATE", line 2963
ORA-06512: at "SYSMAN.MGMT_TEMPLATE", line 4504
ORA-06512: 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


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