• Welcome to KonaKart Community Forum. Please login or sign up.
 

Birt Report Error ( Chart (id = 148))

Started by nkpsu, October 08, 2007, 11:47:00 am

Previous topic - Next topic

nkpsu

October 08, 2007, 11:47:00 am Last Edit: October 09, 2007, 07:30:52 am by nkpsu
hi,
   i run the report files then i got error

The following items have errors:

Chart (id = 148):
- There are errors evaluating script "row["monyy"]".

Error.ScriptEvaluationError ( 12 time(s) )
detail : org.eclipse.birt.report.engine.api.EngineException: There are errors evaluating script "row["monyy"]".
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.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.c61._c0(<inline>:1)
at org.mozilla.javascript.gen.c61.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.c61.call(<inline>)
at org.mozilla.javascript.gen.c61.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)


There are errors evaluating script "row["order_value"]".


Error.ScriptEvaluationError ( 12 time(s) )
detail : org.eclipse.birt.report.engine.api.EngineException: There are errors evaluating script "row["order_value"]".
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.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.c62._c0(<inline>:1)
at org.mozilla.javascript.gen.c62.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.c62.call(<inline>)
at org.mozilla.javascript.gen.c62.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

then how do i fix the error
thanks,


Brian

Hi,

Could it be that you're running a report but have no data?


You are free to change the reports as you see fit as they are all provided in the download package.

Regards,
Brian

nkpsu

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




Brian

Hi,

As I said last time, it looks like you have no data.  By that I mean you're running a report on Orders but you have no orders.

Regards,
Brian

nkpsu

Thank you very much for reply

I have used both Windows installer and zip folder.

For windows installer, (SetUp)
          I can view all the reports.Its working fine and its look nice

For zip folder,
           here its working fine for two things like Customer Phone Number List and Product List But not working for other reports.
             
         Even,For Both type of installation am using same database. So that only i have confused.

Brian

Hi,

The nice thing about the wizard based installer is that it will set all the configuration parameters correctly for you based on your installation options.

When you use the zip based installation method you have to configure KonaKart's parameters yourself.

I would check the reporting FAQ (http://www.konakart.com/reportingfaq.php) and ensure that all the report variables are set as you require.

Regards,
Brian

nkpsu

hello Mr.Brian

  in my konakart admin configuration, Report Configuration is not available (http://www.konakart.com/reportingfaq.php) so I configure directly in the konakart  database(MySQL),  Report definition base path, Report file extension, Report viewer URL and Status Page Report URL,  and I also check the konakart.rptlibrary files in webapps/birt-viewer/reports/lib/ .
set path dbProps File C:/Program Files/KonaKart/webapps/konakartadmin/WEB-INF/classes/konakartadmin.properties
Still I Have the same problem,  any other changes apart from this 

regards
nkpsu

Brian

Hi nkpsu,

It's difficult to determine what's wrong with your setup here.

To recap,

You have an installation that is completely working that you installed using the wizard.
Then you did an installation from the zip and it isn't working.

Why is it that you installed from the zip anyway if you had it working from the installer?

Somewhere in the configuration there must be something wrong.  Are you pointing to the correct database?  Are the paths all correct?

Can you compare the values between the installation that's working and the one that isn't to narrow down the problem?

Regards,
Brian

nkpsu

October 10, 2007, 07:23:55 am #8 Last Edit: October 10, 2007, 07:56:10 am by nkpsu
i remove "mysql-connector-java" jre files in Program Files\Java\jdk1.5.0_08\jre\lib\ext.
Now its working fine. But i try to up load a new report it rise an error message " There has been a problem with the Upload <pre></pre>" . 

----------------------------------------------------------------------
A new Problem : After i got a new problem product can not add into the cart :

The details of the malfunction are :

Exception Name = com.konakart.app.KKException
Exception Message = org.apache.torque.TorqueException: java.sql.SQLException: Incorrect arguments to mysql_stmt_execute
Exception Stack Trace =
at com.konakart.app.KKEng.addToBasket(KKEng.java:759)
at com.konakart.al.BasketMgr.addToBasket(BasketMgr.java:148)


--------------------------------------------------------------


some jar file conflict ! i am not sure.

Brian

QuoteBut i try to up load a new report it rise an error message " There has been a problem with the Upload <pre></pre>"


This is a problem in 2.2.0.6 and earlier versions of the Admin App on Firefox - I'm guessing that you're using Firefox.  This is fixed for Firefox in 2.2.0.7 and beyond.

The simple workaround is to use IE7 or simply copy your report file to your report file directory.


QuoteIncorrect arguments to mysql_stmt_execute


Check that you're not picking up the wrong mysql jars like your were last time.

Brian

Brian

Hi,

QuoteBut i try to up load a new report it rise an error message " There has been a problem with the Upload <pre></pre>" .


A colleague has just reminded me that this is just a spurious message that we've only seen on Firefox.  You should find that the report file does actually get uploaded OK despite the odd message.   It is just the message that is corrected in future versions.

Brian

nkpsu

ok Brain,
yes,
it working properly in IE,
thank you for your replay.