Skip to main content


Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » BIRT » Error when generating the Birt report (BIRT)
icon9.gif  Error when generating the Birt report [message #896926] Fri, 20 July 2012 13:07 Go to next message
BRAROU NABIL is currently offline BRAROU NABILFriend
Messages: 3
Registered: July 2012
Junior Member
I am brand new to BIRT's world, i would like to generate a simple report wich contains a pie chart from a database that i have created.
I Have a Dataset called "commune" that contains a query which fetch by "code_commune" column.
The pie chart is created within another Dataset (Data_set1)for example.
In this last Dataset I put the following query in order to create my pie chart:

select distinct 
1 as idCandidat, public.election.nom1 as nomCandidat,public.election.voix1 as voix from public.election where public.election.code_commune=?
 
UNION
 
select 2 as idCandidat, public.election.nom2 as nomCandidat,public.election.voix2 as voix from public.election where public.election.code_commune=?
 
UNION
 
select 3 as idCandidat, public.election.nom3 as nomCandidat,public.election.voix3 as voix from public.election where public.election.code_commune=?

UNION

select 4 as idCandidat, public.election.nom4 as nomCandidat,public.election.voix4 as voix from public.election where public.election.code_commune=?
 
UNION
 
select 5 as idCandidat, public.election.nom5 as nomCandidat,public.election.voix5 as voix from public.election where public.election.code_commune=?
 
UNION
 
select 6 as idCandidat, public.election.nom6 as nomCandidat,public.election.voix6 as voix from public.election where public.election.code_commune=?

UNION 

select 7 as idCandidat, public.election.nom7 as nomCandidat,public.election.voix7 as voix from public.election where public.election.code_commune=?
 
UNION
 
select 8 as idCandidat, public.election.nom8 as nomCandidat,public.election.voix8 as voix from public.election where public.election.code_commune=?
 
UNION
 
select 9 as idCandidat, public.election.nom9 as nomCandidat,public.election.voix9 as voix from public.election where public.election.code_commune=?
UNION   

select 10 as idCandidat, public.election.nom10 as nomCandidat,public.election.voix10 as voix from public.election where public.election.code_commune=?


But the problem is while previewing my report I got the following error.

Quote:

The following items have errors:


Grid (id = 28):
+ A BIRT exception occurred. See next exception for more information.
Error evaluating Javascript expression. Script engine error: ReferenceError: "commune" n'est pas défini
Script source: unnamed script, line: 0, text:
commune (Element ID:28)
data.engine.BirtException ( 1 time(s) )
detail : org.eclipse.birt.report.engine.api.EngineException: A BIRT exception occurred. See next exception for more information.
Error evaluating Javascript expression. Script engine error: ReferenceError: "commune" n'est pas défini
Script source: unnamed script, line: 0, text:
commune (Element ID:28)
at org.eclipse.birt.report.engine.executor.ExecutionContext.addException(ExecutionContext.java:1237)
at org.eclipse.birt.report.engine.executor.ExecutionContext.addException(ExecutionContext.java:1216)
at org.eclipse.birt.report.engine.executor.QueryItemExecutor.executeQuery(QueryItemExecutor.java:96)
at org.eclipse.birt.report.engine.executor.GridItemExecutor.execute(GridItemExecutor.java:65)
at org.eclipse.birt.report.engine.internal.executor.dup.SuppressDuplicateItemExecutor.execute(SuppressDuplicateItemExecutor.java:43)
at org.eclipse.birt.report.engine.internal.executor.wrap.WrappedReportItemExecutor.execute(WrappedReportItemExecutor.java:46)
at org.eclipse.birt.report.engine.internal.executor.l18n.LocalizedReportItemExecutor.execute(LocalizedReportItemExecutor.java:34)
at org.eclipse.birt.report.engine.layout.html.HTMLBlockStackingLM.layoutNodes(HTMLBlockStackingLM.java:65)
at org.eclipse.birt.report.engine.layout.html.HTMLPageLM.layout(HTMLPageLM.java:92)
at org.eclipse.birt.report.engine.layout.html.HTMLReportLayoutEngine.layout(HTMLReportLayoutEngine.java:100)
at org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.doRun(RunAndRenderTask.java:180)
at org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.run(RunAndRenderTask.java:77)
at org.eclipse.birt.report.service.ReportEngineService.runAndRenderReport(ReportEngineService.java:929)
at org.eclipse.birt.report.service.BirtViewerReportService.runAndRenderReport(BirtViewerReportService.java:973)
at org.eclipse.birt.report.service.actionhandler.BirtGetPageAllActionHandler.__execute(BirtGetPageAllActionHandler.java:131)
at org.eclipse.birt.report.service.actionhandler.AbstractBaseActionHandler.execute(AbstractBaseActionHandler.java:90)
at org.eclipse.birt.report.soapengine.processor.AbstractBaseDocumentProcessor.__executeAction(AbstractBaseDocumentProcessor.java:47)
at org.eclipse.birt.report.soapengine.processor.AbstractBaseComponentProcessor.executeAction(AbstractBaseComponentProcessor.java:143)
at org.eclipse.birt.report.soapengine.processor.BirtDocumentProcessor.handleGetPageAll(BirtDocumentProcessor.java:183)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:601)
at org.eclipse.birt.report.soapengine.processor.AbstractBaseComponentProcessor.process(AbstractBaseComponentProcessor.java:112)
at org.eclipse.birt.report.soapengine.endpoint.BirtSoapBindingImpl.getUpdatedObjects(BirtSoapBindingImpl.java:66)
at sun.reflect.GeneratedMethodAccessor34.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:601)
at org.apache.axis.providers.java.RPCProvider.invokeMethod(RPCProvider.java:397)
at org.apache.axis.providers.java.RPCProvider.processMessage(RPCProvider.java:186)
at org.apache.axis.providers.java.JavaProvider.invoke(JavaProvider.java:323)
at org.apache.axis.strategies.InvocationStrategy.visit(InvocationStrategy.java:32)
at org.apache.axis.SimpleChain.doVisiting(SimpleChain.java:118)
at org.apache.axis.SimpleChain.invoke(SimpleChain.java:83)
at org.apache.axis.handlers.soap.SOAPService.invoke(SOAPService.java:454)
at org.apache.axis.server.AxisServer.invoke(AxisServer.java:281)
at org.apache.axis.transport.http.AxisServlet.doPost(AxisServlet.java:699)
at org.eclipse.birt.report.servlet.BirtSoapMessageDispatcherServlet.doPost(BirtSoapMessageDispatcherServlet.java:265)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
at org.apache.axis.transport.http.AxisServletBase.service(AxisServletBase.java:327)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
at org.eclipse.birt.report.servlet.BirtSoapMessageDispatcherServlet.service(BirtSoapMessageDispatcherServlet.java:122)
at org.eclipse.equinox.http.registry.internal.ServletManager$ServletWrapper.service(ServletManager.java:180)
at org.eclipse.equinox.http.servlet.internal.ServletRegistration.service(ServletRegistration.java:61)
at org.eclipse.equinox.http.servlet.internal.ProxyServlet.processAlias(ProxyServlet.java:126)
at org.eclipse.equinox.http.servlet.internal.ProxyServlet.service(ProxyServlet.java:60)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
at org.eclipse.equinox.http.jetty.internal.HttpServerManager$InternalHttpServiceServlet.service(HttpServerManager.java:317)
at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:511)
at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:390)
at org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:182)
at org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:765)
at org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:152)
at org.mortbay.jetty.Server.handle(Server.java:326)
at org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:542)
at org.mortbay.jetty.HttpConnection$RequestHandler.content(HttpConnection.java:939)
at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:756)
at org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:212)
at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:404)
at org.mortbay.io.nio.SelectChannelEndPoint.run(SelectChannelEndPoint.java:409)
at org.mortbay.thread.QueuedThreadPool$PoolThread.run(QueuedThreadPool.java:582)
Caused by: org.eclipse.birt.data.engine.core.DataException: A BIRT exception occurred. See next exception for more information.
Error evaluating Javascript expression. Script engine error: ReferenceError: "commune" n'est pas défini
Script source: unnamed script, line: 0, text:
commune
at org.eclipse.birt.data.engine.core.DataException.wrap(DataException.java:123)
at org.eclipse.birt.data.engine.script.ScriptEvalUtil.evaluateJSAsExpr(ScriptEvalUtil.java:996)
at org.eclipse.birt.data.engine.expression.ExprEvaluateUtil.doEvaluateRawExpression(ExprEvaluateUtil.java:281)
at org.eclipse.birt.data.engine.expression.ExprEvaluateUtil.evaluateRawExpression(ExprEvaluateUtil.java:236)
at org.eclipse.birt.data.engine.impl.PreparedDummyQuery$ResultIterator.<init>(PreparedDummyQuery.java:532)
at org.eclipse.birt.data.engine.impl.PreparedDummyQuery$ResultIterator.<init>(PreparedDummyQuery.java:509)
at org.eclipse.birt.data.engine.impl.PreparedDummyQuery$QueryResults.getResultIterator(PreparedDummyQuery.java:368)
at org.eclipse.birt.report.engine.data.dte.QueryResultSet.<init>(QueryResultSet.java:98)
at org.eclipse.birt.report.engine.data.dte.DteDataEngine.doExecuteQuery(DteDataEngine.java:168)
at org.eclipse.birt.report.engine.data.dte.AbstractDataEngine.execute(AbstractDataEngine.java:267)
at org.eclipse.birt.report.engine.executor.ExecutionContext.executeQuery(ExecutionContext.java:1939)
at org.eclipse.birt.report.engine.executor.QueryItemExecutor.executeQuery(QueryItemExecutor.java:80)
... 58 more
Caused by: org.eclipse.birt.core.exception.CoreException: Error evaluating Javascript expression. Script engine error: ReferenceError: "commune" n'est pas défini
Script source: unnamed script, line: 0, text:
commune
at org.eclipse.birt.core.script.JavascriptEvalUtil.wrapRhinoException(JavascriptEvalUtil.java:303)
at org.eclipse.birt.core.script.JavascriptEvalUtil.evaluateRawScript(JavascriptEvalUtil.java:102)
at org.eclipse.birt.core.script.JavascriptEvalUtil.evaluateScript(JavascriptEvalUtil.java:134)
at org.eclipse.birt.data.engine.script.ScriptEvalUtil.evaluateJSAsExpr(ScriptEvalUtil.java:992)
... 68 more
Caused by: org.mozilla.javascript.EcmaError: ReferenceError: "commune" n'est pas défini
at org.mozilla.javascript.ScriptRuntime.constructError(ScriptRuntime.java:3654)
at org.mozilla.javascript.ScriptRuntime.constructError(ScriptRuntime.java:3632)
at org.mozilla.javascript.ScriptRuntime.notFoundError(ScriptRuntime.java:3717)
at org.mozilla.javascript.ScriptRuntime.nameOrFunction(ScriptRuntime.java:1758)
at org.mozilla.javascript.ScriptRuntime.name(ScriptRuntime.java:1697)
at org.mozilla.javascript.gen.c7._c0(unnamed script:0)
at org.mozilla.javascript.gen.c7.call(unnamed script)
at org.mozilla.javascript.ContextFactory.doTopCall(ContextFactory.java:398)
at org.mozilla.javascript.ScriptRuntime.doTopCall(ScriptRuntime.java:3065)
at org.mozilla.javascript.gen.c7.call(unnamed script)
at org.mozilla.javascript.gen.c7.exec(unnamed script)
at org.eclipse.birt.core.script.JavascriptEvalUtil.evaluateRawScript(JavascriptEvalUtil.java:95)
... 70 more



