After Jaspersoft upgrade, some reports do not open with error on Input control (How to import Input Control from another environment)

Products

• Clarity PPM On Premise

Issue/Introduction

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

Environment

Release : All Supported Clarity releases with Jaspersoft

Component : CA PPM JASPERSOFT

Resolution

This is caused by a corrupted Input Control.

To fix the issue, import a working input control from another environment as follows:

1. In a working environment, connect to Clarity - Advanced Reporting
2. Go to View - Repository - Input Controls - Common
3. Find the affected Input Control in the list (in this case Project Manager)
4. Right click - select Export - uncheck all options, only leave Dependencies included
5. Save the exported file on your PC
6. Now open the affected environment with the issue
7. Go to Clarity - Advanced Reporting
8. Manage - Organizations - right click on your Organization - select Import
9. Import the file you previously saved. Ensure Update is selected to replace the existing files if same
   Now test again and the issue should be resolved.