After upgrading Jaspersoft, some of the reports do not work in Advanced Reporting. When you click, you 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
Running the Jaspersoft commands and also the Data Warehouse job does not help. When running the SQL query for the Input control, it works well and retrieves the results
Release : All Supported Clarity releases with Jaspersoft
This is caused by a corrupted Input Control.
Import a working input control from another environment as follows: