CA PPM Jaspersoft Resource Report Error
book
Article ID: 186823
calendar_today
Updated On:
Products
Clarity PPM SaaS
Issue/Introduction
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
Environment
Release : 15.7.1
Component : CA PPM SAAS APPLICATION
Resolution
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.
Feedback
thumb_up
Yes
thumb_down
No