|Applies To||RSA Product Set: Identity Governance & Lifecycle|
RSA Version/Condition: 7.x
|Issue||When building a custom report in RSA Identity Governance & Lifecycle (Reports > Tabular > Create Report > Query tab), the following error occurs when testing the SQL statement in the FROM clause:|
This occurs when using a public view (a view prefaced with PV_) and it can be seen in the AVUSER schema.
|Cause||The RSA Identity Governance & Lifecycle Report module points to schema AVDWUSER and not AVUSER.|
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.
|Workaround||A workaround would be to preface the view name with the AVUSER schema name as in:|
Change the query from: