My Oracle Support Banner

EM13c: IP Report Preview Causing : "Error rendering element. Exception: ORA-00942: table or view does not exist" (Doc ID 2642503.1)

Last updated on MARCH 13, 2020

Applies to:

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

Symptoms

In Enterprise Manager (EM) Cloud Control Console level, When scheduling a Information Publisher report or Preview of SQL elements from the report throwing below error.

 

SQL Used to generate the report:

SELECT distinct mt.TARGET_NAME,mt.TARGET_TYPE from
mgmt$target mt left join
GC$EVENTS EV
on
mt.target_guid=ev.TARGET_GUID
and ev.reported_date >= (sysdate -7) and ev.severity in ('Critical')
and (EV.event_name IS NULL)
where mt.TARGET_TYPE='oracle_database'

Error:

Error rendering element. Exception: ORA-00942: table or view does not exist

Changes

 

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
Changes
Cause
Solution


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