After we upgraded Jaspersoft, some of the reports do not work in Advanced Reporting. When we click we immediately see an error message:
2020-01-29 11:34:49,834 ERROR JRQueryExecuterAdapter,http-nio-8080-exec-10:152 [ca_tech|admin] - Error while executing query
net.sf.jasperreports.engine.JRException: Error executing SQL statement for: projectManager.
Caused by: java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist
We tried running the Jaspersoft commands and also the Data Warehouse job and still have this issue. When running the SQL query for the Input control it works well and retrieves the results
Release : All Supported Clarity releases with Jaspersoft
Component : CA PPM JASPERSOFT
This is caused by a corrupted Input Control.
To fix the issue, import a working input control from another environment as follows: