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 13.4.1.0.0 and later
Information 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


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