hello Brian,
it have six reports in the reports folder, Customer Phone number List and Product List are run properly, but the others are not working(error), I have all data, Other than it needs any configuration particularly for this?
i run the report Orders in Last 30 days i got the following error.
The following items have errors:
Chart Orders in the Last 30 Days (Chart Only):
+ There are errors evaluating script "row["ddmon"]".
Error.ScriptEvaluationError ( 30 time(s) )
detail : org.eclipse.birt.report.engine.api.EngineException: There are errors evaluating script "row["ddmon"]".
at org.eclipse.birt.report.engine.executor.ExecutionContext.evaluate(ExecutionContext.java:557)
at org.eclipse.birt.report.engine.executor.ExecutionContext.evaluate(ExecutionContext.java:529)
at org.eclipse.birt.report.engine.data.dte.DteResultSet.evaluate(DteResultSet.java:326)
at org.eclipse.birt.report.engine.extension.internal.RowSet.evaluate(RowSet.java:113)
at org.eclipse.birt.chart.reportitem.BIRTDataRowEvaluator.evaluate(BIRTDataRowEvaluator.java:44)
at org.eclipse.birt.chart.internal.datafeed.DataProcessor.mapToChartResultSet(DataProcessor.java:584)
at org.eclipse.birt.chart.internal.datafeed.DataProcessor.generateRuntimeSeries(DataProcessor.java:715)
at org.eclipse.birt.chart.factory.Generator.bindData(Generator.java:559)
at org.eclipse.birt.chart.reportitem.ChartReportItemPresentationImpl.onRowSets(ChartReportItemPresentationImpl.java:399)
at org.eclipse.birt.report.engine.presentation.LocalizedContentVisitor.processExtendedContent(LocalizedContentVisitor.java:653)
at org.eclipse.birt.report.engine.presentation.LocalizedContentVisitor.visitForeign(LocalizedContentVisitor.java:359)
at org.eclipse.birt.report.engine.content.impl.ForeignContent.accept(ForeignContent.java:58)
at org.eclipse.birt.report.engine.presentation.LocalizedContentVisitor.localize(LocalizedContentVisitor.java:111)
at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
at java.lang.Thread.run(Thread.java:595)
Caused by: org.mozilla.javascript.EvaluatorException: org.eclipse.birt.data.engine.core.DataException: Invalid expression to retrieve value in presentation.
at org.eclipse.birt.report.engine.data.dte.NativeRowObject.get(NativeRowObject.java:93)
at org.mozilla.javascript.ScriptableObject.getProperty(ScriptableObject.java:1263)
at org.mozilla.javascript.ScriptRuntime.getObjectElem(ScriptRuntime.java:1301)
at org.mozilla.javascript.ScriptRuntime.getObjectElem(ScriptRuntime.java:1283)
at org.mozilla.javascript.gen.c189._c0(<inline>:1)
at org.mozilla.javascript.gen.c189.call(<inline>)
at org.mozilla.javascript.ContextFactory.doTopCall(ContextFactory.java:304)
at org.mozilla.javascript.ScriptRuntime.doTopCall(ScriptRuntime.java:2769)
at org.mozilla.javascript.gen.c189.call(<inline>)
at org.mozilla.javascript.gen.c189.exec(<inline>)
at org.eclipse.birt.core.script.ScriptContext.eval(ScriptContext.java:223)
at org.eclipse.birt.report.engine.executor.ExecutionContext.evaluate(ExecutionContext.java:550)
... 70 more
+ There are errors evaluating script "row["order_count"]".
Error.ScriptEvaluationError ( 30 time(s) )
detail : org.eclipse.birt.report.engine.api.EngineException: There are errors evaluating script "row["order_count"]".
at org.eclipse.birt.report.engine.executor.ExecutionContext.evaluate(ExecutionContext.java:557)
at org.eclipse.birt.report.engine.executor.ExecutionContext.evaluate(ExecutionContext.java:529)
at org.eclipse.birt.report.engine.data.dte.DteResultSet.evaluate(DteResultSet.java:326)
at org.eclipse.birt.report.engine.extension.internal.RowSet.evaluate(RowSet.java:113)
at org.eclipse.birt.chart.reportitem.BIRTDataRowEvaluator.evaluate(BIRTDataRowEvaluator.java:44)
at org.eclipse.birt.chart.internal.datafeed.DataProcessor.mapToChartResultSet(DataProcessor.java:584)
at org.eclipse.birt.chart.internal.datafeed.DataProcessor.generateRuntimeSeries(DataProcessor.java:715)
at org.eclipse.birt.chart.factory.Generator.bindData(Generator.java:559)
at org.eclipse.birt.chart.reportitem.ChartReportItemPresentationImpl.onRowSets(ChartReportItemPresentationImpl.java:399)
at org.eclipse.birt.report.engine.presentation.LocalizedContentVisitor.processExtendedContent(LocalizedContentVisitor.java:653)
at org.eclipse.birt.report.engine.presentation.LocalizedContentVisitor.visitForeign(LocalizedContentVisitor.java:359)
at org.eclipse.birt.report.engine.content.impl.ForeignContent.accept(ForeignContent.java:58)
at org.eclipse.birt.report.engine.presentation.LocalizedContentVisitor.localize(LocalizedContentVisitor.java:111)
at org.eclipse.birt.report.engine.internal.executor.l18n.LocalizedReportItemExecutor.execute(LocalizedReportItemExecutor.java:38)
at org.eclipse.birt.report.engine.internal.executor.l18n.LocalizedReportExecutor.execute(LocalizedReportExecutor.java:90)
at org.eclipse.birt.report.engine.internal.executor.l18n.LocalizedReportExecutor.execute(LocalizedReportExecutor.java:98)
at org.eclipse.birt.report.engine.internal.executor.l18n.LocalizedReportExecutor.execute(LocalizedReportExecutor.java:98)
at org.eclipse.birt.report.engine.internal.executor.l18n.LocalizedReportExecutor.execute(LocalizedReportExecutor.java:98)
at org.eclipse.birt.report.engine.internal.executor.l18n.LocalizedReportExecutor.execute(LocalizedReportExecutor.java:98)
at org.eclipse.birt.report.engine.internal.executor.l18n.LocalizedReportExecutor.execute(LocalizedReportExecutor.java:77)
at org.eclipse.birt.report.engine.internal.document.v3.ReportContentLoaderV3.loadPage(ReportContentLoaderV3.java:51)
... 70 more
I run Top Ten Customers By Amount of Orders i got the following error
The following items have errors:
Chart Top10CustomersChart:
+ There are errors evaluating script "row["customers_lastname"]".
Error.ScriptEvaluationError ( 1 time(s) )
detail : org.eclipse.birt.report.engine.api.EngineException: There are errors evaluating script "row["customers_lastname"]".
at org.eclipse.birt.report.engine.executor.ExecutionContext.evaluate(ExecutionContext.java:557)
at org.eclipse.birt.report.engine.executor.ExecutionContext.evaluate(ExecutionContext.java:529)
at org.eclipse.birt.report.engine.data.dte.DteResultSet.evaluate(DteResultSet.java:326)
at org.eclipse.birt.report.engine.extension.internal.RowSet.evaluate(RowSet.java:113)
at org.eclipse.birt.chart.reportitem.BIRTDataRowEvaluator.evaluate(BIRTDataRowEvaluator.java:44)
at org.eclipse.birt.chart.internal.datafeed.DataProcessor.mapToChartResultSet(DataProcessor.java:584)
at org.eclipse.birt.chart.internal.datafeed.DataProcessor.generateRuntimeSeries(DataProcessor.java:715)
at org.eclipse.birt.chart.factory.Generator.bindData(Generator.java:559)
at org.eclipse.birt.chart.reportitem.ChartReportItemPresentationImpl.onRowSets(ChartReportItemPresentationImpl.java:399)
at org.eclipse.birt.report.engine.presentation.LocalizedContentVisitor.processExtendedContent(LocalizedContentVisitor.java:653)
at org.eclipse.birt.report.engine.presentation.LocalizedContentVisitor.visitForeign(LocalizedContentVisitor.java:359)
at org.eclipse.birt.report.engine.content.impl.ForeignContent.accept(ForeignContent.java:58)
at org.eclipse.birt.report.engine.presentation.LocalizedContentVisitor.localize(LocalizedContentVisitor.java:111)
at org.eclipse.birt.report.engine.internal.executor.l18n.LocalizedReportItemExecutor.execute(LocalizedReportItemExecutor.java:38)
at org.eclipse.birt.report.engine.internal.executor.l18n.LocalizedReportExecutor.execute(LocalizedReportExecutor.java:90)
at org.eclipse.birt.report.engine.internal.executor.l18n.LocalizedReportExecutor.execute(LocalizedReportExecutor.java:98)
at org.eclipse.birt.report.engine.internal.executor.l18n.LocalizedReportExecutor.execute(LocalizedReportExecutor.java:98)
at org.eclipse.birt.report.engine.internal.executor.l18n.LocalizedReportExecutor.execute(LocalizedReportExecutor.java:98)
at org.eclipse.birt.report.engine.internal.executor.l18n.LocalizedReportExecutor.execute(LocalizedReportExecutor.java:98)
at org.eclipse.birt.report.engine.internal.executor.l18n.LocalizedReportExecutor.execute(LocalizedReportExecutor.java:77)
at org.eclipse.birt.report.engine.internal.document.v3.ReportContentLoaderV3.loadPage(ReportContentLoaderV3.java:51)
at org.eclipse.birt.report.engine.internal.document.ReportContentLoader.loadPage(ReportContentLoader.java:55)
at org.eclipse.birt.report.engine.api.impl.RenderTask.doRender(RenderTask.java:248)
at org.eclipse.birt.report.engine.api.impl.RenderTask$PageRender.render(RenderTask.java:702)
at org.eclipse.birt.report.engine.api.impl.RenderTask.render(RenderTask.java:613)
at org.eclipse.birt.report.service.ReportEngineService.renderReport(Unknown Source)
at org.eclipse.birt.report.service.ReportEngineService.renderReport(Unknown Source)
at org.eclipse.birt.report.service.BirtViewerReportService.getPage(Unknown Source)
at org.eclipse.birt.report.service.actionhandler.AbstractGetPageActionHandler.doExecution(Unknown Source)
at org.eclipse.birt.report.service.actionhandler.AbstractGetPageActionHandler.__execute(Unknown Source)
at org.eclipse.birt.report.service.actionhandler.AbstractBaseActionHandler.execute(Unknown Source)
at org.eclipse.birt.report.soapengine.processor.AbstractBaseDocumentProcessor.__executeAction(Unknown Source)
at org.eclipse.birt.report.soapengine.processor.AbstractBaseComponentProcessor.executeAction(Unknown Source)
org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
at java.lang.Thread.run(Thread.java:595)
Caused by: org.mozilla.javascript.EvaluatorException: org.eclipse.birt.data.engine.core.DataException: Invalid expression to retrieve value in presentation.
at org.eclipse.birt.report.engine.data.dte.NativeRowObject.get(NativeRowObject.java:93)
at org.mozilla.javascript.ScriptableObject.getProperty(ScriptableObject.java:1263)
at org.mozilla.javascript.ScriptRuntime.getObjectElem(ScriptRuntime.java:1301)
at org.mozilla.javascript.ScriptRuntime.getObjectElem(ScriptRuntime.java:1283)
at org.mozilla.javascript.gen.c207._c0(<inline>:1)
at org.mozilla.javascript.gen.c207.call(<inline>)
at org.mozilla.javascript.ContextFactory.doTopCall(ContextFactory.java:304)
at org.mozilla.javascript.ScriptRuntime.doTopCall(ScriptRuntime.java:2769)
at org.mozilla.javascript.gen.c207.call(<inline>)
at org.mozilla.javascript.gen.c207.exec(<inline>)
at org.eclipse.birt.core.script.ScriptContext.eval(ScriptContext.java:223)
at org.eclipse.birt.report.engine.executor.ExecutionContext.evaluate(ExecutionContext.java:550)
... 70 more
+ There are errors evaluating script "//importPackage(Packages.com.konakart.reports);
//priceFormatter.formatPrice(row["total"])
row["total"]".
Error.ScriptEvaluationError ( 2 time(s) )
detail : org.eclipse.birt.report.engine.api.EngineException: There are errors evaluating script "//importPackage(Packages.com.konakart.reports);
//priceFormatter.formatPrice(row["total"])
row["total"]".
at org.eclipse.birt.report.engine.executor.ExecutionContext.evaluate(ExecutionContext.java:557)
at org.eclipse.birt.report.engine.executor.ExecutionContext.evaluate(ExecutionContext.java:529)
at org.eclipse.birt.report.engine.data.dte.DteResultSet.evaluate(DteResultSet.java:326)
at org.eclipse.birt.report.engine.extension.internal.RowSet.evaluate(RowSet.java:113)
at org.eclipse.birt.chart.reportitem.BIRTDataRowEvaluator.evaluate(BIRTDataRowEvaluator.java:44)
at org.eclipse.birt.chart.internal.datafeed.DataProcessor.mapToChartResultSet(DataProcessor.java:584)
at org.eclipse.birt.chart.internal.datafeed.DataProcessor.generateRuntimeSeries(DataProcessor.java:715)
at org.eclipse.birt.chart.factory.Generator.bindData(Generator.java:559)
at org.eclipse.birt.chart.reportitem.ChartReportItemPresentationImpl.onRowSets(ChartReportItemPresentationImpl.java:399)
at org.eclipse.birt.report.engine.presentation.LocalizedContentVisitor.processExtendedContent(LocalizedContentVisitor.java:653)
at org.eclipse.birt.report.engine.presentation.LocalizedContentVisitor.visitForeign(LocalizedContentVisitor.java:359)
at org.eclipse.birt.report.engine.content.impl.ForeignContent.accept(ForeignContent.java:58)
at org.eclipse.birt.report.engine.presentation.LocalizedContentVisitor.localize(LocalizedContentVisitor.java:111)
at org.eclipse.birt.report.engine.internal.executor.l18n.LocalizedReportItemExecutor.execute(LocalizedReportItemExecutor.java:38)
at org.eclipse.birt.report.engine.internal.executor.l18n.LocalizedReportExecutor.execute(LocalizedReportExecutor.java:90)
at org.eclipse.birt.report.engine.internal.executor.l18n.LocalizedReportExecutor.execute(LocalizedReportExecutor.java:98)
at org.eclipse.birt.report.engine.internal.executor.l18n.LocalizedReportExecutor.execute(LocalizedReportExecutor.java:98)
at org.eclipse.birt.report.engine.internal.executor.l18n.LocalizedReportExecutor.execute(LocalizedReportExecutor.java:98)
at org.eclipse.birt.report.engine.internal.executor.l18n.LocalizedReportExecutor.execute(LocalizedReportExecutor.java:98)
at org.eclipse.birt.report.engine.internal.executor.l18n.LocalizedReportExecutor.execute(LocalizedReportExecutor.java:77)
at org.eclipse.birt.report.engine.internal.document.v3.ReportContentLoaderV3.loadPage(ReportContentLoaderV3.java:51)
at org.eclipse.birt.report.engine.internal.document.ReportContentLoader.loadPage(ReportContentLoader.java:55)
at org.eclipse.birt.report.engine.api.impl.RenderTask.doRender(RenderTask.java:248)
at org.eclipse.birt.report.engine.api.impl.RenderTask$PageRender.render(RenderTask.java:702)
at org.eclipse.birt.report.engine.api.impl.RenderTask.render(RenderTask.java:613)
at org.eclipse.birt.report.service.ReportEngineService.renderReport(Unknown Source)
at org.eclipse.birt.report.service.ReportEngineService.renderReport(Unknown Source)
at org.eclipse.birt.report.service.BirtViewerReportService.getPage(Unknown Source)
at org.eclipse.birt.report.service.actionhandler.AbstractGetPageActionHandler.doExecution(Unknown Source)
at org.eclipse.birt.report.service.actionhandler.AbstractGetPageActionHandler.__execute(Unknown Source)
at org.eclipse.birt.report.service.actionhandler.AbstractBaseActionHandler.execute(Unknown Source)
at org.eclipse.birt.report.soapengine.processor.AbstractBaseDocumentProcessor.__executeAction(Unknown Source)
at org.eclipse.birt.report.soapengine.processor.AbstractBaseComponentProcessor.executeAction(Unknown Source)
at org.eclipse.birt.report.soapengine.processor.BirtDocumentProcessor.handleGetPage(Unknown Source)
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:585)
at org.eclipse.birt.report.soapengine.processor.AbstractBaseComponentProcessor.process(Unknown Source)
at org.eclipse.birt.report.soapengine.endpoint.BirtSoapBindingImpl.getUpdatedObjects(Unknown Source)
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:585)
at org.apache.axis.providers.java.RPCProvider.invokeMethod(RPCProvider.java:397)
at org.apache.axis.providers.java.RPCProvider.processMessage(RPCProvider.java:186)
at org.apache.axis.providers.java.JavaProvider.invoke(JavaProvider.java:323)
at org.apache.axis.strategies.InvocationStrategy.visit(InvocationStrategy.java:32)
at org.apache.axis.SimpleChain.doVisiting(SimpleChain.java:118)
at org.apache.axis.SimpleChain.invoke(SimpleChain.java:83)
at org.apache.axis.handlers.soap.SOAPService.invoke(SOAPService.java:453)
at org.apache.axis.server.AxisServer.invoke(AxisServer.java:281)
at org.apache.axis.transport.http.AxisServlet.doPost(AxisServlet.java:699)
at org.eclipse.birt.report.servlet.BirtSoapMessageDispatcherServlet.doPost(Unknown Source)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
at org.apache.axis.transport.http.AxisServletBase.service(AxisServletBase.java:327)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
at org.eclipse.birt.report.engine.executor.ExecutionContext.evaluate(ExecutionContext.java:550)
... 70 more
Pls help to me.
nkpsu