Cannot run the custom report from Advance Reporting

Products

• Clarity PPM SaaS
• Clarity PPM On Premise

Issue/Introduction

When we are trying to run the report from the Jaspersoft Studio, the report is successful, but when the same report tries to run from Advance Reporting, we are getting the error like this:

Error preparing statement for executing the report query:

Cause

The Custom Report has wrong DB provider

Resolution

- Log into Jaspersoft Studio

- Refresh the Report the Report in Jaspersoft Studio

- Once Refreshed - When publishing the report - select the correct DB and then Published.

- Once the report published then refresh the Advance Reporting and select the report - run the report.