My Oracle Support Banner

EM13c : Error ORA-00936 Reported Against 18c AWR Warehouse Viewing ASH Analytics Historical (Doc ID 2602842.1)

Last updated on OCTOBER 23, 2019

Applies to:

Enterprise Manager for Oracle Database - Version 13.2.0.0.0 and later
Information in this document applies to any platform.

Symptoms

In Enterprise Manager (EM) Cloud Control, trying to view ASH Analytics Historical with data from 18c AWR Warehouse source results in ORA-00936 error.

Error Stack Observed from <EM_INSTANCE_HOME>/em/EMGC_OMS*/sysman/log/emoms.trc file:

[EMUI_12_11_44_/console/database/instance/orarep/ash/viewer] DEBUG reports.CentralAwrXMLReportGenerator logp.251 - Error ORA-00936: missing expression
ORA-06512: at "DBSNMP.DBMS_ASHVIEWER_MULTIDB", line 4629
ORA-06512: at "DBSNMP.DBMS_ASHVIEWER_MULTIDB", line 4853
ORA-06512: at line 2 java.sql.SQLSyntaxErrorException: ORA-00936: missing expression
ORA-06512: at "DBSNMP.DBMS_ASHVIEWER_MULTIDB", line 4629
ORA-06512: at "DBSNMP.DBMS_ASHVIEWER_MULTIDB", line 4853
ORA-06512: at line 2

 

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.