<p>Hi All,</p>
<p> </p>
<p>We are using Birt 2.5.1 currently. We have reports that use:</p>
<p> </p>
<div><list-property name="visibility"></div>
<div> <structure></div>
<div> <property name="format">all</property></div>
<div> <expression name="valueExpr">rowsReturned = Total.count();</div>
<div>(Total.count() < 1)</expression></div>
<div> </structure></div>
<div> </list-property></div>
<div> </div>
<div>and it works for all reports. But on a couple of servers we are getting:</div>
<div> </div>
<div>
<div>
<div>Aug 08, 2016 12:13:33 AM org.eclipse.birt.report.model.metadata.ChoicePropertyType</div>
<div>SEVERE: Not found choice: any</div>
<div>Aug 08, 2016 12:13:34 AM org.eclipse.birt.report.model.metadata.ChoicePropertyType</div>
<div>SEVERE: Not found choice: any</div>
<div>Aug 08, 2016 12:13:34 AM org.eclipse.birt.data.engine.odaconsumer.Connection setOdaQuerySpec</div>
<div>INFO: Ignoring the UnsupportedOperationException thrown by ODA driver (org.eclipse.birt.report.data.oda.jdbc) on IQuery#setSpecification.</div>
<div>Aug 08, 2016 12:13:34 AM org.eclipse.birt.report.engine.api.impl.ReportEngine</div>
<div>SEVERE: An error happened while running the report. Cause:</div>
<div>org.mozilla.javascript.EcmaError: ReferenceError: "row" is not defined. (<inline>#1)</div>
<div>at org.mozilla.javascript.ScriptRuntime.constructError(ScriptRuntime.java:3557)</div>
<div>at org.mozilla.javascript.ScriptRuntime.constructError(ScriptRuntime.java:3535)</div>
<div>at org.mozilla.javascript.ScriptRuntime.notFoundError(ScriptRuntime.java:3620)</div>
<div>at org.mozilla.javascript.ScriptRuntime.nameOrFunction(ScriptRuntime.java:1718)</div>
<div>at org.mozilla.javascript.ScriptRuntime.name(ScriptRuntime.java:1657)</div>
<div>at org.mozilla.javascript.gen.c305._c0(<inline>:1)</div>
<div>at org.mozilla.javascript.gen.c305.call(<inline>)</div>
<div>at org.mozilla.javascript.ContextFactory.doTopCall(ContextFactory.java:401)</div>
<div>at org.mozilla.javascript.ScriptRuntime.doTopCall(ScriptRuntime.java:3003)</div>
<div>at org.mozilla.javascript.gen.c305.call(<inline>)</div>
<div>at org.mozilla.javascript.gen.c305.exec(<inline>)</div>
<div>at org.eclipse.birt.report.engine.javascript.JavascriptEngine.evaluate(JavascriptEngine.java:256)</div>
<div>at org.eclipse.birt.core.script.ScriptContext.evaluate(ScriptContext.java:152)</div>
<div>at org.eclipse.birt.report.engine.executor.ExecutionContext.evaluate(ExecutionContext.java:706)</div>
<div>at org.eclipse.birt.report.engine.executor.ExecutionContext.evaluate(ExecutionContext.java:637)</div>
<div>at org.eclipse.birt.report.engine.executor.ReportItemExecutor.evaluateBoolean(ReportItemExecutor.java:309)</div>
<div>at org.eclipse.birt.report.engine.executor.ReportItemExecutor.processVisibility(ReportItemExecutor.java:470)</div>
<div>at org.eclipse.birt.report.engine.executor.TableItemExecutor.execute(TableItemExecutor.java:66)</div>
<div>at org.eclipse.birt.report.engine.internal.executor.wrap.WrappedReportItemExecutor.execute(WrappedReportItemExecutor.java:46)</div>
<div>at org.eclipse.birt.report.engine.internal.executor.emitter.ReportItemEmitterExecutor.execute(ReportItemEmitterExecutor.java:46)</div>
<div>at org.eclipse.birt.report.engine.internal.executor.dup.SuppressDuplicateItemExecutor.execute(SuppressDuplicateItemExecutor.java:43)</div>
<div>at org.eclipse.birt.report.engine.layout.html.HTMLBlockStackingLM.layoutNodes(HTMLBlockStackingLM.java:65)</div>
<div>at org.eclipse.birt.report.engine.layout.html.HTMLPageLM.layout(HTMLPageLM.java:90)</div>
<div>at org.eclipse.birt.report.engine.layout.html.HTMLReportLayoutEngine.layout(HTMLReportLayoutEngine.java:99)</div>
<div>at org.eclipse.birt.report.engine.presentation.ReportDocumentBuilder.build(ReportDocumentBuilder.java:258)</div>
<div>at org.eclipse.birt.report.engine.api.impl.RunTask.doRun(RunTask.java:243)</div>
<div>at org.eclipse.birt.report.engine.api.impl.RunTask.run(RunTask.java:82)</div>
<div>at org.eclipse.birt.report.service.ReportEngineService.runReport(ReportEngineService.java:1263)</div>
<div>at org.eclipse.birt.report.service.BirtViewerReportService.runReport(BirtViewerReportService.java:158)</div>
<div>at org.eclipse.birt.report.service.actionhandler.BirtRunReportActionHandler.__execute(BirtRunReportActionHandler.java:81)</div>
<div>at org.eclipse.birt.report.service.actionhandler.BirtGetPageActionHandler.__checkDocumentExists(BirtGetPageActionHandler.java:58)</div>
<div>at org.eclipse.birt.report.service.actionhandler.AbstractGetPageActionHandler.prepareParameters(AbstractGetPageActionHandler.java:119)</div>
<div>at org.eclipse.birt.report.service.actionhandler.AbstractGetPageActionHandler.__execute(AbstractGetPageActionHandler.java:104)</div>
<div>at org.eclipse.birt.report.service.actionhandler.AbstractBaseActionHandler.execute(AbstractBaseActionHandler.java:90)</div>
<div>at org.eclipse.birt.report.soapengine.processor.AbstractBaseDocumentProcessor.__executeAction(AbstractBaseDocumentProcessor.java:47)</div>
<div>at org.eclipse.birt.report.soapengine.processor.AbstractBaseComponentProcessor.executeAction(AbstractBaseComponentProcessor.java:143)</div>
<div>at org.eclipse.birt.report.soapengine.processor.BirtDocumentProcessor.handleGetPage(BirtDocumentProcessor.java:87)</div>
<div>at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)</div>
<div>at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:94)</div>
<div>at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:55)</div>
<div>at java.lang.reflect.Method.invoke(Method.java:619)</div>
<div>at org.eclipse.birt.report.soapengine.processor.AbstractBaseComponentProcessor.process(AbstractBaseComponentProcessor.java:112)</div>
<div>at org.eclipse.birt.report.soapengine.endpoint.BirtSoapBindingImpl.getUpdatedObjects(BirtSoapBindingImpl.java:66)</div>
<div>at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)</div>
<div>at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:94)</div>
<div>at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:55)</div>
<div>at java.lang.reflect.Method.invoke(Method.java:619)</div>
<div>at org.apache.axis.providers.java.RPCProvider.invokeMethod(RPCProvider.java:397)</div>
<div>at org.apache.axis.providers.java.RPCProvider.processMessage(RPCProvider.java:186)</div>
<div>at org.apache.axis.providers.java.JavaProvider.invoke(JavaProvider.java:323)</div>
<div>at org.apache.axis.strategies.InvocationStrategy.visit(InvocationStrategy.java:32)</div>
<div>at org.apache.axis.SimpleChain.doVisiting(SimpleChain.java:118)</div>
<div>at org.apache.axis.SimpleChain.invoke(SimpleChain.java:83)</div>
<div>at org.apache.axis.handlers.soap.SOAPService.invoke(SOAPService.java:454)</div>
<div>at org.apache.axis.server.AxisServer.invoke(AxisServer.java:281)</div>
<div>at org.apache.axis.transport.http.AxisServlet.doPost(AxisServlet.java:699)</div>
<div>at org.eclipse.birt.report.servlet.BirtSoapMessageDispatcherServlet.doPost(BirtSoapMessageDispatcherServlet.java:265)</div>
<div>at javax.servlet.http.HttpServlet.service(HttpServlet.java:595)</div>
<div>at org.apache.axis.transport.http.AxisServletBase.service(AxisServletBase.java:327)</div>
<div>at javax.servlet.http.HttpServlet.service(HttpServlet.java:668)</div>
<div>at org.eclipse.birt.report.servlet.BirtSoapMessageDispatcherServlet.service(BirtSoapMessageDispatcherServlet.java:122)</div>
<div>at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1230)</div>
<div>at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:779)</div>
<div>at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:478)</div>
<div>at com.ibm.ws.webcontainer.servlet.ServletWrapperImpl.handleRequest(ServletWrapperImpl.java:178)</div>
<div>at com.ibm.ws.webcontainer.filter.WebAppFilterChain.invokeTarget(WebAppFilterChain.java:136)</div>
<div>at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:97)</div>
<div>at org.eclipse.birt.report.filter.ViewerFilter.doFilter(ViewerFilter.java:68)</div>
<div>at com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java:195)</div>
<div>at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:91)</div>
<div>at com.carreker.reportviewer.common.RequestFilter.doFilter(RequestFilter.java:364)</div>
<div>at com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java:195)</div>
<div>at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:91)</div>
<div> </div>
<div>Any help would be appreciated. We are only getting this issue on a couple of environments. I have checked the db query and it executes just fine on the db's, but I think the Total.count does it based on table rows populated correct?</div>
<div> </div>
<div>Anyway...I am stuck on this issue.</div>
<div> </div>
<div>Thanks in advance!</div>
</div>
</div>
<p> </p>
