EM 13c : Compliance Standard Target Association Fails: Error occurred while either the Associate Target operation or the Remove Association Operation was still in progress. This error occurs when there is a backlog
(Doc ID 2197414.1)
Last updated on SEPTEMBER 13, 2023
Applies to:
Enterprise Manager Base Platform - Version 13.1.0.0.0 and laterInformation in this document applies to any platform.
Symptoms
Running a Compliance Standard Association job In Enterprise Manager (EM) 13c Cloud Control fails with the following error:
Error occurred while either the Associate Target operation or the Remove Association Operation was still in progress. This error occurs when there is a backlog in batch processing. Retry the operation.
Case 1:
The following is found in the .../gc_inst/em/EMGC_OMS1/sysman/log/emoms.log:
2016-09-27 14:14:09,103 [[ACTIVE] ExecuteThread: '3' for queue: 'weblogic.kernel.Default (self-tuning)'] ERROR console.ConsolePerfCollector logp.251 - Session Expired while processing page with viewId /csTargetAssoc-tfd/csTargetAssoc,so tracing for the page is not recorded. ConsolePerfTraceData is m_uriPath:/em/faces/csTargetAssoc-tfd/csTargetAssoc ; m_viewId:/csTargetAssoc-tfd/csTargetAssoc ; m_jSessionId:oXVrigYl-zA0984Gb63Zoy0hiQxdkpeojofcqtyuTvQGeRMcYpeb!-503732120!1474977984127 ; m_requestReceivedAt:1474978448836 ; m_requestEndTime:1474978449102 ; m_jdbcSelectTime:11 ; m_jdbcFetchTime:11 ; m_noOfSqls:13 ; m_initialRender:false ; m_reqEventType:null ; m_streamRequest:false
2016-09-27 14:14:09,528 [MetricCollector:HOMETAB_THREAD600:60] WARN db.home logp.251 - ora127.md-man.biz::oracle_database::HOMEPAGE_DATA_FROM_TARGET_METRIC: ORA-00904: "BUNDLE_SERIES": invalid identifier
java.sql.SQLSyntaxErrorException: ORA-00904: "BUNDLE_SERIES": invalid identifier
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.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:234)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:55)
at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:829)
at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1049)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1270)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:5010)
at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:5070)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1677)
at oracle.sysman.emSDK.core.util.jdbc.PreparedStatementWrapper.executeQuery(PreparedStatementWrapper.java:408)
at oracle.sysman.emo.perf.metric.rt.DbHomeSummaryForTileMetric.getAllInfoForTile(DbHomeSummaryForTileMetric.java:238)
at oracle.sysman.emo.perf.metric.rt.DbHomeSummaryForTileMetric.getHomeSummaryData(DbHomeSummaryForTileMetric.java:321)
at oracle.sysman.emo.perf.metric.rt.DbHomeSummaryForTileMetric.getData(DbHomeSummaryForTileMetric.java:179)
at oracle.sysman.emo.perf.metric.eng.MetricCached.collectCachedData(MetricCached.java:432)
at oracle.sysman.emo.perf.metric.eng.MetricCollectorThread._collectCachedData(MetricCollectorThread.java:629)
at oracle.sysman.emo.perf.metric.eng.MetricCollectorThread.run(MetricCollectorThread.java:342)
at oracle.sysman.emo.perf.metric.rt.DbMetricCollectorThread.run(DbMetricCollectorThread.java:92)
at java.lang.Thread.run(Thread.java:745)
2016-09-27 14:14:10,282 [[ACTIVE] ExecuteThread: '24' for queue: 'weblogic.kernel.Default (self-tuning)'] ERROR console.ConsolePerfCollector logp.251 - Session Expired while processing page with viewId /csTargetAssoc-tfd/csTargetAssoc,so tracing for the page is not recorded. ConsolePerfTraceData is m_uriPath:/em/faces/csTargetAssoc-tfd/csTargetAssoc ; m_viewId:/csTargetAssoc-tfd/csTargetAssoc ; m_jSessionId:oXVrigYl-zA0984Gb63Zoy0hiQxdkpeojofcqtyuTvQGeRMcYpeb!-503732120!1474977984127 ; m_requestReceivedAt:1474978450016 ; m_requestEndTime:1474978450282 ; m_jdbcSelectTime:7 ; m_jdbcFetchTime:14 ; m_noOfSqls:13 ; m_initialRender:false ; m_reqEventType:null ; m_streamRequest:false
2016-09-27 14:14:09,528 [MetricCollector:HOMETAB_THREAD600:60] WARN db.home logp.251 - ora127.md-man.biz::oracle_database::HOMEPAGE_DATA_FROM_TARGET_METRIC: ORA-00904: "BUNDLE_SERIES": invalid identifier
java.sql.SQLSyntaxErrorException: ORA-00904: "BUNDLE_SERIES": invalid identifier
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.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:234)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:55)
at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:829)
at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1049)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1270)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:5010)
at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:5070)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1677)
at oracle.sysman.emSDK.core.util.jdbc.PreparedStatementWrapper.executeQuery(PreparedStatementWrapper.java:408)
at oracle.sysman.emo.perf.metric.rt.DbHomeSummaryForTileMetric.getAllInfoForTile(DbHomeSummaryForTileMetric.java:238)
at oracle.sysman.emo.perf.metric.rt.DbHomeSummaryForTileMetric.getHomeSummaryData(DbHomeSummaryForTileMetric.java:321)
at oracle.sysman.emo.perf.metric.rt.DbHomeSummaryForTileMetric.getData(DbHomeSummaryForTileMetric.java:179)
at oracle.sysman.emo.perf.metric.eng.MetricCached.collectCachedData(MetricCached.java:432)
at oracle.sysman.emo.perf.metric.eng.MetricCollectorThread._collectCachedData(MetricCollectorThread.java:629)
at oracle.sysman.emo.perf.metric.eng.MetricCollectorThread.run(MetricCollectorThread.java:342)
at oracle.sysman.emo.perf.metric.rt.DbMetricCollectorThread.run(DbMetricCollectorThread.java:92)
at java.lang.Thread.run(Thread.java:745)
2016-09-27 14:14:10,282 [[ACTIVE] ExecuteThread: '24' for queue: 'weblogic.kernel.Default (self-tuning)'] ERROR console.ConsolePerfCollector logp.251 - Session Expired while processing page with viewId /csTargetAssoc-tfd/csTargetAssoc,so tracing for the page is not recorded. ConsolePerfTraceData is m_uriPath:/em/faces/csTargetAssoc-tfd/csTargetAssoc ; m_viewId:/csTargetAssoc-tfd/csTargetAssoc ; m_jSessionId:oXVrigYl-zA0984Gb63Zoy0hiQxdkpeojofcqtyuTvQGeRMcYpeb!-503732120!1474977984127 ; m_requestReceivedAt:1474978450016 ; m_requestEndTime:1474978450282 ; m_jdbcSelectTime:7 ; m_jdbcFetchTime:14 ; m_noOfSqls:13 ; m_initialRender:false ; m_reqEventType:null ; m_streamRequest:false
Case 2:
Error stack from <EM_Instance_Home>/em/EMGC_OMS*/sysman/log/emoms.trc file:
2022-01-18 10:07:21,883 [[ACTIVE] ExecuteThread: '5' for queue: 'weblogic.kernel.Default (self-tuning)'] ERROR assoc.AssociationBean logp.251 - DEBUG AssociationBean() end
2022-01-18 10:07:36,430 [[ACTIVE] ExecuteThread: '8' for queue: 'weblogic.kernel.Default (self-tuning)'] WARN sysman.ComplianceAssocAMImpl logp.251 - SQL Exception
java.sql.SQLException: ORA-20759: Cannot acquire lock
ORA-06512: at "SYSMAN.EM_COMPLIANCE_LOCK", line 111
ORA-06512: at "SYSMAN.EM_COMPLIANCE_LOCK", line 851
ORA-06512: at line 1
at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:495)
.....
at oracle.sysman.core.gccompliance.model.library.standard.assoc.applicationModule.ComplianceAssocAMImpl.lockAssoc(ComplianceAssocAMImpl.java:288)
.....
Caused by: Error : 20759, Position : 0, Sql = BEGIN EM_COMPLIANCE_LOCK.lock_cs_for_assoc( p_critical_edit_version => :1 ); end; , OriginalSql = BEGIN EM_COMPLIANCE_LOCK.lock_cs_for_assoc( p_critical_edit_version => ?); end; , Error Msg = ORA-20759: Cannot acquire lock
ORA-06512: at "SYSMAN.EM_COMPLIANCE_LOCK", line 111
ORA-06512: at "SYSMAN.EM_COMPLIANCE_LOCK", line 851
ORA-06512: at line 1
2022-01-18 10:07:36,430 [[ACTIVE] ExecuteThread: '8' for queue: 'weblogic.kernel.Default (self-tuning)'] WARN sysman.ComplianceAssocAMImpl logp.251 - SQL Exception
java.sql.SQLException: ORA-20759: Cannot acquire lock
ORA-06512: at "SYSMAN.EM_COMPLIANCE_LOCK", line 111
ORA-06512: at "SYSMAN.EM_COMPLIANCE_LOCK", line 851
ORA-06512: at line 1
at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:495)
.....
at oracle.sysman.core.gccompliance.model.library.standard.assoc.applicationModule.ComplianceAssocAMImpl.lockAssoc(ComplianceAssocAMImpl.java:288)
.....
Caused by: Error : 20759, Position : 0, Sql = BEGIN EM_COMPLIANCE_LOCK.lock_cs_for_assoc( p_critical_edit_version => :1 ); end; , OriginalSql = BEGIN EM_COMPLIANCE_LOCK.lock_cs_for_assoc( p_critical_edit_version => ?); end; , Error Msg = ORA-20759: Cannot acquire lock
ORA-06512: at "SYSMAN.EM_COMPLIANCE_LOCK", line 111
ORA-06512: at "SYSMAN.EM_COMPLIANCE_LOCK", line 851
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 |