ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.
CA PPM Jaspersoft Resource Report Error
Article ID: 186823
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
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.
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
Yes
No
Powered by
