My Oracle Support Banner

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 JANUARY 27, 2022

Applies to:

Enterprise Manager Base Platform - Version 13.1.0.0.0 and later
Information 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


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

 

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.