Create Report in Jaspersoft generate exception getting dataset from cache


Article ID: 39414


Updated On:


Clarity PPM On Premise



Creating a Report in Jaspersoft from an existing Ad Hoc View might fail with the following error message:
java.lang.RuntimeException: exception getting dataset from cache

Steps to Reproduce:

  1. Create an Ad Hoc View.
  2. Add "Investment Name" and "Total Planned Cost" as columns.
  3. Add "Investment Type" as Groups.
  4. Add "Total Planned Cost" as Filters.
  5. Save the Ad Hoc View.
  6. Create a Report selecting the new created Ad Hoc View: "Create" => "Report".
  7. On the Ad Hoc View Report window, Click on the "Options" button.
  8. On Input Controls view, configure the following value for Total Planned Cost: 12340 and click on "Apply".
Expected Result:  The report to be generated filtering the results by the entered Total Planned Cost. 
Actual Result:  The report is not generated and an exception occurs (java.lang.RuntimeException: exception getting dataset from cache).




Caused by CLRT-79604.

A Jaspersoft bug is found when entering a value in the filter with more than 5 digits (without decimals) ending with zero. Ex. 10000.


Applies to CA PPM 14.3 with Jaspersoft version 6.1.1.


This issue is resolved in JSFT v6.2.x