EM13c : Compliance Standard Target Association in Cloud Control Fails or Leaves Targets in Pending Status

(Doc ID 2197389.1)

Last updated on OCTOBER 31, 2017

Applies to:

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

Symptoms

 

An agent-side compliance standard created in Enterprise Manager (EM) 13c Cloud Control fails to associate for some targets and leaves others in a pending state.

Here is an example of the EM 13c Compliance Standard Association page with several targets in these fault conditions (scroll over):

 

 

 

From 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)

 

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms