Unable to retrieve metadata through Jaspersoft Studio and Clarity reports

Products

• Clarity PPM SaaS
• Clarity 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 )

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.

Environment

Release:16.0.2
Component: CLARITY

Resolution

Ran the command: admin jaspersoft syncPPMContext -userName superuser -password superuser The reports are now returning fine.