Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » BIRT » passing report parameter
passing report parameter [message #200906] Wed, 15 November 2006 07:18 Go to next message
Eclipse UserFriend
Originally posted by: keeling040982.yahoo.com

hai
i am using the birt-report-designer-all-in-one-2_1_1 to design my report
for my project; jboss-4.0.2 as my project server and run my project
application with JBossIDE-1.5.1.
then, i put my ".rptdesign" file into the server, "birt.war/report" folder
and run the application with JBossIDE-1.5.1. The report is shown but how
could i display the parameter in my report?

I try to use the script to pass as below:
at the initialize:

titleStr = params["titles"].split(",");

title1='';title2='';title3='';title4='';title5='';title6=''; title7='';title8='';

if(titleStr.length >= 1)
title1= titleStr[0];
if(titleStr.length >= 2)
title2= titleStr[1];
if(titleStr.length >= 3)
title3= titleStr[2];
if(titleStr.length >= 4)
title4= titleStr[3];
if(titleStr.length >= 5)
title5= titleStr[4];
if(titleStr.length >= 6)
title6= titleStr[5];
if(titleStr.length >= 7)
title7= titleStr[6];
if(titleStr.length >= 8)
title8= titleStr[7];

and at beforeOpen,

this.queryText = "select * "+params["stmt"]

but the error message shown as below:

The following items have errors:


ReportDesign (id = 1):
+ There are errors evaluating script "titleStr =
params["titles"].split(",");

title1='';title2='';title3='';title4='';title5='';title6=''; title7='';title8='';

if(titleStr.length >= 1)
title1= titleStr[0];
if(titleStr.length >= 2)
title2= titleStr[1];
if(titleStr.length >= 3)
title3= titleStr[2];
if(titleStr.length >= 4)
title4= titleStr[3];
if(titleStr.length >= 5)
title5= titleStr[4];
if(titleStr.length >= 6)
title6= titleStr[5];
if(titleStr.length >= 7)
title7= titleStr[6];
if(titleStr.length >= 8)
title8= titleStr[7];".
Error.ScriptEvaluationError ( 1 time(s) )
detail : org.eclipse.birt.report.engine.api.EngineException: There are
errors evaluating script "titleStr =
params["titles"].split("," );title1='';title2='';title3='';title4='';title5='';title6=' ';title7='';title8='';if(titleStr.length
>= 1) title1= titleStr[0];if(titleStr.length >= 2) title2=
titleStr[1];if(titleStr.length >= 3) title3=
titleStr[2];if(titleStr.length >= 4) title4=
titleStr[3];if(titleStr.length >= 5) title5=
titleStr[4];if(titleStr.length >= 6) title6=
titleStr[5];if(titleStr.length >= 7) title7=
titleStr[6];if(titleStr.length >= 8) title8= titleStr[7];". at
org.eclipse.birt.report.engine.executor.ExecutionContext.eva luate(ExecutionContext.java:556)
at
org.eclipse.birt.report.engine.executor.ExecutionContext.eva luate(ExecutionContext.java:528)
at
org.eclipse.birt.report.engine.script.internal.ScriptExecuto r.handleJSInternal(ScriptExecutor.java:66)
at
org.eclipse.birt.report.engine.script.internal.ScriptExecuto r.handleJS(ScriptExecutor.java:50)
at
org.eclipse.birt.report.engine.script.internal.ReportScriptE xecutor.handleInitialize(ReportScriptExecutor.java:28)
at
org.eclipse.birt.report.engine.api.impl.EngineTask.loadDesig n(EngineTask.java:860)
at
org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.run (RunAndRenderTask.java:149)
at
org.eclipse.birt.report.service.ReportEngineService.runAndRe nderReport(Unknown
Source) at
org.eclipse.birt.report.service.ReportEngineService.runAndRe nderReport(Unknown
Source) at
org.eclipse.birt.report.service.BirtViewerReportService.runA ndRenderReport(Unknown
Source) at
org.eclipse.birt.report.service.actionhandler.BirtRunAndRend erActionHandler.__execute(Unknown
Source) at
org.eclipse.birt.report.service.actionhandler.AbstractBaseAc tionHandler.execute(Unknown
Source) at
org.eclipse.birt.report.presentation.aggregation.layout.Engi neFragment.doService(Unknown
Source) at
org.eclipse.birt.report.presentation.aggregation.AbstractBas eFragment.service(Unknown
Source) at
org.eclipse.birt.report.servlet.BirtEngineServlet.__doGet(Un known Source)
at org.eclipse.birt.report.servlet.BaseReportEngineServlet.doGe t(Unknown
Source) at javax.servlet.http.HttpServlet.service(HttpServlet.java:697) at
org.apache.axis.transport.http.AxisServletBase.service(AxisS ervletBase.java:327)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:810) at
org.apache.catalina.core.ApplicationFilterChain.internalDoFi lter(ApplicationFilterChain.java:252)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(App licationFilterChain.java:173)
at
org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(Repl yHeaderFilter.java:81)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFi lter(ApplicationFilterChain.java:202)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(App licationFilterChain.java:173)
at
org.apache.catalina.core.StandardWrapperValve.invoke(Standar dWrapperValve.java:213)
at
org.apache.catalina.core.StandardContextValve.invoke(Standar dContextValve.java:178)
at
org.jboss.web.tomcat.security.CustomPrincipalValve.invoke(Cu stomPrincipalValve.java:39)
at
org.jboss.web.tomcat.security.SecurityAssociationValve.invok e(SecurityAssociationValve.java:153)
at
org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccCo ntextValve.java:59)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHo stValve.java:126)
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorRepo rtValve.java:105)
at
org.apache.catalina.core.StandardEngineValve.invoke(Standard EngineValve.java:107)
at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAd apter.java:148)
at
org.apache.coyote.http11.Http11Processor.process(Http11Proce ssor.java:856)
at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHand ler.processConnection(Http11Protocol.java:744)
at
org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(Poo lTcpEndpoint.java:527)
at
org.apache.tomcat.util.net.MasterSlaveWorkerThread.run(Maste rSlaveWorkerThread.java:112)
at java.lang.Thread.run(Thread.java:534)Caused by:
org.mozilla.javascript.EcmaError: TypeError: split is not a function.
(<inline>#1) at
org.mozilla.javascript.ScriptRuntime.constructError(ScriptRu ntime.java:3240)
at
org.mozilla.javascript.ScriptRuntime.constructError(ScriptRu ntime.java:3230)
at org.mozilla.javascript.ScriptRuntime.typeError(ScriptRuntime .java:3246)
at
org.mozilla.javascript.ScriptRuntime.typeError1(ScriptRuntim e.java:3258)
at
org.mozilla.javascript.ScriptRuntime.notFunctionError(Script Runtime.java:3317)
at
org.mozilla.javascript.ScriptRuntime.getPropFunctionAndThis( ScriptRuntime.java:1987)
at org.mozilla.javascript.gen.c6._c0(<inline>:1) at
org.mozilla.javascript.gen.c6.call(<inline>) at
org.mozilla.javascript.ContextFactory.doTopCall(ContextFacto ry.java:304)
at org.mozilla.javascript.ScriptRuntime.doTopCall(ScriptRuntime .java:2769)
at org.mozilla.javascript.gen.c6.call(<inline>) at
org.mozilla.javascript.gen.c6.exec(<inline>) at
org.eclipse.birt.core.script.ScriptContext.eval(ScriptContex t.java:224) at
org.eclipse.birt.report.engine.executor.ExecutionContext.eva luate(ExecutionContext.java:549)
... 37 more


Data (id = 20):
+ There are errors evaluating script "row["title1"]".
Error.ScriptEvaluationError ( 1 time(s) )
detail : org.eclipse.birt.report.engine.api.EngineException: There are
errors evaluating script "row["title1"]". at
org.eclipse.birt.report.engine.executor.ExecutionContext.eva luate(ExecutionContext.java:556)
at
org.eclipse.birt.report.engine.executor.ExecutionContext.eva luate(ExecutionContext.java:528)
at
org.eclipse.birt.report.engine.executor.DataItemExecutor.exe cute(DataItemExecutor.java:89)
at
org.eclipse.birt.report.engine.internal.executor.l18n.Locali zedReportItemExecutor.execute(LocalizedReportItemExecutor.ja va:35)
at
org.eclipse.birt.report.engine.layout.html.HTMLBlockStacking LM.layoutChildren(HTMLBlockStackingLM.java:63)
at
org.eclipse.birt.report.engine.layout.html.HTMLAbstractLM.la yout(HTMLAbstractLM.java:159)
at
org.eclipse.birt.report.engine.layout.html.HTMLInlineStackin gLM.resumeLayout(HTMLInlineStackingLM.java:94)
at
org.eclipse.birt.report.engine.layout.html.HTMLInlineStackin gLM.layoutChildren(HTMLInlineStackingLM.java:138)
at
org.eclipse.birt.report.engine.layout.html.HTMLAbstractLM.la yout(HTMLAbstractLM.java:159)
at
org.eclipse.birt.report.engine.layout.html.HTMLRowLM.layout( HTMLRowLM.java:30)
at
org.eclipse.birt.report.engine.layout.html.HTMLBlockStacking LM.layoutChildren(HTMLBlockStackingLM.java:68)
at
org.eclipse.birt.report.engine.layout.html.HTMLTableLM.layou tChildren(HTMLTableLM.java:74)
at
org.eclipse.birt.report.engine.layout.html.HTMLAbstractLM.la yout(HTMLAbstractLM.java:159)
at
org.eclipse.birt.report.engine.layout.html.HTMLPageLM.layout Children(HTMLPageLM.java:139)
at
org.eclipse.birt.report.engine.layout.html.HTMLPageLM.layout (HTMLPageLM.java:81)
at
org.eclipse.birt.report.engine.layout.html.HTMLReportLayoutE ngine.layout(HTMLReportLayoutEngine.java:80)
at
org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.run (RunAndRenderTask.java:194)
at
org.eclipse.birt.report.service.ReportEngineService.runAndRe nderReport(Unknown
Source) at
org.eclipse.birt.report.service.ReportEngineService.runAndRe nderReport(Unknown
Source) at
org.eclipse.birt.report.service.BirtViewerReportService.runA ndRenderReport(Unknown
Source) at
org.eclipse.birt.report.service.actionhandler.BirtRunAndRend erActionHandler.__execute(Unknown
Source) at
org.eclipse.birt.report.service.actionhandler.AbstractBaseAc tionHandler.execute(Unknown
Source) at
org.eclipse.birt.report.presentation.aggregation.layout.Engi neFragment.doService(Unknown
Source) at
org.eclipse.birt.report.presentation.aggregation.AbstractBas eFragment.service(Unknown
Source) at
org.eclipse.birt.report.servlet.BirtEngineServlet.__doGet(Un known Source)
at org.eclipse.birt.report.servlet.BaseReportEngineServlet.doGe t(Unknown
Source) at javax.servlet.http.HttpServlet.service(HttpServlet.java:697) at
org.apache.axis.transport.http.AxisServletBase.service(AxisS ervletBase.java:327)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:810) at
org.apache.catalina.core.ApplicationFilterChain.internalDoFi lter(ApplicationFilterChain.java:252)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(App licationFilterChain.java:173)
at
org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(Repl yHeaderFilter.java:81)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFi lter(ApplicationFilterChain.java:202)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(App licationFilterChain.java:173)
at
org.apache.catalina.core.StandardWrapperValve.invoke(Standar dWrapperValve.java:213)
at
org.apache.catalina.core.StandardContextValve.invoke(Standar dContextValve.java:178)
at
org.jboss.web.tomcat.security.CustomPrincipalValve.invoke(Cu stomPrincipalValve.java:39)
at
org.jboss.web.tomcat.security.SecurityAssociationValve.invok e(SecurityAssociationValve.java:153)
at
org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccCo ntextValve.java:59)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHo stValve.java:126)
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorRepo rtValve.java:105)
at
org.apache.catalina.core.StandardEngineValve.invoke(Standard EngineValve.java:107)
at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAd apter.java:148)
at
org.apache.coyote.http11.Http11Processor.process(Http11Proce ssor.java:856)
at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHand ler.processConnection(Http11Protocol.java:744)
at
org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(Poo lTcpEndpoint.java:527)
at
org.apache.tomcat.util.net.MasterSlaveWorkerThread.run(Maste rSlaveWorkerThread.java:112)
at java.lang.Thread.run(Thread.java:534)Caused by:
org.mozilla.javascript.EvaluatorException:
org.eclipse.birt.core.exception.CoreException: Error evaluating Javascript
expression. Script engine error: ReferenceError: "title1" is not defined.
Script source: source, line: 0, text:title1 at
org.eclipse.birt.report.engine.data.dte.NativeRowObject.get( NativeRowObject.java:94)
at
org.mozilla.javascript.ScriptableObject.getProperty(Scriptab leObject.java:1263)
at
org.mozilla.javascript.ScriptRuntime.getObjectElem(ScriptRun time.java:1301)
at
org.mozilla.javascript.ScriptRuntime.getObjectElem(ScriptRun time.java:1283)
at org.mozilla.javascript.gen.c8._c0(<inline>:1) at
org.mozilla.javascript.gen.c8.call(<inline>) at
org.mozilla.javascript.ContextFactory.doTopCall(ContextFacto ry.java:304)
at org.mozilla.javascript.ScriptRuntime.doTopCall(ScriptRuntime .java:2769)
at org.mozilla.javascript.gen.c8.call(<inline>) at
org.mozilla.javascript.gen.c8.exec(<inline>) at
org.eclipse.birt.core.script.ScriptContext.eval(ScriptContex t.java:224) at
org.eclipse.birt.report.engine.executor.ExecutionContext.eva luate(ExecutionContext.java:549)
... 47 more


