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

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.