AnsweredAssumed Answered

Jaspersoft:  Exception getting data strategy; does not exist

Question asked by Dale_Stockman Champion on Aug 30, 2017
Latest reply on Sep 11, 2017 by GeorgSchmid2014

Getting odd errors when saving/running Jaspersoft ad hoc report.  Why odd?  Well, the ad hoc view works perfect - only when I try to save/run as a report do I get these errors:

 

- java.lang.illegalArguementException: resource id:  RiskScore_1 does not exist

- exception getting data strategy

 

Google search and search of Jaspersoft site produced no applicable results.

 

Both errors are related to filters, which are based on calculated fields:

 

  • Calculated Risk Score is not available for export to DWH (unchecked box shaded out/not editable on attribute in Risk Object)
  • So, I use Risk Impact and Risk Probability in Jaspersoft to calculate the Risk Score
    • Create Risk Probability Number (RPN) and Risk Impact Number (RIN) fields using CASEWHEN function to convert Low, Medium, High to 1, 2, 3
    • Create a Risk Score Number field which is the calculated value (multiple) of RPN and RIN
    • Create a Risk Score field using CASEWHEN to convert numeric result back into readable Low, Medium, High text
  • In the column section of ad hoc view, I place Risk Score - users can read the Low, Medium, High values
  • All good
  • I then create Risk Score as a filter
    • Set filter to "High"
    • Apply - get expected results to display
    • Save ad hoc view
    • All good
  • Then, create Report from ad hoc view
    • Expect report to save
    • Instead, get error message:  java.lang.illegalArguementException: resource id:  RiskScore_1 does not exist
  • Next,
    • remove Risk Score as filter from ad hoc view
    • Create filter from Risk Score Number
    • Set filter to ">=6"
    • Apply - get expected results to display
    • Save ad hoc view
    • All good
  • Then, create Report from ad hoc view
    • Expect Report to save
    • Instead get error message:  exception getting data strategy
    • (BTW - fed up with the "Please excuse the inconvenience" message in the error window...c'mon, give me something useful, please.")
  • Next, remove Risk Score filter from ad hoc view
    • no filters of any kind left related risk score, impact, probably, whether numbers or text
    • Save ad hoc view
    • All good
  • Then, create Report from ad hoc view
    • Expect Report to save
    • It does
    • Report runs
    • Would be fine, but I can't filter for the "High"/">=6" risks.

 

Any ideas?

 

Odd that these filters work fine in ad hoc view, but then report says field doesn't exist or can't get a 'strategy' - maybe there's an error but these are the wrong messages?

 

Open to any ideas.

 

Dale

Outcomes