Data (id = 22):
+ There are errors evaluating script "row["title3"]".
Error.ScriptEvaluationError ( 1 time(s) )
detail : org.eclipse.birt.report.engine.api.EngineException: There are
errors evaluating script "row["title3"]". at
org.eclipse.birt.report.engine.executor.ExecutionContext.eva luate(ExecutionContext.java:556)
at
org.eclipse.birt.report.engine.executor.ExecutionContext.eva luate(ExecutionContext.java:528)
at
org.eclipse.birt.report.engine.executor.DataItemExecutor.exe cute(DataItemExecutor.java:89)
at
org.eclipse.birt.report.engine.internal.executor.l18n.Locali zedReportItemExecutor.execute(LocalizedReportItemExecutor.ja va:35)
at
org.eclipse.birt.report.engine.layout.html.HTMLBlockStacking LM.layoutChildren(HTMLBlockStackingLM.java:63)
at
org.eclipse.birt.report.engine.layout.html.HTMLAbstractLM.la yout(HTMLAbstractLM.java:159)
at
org.eclipse.birt.report.engine.layout.html.HTMLInlineStackin gLM.resumeLayout(HTMLInlineStackingLM.java:94)
at
org.eclipse.birt.report.engine.layout.html.HTMLInlineStackin gLM.layoutChildren(HTMLInlineStackingLM.java:138)
at
org.eclipse.birt.report.engine.layout.html.HTMLAbstractLM.la yout(HTMLAbstractLM.java:159)
at
org.eclipse.birt.report.engine.layout.html.HTMLRowLM.layout( HTMLRowLM.java:30)
at
org.eclipse.birt.report.engine.layout.html.HTMLBlockStacking LM.layoutChildren(HTMLBlockStackingLM.java:68)
at
org.eclipse.birt.report.engine.layout.html.HTMLTableLM.layou tChildren(HTMLTableLM.java:74)
at
org.eclipse.birt.report.engine.layout.html.HTMLAbstractLM.la yout(HTMLAbstractLM.java:159)
at
org.eclipse.birt.report.engine.layout.html.HTMLPageLM.layout Children(HTMLPageLM.java:139)
at
org.eclipse.birt.report.engine.layout.html.HTMLPageLM.layout (HTMLPageLM.java:81)
at
org.eclipse.birt.report.engine.layout.html.HTMLReportLayoutE ngine.layout(HTMLReportLayoutEngine.java:80)
at
org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.run (RunAndRenderTask.java:194)
at
org.eclipse.birt.report.service.ReportEngineService.runAndRe nderReport(Unknown
Source) at
org.eclipse.birt.report.service.ReportEngineService.runAndRe nderReport(Unknown
Source) at
org.eclipse.birt.report.service.BirtViewerReportService.runA ndRenderReport(Unknown
Source) at
org.eclipse.birt.report.service.actionhandler.BirtRunAndRend erActionHandler.__execute(Unknown
Source) at
org.eclipse.birt.report.service.actionhandler.AbstractBaseAc tionHandler.execute(Unknown
Source) at
org.eclipse.birt.report.presentation.aggregation.layout.Engi neFragment.doService(Unknown
Source) at
org.eclipse.birt.report.presentation.aggregation.AbstractBas eFragment.service(Unknown
Source) at
org.eclipse.birt.report.servlet.BirtEngineServlet.__doGet(Un known Source)
at org.eclipse.birt.report.servlet.BaseReportEngineServlet.doGe t(Unknown
Source) at javax.servlet.http.HttpServlet.service(HttpServlet.java:697) at
org.apache.axis.transport.http.AxisServletBase.service(AxisS ervletBase.java:327)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:810) at
org.apache.catalina.core.ApplicationFilterChain.internalDoFi lter(ApplicationFilterChain.java:252)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(App licationFilterChain.java:173)
at
org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(Repl yHeaderFilter.java:81)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFi lter(ApplicationFilterChain.java:202)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(App licationFilterChain.java:173)
at
org.apache.catalina.core.StandardWrapperValve.invoke(Standar dWrapperValve.java:213)
at
org.apache.catalina.core.StandardContextValve.invoke(Standar dContextValve.java:178)
at
org.jboss.web.tomcat.security.CustomPrincipalValve.invoke(Cu stomPrincipalValve.java:39)
at
org.jboss.web.tomcat.security.SecurityAssociationValve.invok e(SecurityAssociationValve.java:153)
at
org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccCo ntextValve.java:59)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHo stValve.java:126)
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorRepo rtValve.java:105)
at
org.apache.catalina.core.StandardEngineValve.invoke(Standard EngineValve.java:107)
at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAd apter.java:148)
at
org.apache.coyote.http11.Http11Processor.process(Http11Proce ssor.java:856)
at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHand ler.processConnection(Http11Protocol.java:744)
at
org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(Poo lTcpEndpoint.java:527)
at
org.apache.tomcat.util.net.MasterSlaveWorkerThread.run(Maste rSlaveWorkerThread.java:112)
at java.lang.Thread.run(Thread.java:534)Caused by:
org.mozilla.javascript.EvaluatorException:
org.eclipse.birt.core.exception.CoreException: Error evaluating Javascript
expression. Script engine error: ReferenceError: "title3" is not defined.
Script source: source, line: 0, text:title3 at
org.eclipse.birt.report.engine.data.dte.NativeRowObject.get( NativeRowObject.java:94)
at
org.mozilla.javascript.ScriptableObject.getProperty(Scriptab leObject.java:1263)
at
org.mozilla.javascript.ScriptRuntime.getObjectElem(ScriptRun time.java:1301)
at
org.mozilla.javascript.ScriptRuntime.getObjectElem(ScriptRun time.java:1283)
at org.mozilla.javascript.gen.c10._c0(<inline>:1) at
org.mozilla.javascript.gen.c10.call(<inline>) at
org.mozilla.javascript.ContextFactory.doTopCall(ContextFacto ry.java:304)
at org.mozilla.javascript.ScriptRuntime.doTopCall(ScriptRuntime .java:2769)
at org.mozilla.javascript.gen.c10.call(<inline>) at
org.mozilla.javascript.gen.c10.exec(<inline>) at
org.eclipse.birt.core.script.ScriptContext.eval(ScriptContex t.java:224) at
org.eclipse.birt.report.engine.executor.ExecutionContext.eva luate(ExecutionContext.java:549)
... 47 more


Data (id = 25):
+ There are errors evaluating script "row["title2"]".
Error.ScriptEvaluationError ( 1 time(s) )
detail : org.eclipse.birt.report.engine.api.EngineException: There are
errors evaluating script "row["title2"]". at
org.eclipse.birt.report.engine.executor.ExecutionContext.eva luate(ExecutionContext.java:556)
at
org.eclipse.birt.report.engine.executor.ExecutionContext.eva luate(ExecutionContext.java:528)
at
org.eclipse.birt.report.engine.executor.DataItemExecutor.exe cute(DataItemExecutor.java:89)
at
org.eclipse.birt.report.engine.internal.executor.l18n.Locali zedReportItemExecutor.execute(LocalizedReportItemExecutor.ja va:35)
at
org.eclipse.birt.report.engine.layout.html.HTMLBlockStacking LM.layoutChildren(HTMLBlockStackingLM.java:63)
at
org.eclipse.birt.report.engine.layout.html.HTMLAbstractLM.la yout(HTMLAbstractLM.java:159)
at
org.eclipse.birt.report.engine.layout.html.HTMLInlineStackin gLM.resumeLayout(HTMLInlineStackingLM.java:94)
at
org.eclipse.birt.report.engine.layout.html.HTMLInlineStackin gLM.layoutChildren(HTMLInlineStackingLM.java:138)
at
org.eclipse.birt.report.engine.layout.html.HTMLAbstractLM.la yout(HTMLAbstractLM.java:159)
at
org.eclipse.birt.report.engine.layout.html.HTMLRowLM.layout( HTMLRowLM.java:30)
at
org.eclipse.birt.report.engine.layout.html.HTMLBlockStacking LM.layoutChildren(HTMLBlockStackingLM.java:68)
at
org.eclipse.birt.report.engine.layout.html.HTMLTableLM.layou tChildren(HTMLTableLM.java:74)
at
org.eclipse.birt.report.engine.layout.html.HTMLAbstractLM.la yout(HTMLAbstractLM.java:159)
at
org.eclipse.birt.report.engine.layout.html.HTMLPageLM.layout Children(HTMLPageLM.java:139)
at
org.eclipse.birt.report.engine.layout.html.HTMLPageLM.layout (HTMLPageLM.java:81)
at
org.eclipse.birt.report.engine.layout.html.HTMLReportLayoutE ngine.layout(HTMLReportLayoutEngine.java:80)
at
org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.run (RunAndRenderTask.java:194)
at
org.eclipse.birt.report.service.ReportEngineService.runAndRe nderReport(Unknown
Source) at
org.eclipse.birt.report.service.ReportEngineService.runAndRe nderReport(Unknown
Source) at
org.eclipse.birt.report.service.BirtViewerReportService.runA ndRenderReport(Unknown
Source) at
org.eclipse.birt.report.service.actionhandler.BirtRunAndRend erActionHandler.__execute(Unknown
Source) at
org.eclipse.birt.report.service.actionhandler.AbstractBaseAc tionHandler.execute(Unknown
Source) at
org.eclipse.birt.report.presentation.aggregation.layout.Engi neFragment.doService(Unknown
Source) at
org.eclipse.birt.report.presentation.aggregation.AbstractBas eFragment.service(Unknown
Source) at
org.eclipse.birt.report.servlet.BirtEngineServlet.__doGet(Un known Source)
at org.eclipse.birt.report.servlet.BaseReportEngineServlet.doGe t(Unknown
Source) at javax.servlet.http.HttpServlet.service(HttpServlet.java:697) at
org.apache.axis.transport.http.AxisServletBase.service(AxisS ervletBase.java:327)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:810) at
org.apache.catalina.core.ApplicationFilterChain.internalDoFi lter(ApplicationFilterChain.java:252)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(App licationFilterChain.java:173)
at
org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(Repl yHeaderFilter.java:81)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFi lter(ApplicationFilterChain.java:202)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(App licationFilterChain.java:173)
at
org.apache.catalina.core.StandardWrapperValve.invoke(Standar dWrapperValve.java:213)
at
org.apache.catalina.core.StandardContextValve.invoke(Standar dContextValve.java:178)
at
org.jboss.web.tomcat.security.CustomPrincipalValve.invoke(Cu stomPrincipalValve.java:39)
at
org.jboss.web.tomcat.security.SecurityAssociationValve.invok e(SecurityAssociationValve.java:153)
at
org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccCo ntextValve.java:59)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHo stValve.java:126)
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorRepo rtValve.java:105)
at
org.apache.catalina.core.StandardEngineValve.invoke(Standard EngineValve.java:107)
at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAd apter.java:148)
at
org.apache.coyote.http11.Http11Processor.process(Http11Proce ssor.java:856)
at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHand ler.processConnection(Http11Protocol.java:744)
at
org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(Poo lTcpEndpoint.java:527)
at
org.apache.tomcat.util.net.MasterSlaveWorkerThread.run(Maste rSlaveWorkerThread.java:112)
at java.lang.Thread.run(Thread.java:534)Caused by:
org.mozilla.javascript.EvaluatorException:
org.eclipse.birt.core.exception.CoreException: Error evaluating Javascript
expression. Script engine error: ReferenceError: "title2" is not defined.
Script source: source, line: 0, text:title2 at
org.eclipse.birt.report.engine.data.dte.NativeRowObject.get( NativeRowObject.java:94)
at
org.mozilla.javascript.ScriptableObject.getProperty(Scriptab leObject.java:1263)
at
org.mozilla.javascript.ScriptRuntime.getObjectElem(ScriptRun time.java:1301)
at
org.mozilla.javascript.ScriptRuntime.getObjectElem(ScriptRun time.java:1283)
at org.mozilla.javascript.gen.c12._c0(<inline>:1) at
org.mozilla.javascript.gen.c12.call(<inline>) at
org.mozilla.javascript.ContextFactory.doTopCall(ContextFacto ry.java:304)
at org.mozilla.javascript.ScriptRuntime.doTopCall(ScriptRuntime .java:2769)
at org.mozilla.javascript.gen.c12.call(<inline>) at
org.mozilla.javascript.gen.c12.exec(<inline>) at
org.eclipse.birt.core.script.ScriptContext.eval(ScriptContex t.java:224) at
org.eclipse.birt.report.engine.executor.ExecutionContext.eva luate(ExecutionContext.java:549)
... 47 more


