My Oracle Support Banner

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 and later
Information in this document applies to any platform.


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



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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.