EM 13C: Status Of All Jobs Stuck In Scheduled Status
(Doc ID 2926514.1)
Last updated on FEBRUARY 15, 2023
Applies to:
Enterprise Manager Base Platform - Version 13.4.0.0.0 to 13.5.0.0.0 [Release 13c]Information in this document applies to any platform.
Symptoms
All jobs stuck in scheduled status. Testing simple OS job from Job activity page stuck in scheduled status.
Error stack from OMS log :
$EM_INSTANCE_BASE/gc_inst/em/EMGC_OMSn/sysman/log/emoms_pbs.trc
Caused by: Error : 2014, Position : 0, Sql = BEGIN EMDW_LOG.set_context(MGMT_JOB_ENGINE.MODULE_NAME, :1 ); BEGIN EM_JOB_DISPATCH.update_bulk_step_status(:2 ,:3 ,:4 ,:5 ,:6 ,:7 ); END; EMDW_LOG.set_context; END; , OriginalSql = BEGIN EMDW_LOG.set_context(MGMT_JOB_ENGINE.MODULE_NAME, ?); BEGIN EM_JOB_DISPATCH.update_bulk_step_status(?,?,?,?,?,?); END; EMDW_LOG.set_context; END; , Error Msg = ORA-02014: cannot select FOR UPDATE from view with DISTINCT, GROUP BY, etc.
ORA-06512: at "SYSMAN.MGMT_JOB_ENGINE", line 6839
ORA-06512: at "SYSMAN.EM_JOB_LOCKS", line 44
ORA-06512: at "SYSMAN.EM_JOB_OPS", line 2594
ORA-06512: at "SYSMAN.EM_JOB_OPS", line 2687
ORA-06512: at "SYSMAN.EM_JOB_OPS", line 3339
ORA-06512: at "SYSMAN.EM_JOB_OPS", line 3497
ORA-06512: at "SYSMAN.EM_JOB_OPS", line 3449
ORA-06512: at "SYSMAN.MGMT_JOB_ENGINE", line 6829
ORA-06512: at "SYSMAN.MGMT_JOB_ENGINE", line 6995
ORA-06512: at "SYSMAN.MGMT_JOB_ENGINE", line 7720
ORA-06512: at "SYSMAN.MGMT_JOB_ENGINE", line 8177
ORA-06512: at "SYSMAN.MGMT_JOB_ENGINE", line 593
ORA-06512: at "SYSMAN.MGMT_JOB_ENGINE", line 8230
ORA-06512: at "SYSMAN.MGMT_JOB_ENGINE", line 593
ORA-06512: at "SYSMAN.MGMT_JOB_ENGINE", line 8306
ORA-06512: at "SYSMAN.EM_JOB_DISPATCH", line 4116
ORA-06512: at line 1
ORA-06512: at "SYSMAN.MGMT_JOB_ENGINE", line 6839
ORA-06512: at "SYSMAN.EM_JOB_LOCKS", line 44
ORA-06512: at "SYSMAN.EM_JOB_OPS", line 2594
ORA-06512: at "SYSMAN.EM_JOB_OPS", line 2687
ORA-06512: at "SYSMAN.EM_JOB_OPS", line 3339
ORA-06512: at "SYSMAN.EM_JOB_OPS", line 3497
ORA-06512: at "SYSMAN.EM_JOB_OPS", line 3449
ORA-06512: at "SYSMAN.MGMT_JOB_ENGINE", line 6829
ORA-06512: at "SYSMAN.MGMT_JOB_ENGINE", line 6995
ORA-06512: at "SYSMAN.MGMT_JOB_ENGINE", line 7720
ORA-06512: at "SYSMAN.MGMT_JOB_ENGINE", line 8177
ORA-06512: at "SYSMAN.MGMT_JOB_ENGINE", line 593
ORA-06512: at "SYSMAN.MGMT_JOB_ENGINE", line 8230
ORA-06512: at "SYSMAN.MGMT_JOB_ENGINE", line 593
ORA-06512: at "SYSMAN.MGMT_JOB_ENGINE", line 8306
ORA-06512: at "SYSMAN.EM_JOB_DISPATCH", line 4116
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 |
| References |