Unable to retrieve metadata through Jaspersoft Studio and Clarity reports
book
Article ID: 111830
calendar_today
Updated On:
Products
Clarity PPM SaaSClarity PPM On Premise
Issue/Introduction
After environment migration, we have been unable to retrieve metadata through Jaspersoft studio and Clarity reports (e.g. “Database Connection Check: Data Warehouse” Report in Advanced Reporting )
Environment
Release:16.0.2 Component: CLARITY
Cause
On webex with Ops confirmed Load DWH is running fine, whilst reports are giving error message:
java.sql.SQLRecoverableException: ORA-01033: ORACLE initialization or shutdown in progress
Confirmed data is correct in the properties.xml file - the JS db connection was probably not updated in Jaspersoft. If something else was affected, it would have impacted the DWH job.
Resolution
Ran the command: admin jaspersoft syncPPMContext -userName superuser -password superuser The reports are now returning fine.