[Adhoc report] Unknown field when hiding detail lines

[vincentc]

 

Hello,

We have something that looks like a bug on JasperServer 4.5.

This happens when we created an Ad Hoc report ('table') and we choose to "Hide detail lines." When we execute the report, we get this error message:

2012-03-21 09:59:54,170 ERROR errorPage_jsp, http-80-1: 487 - stack trace of exception That redirected to errorPage.jsp
com.jaspersoft.jasperserver.api.JSException: error setting up deferral
Has com.jaspersoft.ji.adhoc.action.ViewAdhocReportAction.runReport (ViewAdhocReportAction.java: 203)
at sun.reflect.NativeMethodAccessorImpl.invoke0 (Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke (NativeMethodAccessorImpl.java: 39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke (DelegatingMethodAccessorImpl.java: 25)
at java.lang.reflect.Method.invoke (Method.java: 597)
[... ]

Caused by: java.lang.IllegalArgumentException: unknown field [our_field]_count
at
at
Has net.sf.jasperreports.engine.fill.JRFillDataset.setOldValues ​​(JRFillDataset.java: 895)
Has net.sf.jasperreports.engine.fill.JRFillDataset.next (JRFillDataset.java: 860)
Has net.sf.jasperreports.engine.fill.JRFillDataset.next (JRFillDataset.java: 837)
Has net.sf.jasperreports.engine.fill.JRBaseFiller.next (JRBaseFiller.java: 1434)
Has net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport (JRVerticalFiller.java: 126)
Has net.sf.jasperreports.engine.fill.JRBaseFiller.fill (JRBaseFiller.java: 836)
Has net.sf.jasperreports.engine.fill.JRBaseFiller.fill (JRBaseFiller.java: 765)
Has com.jaspersoft.ji.engine.ProEngineServiceImpl.fillReport (ProEngineServiceImpl.java: 253)
Has com.jaspersoft.ji.adhoc.service.AdhocEngineServiceImpl.fillReport (AdhocEngineServiceImpl.java: 662)
Has com.jaspersoft.ji.adhoc.service.AdhocEngineServiceImpl.fillReport (AdhocEngineServiceImpl.java: 2158)
Has com.jaspersoft.ji.adhoc.service.AdhocEngineServiceImpl.fillReport (AdhocEngineServiceImpl.java: 2087)
Has com.jaspersoft.ji.adhoc.action.ViewAdhocReportAction.runReport (ViewAdhocReportAction.java: 163)

I noticed that these are the automatic calculations made by Jasper (total, sums ...) that are a problem.
When we execute the report with "Displaying the detail lines," everything is OK (no crash).
Anyone know there a workaround for this problem??
Thank you very much in advance
Vincent

[twmoore]

Virginia Tech is also seeing this issue.  We are seeing some major bugs in the Ad Hoc editor that are causing Ad Hocs to no longer run correctly.

A list of bugs that will be included in the next release, that was supposed to be out by now, would be extremely helpful.