Data (id = 27):
+ There are errors evaluating script "row["title4"]".
Error.ScriptEvaluationError ( 1 time(s) )
detail : org.eclipse.birt.report.engine.api.EngineException: There are
errors evaluating script "row["title4"]". at
org.eclipse.birt.report.engine.executor.ExecutionContext.eva luate(ExecutionContext.java:556)
at
org.eclipse.birt.report.engine.executor.ExecutionContext.eva luate(ExecutionContext.java:528)
at
org.eclipse.birt.report.engine.executor.DataItemExecutor.exe cute(DataItemExecutor.java:89)
at
org.eclipse.birt.report.engine.internal.executor.l18n.Locali zedReportItemExecutor.execute(LocalizedReportItemExecutor.ja va:35)
at
org.eclipse.birt.report.engine.layout.html.HTMLBlockStacking LM.layoutChildren(HTMLBlockStackingLM.java:63)
at
org.eclipse.birt.report.engine.layout.html.HTMLAbstractLM.la yout(HTMLAbstractLM.java:159)
at
org.eclipse.birt.report.engine.layout.html.HTMLInlineStackin gLM.resumeLayout(HTMLInlineStackingLM.java:94)
at
org.eclipse.birt.report.engine.layout.html.HTMLInlineStackin gLM.layoutChildren(HTMLInlineStackingLM.java:138)
at
org.eclipse.birt.report.engine.layout.html.HTMLAbstractLM.la yout(HTMLAbstractLM.java:159)
at
org.eclipse.birt.report.engine.layout.html.HTMLRowLM.layout( HTMLRowLM.java:30)
at
org.eclipse.birt.report.engine.layout.html.HTMLBlockStacking LM.layoutChildren(HTMLBlockStackingLM.java:68)
at
org.eclipse.birt.report.engine.layout.html.HTMLTableLM.layou tChildren(HTMLTableLM.java:74)
at
org.eclipse.birt.report.engine.layout.html.HTMLAbstractLM.la yout(HTMLAbstractLM.java:159)
at
org.eclipse.birt.report.engine.layout.html.HTMLPageLM.layout Children(HTMLPageLM.java:139)
at
org.eclipse.birt.report.engine.layout.html.HTMLPageLM.layout (HTMLPageLM.java:81)
at
org.eclipse.birt.report.engine.layout.html.HTMLReportLayoutE ngine.layout(HTMLReportLayoutEngine.java:80)
at
org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.run (RunAndRenderTask.java:194)
at
org.eclipse.birt.report.service.ReportEngineService.runAndRe nderReport(Unknown
Source) at
org.eclipse.birt.report.service.ReportEngineService.runAndRe nderReport(Unknown
Source) at
org.eclipse.birt.report.service.BirtViewerReportService.runA ndRenderReport(Unknown
Source) at
org.eclipse.birt.report.service.actionhandler.BirtRunAndRend erActionHandler.__execute(Unknown
Source) at
org.eclipse.birt.report.service.actionhandler.AbstractBaseAc tionHandler.execute(Unknown
Source) at
org.eclipse.birt.report.presentation.aggregation.layout.Engi neFragment.doService(Unknown
Source) at
org.eclipse.birt.report.presentation.aggregation.AbstractBas eFragment.service(Unknown
Source) at
org.eclipse.birt.report.servlet.BirtEngineServlet.__doGet(Un known Source)
at org.eclipse.birt.report.servlet.BaseReportEngineServlet.doGe t(Unknown
Source) at javax.servlet.http.HttpServlet.service(HttpServlet.java:697) at
org.apache.axis.transport.http.AxisServletBase.service(AxisS ervletBase.java:327)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:810) at
org.apache.catalina.core.ApplicationFilterChain.internalDoFi lter(ApplicationFilterChain.java:252)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(App licationFilterChain.java:173)
at
org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(Repl yHeaderFilter.java:81)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFi lter(ApplicationFilterChain.java:202)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(App licationFilterChain.java:173)
at
org.apache.catalina.core.StandardWrapperValve.invoke(Standar dWrapperValve.java:213)
at
org.apache.catalina.core.StandardContextValve.invoke(Standar dContextValve.java:178)
at
org.jboss.web.tomcat.security.CustomPrincipalValve.invoke(Cu stomPrincipalValve.java:39)
at
org.jboss.web.tomcat.security.SecurityAssociationValve.invok e(SecurityAssociationValve.java:153)
at
org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccCo ntextValve.java:59)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHo stValve.java:126)
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorRepo rtValve.java:105)
at
org.apache.catalina.core.StandardEngineValve.invoke(Standard EngineValve.java:107)
at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAd apter.java:148)
at
org.apache.coyote.http11.Http11Processor.process(Http11Proce ssor.java:856)
at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHand ler.processConnection(Http11Protocol.java:744)
at
org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(Poo lTcpEndpoint.java:527)
at
org.apache.tomcat.util.net.MasterSlaveWorkerThread.run(Maste rSlaveWorkerThread.java:112)
at java.lang.Thread.run(Thread.java:534)Caused by:
org.mozilla.javascript.EvaluatorException:
org.eclipse.birt.core.exception.CoreException: Error evaluating Javascript
expression. Script engine error: ReferenceError: "title4" is not defined.
Script source: source, line: 0, text:title4 at
org.eclipse.birt.report.engine.data.dte.NativeRowObject.get( NativeRowObject.java:94)
at
org.mozilla.javascript.ScriptableObject.getProperty(Scriptab leObject.java:1263)
at
org.mozilla.javascript.ScriptRuntime.getObjectElem(ScriptRun time.java:1301)
at
org.mozilla.javascript.ScriptRuntime.getObjectElem(ScriptRun time.java:1283)
at org.mozilla.javascript.gen.c14._c0(<inline>:1) at
org.mozilla.javascript.gen.c14.call(<inline>) at
org.mozilla.javascript.ContextFactory.doTopCall(ContextFacto ry.java:304)
at org.mozilla.javascript.ScriptRuntime.doTopCall(ScriptRuntime .java:2769)
at org.mozilla.javascript.gen.c14.call(<inline>) at
org.mozilla.javascript.gen.c14.exec(<inline>) at
org.eclipse.birt.core.script.ScriptContext.eval(ScriptContex t.java:224) at
org.eclipse.birt.report.engine.executor.ExecutionContext.eva luate(ExecutionContext.java:549)
... 47 more


