Problem

As part of the installation process of Central Governance and Sentinel, the data.xml file must be updated, by replacing all occurrences of @SCHEMA@ with the Sentinel database schema name.

This was not done, leading to errors like this in the SentinelWebDashboards.log file:

2017-05-12 11:26:07,790 ERROR [qtp935044096-52] interfaces.DashboardException (DashboardException.java:46) - com.prelytis.dashboard.interfaces.DashboardException: java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist

2017-05-12 11:26:07,790 ERROR [qtp935044096-52] interfaces.DashboardException (DashboardException.java:53) - java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist

Resolution

1. Modify the data.xml and put in the correct values as above.

2. Suppress the previously imported dashboards: In the CG admin interface, go to Sentinel Webdashboards, and under Dashboard Design, delete all the links, reports and dashboards. (If you can't delete any particular object, use the Dependency button to check what existing objects depend on it.)

3. You should then be able to successfully reimport the data.xml file.