with 'commune' as i defined is a Dataset full with a list of "code_commune".

how can i get out of this problem?
Please find two pictures one displaying the error and the other the my DataExplorer view in order to make it straightforward for you to understand the context in wich i'm working.
I really need your help
  • Attachment: parametre.JPG
    (Size: 107.82KB, Downloaded 137 times)
  • Attachment: erreur.JPG
    (Size: 125.84KB, Downloaded 136 times)
Re: Error when generating the Birt report [message #897032 is a reply to message #896926] Fri, 20 July 2012 20:39 Go to previous message
Jason Weathersby is currently offline Jason WeathersbyFriend
Messages: 9167
Registered: July 2009
Senior Member

Are you setting the parameter values for the ? markers?

Jason

On 7/20/2012 9:07 AM, BRAROU NABIL wrote:
> I am brand new to BIRT's world, i would like to generate a simple report wich contains a pie chart from a database that i have created.
> I Have a Dataset called "commune" that contains a query which fetch by "code_commune" column.
> The pie chart is created within another Dataset (Data_set1)for example.
> In this last Dataset I put the following query in order to create my pie chart:
>
> select distinct
> 1 as idCandidat, public.election.nom1 as nomCandidat,public.election.voix1 as voix from public.election where public.election.code_commune=?
>
> UNION
>
> select 2 as idCandidat, public.election.nom2 as nomCandidat,public.election.voix2 as voix from public.election where public.election.code_commune=?
>
> UNION
>
> select 3 as idCandidat, public.election.nom3 as nomCandidat,public.election.voix3 as voix from public.election where public.election.code_commune=?
>
> UNION
>
> select 4 as idCandidat, public.election.nom4 as nomCandidat,public.election.voix4 as voix from public.election where public.election.code_commune=?
>
> UNION
>
> select 5 as idCandidat, public.election.nom5 as nomCandidat,public.election.voix5 as voix from public.election where public.election.code_commune=?
>
> UNION
>
> select 6 as idCandidat, public.election.nom6 as nomCandidat,public.election.voix6 as voix from public.election where public.election.code_commune=?
>
> UNION
>
> select 7 as idCandidat, public.election.nom7 as nomCandidat,public.election.voix7 as voix from public.election where public.election.code_commune=?
>
> UNION
>
> select 8 as idCandidat, public.election.nom8 as nomCandidat,public.election.voix8 as voix from public.election where public.election.code_commune=?
>
> UNION
>
> select 9 as idCandidat, public.election.nom9 as nomCandidat,public.election.voix9 as voix from public.election where public.election.code_commune=?
> UNION
>
> select 10 as idCandidat, public.election.nom10 as nomCandidat,public.election.voix10 as voix from public.election where public.election.code_commune=?
>
>
> But the problem is while previewing my report I got the following error.
>
> Quote:
>> The following items have errors:
>>
>>
>> Grid (id = 28):
>> + A BIRT exception occurred. See next exception for more information.
>> Error evaluating Javascript expression. Script engine error: ReferenceError: "commune" n'est pas défini
>> Script source: unnamed script, line: 0, text:
>> commune (Element ID:28)
>> data.engine.BirtException ( 1 time(s) )
>> detail : org.eclipse.birt.report.engine.api.EngineException: A BIRT exception occurred. See next exception for more information.
>> Error evaluating Javascript expression. Script engine error: ReferenceError: "commune" n'est pas défini
>> Script source: unnamed script, line: 0, text:
>> commune (Element ID:28)
>> at org.eclipse.birt.report.engine.executor.ExecutionContext.addException(ExecutionContext.java:1237)
>> at org.eclipse.birt.report.engine.executor.ExecutionContext.addException(ExecutionContext.java:1216)
>> at org.eclipse.birt.report.engine.executor.QueryItemExecutor.executeQuery(QueryItemExecutor.java:96)
>> at org.eclipse.birt.report.engine.executor.GridItemExecutor.execute(GridItemExecutor.java:65)
>> at org.eclipse.birt.report.engine.internal.executor.dup.SuppressDuplicateItemExecutor.execute(SuppressDuplicateItemExecutor.java:43)
>> at org.eclipse.birt.report.engine.internal.executor.wrap.WrappedReportItemExecutor.execute(WrappedReportItemExecutor.java:46)
>> at org.eclipse.birt.report.engine.internal.executor.l18n.LocalizedReportItemExecutor.execute(LocalizedReportItemExecutor.java:34)
>> at org.eclipse.birt.report.engine.layout.html.HTMLBlockStackingLM.layoutNodes(HTMLBlockStackingLM.java:65)
>> at org.eclipse.birt.report.engine.layout.html.HTMLPageLM.layout(HTMLPageLM.java:92)
>> at org.eclipse.birt.report.engine.layout.html.HTMLReportLayoutEngine.layout(HTMLReportLayoutEngine.java:100)
>> at org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.doRun(RunAndRenderTask.java:180)
>> at org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.run(RunAndRenderTask.java:77)
>> at org.eclipse.birt.report.service.ReportEngineService.runAndRenderReport(ReportEngineService.java:929)
>> at org.eclipse.birt.report.service.BirtViewerReportService.runAndRenderReport(BirtViewerReportService.java:973)
>> at org.eclipse.birt.report.service.actionhandler.BirtGetPageAllActionHandler.__execute(BirtGetPageAllActionHandler.java:131)
>> at org.eclipse.birt.report.service.actionhandler.AbstractBaseActionHandler.execute(AbstractBaseActionHandler.java:90)
>> at org.eclipse.birt.report.soapengine.processor.AbstractBaseDocumentProcessor.__executeAction(AbstractBaseDocumentProcessor.java:47)
>> at org.eclipse.birt.report.soapengine.processor.AbstractBaseComponentProcessor.executeAction(AbstractBaseComponentProcessor.java:143)
>> at org.eclipse.birt.report.soapengine.processor.BirtDocumentProcessor.handleGetPageAll(BirtDocumentProcessor.java:183)
>> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
>> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
>> at java.lang.reflect.Method.invoke(Method.java:601)
>> at org.eclipse.birt.report.soapengine.processor.AbstractBaseComponentProcessor.process(AbstractBaseComponentProcessor.java:112)
>> at org.eclipse.birt.report.soapengine.endpoint.BirtSoapBindingImpl.getUpdatedObjects(BirtSoapBindingImpl.java:66)
>> at sun.reflect.GeneratedMethodAccessor34.invoke(Unknown Source)
>> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
>> at java.lang.reflect.Method.invoke(Method.java:601)
>> at org.apache.axis.providers.java.RPCProvider.invokeMethod(RPCProvider.java:397)
>> at org.apache.axis.providers.java.RPCProvider.processMessage(RPCProvider.java:186)
>> at org.apache.axis.providers.java.JavaProvider.invoke(JavaProvider.java:323)
>> at org.apache.axis.strategies.InvocationStrategy.visit(InvocationStrategy.java:32)
>> at org.apache.axis.SimpleChain.doVisiting(SimpleChain.java:118)
>> at org.apache.axis.SimpleChain.invoke(SimpleChain.java:83)
>> at org.apache.axis.handlers.soap.SOAPService.invoke(SOAPService.java:454)
>> at org.apache.axis.server.AxisServer.invoke(AxisServer.java:281)
>> at org.apache.axis.transport.http.AxisServlet.doPost(AxisServlet.java:699)
>> at org.eclipse.birt.report.servlet.BirtSoapMessageDispatcherServlet.doPost(BirtSoapMessageDispatcherServlet.java:265)
>> at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
>> at org.apache.axis.transport.http.AxisServletBase.service(AxisServletBase.java:327)
>> at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
>> at org.eclipse.birt.report.servlet.BirtSoapMessageDispatcherServlet.service(BirtSoapMessageDispatcherServlet.java:122)
>> at org.eclipse.equinox.http.registry.internal.ServletManager$ServletWrapper.service(ServletManager.java:180)
>> at org.eclipse.equinox.http.servlet.internal.ServletRegistration.service(ServletRegistration.java:61)
>> at org.eclipse.equinox.http.servlet.internal.ProxyServlet.processAlias(ProxyServlet.java:126)
>> at org.eclipse.equinox.http.servlet.internal.ProxyServlet.service(ProxyServlet.java:60)
>> at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
>> at org.eclipse.equinox.http.jetty.internal.HttpServerManager$InternalHttpServiceServlet.service(HttpServerManager.java:317)
>> at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:511)
>> at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:390)
>> at org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:182)
>> at org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:765)
>> at org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:152)
>> at org.mortbay.jetty.Server.handle(Server.java:326)
>> at org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:542)
>> at org.mortbay.jetty.HttpConnection$RequestHandler.content(HttpConnection.java:939)
>> at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:756)
>> at org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:212)
>> at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:404)
>> at org.mortbay.io.nio.SelectChannelEndPoint.run(SelectChannelEndPoint.java:409)
>> at org.mortbay.thread.QueuedThreadPool$PoolThread.run(QueuedThreadPool.java:582)
>> Caused by: org.eclipse.birt.data.engine.core.DataException: A BIRT exception occurred. See next exception for more information.
>> Error evaluating Javascript expression. Script engine error: ReferenceError: "commune" n'est pas défini
>> Script source: unnamed script, line: 0, text:
>> commune
>> at org.eclipse.birt.data.engine.core.DataException.wrap(DataException.java:123)
>> at org.eclipse.birt.data.engine.script.ScriptEvalUtil.evaluateJSAsExpr(ScriptEvalUtil.java:996)
>> at org.eclipse.birt.data.engine.expression.ExprEvaluateUtil.doEvaluateRawExpression(ExprEvaluateUtil.java:281)
>> at org.eclipse.birt.data.engine.expression.ExprEvaluateUtil.evaluateRawExpression(ExprEvaluateUtil.java:236)
>> at org.eclipse.birt.data.engine.impl.PreparedDummyQuery$ResultIterator.<init>(PreparedDummyQuery.java:532)
>> at org.eclipse.birt.data.engine.impl.PreparedDummyQuery$ResultIterator.<init>(PreparedDummyQuery.java:509)
>> at org.eclipse.birt.data.engine.impl.PreparedDummyQuery$QueryResults.getResultIterator(PreparedDummyQuery.java:368)
>> at org.eclipse.birt.report.engine.data.dte.QueryResultSet.<init>(QueryResultSet.java:98)
>> at org.eclipse.birt.report.engine.data.dte.DteDataEngine.doExecuteQuery(DteDataEngine.java:168)
>> at org.eclipse.birt.report.engine.data.dte.AbstractDataEngine.execute(AbstractDataEngine.java:267)
>> at org.eclipse.birt.report.engine.executor.ExecutionContext.executeQuery(ExecutionContext.java:1939)
>> at org.eclipse.birt.report.engine.executor.QueryItemExecutor.executeQuery(QueryItemExecutor.java:80)
>> ... 58 more
>> Caused by: org.eclipse.birt.core.exception.CoreException: Error evaluating Javascript expression. Script engine error: ReferenceError: "commune" n'est pas défini
>> Script source: unnamed script, line: 0, text:
>> commune
>> at org.eclipse.birt.core.script.JavascriptEvalUtil.wrapRhinoException(JavascriptEvalUtil.java:303)
>> at org.eclipse.birt.core.script.JavascriptEvalUtil.evaluateRawScript(JavascriptEvalUtil.java:102)
>> at org.eclipse.birt.core.script.JavascriptEvalUtil.evaluateScript(JavascriptEvalUtil.java:134)
>> at org.eclipse.birt.data.engine.script.ScriptEvalUtil.evaluateJSAsExpr(ScriptEvalUtil.java:992)
>> ... 68 more
>> Caused by: org.mozilla.javascript.EcmaError: ReferenceError: "commune" n'est pas défini
>> at org.mozilla.javascript.ScriptRuntime.constructError(ScriptRuntime.java:3654)
>> at org.mozilla.javascript.ScriptRuntime.constructError(ScriptRuntime.java:3632)
>> at org.mozilla.javascript.ScriptRuntime.notFoundError(ScriptRuntime.java:3717)
>> at org.mozilla.javascript.ScriptRuntime.nameOrFunction(ScriptRuntime.java:1758)
>> at org.mozilla.javascript.ScriptRuntime.name(ScriptRuntime.java:1697)
>> at org.mozilla.javascript.gen.c7._c0(unnamed script:0)
>> at org.mozilla.javascript.gen.c7.call(unnamed script)
>> at org.mozilla.javascript.ContextFactory.doTopCall(ContextFactory.java:398)
>> at org.mozilla.javascript.ScriptRuntime.doTopCall(ScriptRuntime.java:3065)
>> at org.mozilla.javascript.gen.c7.call(unnamed script)
>> at org.mozilla.javascript.gen.c7.exec(unnamed script)
>> at org.eclipse.birt.core.script.JavascriptEvalUtil.evaluateRawScript(JavascriptEvalUtil.java:95)
>> ... 70 more
>
> with 'commune' as i defined is a Dataset full with a list of "code_commune".
>
> how can i get out of this problem?
> Please find two pictures one displaying the error and the other the my DataExplorer view in order to make it straightforward for you to understand the context in wich i'm working.
> I really need your help
>
Previous Topic:How to add HTML attributes in BIRT
Next Topic:Export report to excel
Goto Forum:
  


Current Time: Sat Oct 23 02:39:24 GMT 2021

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

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

Back to the top