com.aveksa.server.runtime.ServerException:
com.aveksa.server.runtime.ServerException:
java.sql.SQLSyntaxErrorException: ORA-00942:
table or view does not exist
AVDWUSER is the schema where all the public views referred to in the RSA Identity Governance and Lifecycle <version> Public Database Schema Reference Guide are stored. Click the link to find the documentation for your version.
Public views in AVUSER are defined as synonyms in AVDWUSER. To resolve this issue, rewrite your query to refer to the public view names in the public database schema.
For example, PV_ACCOUNT in AVUSER is ACCOUNT in AVDWUSER. Rewrite a query referring to this view as in the example below.
Change the query from:
(SELECT * FROM PV_ACCOUNT)to:
(SELECT * FROM ACCOUNT)
Note: Queries in report definitions must be surrounded by parentheses.
(SELECT * FROM PV_ACCOUNT)to:
(SELECT * FROM AVUSER.PV_ACCOUNT)