000027957 - KB-1436 - ORA-00942 error when defining a query in a custom report

Document created by RSA Customer Support Employee on Jun 14, 2016Last modified by RSA Customer Support Employee on Apr 21, 2017
Version 2Show Document
  • View in full screen mode

Article Content

Article Number000027957
Applies ToAffected Versions: 4.X
Resolution

When building a custom report (Reports>>Tabular>>'Create Report'), you may encounter the following error upon building your SQL statement under the 'Query' tab in the 'Create New Report' window:


ORA-00942: table or view does not exist


This issue will be addressed in a future release of ACM. To resolve this issue, please include the schema name (AVUSER.) as a prefix before the FROM clause in the SQL statement. This will resolve the error, and allow the query to succeed within the report builder.


For example, instead of:


SELECT pvr.name, pvr.end_date as "End Date"
FROM PV_REVIEW...


You may use:


SELECT pvr.name, pvr.end_date as "End Date"


FROM AVUSER.PV_REVIEW pvr


Please note that it's good practice to test your SQL query in a SQL client first, before constructing your SQL statement in the Report builder.

Attachments

    Outcomes