anyone can help me? thanks...
Re: passing report parameter [message #201043 is a reply to message #200906] Wed, 15 November 2006 19:44 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason WeathersbyFriend
Messages: 9167
Registered: July 2009
Senior Member

Try

str1 = params["splitparm"].value;

arr1 = str1.split(",");



Then you should be able to reference like

arr1[0]

You may also have to trim double quotes if this is a string.


Jason

"ice" <keeling040982@yahoo.com> wrote in message
news:146d6a1af6e89b9bf759c59d2f4ec8a2$1@www.eclipse.org...
> hai
> i am using the birt-report-designer-all-in-one-2_1_1 to design my report
> for my project; jboss-4.0.2 as my project server and run my project
> application with JBossIDE-1.5.1. then, i put my ".rptdesign" file into the
> server, "birt.war/report" folder and run the application with
> JBossIDE-1.5.1. The report is shown but how could i display the parameter
> in my report?
>
> I try to use the script to pass as below:
> at the initialize:
>
> titleStr = params["titles"].split(",");
>
> title1='';title2='';title3='';title4='';title5='';title6=''; title7='';title8='';
>
> if(titleStr.length >= 1)
> title1= titleStr[0];
> if(titleStr.length >= 2)
> title2= titleStr[1];
> if(titleStr.length >= 3)
> title3= titleStr[2];
> if(titleStr.length >= 4)
> title4= titleStr[3];
> if(titleStr.length >= 5)
> title5= titleStr[4];
> if(titleStr.length >= 6)
> title6= titleStr[5];
> if(titleStr.length >= 7)
> title7= titleStr[6];
> if(titleStr.length >= 8)
> title8= titleStr[7];
>
> and at beforeOpen,
> this.queryText = "select * "+params["stmt"]
>
> but the error message shown as below:
>
> The following items have errors:
>
> ReportDesign (id = 1): + There are errors evaluating script "titleStr =
> params["titles"].split(",");
>
> title1='';title2='';title3='';title4='';title5='';title6=''; title7='';title8='';
>
> if(titleStr.length >= 1)
> title1= titleStr[0];
> if(titleStr.length >= 2)
> title2= titleStr[1];
> if(titleStr.length >= 3)
> title3= titleStr[2];
> if(titleStr.length >= 4)
> title4= titleStr[3];
> if(titleStr.length >= 5)
> title5= titleStr[4];
> if(titleStr.length >= 6)
> title6= titleStr[5];
> if(titleStr.length >= 7)
> title7= titleStr[6];
> if(titleStr.length >= 8)
> title8= titleStr[7];". Error.ScriptEvaluationError ( 1 time(s) )
> detail : org.eclipse.birt.report.engine.api.EngineException: There are
> errors evaluating script "titleStr =
> params["titles"].split("," );title1='';title2='';title3='';title4='';title5='';title6=' ';title7='';title8='';if(titleStr.length
>>= 1) title1= titleStr[0];if(titleStr.length >= 2) title2=
> titleStr[1];if(titleStr.length >= 3) title3=
> titleStr[2];if(titleStr.length >= 4) title4=
> titleStr[3];if(titleStr.length >= 5) title5=
> titleStr[4];if(titleStr.length >= 6) title6=
> titleStr[5];if(titleStr.length >= 7) title7=
> titleStr[6];if(titleStr.length >= 8) title8= titleStr[7];". at
> org.eclipse.birt.report.engine.executor.ExecutionContext.eva luate(ExecutionContext.java:556)
> at
> org.eclipse.birt.report.engine.executor.ExecutionContext.eva luate(ExecutionContext.java:528)
> at
> org.eclipse.birt.report.engine.script.internal.ScriptExecuto r.handleJSInternal(ScriptExecutor.java:66)
> at
> org.eclipse.birt.report.engine.script.internal.ScriptExecuto r.handleJS(ScriptExecutor.java:50)
> at
> org.eclipse.birt.report.engine.script.internal.ReportScriptE xecutor.handleInitialize(ReportScriptExecutor.java:28)
> at
> org.eclipse.birt.report.engine.api.impl.EngineTask.loadDesig n(EngineTask.java:860)
> at
> org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.run (RunAndRenderTask.java:149)
> at
> org.eclipse.birt.report.service.ReportEngineService.runAndRe nderReport(Unknown
> Source) at
> org.eclipse.birt.report.service.ReportEngineService.runAndRe nderReport(Unknown
> Source) at
> org.eclipse.birt.report.service.BirtViewerReportService.runA ndRenderReport(Unknown
> Source) at
> org.eclipse.birt.report.service.actionhandler.BirtRunAndRend erActionHandler.__execute(Unknown
> Source) at
> org.eclipse.birt.report.service.actionhandler.AbstractBaseAc tionHandler.execute(Unknown
> Source) at
> org.eclipse.birt.report.presentation.aggregation.layout.Engi neFragment.doService(Unknown
> Source) at
> org.eclipse.birt.report.presentation.aggregation.AbstractBas eFragment.service(Unknown
> Source) at
> org.eclipse.birt.report.servlet.BirtEngineServlet.__doGet(Un known Source)
> at org.eclipse.birt.report.servlet.BaseReportEngineServlet.doGe t(Unknown
> Source) at javax.servlet.http.HttpServlet.service(HttpServlet.java:697) at
> org.apache.axis.transport.http.AxisServletBase.service(AxisS ervletBase.java:327)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:810) at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFi lter(ApplicationFilterChain.java:252)
> at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(App licationFilterChain.java:173)
> at
> org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(Repl yHeaderFilter.java:81)
> at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFi lter(ApplicationFilterChain.java:202)
> at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(App licationFilterChain.java:173)
> at
> org.apache.catalina.core.StandardWrapperValve.invoke(Standar dWrapperValve.java:213)
> at
> org.apache.catalina.core.StandardContextValve.invoke(Standar dContextValve.java:178)
> at
> org.jboss.web.tomcat.security.CustomPrincipalValve.invoke(Cu stomPrincipalValve.java:39)
> at
> org.jboss.web.tomcat.security.SecurityAssociationValve.invok e(SecurityAssociationValve.java:153)
> at
> org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccCo ntextValve.java:59)
> at
> org.apache.catalina.core.StandardHostValve.invoke(StandardHo stValve.java:126)
> at
> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorRepo rtValve.java:105)
> at
> org.apache.catalina.core.StandardEngineValve.invoke(Standard EngineValve.java:107)
> at
> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAd apter.java:148)
> at
> org.apache.coyote.http11.Http11Processor.process(Http11Proce ssor.java:856)
> at
> org.apache.coyote.http11.Http11Protocol$Http11ConnectionHand ler.processConnection(Http11Protocol.java:744)
> at
> org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(Poo lTcpEndpoint.java:527)
> at
> org.apache.tomcat.util.net.MasterSlaveWorkerThread.run(Maste rSlaveWorkerThread.java:112)
> at java.lang.Thread.run(Thread.java:534)Caused by:
> org.mozilla.javascript.EcmaError: TypeError: split is not a function.
> (<inline>#1) at
> org.mozilla.javascript.ScriptRuntime.constructError(ScriptRu ntime.java:3240)
> at
> org.mozilla.javascript.ScriptRuntime.constructError(ScriptRu ntime.java:3230)
> at org.mozilla.javascript.ScriptRuntime.typeError(ScriptRuntime .java:3246)
> at
> org.mozilla.javascript.ScriptRuntime.typeError1(ScriptRuntim e.java:3258)
> at
> org.mozilla.javascript.ScriptRuntime.notFunctionError(Script Runtime.java:3317)
> at
> org.mozilla.javascript.ScriptRuntime.getPropFunctionAndThis( ScriptRuntime.java:1987)
> at org.mozilla.javascript.gen.c6._c0(<inline>:1) at
> org.mozilla.javascript.gen.c6.call(<inline>) at
> org.mozilla.javascript.ContextFactory.doTopCall(ContextFacto ry.java:304)
> at org.mozilla.javascript.ScriptRuntime.doTopCall(ScriptRuntime .java:2769)
> at org.mozilla.javascript.gen.c6.call(<inline>) at
> org.mozilla.javascript.gen.c6.exec(<inline>) at
> org.eclipse.birt.core.script.ScriptContext.eval(ScriptContex t.java:224) at
> org.eclipse.birt.report.engine.executor.ExecutionContext.eva luate(ExecutionContext.java:549)
> .. 37 more
>
>
> Data (id = 20): + There are errors evaluating script "row["title1"]".
> Error.ScriptEvaluationError ( 1 time(s) )
> detail : org.eclipse.birt.report.engine.api.EngineException: There are
> errors evaluating script "row["title1"]". at
> org.eclipse.birt.report.engine.executor.ExecutionContext.eva luate(ExecutionContext.java:556)
> at
> org.eclipse.birt.report.engine.executor.ExecutionContext.eva luate(ExecutionContext.java:528)
> at
> org.eclipse.birt.report.engine.executor.DataItemExecutor.exe cute(DataItemExecutor.java:89)
> at
> org.eclipse.birt.report.engine.internal.executor.l18n.Locali zedReportItemExecutor.execute(LocalizedReportItemExecutor.ja va:35)
> at
> org.eclipse.birt.report.engine.layout.html.HTMLBlockStacking LM.layoutChildren(HTMLBlockStackingLM.java:63)
> at
> org.eclipse.birt.report.engine.layout.html.HTMLAbstractLM.la yout(HTMLAbstractLM.java:159)
> at
> org.eclipse.birt.report.engine.layout.html.HTMLInlineStackin gLM.resumeLayout(HTMLInlineStackingLM.java:94)
> at
> org.eclipse.birt.report.engine.layout.html.HTMLInlineStackin gLM.layoutChildren(HTMLInlineStackingLM.java:138)
> at
> org.eclipse.birt.report.engine.layout.html.HTMLAbstractLM.la yout(HTMLAbstractLM.java:159)
> at
> org.eclipse.birt.report.engine.layout.html.HTMLRowLM.layout( HTMLRowLM.java:30)
> at
> org.eclipse.birt.report.engine.layout.html.HTMLBlockStacking LM.layoutChildren(HTMLBlockStackingLM.java:68)
> at
> org.eclipse.birt.report.engine.layout.html.HTMLTableLM.layou tChildren(HTMLTableLM.java:74)
> at
> org.eclipse.birt.report.engine.layout.html.HTMLAbstractLM.la yout(HTMLAbstractLM.java:159)
> at
> org.eclipse.birt.report.engine.layout.html.HTMLPageLM.layout Children(HTMLPageLM.java:139)
> at
> org.eclipse.birt.report.engine.layout.html.HTMLPageLM.layout (HTMLPageLM.java:81)
> at
> org.eclipse.birt.report.engine.layout.html.HTMLReportLayoutE ngine.layout(HTMLReportLayoutEngine.java:80)
> at
> org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.run (RunAndRenderTask.java:194)
> at
> org.eclipse.birt.report.service.ReportEngineService.runAndRe nderReport(Unknown
> Source) at
> org.eclipse.birt.report.service.ReportEngineService.runAndRe nderReport(Unknown
> Source) at
> org.eclipse.birt.report.service.BirtViewerReportService.runA ndRenderReport(Unknown
> Source) at
> org.eclipse.birt.report.service.actionhandler.BirtRunAndRend erActionHandler.__execute(Unknown
> Source) at
> org.eclipse.birt.report.service.actionhandler.AbstractBaseAc tionHandler.execute(Unknown
> Source) at
> org.eclipse.birt.report.presentation.aggregation.layout.Engi neFragment.doService(Unknown
> Source) at
> org.eclipse.birt.report.presentation.aggregation.AbstractBas eFragment.service(Unknown
> Source) at
> org.eclipse.birt.report.servlet.BirtEngineServlet.__doGet(Un known Source)
> at org.eclipse.birt.report.servlet.BaseReportEngineServlet.doGe t(Unknown
> Source) at javax.servlet.http.HttpServlet.service(HttpServlet.java:697) at
> org.apache.axis.transport.http.AxisServletBase.service(AxisS ervletBase.java:327)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:810) at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFi lter(ApplicationFilterChain.java:252)
> at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(App licationFilterChain.java:173)
> at
> org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(Repl yHeaderFilter.java:81)
> at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFi lter(ApplicationFilterChain.java:202)
> at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(App licationFilterChain.java:173)
> at
> org.apache.catalina.core.StandardWrapperValve.invoke(Standar dWrapperValve.java:213)
> at
> org.apache.catalina.core.StandardContextValve.invoke(Standar dContextValve.java:178)
> at
> org.jboss.web.tomcat.security.CustomPrincipalValve.invoke(Cu stomPrincipalValve.java:39)
> at
> org.jboss.web.tomcat.security.SecurityAssociationValve.invok e(SecurityAssociationValve.java:153)
> at
> org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccCo ntextValve.java:59)
> at
> org.apache.catalina.core.StandardHostValve.invoke(StandardHo stValve.java:126)
> at
> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorRepo rtValve.java:105)
> at
> org.apache.catalina.core.StandardEngineValve.invoke(Standard EngineValve.java:107)
> at
> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAd apter.java:148)
> at
> org.apache.coyote.http11.Http11Processor.process(Http11Proce ssor.java:856)
> at
> org.apache.coyote.http11.Http11Protocol$Http11ConnectionHand ler.processConnection(Http11Protocol.java:744)
> at
> org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(Poo lTcpEndpoint.java:527)
> at
> org.apache.tomcat.util.net.MasterSlaveWorkerThread.run(Maste rSlaveWorkerThread.java:112)
> at java.lang.Thread.run(Thread.java:534)Caused by:
> org.mozilla.javascript.EvaluatorException:
> org.eclipse.birt.core.exception.CoreException: Error evaluating Javascript
> expression. Script engine error: ReferenceError: "title1" is not defined.
> Script source: source, line: 0, text:title1 at
> org.eclipse.birt.report.engine.data.dte.NativeRowObject.get( NativeRowObject.java:94)
> at
> org.mozilla.javascript.ScriptableObject.getProperty(Scriptab leObject.java:1263)
> at
> org.mozilla.javascript.ScriptRuntime.getObjectElem(ScriptRun time.java:1301)
> at
> org.mozilla.javascript.ScriptRuntime.getObjectElem(ScriptRun time.java:1283)
> at org.mozilla.javascript.gen.c8._c0(<inline>:1) at
> org.mozilla.javascript.gen.c8.call(<inline>) at
> org.mozilla.javascript.ContextFactory.doTopCall(ContextFacto ry.java:304)
> at org.mozilla.javascript.ScriptRuntime.doTopCall(ScriptRuntime .java:2769)
> at org.mozilla.javascript.gen.c8.call(<inline>) at
> org.mozilla.javascript.gen.c8.exec(<inline>) at
> org.eclipse.birt.core.script.ScriptContext.eval(ScriptContex t.java:224) at
> org.eclipse.birt.report.engine.executor.ExecutionContext.eva luate(ExecutionContext.java:549)
> .. 47 more
>
>
> Data (id = 22): + There are errors evaluating script "row["title3"]".
> Error.ScriptEvaluationError ( 1 time(s) )
> detail : org.eclipse.birt.report.engine.api.EngineException: There are
> errors evaluating script "row["title3"]". at
> org.eclipse.birt.report.engine.executor.ExecutionContext.eva luate(ExecutionContext.java:556)
> at
> org.eclipse.birt.report.engine.executor.ExecutionContext.eva luate(ExecutionContext.java:528)
> at
> org.eclipse.birt.report.engine.executor.DataItemExecutor.exe cute(DataItemExecutor.java:89)
> at
> org.eclipse.birt.report.engine.internal.executor.l18n.Locali zedReportItemExecutor.execute(LocalizedReportItemExecutor.ja va:35)
> at
> org.eclipse.birt.report.engine.layout.html.HTMLBlockStacking LM.layoutChildren(HTMLBlockStackingLM.java:63)
> at
> org.eclipse.birt.report.engine.layout.html.HTMLAbstractLM.la yout(HTMLAbstractLM.java:159)
> at
> org.eclipse.birt.report.engine.layout.html.HTMLInlineStackin gLM.resumeLayout(HTMLInlineStackingLM.java:94)
> at
> org.eclipse.birt.report.engine.layout.html.HTMLInlineStackin gLM.layoutChildren(HTMLInlineStackingLM.java:138)
> at
> org.eclipse.birt.report.engine.layout.html.HTMLAbstractLM.la yout(HTMLAbstractLM.java:159)
> at
> org.eclipse.birt.report.engine.layout.html.HTMLRowLM.layout( HTMLRowLM.java:30)
> at
> org.eclipse.birt.report.engine.layout.html.HTMLBlockStacking LM.layoutChildren(HTMLBlockStackingLM.java:68)
> at
> org.eclipse.birt.report.engine.layout.html.HTMLTableLM.layou tChildren(HTMLTableLM.java:74)
> at
> org.eclipse.birt.report.engine.layout.html.HTMLAbstractLM.la yout(HTMLAbstractLM.java:159)
> at
> org.eclipse.birt.report.engine.layout.html.HTMLPageLM.layout Children(HTMLPageLM.java:139)
> at
> org.eclipse.birt.report.engine.layout.html.HTMLPageLM.layout (HTMLPageLM.java:81)
> at
> org.eclipse.birt.report.engine.layout.html.HTMLReportLayoutE ngine.layout(HTMLReportLayoutEngine.java:80)
> at
> org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.run (RunAndRenderTask.java:194)
> at
> org.eclipse.birt.report.service.ReportEngineService.runAndRe nderReport(Unknown
> Source) at
> org.eclipse.birt.report.service.ReportEngineService.runAndRe nderReport(Unknown
> Source) at
> org.eclipse.birt.report.service.BirtViewerReportService.runA ndRenderReport(Unknown
> Source) at
> org.eclipse.birt.report.service.actionhandler.BirtRunAndRend erActionHandler.__execute(Unknown
> Source) at
> org.eclipse.birt.report.service.actionhandler.AbstractBaseAc tionHandler.execute(Unknown
> Source) at
> org.eclipse.birt.report.presentation.aggregation.layout.Engi neFragment.doService(Unknown
> Source) at
> org.eclipse.birt.report.presentation.aggregation.AbstractBas eFragment.service(Unknown
> Source) at
> org.eclipse.birt.report.servlet.BirtEngineServlet.__doGet(Un known Source)
> at org.eclipse.birt.report.servlet.BaseReportEngineServlet.doGe t(Unknown
> Source) at javax.servlet.http.HttpServlet.service(HttpServlet.java:697) at
> org.apache.axis.transport.http.AxisServletBase.service(AxisS ervletBase.java:327)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:810) at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFi lter(ApplicationFilterChain.java:252)
> at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(App licationFilterChain.java:173)
> at
> org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(Repl yHeaderFilter.java:81)
> at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFi lter(ApplicationFilterChain.java:202)
> at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(App licationFilterChain.java:173)
> at
> org.apache.catalina.core.StandardWrapperValve.invoke(Standar dWrapperValve.java:213)
> at
> org.apache.catalina.core.StandardContextValve.invoke(Standar dContextValve.java:178)
> at
> org.jboss.web.tomcat.security.CustomPrincipalValve.invoke(Cu stomPrincipalValve.java:39)
> at
> org.jboss.web.tomcat.security.SecurityAssociationValve.invok e(SecurityAssociationValve.java:153)
> at
> org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccCo ntextValve.java:59)
> at
> org.apache.catalina.core.StandardHostValve.invoke(StandardHo stValve.java:126)
> at
> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorRepo rtValve.java:105)
> at
> org.apache.catalina.core.StandardEngineValve.invoke(Standard EngineValve.java:107)
> at
> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAd apter.java:148)
> at
> org.apache.coyote.http11.Http11Processor.process(Http11Proce ssor.java:856)
> at
> org.apache.coyote.http11.Http11Protocol$Http11ConnectionHand ler.processConnection(Http11Protocol.java:744)
> at
> org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(Poo lTcpEndpoint.java:527)
> at
> org.apache.tomcat.util.net.MasterSlaveWorkerThread.run(Maste rSlaveWorkerThread.java:112)
> at java.lang.Thread.run(Thread.java:534)Caused by:
> org.mozilla.javascript.EvaluatorException:
> org.eclipse.birt.core.exception.CoreException: Error evaluating Javascript
> expression. Script engine error: ReferenceError: "title3" is not defined.
> Script source: source, line: 0, text:title3 at
> org.eclipse.birt.report.engine.data.dte.NativeRowObject.get( NativeRowObject.java:94)
> at
> org.mozilla.javascript.ScriptableObject.getProperty(Scriptab leObject.java:1263)
> at
> org.mozilla.javascript.ScriptRuntime.getObjectElem(ScriptRun time.java:1301)
> at
> org.mozilla.javascript.ScriptRuntime.getObjectElem(ScriptRun time.java:1283)
> at org.mozilla.javascript.gen.c10._c0(<inline>:1) at
> org.mozilla.javascript.gen.c10.call(<inline>) at
> org.mozilla.javascript.ContextFactory.doTopCall(ContextFacto ry.java:304)
> at org.mozilla.javascript.ScriptRuntime.doTopCall(ScriptRuntime .java:2769)
> at org.mozilla.javascript.gen.c10.call(<inline>) at
> org.mozilla.javascript.gen.c10.exec(<inline>) at
> org.eclipse.birt.core.script.ScriptContext.eval(ScriptContex t.java:224) at
> org.eclipse.birt.report.engine.executor.ExecutionContext.eva luate(ExecutionContext.java:549)
> .. 47 more
>
>
> Data (id = 25): + There are errors evaluating script "row["title2"]".
> Error.ScriptEvaluationError ( 1 time(s) )
> detail : org.eclipse.birt.report.engine.api.EngineException: There are
> errors evaluating script "row["title2"]". at
> org.eclipse.birt.report.engine.executor.ExecutionContext.eva luate(ExecutionContext.java:556)
> at
> org.eclipse.birt.report.engine.executor.ExecutionContext.eva luate(ExecutionContext.java:528)
> at
> org.eclipse.birt.report.engine.executor.DataItemExecutor.exe cute(DataItemExecutor.java:89)
> at
> org.eclipse.birt.report.engine.internal.executor.l18n.Locali zedReportItemExecutor.execute(LocalizedReportItemExecutor.ja va:35)
> at
> org.eclipse.birt.report.engine.layout.html.HTMLBlockStacking LM.layoutChildren(HTMLBlockStackingLM.java:63)
> at
> org.eclipse.birt.report.engine.layout.html.HTMLAbstractLM.la yout(HTMLAbstractLM.java:159)
> at
> org.eclipse.birt.report.engine.layout.html.HTMLInlineStackin gLM.resumeLayout(HTMLInlineStackingLM.java:94)
> at
> org.eclipse.birt.report.engine.layout.html.HTMLInlineStackin gLM.layoutChildren(HTMLInlineStackingLM.java:138)
> at
> org.eclipse.birt.report.engine.layout.html.HTMLAbstractLM.la yout(HTMLAbstractLM.java:159)
> at
> org.eclipse.birt.report.engine.layout.html.HTMLRowLM.layout( HTMLRowLM.java:30)
> at
> org.eclipse.birt.report.engine.layout.html.HTMLBlockStacking LM.layoutChildren(HTMLBlockStackingLM.java:68)
> at
> org.eclipse.birt.report.engine.layout.html.HTMLTableLM.layou tChildren(HTMLTableLM.java:74)
> at
> org.eclipse.birt.report.engine.layout.html.HTMLAbstractLM.la yout(HTMLAbstractLM.java:159)
> at
> org.eclipse.birt.report.engine.layout.html.HTMLPageLM.layout Children(HTMLPageLM.java:139)
> at
> org.eclipse.birt.report.engine.layout.html.HTMLPageLM.layout (HTMLPageLM.java:81)
> at
> org.eclipse.birt.report.engine.layout.html.HTMLReportLayoutE ngine.layout(HTMLReportLayoutEngine.java:80)
> at
> org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.run (RunAndRenderTask.java:194)
> at
> org.eclipse.birt.report.service.ReportEngineService.runAndRe nderReport(Unknown
> Source) at
> org.eclipse.birt.report.service.ReportEngineService.runAndRe nderReport(Unknown
> Source) at
> org.eclipse.birt.report.service.BirtViewerReportService.runA ndRenderReport(Unknown
> Source) at
> org.eclipse.birt.report.service.actionhandler.BirtRunAndRend erActionHandler.__execute(Unknown
> Source) at
> org.eclipse.birt.report.service.actionhandler.AbstractBaseAc tionHandler.execute(Unknown
> Source) at
> org.eclipse.birt.report.presentation.aggregation.layout.Engi neFragment.doService(Unknown
> Source) at
> org.eclipse.birt.report.presentation.aggregation.AbstractBas eFragment.service(Unknown
> Source) at
> org.eclipse.birt.report.servlet.BirtEngineServlet.__doGet(Un known Source)
> at org.eclipse.birt.report.servlet.BaseReportEngineServlet.doGe t(Unknown
> Source) at javax.servlet.http.HttpServlet.service(HttpServlet.java:697) at
> org.apache.axis.transport.http.AxisServletBase.service(AxisS ervletBase.java:327)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:810) at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFi lter(ApplicationFilterChain.java:252)
> at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(App licationFilterChain.java:173)
> at
> org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(Repl yHeaderFilter.java:81)
> at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFi lter(ApplicationFilterChain.java:202)
> at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(App licationFilterChain.java:173)
> at
> org.apache.catalina.core.StandardWrapperValve.invoke(Standar dWrapperValve.java:213)
> at
> org.apache.catalina.core.StandardContextValve.invoke(Standar dContextValve.java:178)
> at
> org.jboss.web.tomcat.security.CustomPrincipalValve.invoke(Cu stomPrincipalValve.java:39)
> at
> org.jboss.web.tomcat.security.SecurityAssociationValve.invok e(SecurityAssociationValve.java:153)
> at
> org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccCo ntextValve.java:59)
> at
> org.apache.catalina.core.StandardHostValve.invoke(StandardHo stValve.java:126)
> at
> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorRepo rtValve.java:105)
> at
> org.apache.catalina.core.StandardEngineValve.invoke(Standard EngineValve.java:107)
> at
> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAd apter.java:148)
> at
> org.apache.coyote.http11.Http11Processor.process(Http11Proce ssor.java:856)
> at
> org.apache.coyote.http11.Http11Protocol$Http11ConnectionHand ler.processConnection(Http11Protocol.java:744)
> at
> org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(Poo lTcpEndpoint.java:527)
> at
> org.apache.tomcat.util.net.MasterSlaveWorkerThread.run(Maste rSlaveWorkerThread.java:112)
> at java.lang.Thread.run(Thread.java:534)Caused by:
> org.mozilla.javascript.EvaluatorException:
> org.eclipse.birt.core.exception.CoreException: Error evaluating Javascript
> expression. Script engine error: ReferenceError: "title2" is not defined.
> Script source: source, line: 0, text:title2 at
> org.eclipse.birt.report.engine.data.dte.NativeRowObject.get( NativeRowObject.java:94)
> at
> org.mozilla.javascript.ScriptableObject.getProperty(Scriptab leObject.java:1263)
> at
> org.mozilla.javascript.ScriptRuntime.getObjectElem(ScriptRun time.java:1301)
> at
> org.mozilla.javascript.ScriptRuntime.getObjectElem(ScriptRun time.java:1283)
> at org.mozilla.javascript.gen.c12._c0(<inline>:1) at
> org.mozilla.javascript.gen.c12.call(<inline>) at
> org.mozilla.javascript.ContextFactory.doTopCall(ContextFacto ry.java:304)
> at org.mozilla.javascript.ScriptRuntime.doTopCall(ScriptRuntime .java:2769)
> at org.mozilla.javascript.gen.c12.call(<inline>) at
> org.mozilla.javascript.gen.c12.exec(<inline>) at
> org.eclipse.birt.core.script.ScriptContext.eval(ScriptContex t.java:224) at
> org.eclipse.birt.report.engine.executor.ExecutionContext.eva luate(ExecutionContext.java:549)
> .. 47 more
>
>
> Data (id = 27): + There are errors evaluating script "row["title4"]".
> Error.ScriptEvaluationError ( 1 time(s) )
> detail : org.eclipse.birt.report.engine.api.EngineException: There are
> errors evaluating script "row["title4"]". at
> org.eclipse.birt.report.engine.executor.ExecutionContext.eva luate(ExecutionContext.java:556)
> at
> org.eclipse.birt.report.engine.executor.ExecutionContext.eva luate(ExecutionContext.java:528)
> at
> org.eclipse.birt.report.engine.executor.DataItemExecutor.exe cute(DataItemExecutor.java:89)
> at
> org.eclipse.birt.report.engine.internal.executor.l18n.Locali zedReportItemExecutor.execute(LocalizedReportItemExecutor.ja va:35)
> at
> org.eclipse.birt.report.engine.layout.html.HTMLBlockStacking LM.layoutChildren(HTMLBlockStackingLM.java:63)
> at
> org.eclipse.birt.report.engine.layout.html.HTMLAbstractLM.la yout(HTMLAbstractLM.java:159)
> at
> org.eclipse.birt.report.engine.layout.html.HTMLInlineStackin gLM.resumeLayout(HTMLInlineStackingLM.java:94)
> at
> org.eclipse.birt.report.engine.layout.html.HTMLInlineStackin gLM.layoutChildren(HTMLInlineStackingLM.java:138)
> at
> org.eclipse.birt.report.engine.layout.html.HTMLAbstractLM.la yout(HTMLAbstractLM.java:159)
> at
> org.eclipse.birt.report.engine.layout.html.HTMLRowLM.layout( HTMLRowLM.java:30)
> at
> org.eclipse.birt.report.engine.layout.html.HTMLBlockStacking LM.layoutChildren(HTMLBlockStackingLM.java:68)
> at
> org.eclipse.birt.report.engine.layout.html.HTMLTableLM.layou tChildren(HTMLTableLM.java:74)
> at
> org.eclipse.birt.report.engine.layout.html.HTMLAbstractLM.la yout(HTMLAbstractLM.java:159)
> at
> org.eclipse.birt.report.engine.layout.html.HTMLPageLM.layout Children(HTMLPageLM.java:139)
> at
> org.eclipse.birt.report.engine.layout.html.HTMLPageLM.layout (HTMLPageLM.java:81)
> at
> org.eclipse.birt.report.engine.layout.html.HTMLReportLayoutE ngine.layout(HTMLReportLayoutEngine.java:80)
> at
> org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.run (RunAndRenderTask.java:194)
> at
> org.eclipse.birt.report.service.ReportEngineService.runAndRe nderReport(Unknown
> Source) at
> org.eclipse.birt.report.service.ReportEngineService.runAndRe nderReport(Unknown
> Source) at
> org.eclipse.birt.report.service.BirtViewerReportService.runA ndRenderReport(Unknown
> Source) at
> org.eclipse.birt.report.service.actionhandler.BirtRunAndRend erActionHandler.__execute(Unknown
> Source) at
> org.eclipse.birt.report.service.actionhandler.AbstractBaseAc tionHandler.execute(Unknown
> Source) at
> org.eclipse.birt.report.presentation.aggregation.layout.Engi neFragment.doService(Unknown
> Source) at
> org.eclipse.birt.report.presentation.aggregation.AbstractBas eFragment.service(Unknown
> Source) at
> org.eclipse.birt.report.servlet.BirtEngineServlet.__doGet(Un known Source)
> at org.eclipse.birt.report.servlet.BaseReportEngineServlet.doGe t(Unknown
> Source) at javax.servlet.http.HttpServlet.service(HttpServlet.java:697) at
> org.apache.axis.transport.http.AxisServletBase.service(AxisS ervletBase.java:327)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:810) at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFi lter(ApplicationFilterChain.java:252)
> at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(App licationFilterChain.java:173)
> at
> org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(Repl yHeaderFilter.java:81)
> at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFi lter(ApplicationFilterChain.java:202)
> at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(App licationFilterChain.java:173)
> at
> org.apache.catalina.core.StandardWrapperValve.invoke(Standar dWrapperValve.java:213)
> at
> org.apache.catalina.core.StandardContextValve.invoke(Standar dContextValve.java:178)
> at
> org.jboss.web.tomcat.security.CustomPrincipalValve.invoke(Cu stomPrincipalValve.java:39)
> at
> org.jboss.web.tomcat.security.SecurityAssociationValve.invok e(SecurityAssociationValve.java:153)
> at
> org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccCo ntextValve.java:59)
> at
> org.apache.catalina.core.StandardHostValve.invoke(StandardHo stValve.java:126)
> at
> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorRepo rtValve.java:105)
> at
> org.apache.catalina.core.StandardEngineValve.invoke(Standard EngineValve.java:107)
> at
> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAd apter.java:148)
> at
> org.apache.coyote.http11.Http11Processor.process(Http11Proce ssor.java:856)
> at
> org.apache.coyote.http11.Http11Protocol$Http11ConnectionHand ler.processConnection(Http11Protocol.java:744)
> at
> org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(Poo lTcpEndpoint.java:527)
> at
> org.apache.tomcat.util.net.MasterSlaveWorkerThread.run(Maste rSlaveWorkerThread.java:112)
> at java.lang.Thread.run(Thread.java:534)Caused by:
> org.mozilla.javascript.EvaluatorException:
> org.eclipse.birt.core.exception.CoreException: Error evaluating Javascript
> expression. Script engine error: ReferenceError: "title4" is not defined.
> Script source: source, line: 0, text:title4 at
> org.eclipse.birt.report.engine.data.dte.NativeRowObject.get( NativeRowObject.java:94)
> at
> org.mozilla.javascript.ScriptableObject.getProperty(Scriptab leObject.java:1263)
> at
> org.mozilla.javascript.ScriptRuntime.getObjectElem(ScriptRun time.java:1301)
> at
> org.mozilla.javascript.ScriptRuntime.getObjectElem(ScriptRun time.java:1283)
> at org.mozilla.javascript.gen.c14._c0(<inline>:1) at
> org.mozilla.javascript.gen.c14.call(<inline>) at
> org.mozilla.javascript.ContextFactory.doTopCall(ContextFacto ry.java:304)
> at org.mozilla.javascript.ScriptRuntime.doTopCall(ScriptRuntime .java:2769)
> at org.mozilla.javascript.gen.c14.call(<inline>) at
> org.mozilla.javascript.gen.c14.exec(<inline>) at
> org.eclipse.birt.core.script.ScriptContext.eval(ScriptContex t.java:224) at
> org.eclipse.birt.report.engine.executor.ExecutionContext.eva luate(ExecutionContext.java:549)
> .. 47 more
>
>
> anyone can help me? thanks...
>
Re: passing report parameter [message #201112 is a reply to message #201043] Thu, 16 November 2006 00:16 Go to previous messageGo to next message
Eclipse UserFriend
Originally posted by: keeling040982.yahoo.com

hai jason...thanks for you helping in this problem, after i try, the other
error message comes out as below:

The following items have errors:


ReportDesign (id = 1):
+ There are errors evaluating script "str1 = params["splitparm"].value;
arr1 = str1.split(",");".
Error.ScriptEvaluationError ( 1 time(s) )
detail : org.eclipse.birt.report.engine.api.EngineException: There are
errors evaluating script "str1 = params["splitparm"].value;arr1 =
str1.split(",");". at
org.eclipse.birt.report.engine.executor.ExecutionContext.eva luate(ExecutionContext.java:556)
at
org.eclipse.birt.report.engine.executor.ExecutionContext.eva luate(ExecutionContext.java:528)
at
org.eclipse.birt.report.engine.script.internal.ScriptExecuto r.handleJSInternal(ScriptExecutor.java:66)
at
org.eclipse.birt.report.engine.script.internal.ScriptExecuto r.handleJS(ScriptExecutor.java:50)
at
org.eclipse.birt.report.engine.script.internal.ReportScriptE xecutor.handleInitialize(ReportScriptExecutor.java:28)
at
org.eclipse.birt.report.engine.api.impl.EngineTask.loadDesig n(EngineTask.java:860)
at
org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.run (RunAndRenderTask.java:149)
at
org.eclipse.birt.report.service.ReportEngineService.runAndRe nderReport(Unknown
Source) at
org.eclipse.birt.report.service.ReportEngineService.runAndRe nderReport(Unknown
Source) at
org.eclipse.birt.report.service.BirtViewerReportService.runA ndRenderReport(Unknown
Source) at
org.eclipse.birt.report.service.actionhandler.BirtRunAndRend erActionHandler.__execute(Unknown
Source) at
org.eclipse.birt.report.service.actionhandler.AbstractBaseAc tionHandler.execute(Unknown
Source) at
org.eclipse.birt.report.presentation.aggregation.layout.Engi neFragment.doService(Unknown
Source) at
org.eclipse.birt.report.presentation.aggregation.AbstractBas eFragment.service(Unknown
Source) at
org.eclipse.birt.report.servlet.BirtEngineServlet.__doGet(Un known Source)
at org.eclipse.birt.report.servlet.BaseReportEngineServlet.doGe t(Unknown
Source) at javax.servlet.http.HttpServlet.service(HttpServlet.java:740) at
org.apache.axis.transport.http.AxisServletBase.service(AxisS ervletBase.java:327)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at
org.apache.catalina.core.ApplicationFilterChain.internalDoFi lter(ApplicationFilterChain.java:247)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(App licationFilterChain.java:193)
at
org.apache.catalina.core.StandardWrapperValve.invoke(Standar dWrapperValve.java:256)
at
org.apache.catalina.core.StandardPipeline$StandardPipelineVa lveContext.invokeNext(StandardPipeline.java:643)
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPip eline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase. java:995)
at
org.apache.catalina.core.StandardContextValve.invoke(Standar dContextValve.java:191)
at
org.apache.catalina.core.StandardPipeline$StandardPipelineVa lveContext.invokeNext(StandardPipeline.java:643)
at
org.apache.catalina.valves.CertificatesValve.invoke(Certific atesValve.java:246)
at
org.apache.catalina.core.StandardPipeline$StandardPipelineVa lveContext.invokeNext(StandardPipeline.java:641)
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPip eline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase. java:995)
at
org.apache.catalina.core.StandardContext.invoke(StandardCont ext.java:2422)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHo stValve.java:180)
at
org.apache.catalina.core.StandardPipeline$StandardPipelineVa lveContext.invokeNext(StandardPipeline.java:643)
at
org.apache.catalina.valves.ErrorDispatcherValve.invoke(Error DispatcherValve.java:171)
at
org.apache.catalina.core.StandardPipeline$StandardPipelineVa lveContext.invokeNext(StandardPipeline.java:641)
at
org.eclipse.tomcat.internal.EclipseErrorReportValve.invoke(E clipseErrorReportValve.java:153)
at
org.apache.catalina.core.StandardPipeline$StandardPipelineVa lveContext.invokeNext(StandardPipeline.java:641)
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPip eline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase. java:995)
at
org.apache.catalina.core.StandardEngineValve.invoke(Standard EngineValve.java:174)
at
org.apache.catalina.core.StandardPipeline$StandardPipelineVa lveContext.invokeNext(StandardPipeline.java:643)
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPip eline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase. java:995)
at org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapte r.java:199)
at
org.apache.coyote.http11.Http11Processor.process(Http11Proce ssor.java:828)
at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHand ler.processConnection(Http11Protocol.java:700)
at
org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndp oint.java:584)
at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.ru n(ThreadPool.java:683)
at java.lang.Thread.run(Unknown Source)Caused by:
org.mozilla.javascript.EcmaError: TypeError: Cannot call method "split" of
null (<inline>#2) at
org.mozilla.javascript.ScriptRuntime.constructError(ScriptRu ntime.java:3240)
at
org.mozilla.javascript.ScriptRuntime.constructError(ScriptRu ntime.java:3230)
at org.mozilla.javascript.ScriptRuntime.typeError(ScriptRuntime .java:3246)
at
org.mozilla.javascript.ScriptRuntime.typeError2(ScriptRuntim e.java:3265)
at
org.mozilla.javascript.ScriptRuntime.undefCallError(ScriptRu ntime.java:3284)
at
org.mozilla.javascript.ScriptRuntime.getPropFunctionAndThis( ScriptRuntime.java:1965)
at org.mozilla.javascript.gen.c15._c0(<inline>:2) at
org.mozilla.javascript.gen.c15.call(<inline>) at
org.mozilla.javascript.ContextFactory.doTopCall(ContextFacto ry.java:304)
at org.mozilla.javascript.ScriptRuntime.doTopCall(ScriptRuntime .java:2769)
at org.mozilla.javascript.gen.c15.call(<inline>) at
org.mozilla.javascript.gen.c15.exec(<inline>) at
org.eclipse.birt.core.script.ScriptContext.eval(ScriptContex t.java:224) at
org.eclipse.birt.report.engine.executor.ExecutionContext.eva luate(ExecutionContext.java:549)
... 49 more


Table (id = 7):
+ Cannot get the result set metadata.
SQL statement does not return a ResultSet object.
SQL error #1: Syntax error or access violation, message from server: "You
have an error in your SQL syntax; check the manual that corresponds to
your MySQL server version for the right syntax to use near 'null' at line
1"

odaconsumer.CannotGetResultSetMetaData ( 1 time(s) )
detail : org.eclipse.birt.data.engine.core.DataException: Cannot get the
result set metadata.SQL statement does not return a ResultSet object.SQL
error #1: Syntax error or access violation, message from server: "You
have an error in your SQL syntax; check the manual that corresponds to
your MySQL server version for the right syntax to use near 'null' at line
1" at
org.eclipse.birt.data.engine.odaconsumer.PreparedStatement.g etRuntimeMetaData(PreparedStatement.java:379)
at
org.eclipse.birt.data.engine.odaconsumer.PreparedStatement.g etProjectedColumns(PreparedStatement.java:339)
at
org.eclipse.birt.data.engine.odaconsumer.PreparedStatement.d eclareCustomColumn(PreparedStatement.java:1079)
at
org.eclipse.birt.data.engine.executor.DataSourceQuery.addCus tomFields(DataSourceQuery.java:388)
at
org.eclipse.birt.data.engine.executor.DataSourceQuery.prepar e(DataSourceQuery.java:256)
at
org.eclipse.birt.data.engine.impl.PreparedOdaDSQuery$OdaDSQu eryExecutor.prepareOdiQuery(PreparedOdaDSQuery.java:344)
at
org.eclipse.birt.data.engine.impl.QueryExecutor.prepareExecu tion(QueryExecutor.java:212)
at
org.eclipse.birt.data.engine.impl.PreparedQuery.doPrepare(Pr eparedQuery.java:397)
at
org.eclipse.birt.data.engine.impl.PreparedDataSourceQuery.ex ecute(PreparedDataSourceQuery.java:147)
at
org.eclipse.birt.data.engine.impl.PreparedOdaDSQuery.execute (PreparedOdaDSQuery.java:135)
at
org.eclipse.birt.data.engine.impl.PreparedDataSourceQuery.ex ecute(PreparedDataSourceQuery.java:127)
at
org.eclipse.birt.report.engine.data.dte.DteDataEngine.doExec uteQuery(DteDataEngine.java:114)
at
org.eclipse.birt.report.engine.data.dte.AbstractDataEngine.e xecute(AbstractDataEngine.java:208)
at
org.eclipse.birt.report.engine.executor.ExecutionContext.exe cuteQuery(ExecutionContext.java:1640)
at
org.eclipse.birt.report.engine.executor.QueryItemExecutor.ex ecuteQuery(QueryItemExecutor.java:62)
at
org.eclipse.birt.report.engine.executor.TableItemExecutor.ex ecute(TableItemExecutor.java:74)
at
org.eclipse.birt.report.engine.internal.executor.l18n.Locali zedReportItemExecutor.execute(LocalizedReportItemExecutor.ja va:35)
at
org.eclipse.birt.report.engine.layout.html.HTMLPageLM.layout Children(HTMLPageLM.java:123)
at
org.eclipse.birt.report.engine.layout.html.HTMLPageLM.layout (HTMLPageLM.java:81)
at
org.eclipse.birt.report.engine.layout.html.HTMLReportLayoutE ngine.layout(HTMLReportLayoutEngine.java:80)
at
org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.run (RunAndRenderTask.java:194)
at
org.eclipse.birt.report.service.ReportEngineService.runAndRe nderReport(Unknown
Source) at
org.eclipse.birt.report.service.ReportEngineService.runAndRe nderReport(Unknown
Source) at
org.eclipse.birt.report.service.BirtViewerReportService.runA ndRenderReport(Unknown
Source) at
org.eclipse.birt.report.service.actionhandler.BirtRunAndRend erActionHandler.__execute(Unknown
Source) at
org.eclipse.birt.report.service.actionhandler.AbstractBaseAc tionHandler.execute(Unknown
Source) at
org.eclipse.birt.report.presentation.aggregation.layout.Engi neFragment.doService(Unknown
Source) at
org.eclipse.birt.report.presentation.aggregation.AbstractBas eFragment.service(Unknown
Source) at
org.eclipse.birt.report.servlet.BirtEngineServlet.__doGet(Un known Source)
at org.eclipse.birt.report.servlet.BaseReportEngineServlet.doGe t(Unknown
Source) at javax.servlet.http.HttpServlet.service(HttpServlet.java:740) at
org.apache.axis.transport.http.AxisServletBase.service(AxisS ervletBase.java:327)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at
org.apache.catalina.core.ApplicationFilterChain.internalDoFi lter(ApplicationFilterChain.java:247)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(App licationFilterChain.java:193)
at
org.apache.catalina.core.StandardWrapperValve.invoke(Standar dWrapperValve.java:256)
at
org.apache.catalina.core.StandardPipeline$StandardPipelineVa lveContext.invokeNext(StandardPipeline.java:643)
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPip eline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase. java:995)
at
org.apache.catalina.core.StandardContextValve.invoke(Standar dContextValve.java:191)
at
org.apache.catalina.core.StandardPipeline$StandardPipelineVa lveContext.invokeNext(StandardPipeline.java:643)
at
org.apache.catalina.valves.CertificatesValve.invoke(Certific atesValve.java:246)
at
org.apache.catalina.core.StandardPipeline$StandardPipelineVa lveContext.invokeNext(StandardPipeline.java:641)
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPip eline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase. java:995)
at
org.apache.catalina.core.StandardContext.invoke(StandardCont ext.java:2422)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHo stValve.java:180)
at
org.apache.catalina.core.StandardPipeline$StandardPipelineVa lveContext.invokeNext(StandardPipeline.java:643)
at
org.apache.catalina.valves.ErrorDispatcherValve.invoke(Error DispatcherValve.java:171)
at
org.apache.catalina.core.StandardPipeline$StandardPipelineVa lveContext.invokeNext(StandardPipeline.java:641)
at
org.eclipse.tomcat.internal.EclipseErrorReportValve.invoke(E clipseErrorReportValve.java:153)
at
org.apache.catalina.core.StandardPipeline$StandardPipelineVa lveContext.invokeNext(StandardPipeline.java:641)
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPip eline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase. java:995)
at
org.apache.catalina.core.StandardEngineValve.invoke(Standard EngineValve.java:174)
at
org.apache.catalina.core.StandardPipeline$StandardPipelineVa lveContext.invokeNext(StandardPipeline.java:643)
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPip eline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase. java:995)
at org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapte r.java:199)
at
org.apache.coyote.http11.Http11Processor.process(Http11Proce ssor.java:828)
at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHand ler.processConnection(Http11Protocol.java:700)
at
org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndp oint.java:584)
at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.ru n(ThreadPool.java:683)
at java.lang.Thread.run(Unknown Source)Caused by:
org.eclipse.birt.report.data.oda.jdbc.JDBCException: SQL statement does
not return a ResultSet object.SQL error #1: Syntax error or access
violation, message from server: "You have an error in your SQL syntax;
check the manual that corresponds to your MySQL server version for the
right syntax to use near 'null' at line 1" ; java.sql.SQLException:
Syntax error or access violation, message from server: "You have an error
in your SQL syntax; check the manual that corresponds to your MySQL server
version for the right syntax to use near 'null' at line 1" at
org.eclipse.birt.report.data.oda.jdbc.Statement.executeQuery (Statement.java:344)
at
org.eclipse.birt.report.data.oda.jdbc.Statement.getMetaData( Statement.java:296)
at
org.eclipse.datatools.connectivity.oda.consumer.helper.OdaQu ery.doGetMetaData(OdaQuery.java:388)
at
org.eclipse.datatools.connectivity.oda.consumer.helper.OdaQu ery.getMetaData(OdaQuery.java:356)
at
org.eclipse.birt.data.engine.odaconsumer.PreparedStatement.g etRuntimeMetaData(PreparedStatement.java:369)
... 63 moreCaused by: java.sql.SQLException: Syntax error or access
violation, message from server: "You have an error in your SQL syntax;
check the manual that corresponds to your MySQL server version for the
right syntax to use near 'null' at line 1" at
com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:1905) at
com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1109) at
com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1203) at
com.mysql.jdbc.Connection.execSQL(Connection.java:2090) at
com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatem ent.java:1496)
at
org.eclipse.birt.report.data.oda.jdbc.Statement.executeQuery (Statement.java:340)
... 67 more


