CA PPM Jaspersoft Resource Report Error
Article ID: 186823
Clarity PPM SaaS
When running any Resource Based Reports via Advance Reporting / Jaspersoft the Parameter Panel is Blank
Error in the logs:
ORA-00933: SQL command not properly ended java.sql.SQLException: ORA-00933: SQL command not properly endedollowing error
DWH_BOOLEAN_TO_INT_FCT": invalid identifier
Release : 15.7.1
Component : CA PPM SAAS APPLICATION
The OOTB report was overwritten:
Export the same report from another environment and import into the environment when we see the issue.
Note: Please make sure that both environments have same PPM Versions.