EM 13c : ASH Analytics Graph Not Displaying Data In Database Performance Hub Page (Unable to retrieve data.Try again)
(Doc ID 2876266.1)
Last updated on SEPTEMBER 20, 2022
Applies to:
Enterprise Manager for Oracle Database - Version 13.4.1.0.0 and laterInformation in this document applies to any platform.
Symptoms
OEM 13.4.0.0.0
ASH analytics graph not displaying data, an error message on page says "Unable to retrieve data.Try again"
EMOMS.trc errors:
2022-06-08 11:15:54,501 [MetricCollector:HOMETAB_THREAD600:60] WARN client.RepositoryUtils logp.251 - getting unrestricted (private/repository owner) connection
2022-06-08 11:15:54,511 [MetricCollector:HOMETAB_THREAD600:60] WARN client.RepositoryUtils logp.251 - getting unrestricted (private/repository owner) connection
2022-06-08 11:16:34,240 [EMUI_11_16_34_/console/database/instance/<dbname>/ash/viewer/perf/sqltext] ERROR reports.CommonXMLReportGenerator logp.251 - Unexpected exception executing SQL: SELECT sys.dbms_ash.getSqlText(p_dbid=> ?, p_sql_ids=> ?).getClobVal(2,2) AS output FROM dual, Error: ORA-00904: "SYS"."DBMS_ASH"."GETSQLTEXT": invalid identifier
2022-06-08 11:22:31,350 [[ACTIVE] ExecuteThread: '0' for queue: 'weblogic.kernel.Default (self-tuning)'] WARN toaster.MessageBroker logp.251 - WARNING! No Subscriber MQ with session Id: T3FDra_UqXSLCY6c5c2GlMjN6cZef8lm2kOYdRq0mxOH1K1PzWsg!729999196!1654697841257
2022-06-08 11:24:58,857 [[ACTIVE] ExecuteThread: '42' for queue: 'weblogic.kernel.Default (self-tuning)'] ERROR console.ConsolePerfCollector logp.251 - Session Expired while processing page with viewId null,so tracing for the page is not recorded. ConsolePerfTraceData is m_uriPath:/em/console/database/instance/<dbname>/ash/viewer/perf/timepicker/realtime ; m_viewId:null ; m_jSessionId:wUBDa3dsGLlSAQYEN9fJpSljWey_fwanDWZwQYm9tSx5k6gKaXuU!729999196!1654693517896 ; m_requestReceivedAt:1654701893172 ; m_requestEndTime:1654701898857 ; m_jdbcSelectTime:1420 ; m_jdbcFetchTime:3 ; m_noOfSqls:19 ; m_initialRender:false ; m_reqEventType:null ; m_streamRequest:false
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 |