Unable to retrieve metadata through Jaspersoft Studio and Clarity reports
Article ID: 111830
Clarity PPM SaaS
Clarity PPM On Premise
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 )
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.
Ran the command: admin jaspersoft syncPPMContext -userName superuser -password superuser The reports are now returning fine.