is that measn there exist error in my SQL statement??
Re: passing report parameter [message #201288 is a reply to message #201112] Thu, 16 November 2006 18:14 Go to previous message
Jason Weathersby is currently offline Jason WeathersbyFriend
Messages: 9167
Registered: July 2009
Senior Member

Yes. You may be getting a set of double quotes or something. Try building
a blank report put in your parameter and split it and drop a dynmaic text
element and put your value in to see what it is using.

Jason

"ice" <keeling040982@yahoo.com> wrote in message
news:5d29db8bafd4c842887c74d4665c7e25$1@www.eclipse.org...
> hai jason...thanks for you helping in this problem, after i try, the other
> error message comes out as below:
>
> The following items have errors:
>
> ReportDesign (id = 1): + There are errors evaluating script "str1 =
> params["splitparm"].value;
> arr1 = str1.split(",");". Error.ScriptEvaluationError ( 1 time(s) )
> detail : org.eclipse.birt.report.engine.api.EngineException: There are
> errors evaluating script "str1 = params["splitparm"].value;arr1 =
> str1.split(",");". at
> org.eclipse.birt.report.engine.executor.ExecutionContext.eva luate(ExecutionContext.java:556)
> at
> org.eclipse.birt.report.engine.executor.ExecutionContext.eva luate(ExecutionContext.java:528)
> at
> org.eclipse.birt.report.engine.script.internal.ScriptExecuto r.handleJSInternal(ScriptExecutor.java:66)
> at
> org.eclipse.birt.report.engine.script.internal.ScriptExecuto r.handleJS(ScriptExecutor.java:50)
> at
> org.eclipse.birt.report.engine.script.internal.ReportScriptE xecutor.handleInitialize(ReportScriptExecutor.java:28)
> at
> org.eclipse.birt.report.engine.api.impl.EngineTask.loadDesig n(EngineTask.java:860)
> at
> org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.run (RunAndRenderTask.java:149)
> at
> org.eclipse.birt.report.service.ReportEngineService.runAndRe nderReport(Unknown
> Source) at
> org.eclipse.birt.report.service.ReportEngineService.runAndRe nderReport(Unknown
> Source) at
> org.eclipse.birt.report.service.BirtViewerReportService.runA ndRenderReport(Unknown
> Source) at
> org.eclipse.birt.report.service.actionhandler.BirtRunAndRend erActionHandler.__execute(Unknown
> Source) at
> org.eclipse.birt.report.service.actionhandler.AbstractBaseAc tionHandler.execute(Unknown
> Source) at
> org.eclipse.birt.report.presentation.aggregation.layout.Engi neFragment.doService(Unknown
> Source) at
> org.eclipse.birt.report.presentation.aggregation.AbstractBas eFragment.service(Unknown
> Source) at
> org.eclipse.birt.report.servlet.BirtEngineServlet.__doGet(Un known Source)
> at org.eclipse.birt.report.servlet.BaseReportEngineServlet.doGe t(Unknown
> Source) at javax.servlet.http.HttpServlet.service(HttpServlet.java:740) at
> org.apache.axis.transport.http.AxisServletBase.service(AxisS ervletBase.java:327)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFi lter(ApplicationFilterChain.java:247)
> at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(App licationFilterChain.java:193)
> at
> org.apache.catalina.core.StandardWrapperValve.invoke(Standar dWrapperValve.java:256)
> at
> org.apache.catalina.core.StandardPipeline$StandardPipelineVa lveContext.invokeNext(StandardPipeline.java:643)
> at
> org.apache.catalina.core.StandardPipeline.invoke(StandardPip eline.java:480)
> at org.apache.catalina.core.ContainerBase.invoke(ContainerBase. java:995)
> at
> org.apache.catalina.core.StandardContextValve.invoke(Standar dContextValve.java:191)
> at
> org.apache.catalina.core.StandardPipeline$StandardPipelineVa lveContext.invokeNext(StandardPipeline.java:643)
> at
> org.apache.catalina.valves.CertificatesValve.invoke(Certific atesValve.java:246)
> at
> org.apache.catalina.core.StandardPipeline$StandardPipelineVa lveContext.invokeNext(StandardPipeline.java:641)
> at
> org.apache.catalina.core.StandardPipeline.invoke(StandardPip eline.java:480)
> at org.apache.catalina.core.ContainerBase.invoke(ContainerBase. java:995)
> at
> org.apache.catalina.core.StandardContext.invoke(StandardCont ext.java:2422)
> at
> org.apache.catalina.core.StandardHostValve.invoke(StandardHo stValve.java:180)
> at
> org.apache.catalina.core.StandardPipeline$StandardPipelineVa lveContext.invokeNext(StandardPipeline.java:643)
> at
> org.apache.catalina.valves.ErrorDispatcherValve.invoke(Error DispatcherValve.java:171)
> at
> org.apache.catalina.core.StandardPipeline$StandardPipelineVa lveContext.invokeNext(StandardPipeline.java:641)
> at
> org.eclipse.tomcat.internal.EclipseErrorReportValve.invoke(E clipseErrorReportValve.java:153)
> at
> org.apache.catalina.core.StandardPipeline$StandardPipelineVa lveContext.invokeNext(StandardPipeline.java:641)
> at
> org.apache.catalina.core.StandardPipeline.invoke(StandardPip eline.java:480)
> at org.apache.catalina.core.ContainerBase.invoke(ContainerBase. java:995)
> at
> org.apache.catalina.core.StandardEngineValve.invoke(Standard EngineValve.java:174)
> at
> org.apache.catalina.core.StandardPipeline$StandardPipelineVa lveContext.invokeNext(StandardPipeline.java:643)
> at
> org.apache.catalina.core.StandardPipeline.invoke(StandardPip eline.java:480)
> at org.apache.catalina.core.ContainerBase.invoke(ContainerBase. java:995)
> at org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapte r.java:199)
> at
> org.apache.coyote.http11.Http11Processor.process(Http11Proce ssor.java:828)
> at
> org.apache.coyote.http11.Http11Protocol$Http11ConnectionHand ler.processConnection(Http11Protocol.java:700)
> at
> org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndp oint.java:584)
> at
> org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.ru n(ThreadPool.java:683)
> at java.lang.Thread.run(Unknown Source)Caused by:
> org.mozilla.javascript.EcmaError: TypeError: Cannot call method "split" of
> null (<inline>#2) at
> org.mozilla.javascript.ScriptRuntime.constructError(ScriptRu ntime.java:3240)
> at
> org.mozilla.javascript.ScriptRuntime.constructError(ScriptRu ntime.java:3230)
> at org.mozilla.javascript.ScriptRuntime.typeError(ScriptRuntime .java:3246)
> at
> org.mozilla.javascript.ScriptRuntime.typeError2(ScriptRuntim e.java:3265)
> at
> org.mozilla.javascript.ScriptRuntime.undefCallError(ScriptRu ntime.java:3284)
> at
> org.mozilla.javascript.ScriptRuntime.getPropFunctionAndThis( ScriptRuntime.java:1965)
> at org.mozilla.javascript.gen.c15._c0(<inline>:2) at
> org.mozilla.javascript.gen.c15.call(<inline>) at
> org.mozilla.javascript.ContextFactory.doTopCall(ContextFacto ry.java:304)
> at org.mozilla.javascript.ScriptRuntime.doTopCall(ScriptRuntime .java:2769)
> at org.mozilla.javascript.gen.c15.call(<inline>) at
> org.mozilla.javascript.gen.c15.exec(<inline>) at
> org.eclipse.birt.core.script.ScriptContext.eval(ScriptContex t.java:224) at
> org.eclipse.birt.report.engine.executor.ExecutionContext.eva luate(ExecutionContext.java:549)
> .. 49 more
>
>
> Table (id = 7): + Cannot get the result set metadata.
> SQL statement does not return a ResultSet object.
> SQL error #1: Syntax error or access violation, message from server: "You
> have an error in your SQL syntax; check the manual that corresponds to
> your MySQL server version for the right syntax to use near 'null' at line
> 1"
>
> odaconsumer.CannotGetResultSetMetaData ( 1 time(s) )
> detail : org.eclipse.birt.data.engine.core.DataException: Cannot get the
> result set metadata.SQL statement does not return a ResultSet object.SQL
> error #1: Syntax error or access violation, message from server: "You
> have an error in your SQL syntax; check the manual that corresponds to
> your MySQL server version for the right syntax to use near 'null' at line
> 1" at
> org.eclipse.birt.data.engine.odaconsumer.PreparedStatement.g etRuntimeMetaData(PreparedStatement.java:379)
> at
> org.eclipse.birt.data.engine.odaconsumer.PreparedStatement.g etProjectedColumns(PreparedStatement.java:339)
> at
> org.eclipse.birt.data.engine.odaconsumer.PreparedStatement.d eclareCustomColumn(PreparedStatement.java:1079)
> at
> org.eclipse.birt.data.engine.executor.DataSourceQuery.addCus tomFields(DataSourceQuery.java:388)
> at
> org.eclipse.birt.data.engine.executor.DataSourceQuery.prepar e(DataSourceQuery.java:256)
> at
> org.eclipse.birt.data.engine.impl.PreparedOdaDSQuery$OdaDSQu eryExecutor.prepareOdiQuery(PreparedOdaDSQuery.java:344)
> at
> org.eclipse.birt.data.engine.impl.QueryExecutor.prepareExecu tion(QueryExecutor.java:212)
> at
> org.eclipse.birt.data.engine.impl.PreparedQuery.doPrepare(Pr eparedQuery.java:397)
> at
> org.eclipse.birt.data.engine.impl.PreparedDataSourceQuery.ex ecute(PreparedDataSourceQuery.java:147)
> at
> org.eclipse.birt.data.engine.impl.PreparedOdaDSQuery.execute (PreparedOdaDSQuery.java:135)
> at
> org.eclipse.birt.data.engine.impl.PreparedDataSourceQuery.ex ecute(PreparedDataSourceQuery.java:127)
> at
> org.eclipse.birt.report.engine.data.dte.DteDataEngine.doExec uteQuery(DteDataEngine.java:114)
> at
> org.eclipse.birt.report.engine.data.dte.AbstractDataEngine.e xecute(AbstractDataEngine.java:208)
> at
> org.eclipse.birt.report.engine.executor.ExecutionContext.exe cuteQuery(ExecutionContext.java:1640)
> at
> org.eclipse.birt.report.engine.executor.QueryItemExecutor.ex ecuteQuery(QueryItemExecutor.java:62)
> at
> org.eclipse.birt.report.engine.executor.TableItemExecutor.ex ecute(TableItemExecutor.java:74)
> at
> org.eclipse.birt.report.engine.internal.executor.l18n.Locali zedReportItemExecutor.execute(LocalizedReportItemExecutor.ja va:35)
> at
> org.eclipse.birt.report.engine.layout.html.HTMLPageLM.layout Children(HTMLPageLM.java:123)
> at
> org.eclipse.birt.report.engine.layout.html.HTMLPageLM.layout (HTMLPageLM.java:81)
> at
> org.eclipse.birt.report.engine.layout.html.HTMLReportLayoutE ngine.layout(HTMLReportLayoutEngine.java:80)
> at
> org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.run (RunAndRenderTask.java:194)
> at
> org.eclipse.birt.report.service.ReportEngineService.runAndRe nderReport(Unknown
> Source) at
> org.eclipse.birt.report.service.ReportEngineService.runAndRe nderReport(Unknown
> Source) at
> org.eclipse.birt.report.service.BirtViewerReportService.runA ndRenderReport(Unknown
> Source) at
> org.eclipse.birt.report.service.actionhandler.BirtRunAndRend erActionHandler.__execute(Unknown
> Source) at
> org.eclipse.birt.report.service.actionhandler.AbstractBaseAc tionHandler.execute(Unknown
> Source) at
> org.eclipse.birt.report.presentation.aggregation.layout.Engi neFragment.doService(Unknown
> Source) at
> org.eclipse.birt.report.presentation.aggregation.AbstractBas eFragment.service(Unknown
> Source) at
> org.eclipse.birt.report.servlet.BirtEngineServlet.__doGet(Un known Source)
> at org.eclipse.birt.report.servlet.BaseReportEngineServlet.doGe t(Unknown
> Source) at javax.servlet.http.HttpServlet.service(HttpServlet.java:740) at
> org.apache.axis.transport.http.AxisServletBase.service(AxisS ervletBase.java:327)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFi lter(ApplicationFilterChain.java:247)
> at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(App licationFilterChain.java:193)
> at
> org.apache.catalina.core.StandardWrapperValve.invoke(Standar dWrapperValve.java:256)
> at
> org.apache.catalina.core.StandardPipeline$StandardPipelineVa lveContext.invokeNext(StandardPipeline.java:643)
> at
> org.apache.catalina.core.StandardPipeline.invoke(StandardPip eline.java:480)
> at org.apache.catalina.core.ContainerBase.invoke(ContainerBase. java:995)
> at
> org.apache.catalina.core.StandardContextValve.invoke(Standar dContextValve.java:191)
> at
> org.apache.catalina.core.StandardPipeline$StandardPipelineVa lveContext.invokeNext(StandardPipeline.java:643)
> at
> org.apache.catalina.valves.CertificatesValve.invoke(Certific atesValve.java:246)
> at
> org.apache.catalina.core.StandardPipeline$StandardPipelineVa lveContext.invokeNext(StandardPipeline.java:641)
> at
> org.apache.catalina.core.StandardPipeline.invoke(StandardPip eline.java:480)
> at org.apache.catalina.core.ContainerBase.invoke(ContainerBase. java:995)
> at
> org.apache.catalina.core.StandardContext.invoke(StandardCont ext.java:2422)
> at
> org.apache.catalina.core.StandardHostValve.invoke(StandardHo stValve.java:180)
> at
> org.apache.catalina.core.StandardPipeline$StandardPipelineVa lveContext.invokeNext(StandardPipeline.java:643)
> at
> org.apache.catalina.valves.ErrorDispatcherValve.invoke(Error DispatcherValve.java:171)
> at
> org.apache.catalina.core.StandardPipeline$StandardPipelineVa lveContext.invokeNext(StandardPipeline.java:641)
> at
> org.eclipse.tomcat.internal.EclipseErrorReportValve.invoke(E clipseErrorReportValve.java:153)
> at
> org.apache.catalina.core.StandardPipeline$StandardPipelineVa lveContext.invokeNext(StandardPipeline.java:641)
> at
> org.apache.catalina.core.StandardPipeline.invoke(StandardPip eline.java:480)
> at org.apache.catalina.core.ContainerBase.invoke(ContainerBase. java:995)
> at
> org.apache.catalina.core.StandardEngineValve.invoke(Standard EngineValve.java:174)
> at
> org.apache.catalina.core.StandardPipeline$StandardPipelineVa lveContext.invokeNext(StandardPipeline.java:643)
> at
> org.apache.catalina.core.StandardPipeline.invoke(StandardPip eline.java:480)
> at org.apache.catalina.core.ContainerBase.invoke(ContainerBase. java:995)
> at org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapte r.java:199)
> at
> org.apache.coyote.http11.Http11Processor.process(Http11Proce ssor.java:828)
> at
> org.apache.coyote.http11.Http11Protocol$Http11ConnectionHand ler.processConnection(Http11Protocol.java:700)
> at
> org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndp oint.java:584)
> at
> org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.ru n(ThreadPool.java:683)
> at java.lang.Thread.run(Unknown Source)Caused by:
> org.eclipse.birt.report.data.oda.jdbc.JDBCException: SQL statement does
> not return a ResultSet object.SQL error #1: Syntax error or access
> violation, message from server: "You have an error in your SQL syntax;
> check the manual that corresponds to your MySQL server version for the
> right syntax to use near 'null' at line 1" ; java.sql.SQLException:
> Syntax error or access violation, message from server: "You have an error
> in your SQL syntax; check the manual that corresponds to your MySQL server
> version for the right syntax to use near 'null' at line 1" at
> org.eclipse.birt.report.data.oda.jdbc.Statement.executeQuery (Statement.java:344)
> at
> org.eclipse.birt.report.data.oda.jdbc.Statement.getMetaData( Statement.java:296)
> at
> org.eclipse.datatools.connectivity.oda.consumer.helper.OdaQu ery.doGetMetaData(OdaQuery.java:388)
> at
> org.eclipse.datatools.connectivity.oda.consumer.helper.OdaQu ery.getMetaData(OdaQuery.java:356)
> at
> org.eclipse.birt.data.engine.odaconsumer.PreparedStatement.g etRuntimeMetaData(PreparedStatement.java:369)
> .. 63 moreCaused by: java.sql.SQLException: Syntax error or access
> violation, message from server: "You have an error in your SQL syntax;
> check the manual that corresponds to your MySQL server version for the
> right syntax to use near 'null' at line 1" at
> com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:1905) at
> com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1109) at
> com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1203) at
> com.mysql.jdbc.Connection.execSQL(Connection.java:2090) at
> com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatem ent.java:1496)
> at
> org.eclipse.birt.report.data.oda.jdbc.Statement.executeQuery (Statement.java:340)
> .. 67 more
>
>
> is that measn there exist error in my SQL statement??
Previous Topic:download?
Next Topic:Scripted Datasource &amp; Scripting
Goto Forum:
  


Current Time: Mon Dec 22 03:45:45 GMT 2014

Powered by FUDForum. Page generated in 0.01796 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software