Birt Tutorial

268 views
Skip to first unread message
Message has been deleted

hall...@gmail.com

unread,
Apr 10, 2009, 8:41:28 AM4/10/09
to vogella

Hello,

I took this BIRT tutorial and just wanted to point out that there are
some inconsistencies in paragraph 5.3 between the two snippets of
'open' script code for setStocks data set. The code in the screenshot
is different than the code underkneith it, which you can cut and
paste. If you use cut and paste code than you will get errors while
trying to preview the results.
To get rid of errors use the code in the screenshot:
count = 0;
gsh = new Packages.de.vogella.stock.daomock.StockDaoMock(); // Create
instance of the GetStockHistory class
stock = gsh.getStockValues("JAVA"); //Load the ArrayList
The errors will be gone, but the preview won't return any results. If
you want the results - change the

stock = gsh.getStockValues("JAVA")
to
stock = gsh.getStockValues("Java"); You might want to change it in XML
source tab, because for some reason changing the code in 'open' script
('Script' tab) did not refresh the code in XML Source tab, which still
resulted in errors.
Just wanted to save some time to others.

Thanks!

Lars Vogel

unread,
Apr 10, 2009, 8:50:22 AM4/10/09
to vog...@googlegroups.com
Hello Jasmine,

thank you very much. I'll update the tutorial within the next days.

Best regards, Lars

2009/4/10 <hall...@gmail.com>
Thanks,

Jasmine











--
Lars
http://www.vogella.de - Tutorial about Java, Eclipse and Web programming

Lars Vogel

unread,
Apr 12, 2009, 4:33:51 PM4/12/09
to vog...@googlegroups.com
Hi Jasmine,

thank you. The error is corrected and uploaded.

Best regards, Lars

2009/4/10 Lars Vogel <lars....@googlemail.com>

middle...@gmail.com

unread,
May 7, 2009, 11:34:23 AM5/7/09
to vogella
I applied his fix but is still not getting any results during the
preview. Is there anybody else having issues while following the
directions to the letter?

On Apr 12, 4:33 pm, Lars Vogel <lars.vo...@googlemail.com> wrote:
> Hi Jasmine,
> thank you. The error is corrected and uploaded.
>
> Best regards, Lars
>
> 2009/4/10 Lars Vogel <lars.vo...@googlemail.com>
>
>
>
> > Hello Jasmine,
> > thank you very much. I'll update the tutorial within the next days.
>
> > Best regards, Lars
>
> > 2009/4/10 <halldi...@gmail.com>
> >http://www.vogella.de- Tutorial about Java, Eclipse and Web programming
>
> --
> Larshttp://www.vogella.de- Tutorial about Java, Eclipse and Web programming

Lars Vogel

unread,
May 7, 2009, 5:23:02 PM5/7/09
to vog...@googlegroups.com
For me it works. Any error messages? You can compare your report / coding with the code from: http://www.vogella.de/code/codeeclipse.html




--
Lars
http://www.vogella.de - Tutorial about Java, Eclipse and Web programming

Lars Vogel

unread,
May 7, 2009, 5:38:37 PM5/7/09
to vog...@googlegroups.com
I found a potential problem in StockDaoMock. Can you try the new version from my website?



2009/5/7 Lars Vogel <lars....@googlemail.com>

Lars Vogel

unread,
May 7, 2009, 5:40:04 PM5/7/09
to vog...@googlegroups.com

Tim Middlebrook

unread,
May 11, 2009, 9:12:23 AM5/11/09
to vog...@googlegroups.com
I tried the new version but it is still not pulling the data in. I have attached my project, but it is a cut an past of your code. Is there anything special I need to do, to have birt point to my java objects?

One Thing I do:  Forgetting what is behind and straining toward what is ahead, I press on toward the goal...
-------------------
If you learn to trust in the Lord, You will become trustworthy.
If you learn to rely on Him, you will become reliable.
If you learn to lean on God, you will become someone others can lean on.
de.vogella.birt.zip

Lars Vogel

unread,
May 11, 2009, 9:24:42 AM5/11/09
to vog...@googlegroups.com
Looks ok to me. Did you get data in the preview?


2009/5/11 Tim Middlebrook <middle...@gmail.com>

Tim Middlebrook

unread,
May 11, 2009, 9:28:28 AM5/11/09
to vog...@googlegroups.com
No, nothing I do know the stockDaoMock is getting data because I am printing out data to the screen.

Thanks for all you help :)

One Thing I do:  Forgetting what is behind and straining toward what is ahead, I press on toward the goal...
-------------------
If you learn to trust in the Lord, You will become trustworthy.
If you learn to rely on Him, you will become reliable.
If you learn to lean on God, you will become someone others can lean on.


Lars Vogel

unread,
May 11, 2009, 5:15:09 PM5/11/09
to vog...@googlegroups.com
Strange. In the other discussion Ar3s said with the change of the MockDao it works for him. Which version of Eclipse are you using?

2009/5/11 Tim Middlebrook <middle...@gmail.com>

Tim Middlebrook

unread,
May 11, 2009, 5:15:20 PM5/11/09
to vog...@googlegroups.com
Thank you for help I just got the preview working, I don't know what was wrong but looks like it just worked itself out. Next thing I will try tomorrow is to export this report to work in Tomcat.



One Thing I do:  Forgetting what is behind and straining toward what is ahead, I press on toward the goal...
-------------------
If you learn to trust in the Lord, You will become trustworthy.
If you learn to rely on Him, you will become reliable.
If you learn to lean on God, you will become someone others can lean on.


Lars Vogel

unread,
May 11, 2009, 5:16:35 PM5/11/09
to vog...@googlegroups.com
Super!  Good luck with the rest of the tutorial.

2009/5/11 Tim Middlebrook <middle...@gmail.com>

Tim Middlebrook

unread,
May 12, 2009, 9:39:21 AM5/12/09
to vog...@googlegroups.com
I got the preview working when I right click the data sets, but when I build the report and to the full preview (the "preview" tab at the bottom) it does not compile or run.  I ran a debug report and here are the results:

May 12, 2009 9:35:28 AM org.eclipse.birt.report.debug.internal.core.vm.ReportVMServer start
INFO: [Server] client accepted
May 12, 2009 9:35:28 AM org.eclipse.birt.report.debug.internal.core.vm.ReportVMServer$1 run
INFO: [Server] enter request dispatching
May 12, 2009 9:35:28 AM org.eclipse.birt.report.debug.internal.core.launcher.ReportLauncher configEngine
INFO: User class path received:
May 12, 2009 9:35:29 AM org.eclipse.birt.report.debug.internal.core.vm.ReportVMServer$1 run
WARNING: [Server] client disconnected

I will be looking in to this issue further, but have you ever seen something like this?


One Thing I do:  Forgetting what is behind and straining toward what is ahead, I press on toward the goal...
-------------------
If you learn to trust in the Lord, You will become trustworthy.
If you learn to rely on Him, you will become reliable.
If you learn to lean on God, you will become someone others can lean on.


Tim Middlebrook

unread,
May 12, 2009, 10:20:06 AM5/12/09
to vog...@googlegroups.com
I think I found a problem, the stock example doesn't work with the newest version of birt. I found a fix by going back one revision of birt to 2.3.1 v200806... instead of the newest version eclipse offers.  I wanted to let you know my findings.

Thanks again :)


One Thing I do:  Forgetting what is behind and straining toward what is ahead, I press on toward the goal...
-------------------
If you learn to trust in the Lord, You will become trustworthy.
If you learn to rely on Him, you will become reliable.
If you learn to lean on God, you will become someone others can lean on.


Lars Vogel

unread,
May 12, 2009, 11:02:39 AM5/12/09
to vog...@googlegroups.com
Really? This should not be the case. Once Eclipse 3.5 is out I'll look at the next version of BIRT and try to update the tutorial.

2009/5/12 Tim Middlebrook <middle...@gmail.com>

Tim Middlebrook

unread,
May 12, 2009, 2:36:06 PM5/12/09
to vog...@googlegroups.com
Another quick question, when deploying my report (which works in Eclipse thanks to you) to Tomcat I get multiple errors. I don't believe my report design is seeing the .class files I jar-ed together during your export process. Here are the steps I took, can you make sure I didn't forget a step or if I misunderstood a step.

1.) Export project into a .jar file named stock.jar (this includes all .class files and the report design file.
2.) Move the .jar file to the birt-install-directory/WEB-INF/lib directory
3.) Move the report design file into the root directory of birt
3.) Restart Tomcat
4.) Then access the report via the Tomcat web-app


One Thing I do:  Forgetting what is behind and straining toward what is ahead, I press on toward the goal...
-------------------
If you learn to trust in the Lord, You will become trustworthy.
If you learn to rely on Him, you will become reliable.
If you learn to lean on God, you will become someone others can lean on.


Lars Vogel

unread,
May 12, 2009, 3:02:10 PM5/12/09
to vog...@googlegroups.com
Sounds correct to me. 

2009/5/12 Tim Middlebrook <middle...@gmail.com>

Tim Middlebrook

unread,
May 13, 2009, 2:30:22 PM5/13/09
to vog...@googlegroups.com
Here is the error I am getting, if anybody has any help on these issues or suggestions please let me know.

May 13, 2009 1:28:27 PM org.eclipse.birt.report.engine.script.internal.DtEScriptExecutor handleJS
WARNING: A BIRT exception occurred: There are errors evaluating script "__bm_OPEN()":
TypeError: [JavaPackage StockDaoMock] is not a function, it is org.mozilla.javascript.NativeJavaPackage. (<inline>#3).. See next exception for more information.
There are errors evaluating script "__bm_OPEN()":
TypeError: [JavaPackage StockDaoMock] is not a function, it is org.mozilla.javascript.NativeJavaPackage. (<inline>#3).
org.eclipse.birt.data.engine.core.DataException: A BIRT exception occurred: There are errors evaluating script "__bm_OPEN()":
TypeError: [JavaPackage StockDaoMock] is not a function, it is org.mozilla.javascript.NativeJavaPackage. (<inline>#3).. See next exception for more information.
There are errors evaluating script "__bm_OPEN()":
TypeError: [JavaPackage StockDaoMock] is not a function, it is org.mozilla.javascript.NativeJavaPackage. (<inline>#3).
    at org.eclipse.birt.data.engine.core.DataException.wrap(DataException.java:118)
    at org.eclipse.birt.data.engine.script.ScriptEvalUtil.evaluateJSAsExpr(ScriptEvalUtil.java:717)
    at org.eclipse.birt.data.engine.script.JSMethodRunner.runScript(JSMethodRunner.java:76)
    at org.eclipse.birt.report.engine.script.internal.DtEScriptExecutor.handleJS(DtEScriptExecutor.java:71)
    at org.eclipse.birt.report.engine.script.internal.DataSetScriptExecutor.handleJS(DataSetScriptExecutor.java:196)
    at org.eclipse.birt.report.engine.script.internal.ScriptDataSetScriptExecutor.handleOpen(ScriptDataSetScriptExecutor.java:77)
    at org.eclipse.birt.data.engine.impl.ScriptDataSetRuntime.open(ScriptDataSetRuntime.java:79)
    at org.eclipse.birt.data.engine.impl.PreparedScriptDSQuery$ScriptDSQueryExecutor$CustomDataSet.open(PreparedScriptDSQuery.java:244)
    at org.eclipse.birt.data.engine.impl.PreparedScriptDSQuery$ScriptDSQueryExecutor.executeOdiQuery(PreparedScriptDSQuery.java:220)
    at org.eclipse.birt.data.engine.impl.QueryExecutor.execute(QueryExecutor.java:945)
    at org.eclipse.birt.data.engine.impl.ServiceForQueryResults.executeQuery(ServiceForQueryResults.java:233)
    at org.eclipse.birt.data.engine.impl.QueryResults.getResultIterator(QueryResults.java:160)
    at org.eclipse.birt.report.engine.data.dte.QueryResultSet.<init>(QueryResultSet.java:92)
    at org.eclipse.birt.report.engine.data.dte.DteDataEngine.doExecuteQuery(DteDataEngine.java:129)
    at org.eclipse.birt.report.engine.data.dte.DataGenerationEngine.doExecuteQuery(DataGenerationEngine.java:79)
    at org.eclipse.birt.report.engine.data.dte.AbstractDataEngine.execute(AbstractDataEngine.java:253)
    at org.eclipse.birt.report.engine.executor.ExecutionContext.executeQuery(ExecutionContext.java:1755)
    at org.eclipse.birt.report.engine.executor.QueryItemExecutor.executeQuery(QueryItemExecutor.java:77)
    at org.eclipse.birt.report.engine.executor.TableItemExecutor.execute(TableItemExecutor.java:62)
    at org.eclipse.birt.report.engine.internal.executor.wrap.WrappedReportItemExecutor.execute(WrappedReportItemExecutor.java:45)
    at org.eclipse.birt.report.engine.internal.executor.emitter.ReportItemEmitterExecutor.execute(ReportItemEmitterExecutor.java:45)
    at org.eclipse.birt.report.engine.internal.executor.dup.SuppressDuplicateItemExecutor.execute(SuppressDuplicateItemExecutor.java:42)
    at org.eclipse.birt.report.engine.layout.html.HTMLBlockStackingLM.layoutNodes(HTMLBlockStackingLM.java:63)
    at org.eclipse.birt.report.engine.layout.html.HTMLPageLM.layout(HTMLPageLM.java:90)
    at org.eclipse.birt.report.engine.layout.html.HTMLReportLayoutEngine.layout(HTMLReportLayoutEngine.java:101)
    at org.eclipse.birt.report.engine.presentation.ReportDocumentBuilder.build(ReportDocumentBuilder.java:211)
    at org.eclipse.birt.report.engine.api.impl.RunTask.doRun(RunTask.java:237)
    at org.eclipse.birt.report.engine.api.impl.RunTask.run(RunTask.java:90)
    at org.eclipse.birt.report.service.ReportEngineService.runReport(ReportEngineService.java:1246)
    at org.eclipse.birt.report.service.BirtViewerReportService.runReport(BirtViewerReportService.java:155)
    at org.eclipse.birt.report.service.actionhandler.BirtRunReportActionHandler.__execute(BirtRunReportActionHandler.java:81)
    at org.eclipse.birt.report.service.actionhandler.BirtGetPageActionHandler.__checkDocumentExists(BirtGetPageActionHandler.java:58)
    at org.eclipse.birt.report.service.actionhandler.AbstractGetPageActionHandler.prepareParameters(AbstractGetPageActionHandler.java:119)
    at org.eclipse.birt.report.service.actionhandler.AbstractGetPageActionHandler.__execute(AbstractGetPageActionHandler.java:104)
    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.handleGetPage(BirtDocumentProcessor.java:87)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    at java.lang.reflect.Method.invoke(Method.java:585)
    at org.eclipse.birt.report.soapengine.processor.AbstractBaseComponentProcessor.process(AbstractBaseComponentProcessor.java:112)
    at org.eclipse.birt.report.soapengine.endpoint.BirtSoapBindingImpl.getUpdatedObjects(BirtSoapBindingImpl.java:66)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    at java.lang.reflect.Method.invoke(Method.java:585)
    at org.apache.axis.providers.java.RPCProvider.invokeMethod(RPCProvider.java:397)
    at org.apache.axis.providers.java.RPCProvider.processMessage(RPCProvider.java:186)
    at org.apache.axis.providers.java.JavaProvider.invoke(JavaProvider.java:323)
    at org.apache.axis.strategies.InvocationStrategy.visit(InvocationStrategy.java:32)
    at org.apache.axis.SimpleChain.doVisiting(SimpleChain.java:118)
    at org.apache.axis.SimpleChain.invoke(SimpleChain.java:83)
    at org.apache.axis.handlers.soap.SOAPService.invoke(SOAPService.java: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:647)
    at org.apache.axis.transport.http.AxisServletBase.service(AxisServletBase.java:327)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
    at org.eclipse.birt.report.servlet.BirtSoapMessageDispatcherServlet.service(BirtSoapMessageDispatcherServlet.java:122)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
    at org.eclipse.birt.report.filter.ViewerFilter.doFilter(ViewerFilter.java:68)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
    at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
    at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:172)
    at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
    at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
    at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)
    at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:174)
    at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:875)
    at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665)
    at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528)
    at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81)
    at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689)
    at java.lang.Thread.run(Thread.java:595)
Caused by: org.eclipse.birt.core.exception.CoreException: There are errors evaluating script "__bm_OPEN()":
TypeError: [JavaPackage StockDaoMock] is not a function, it is org.mozilla.javascript.NativeJavaPackage. (<inline>#3).
    at org.eclipse.birt.core.script.ScriptContext.eval(ScriptContext.java:307)
    at org.eclipse.birt.core.script.ScriptContext.eval(ScriptContext.java:268)
    at org.eclipse.birt.data.engine.script.ScriptEvalUtil.evaluateJSAsExpr(ScriptEvalUtil.java:713)
    ... 77 more
Caused by: org.mozilla.javascript.EcmaError: TypeError: [JavaPackage StockDaoMock] is not a function, it is org.mozilla.javascript.NativeJavaPackage. (<inline>#3)
    at org.mozilla.javascript.ScriptRuntime.constructError(ScriptRuntime.java:3350)
    at org.mozilla.javascript.ScriptRuntime.constructError(ScriptRuntime.java:3340)
    at org.mozilla.javascript.ScriptRuntime.typeError(ScriptRuntime.java:3356)
    at org.mozilla.javascript.ScriptRuntime.typeError2(ScriptRuntime.java:3375)
    at org.mozilla.javascript.ScriptRuntime.notFunctionError(ScriptRuntime.java:3430)
    at org.mozilla.javascript.ScriptRuntime.notFunctionError(ScriptRuntime.java:3418)
    at org.mozilla.javascript.ScriptRuntime.newObject(ScriptRuntime.java:2129)
    at org.mozilla.javascript.gen.c35._c1(<inline>:3)
    at org.mozilla.javascript.gen.c35.call(<inline>)
    at org.mozilla.javascript.optimizer.OptRuntime.callName0(OptRuntime.java:108)
    at org.mozilla.javascript.gen.c36._c0(<inline>:1)
    at org.mozilla.javascript.gen.c36.call(<inline>)
    at org.mozilla.javascript.ContextFactory.doTopCall(ContextFactory.java:393)
    at org.mozilla.javascript.ScriptRuntime.doTopCall(ScriptRuntime.java:2834)
    at org.mozilla.javascript.gen.c36.call(<inline>)
    at org.mozilla.javascript.gen.c36.exec(<inline>)
    at org.eclipse.birt.core.script.ScriptContext.eval(ScriptContext.java:302)
    ... 79 more
May 13, 2009 1:28:27 PM org.eclipse.birt.report.engine.script.internal.DtEScriptExecutor handleJS
WARNING: A BIRT exception occurred: There are errors evaluating script "__bm_FETCH()":
ReferenceError: "stock" is not defined. (<inline>#3).. See next exception for more information.
There are errors evaluating script "__bm_FETCH()":
ReferenceError: "stock" is not defined. (<inline>#3).
org.eclipse.birt.data.engine.core.DataException: A BIRT exception occurred: There are errors evaluating script "__bm_FETCH()":
ReferenceError: "stock" is not defined. (<inline>#3).. See next exception for more information.
There are errors evaluating script "__bm_FETCH()":
ReferenceError: "stock" is not defined. (<inline>#3).
    at org.eclipse.birt.data.engine.core.DataException.wrap(DataException.java:118)
    at org.eclipse.birt.data.engine.script.ScriptEvalUtil.evaluateJSAsExpr(ScriptEvalUtil.java:717)
    at org.eclipse.birt.data.engine.script.JSMethodRunner.runScript(JSMethodRunner.java:76)
    at org.eclipse.birt.report.engine.script.internal.DtEScriptExecutor.handleJS(DtEScriptExecutor.java:71)
    at org.eclipse.birt.report.engine.script.internal.DataSetScriptExecutor.handleJS(DataSetScriptExecutor.java:196)
    at org.eclipse.birt.report.engine.script.internal.ScriptDataSetScriptExecutor.handleFetch(ScriptDataSetScriptExecutor.java:119)
    at org.eclipse.birt.data.engine.impl.ScriptDataSetRuntime.fetch(ScriptDataSetRuntime.java:102)
    at org.eclipse.birt.data.engine.impl.PreparedScriptDSQuery$ScriptDSQueryExecutor$CustomDataSet.fetch(PreparedScriptDSQuery.java:257)
    at org.eclipse.birt.data.engine.executor.cache.OdiAdapter.fetch(OdiAdapter.java:153)
    at org.eclipse.birt.data.engine.executor.cache.RowResultSet.next(RowResultSet.java:102)
    at org.eclipse.birt.data.engine.executor.cache.ExpandableRowResultSet.next(ExpandableRowResultSet.java:64)
    at org.eclipse.birt.data.engine.executor.cache.SmartCacheHelper.populateData(SmartCacheHelper.java:313)
    at org.eclipse.birt.data.engine.executor.cache.SmartCacheHelper.initInstance(SmartCacheHelper.java:285)
    at org.eclipse.birt.data.engine.executor.cache.SmartCacheHelper.getResultSetCache(SmartCacheHelper.java:246)
    at org.eclipse.birt.data.engine.executor.cache.SmartCache.<init>(SmartCache.java:74)
    at org.eclipse.birt.data.engine.executor.transform.pass.PassUtil.populateOdiResultSet(PassUtil.java:111)
    at org.eclipse.birt.data.engine.executor.transform.pass.PassUtil.pass(PassUtil.java:62)
    at org.eclipse.birt.data.engine.executor.transform.pass.PassManager.doSinglePass(PassManager.java:181)
    at org.eclipse.birt.data.engine.executor.transform.pass.PassManager.pass(PassManager.java:89)
    at org.eclipse.birt.data.engine.executor.transform.pass.PassManager.populateResultSet(PassManager.java:70)
    at org.eclipse.birt.data.engine.executor.transform.ResultSetPopulator.populateResultSet(ResultSetPopulator.java:196)
    at org.eclipse.birt.data.engine.executor.transform.CachedResultSet.<init>(CachedResultSet.java:156)
    at org.eclipse.birt.data.engine.executor.CandidateQuery.execute(CandidateQuery.java:108)
    at org.eclipse.birt.data.engine.impl.PreparedScriptDSQuery$ScriptDSQueryExecutor.executeOdiQuery(PreparedScriptDSQuery.java:223)
    at org.eclipse.birt.data.engine.impl.QueryExecutor.execute(QueryExecutor.java:945)
    at org.eclipse.birt.data.engine.impl.ServiceForQueryResults.executeQuery(ServiceForQueryResults.java:233)
    at org.eclipse.birt.data.engine.impl.QueryResults.getResultIterator(QueryResults.java:160)
    at org.eclipse.birt.report.engine.data.dte.QueryResultSet.<init>(QueryResultSet.java:92)
    at org.eclipse.birt.report.engine.data.dte.DteDataEngine.doExecuteQuery(DteDataEngine.java:129)
    at org.eclipse.birt.report.engine.data.dte.DataGenerationEngine.doExecuteQuery(DataGenerationEngine.java:79)
    at org.eclipse.birt.report.engine.data.dte.AbstractDataEngine.execute(AbstractDataEngine.java:253)
    at org.eclipse.birt.report.engine.executor.ExecutionContext.executeQuery(ExecutionContext.java:1755)
    at org.eclipse.birt.report.engine.executor.QueryItemExecutor.executeQuery(QueryItemExecutor.java:77)
    at org.eclipse.birt.report.engine.executor.TableItemExecutor.execute(TableItemExecutor.java:62)
    at org.eclipse.birt.report.engine.internal.executor.wrap.WrappedReportItemExecutor.execute(WrappedReportItemExecutor.java:45)
    at org.eclipse.birt.report.engine.internal.executor.emitter.ReportItemEmitterExecutor.execute(ReportItemEmitterExecutor.java:45)
    at org.eclipse.birt.report.engine.internal.executor.dup.SuppressDuplicateItemExecutor.execute(SuppressDuplicateItemExecutor.java:42)
    at org.eclipse.birt.report.engine.layout.html.HTMLBlockStackingLM.layoutNodes(HTMLBlockStackingLM.java:63)
    at org.eclipse.birt.report.engine.layout.html.HTMLPageLM.layout(HTMLPageLM.java:90)
    at org.eclipse.birt.report.engine.layout.html.HTMLReportLayoutEngine.layout(HTMLReportLayoutEngine.java:101)
    at org.eclipse.birt.report.engine.presentation.ReportDocumentBuilder.build(ReportDocumentBuilder.java:211)
    at org.eclipse.birt.report.engine.api.impl.RunTask.doRun(RunTask.java:237)
    at org.eclipse.birt.report.engine.api.impl.RunTask.run(RunTask.java:90)
    at org.eclipse.birt.report.service.ReportEngineService.runReport(ReportEngineService.java:1246)
    at org.eclipse.birt.report.service.BirtViewerReportService.runReport(BirtViewerReportService.java:155)
    at org.eclipse.birt.report.service.actionhandler.BirtRunReportActionHandler.__execute(BirtRunReportActionHandler.java:81)
    at org.eclipse.birt.report.service.actionhandler.BirtGetPageActionHandler.__checkDocumentExists(BirtGetPageActionHandler.java:58)
    at org.eclipse.birt.report.service.actionhandler.AbstractGetPageActionHandler.prepareParameters(AbstractGetPageActionHandler.java:119)
    at org.eclipse.birt.report.service.actionhandler.AbstractGetPageActionHandler.__execute(AbstractGetPageActionHandler.java:104)
    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.handleGetPage(BirtDocumentProcessor.java:87)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    at java.lang.reflect.Method.invoke(Method.java:585)
    at org.eclipse.birt.report.soapengine.processor.AbstractBaseComponentProcessor.process(AbstractBaseComponentProcessor.java:112)
    at org.eclipse.birt.report.soapengine.endpoint.BirtSoapBindingImpl.getUpdatedObjects(BirtSoapBindingImpl.java:66)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    at java.lang.reflect.Method.invoke(Method.java:585)
    at org.apache.axis.providers.java.RPCProvider.invokeMethod(RPCProvider.java:397)
    at org.apache.axis.providers.java.RPCProvider.processMessage(RPCProvider.java:186)
    at org.apache.axis.providers.java.JavaProvider.invoke(JavaProvider.java:323)
    at org.apache.axis.strategies.InvocationStrategy.visit(InvocationStrategy.java:32)
    at org.apache.axis.SimpleChain.doVisiting(SimpleChain.java:118)
    at org.apache.axis.SimpleChain.invoke(SimpleChain.java:83)
    at org.apache.axis.handlers.soap.SOAPService.invoke(SOAPService.java: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:647)
    at org.apache.axis.transport.http.AxisServletBase.service(AxisServletBase.java:327)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
    at org.eclipse.birt.report.servlet.BirtSoapMessageDispatcherServlet.service(BirtSoapMessageDispatcherServlet.java:122)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
    at org.eclipse.birt.report.filter.ViewerFilter.doFilter(ViewerFilter.java:68)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
    at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
    at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:172)
    at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
    at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
    at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)
    at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:174)
    at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:875)
    at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665)
    at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528)
    at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81)
    at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689)
    at java.lang.Thread.run(Thread.java:595)
Caused by: org.eclipse.birt.core.exception.CoreException: There are errors evaluating script "__bm_FETCH()":
ReferenceError: "stock" is not defined. (<inline>#3).
    at org.eclipse.birt.core.script.ScriptContext.eval(ScriptContext.java:307)
    at org.eclipse.birt.core.script.ScriptContext.eval(ScriptContext.java:268)
    at org.eclipse.birt.data.engine.script.ScriptEvalUtil.evaluateJSAsExpr(ScriptEvalUtil.java:713)
    ... 92 more
Caused by: org.mozilla.javascript.EcmaError: ReferenceError: "stock" is not defined. (<inline>#3)
    at org.mozilla.javascript.ScriptRuntime.constructError(ScriptRuntime.java:3350)
    at org.mozilla.javascript.ScriptRuntime.constructError(ScriptRuntime.java:3340)
    at org.mozilla.javascript.ScriptRuntime.notFoundError(ScriptRuntime.java:3413)
    at org.mozilla.javascript.ScriptRuntime.nameOrFunction(ScriptRuntime.java:1678)
    at org.mozilla.javascript.ScriptRuntime.name(ScriptRuntime.java:1617)
    at org.mozilla.javascript.gen.c37._c1(<inline>:3)
    at org.mozilla.javascript.gen.c37.call(<inline>)
    at org.mozilla.javascript.optimizer.OptRuntime.callName0(OptRuntime.java:108)
    at org.mozilla.javascript.gen.c38._c0(<inline>:1)
    at org.mozilla.javascript.gen.c38.call(<inline>)
    at org.mozilla.javascript.ContextFactory.doTopCall(ContextFactory.java:393)
    at org.mozilla.javascript.ScriptRuntime.doTopCall(ScriptRuntime.java:2834)
    at org.mozilla.javascript.gen.c38.call(<inline>)
    at org.mozilla.javascript.gen.c38.exec(<inline>)
    at org.eclipse.birt.core.script.ScriptContext.eval(ScriptContext.java:302)
    ... 94 more
May 13, 2009 1:28:27 PM org.eclipse.birt.report.engine.script.internal.ScriptExecutor addException
WARNING: data.engine.BadFetchScriptReturnType
org.eclipse.birt.data.engine.core.DataException: data.engine.BadFetchScriptReturnType
    at org.eclipse.birt.report.engine.script.internal.ScriptDataSetScriptExecutor.handleFetch(ScriptDataSetScriptExecutor.java:129)
    at org.eclipse.birt.data.engine.impl.ScriptDataSetRuntime.fetch(ScriptDataSetRuntime.java:102)
    at org.eclipse.birt.data.engine.impl.PreparedScriptDSQuery$ScriptDSQueryExecutor$CustomDataSet.fetch(PreparedScriptDSQuery.java:257)
    at org.eclipse.birt.data.engine.executor.cache.OdiAdapter.fetch(OdiAdapter.java:153)
    at org.eclipse.birt.data.engine.executor.cache.RowResultSet.next(RowResultSet.java:102)
    at org.eclipse.birt.data.engine.executor.cache.ExpandableRowResultSet.next(ExpandableRowResultSet.java:64)
    at org.eclipse.birt.data.engine.executor.cache.SmartCacheHelper.populateData(SmartCacheHelper.java:313)
    at org.eclipse.birt.data.engine.executor.cache.SmartCacheHelper.initInstance(SmartCacheHelper.java:285)
    at org.eclipse.birt.data.engine.executor.cache.SmartCacheHelper.getResultSetCache(SmartCacheHelper.java:246)
    at org.eclipse.birt.data.engine.executor.cache.SmartCache.<init>(SmartCache.java:74)
    at org.eclipse.birt.data.engine.executor.transform.pass.PassUtil.populateOdiResultSet(PassUtil.java:111)
    at org.eclipse.birt.data.engine.executor.transform.pass.PassUtil.pass(PassUtil.java:62)
    at org.eclipse.birt.data.engine.executor.transform.pass.PassManager.doSinglePass(PassManager.java:181)
    at org.eclipse.birt.data.engine.executor.transform.pass.PassManager.pass(PassManager.java:89)
    at org.eclipse.birt.data.engine.executor.transform.pass.PassManager.populateResultSet(PassManager.java:70)
    at org.eclipse.birt.data.engine.executor.transform.ResultSetPopulator.populateResultSet(ResultSetPopulator.java:196)
    at org.eclipse.birt.data.engine.executor.transform.CachedResultSet.<init>(CachedResultSet.java:156)
    at org.eclipse.birt.data.engine.executor.CandidateQuery.execute(CandidateQuery.java:108)
    at org.eclipse.birt.data.engine.impl.PreparedScriptDSQuery$ScriptDSQueryExecutor.executeOdiQuery(PreparedScriptDSQuery.java:223)
    at org.eclipse.birt.data.engine.impl.QueryExecutor.execute(QueryExecutor.java:945)
    at org.eclipse.birt.data.engine.impl.ServiceForQueryResults.executeQuery(ServiceForQueryResults.java:233)
    at org.eclipse.birt.data.engine.impl.QueryResults.getResultIterator(QueryResults.java:160)
    at org.eclipse.birt.report.engine.data.dte.QueryResultSet.<init>(QueryResultSet.java:92)
    at org.eclipse.birt.report.engine.data.dte.DteDataEngine.doExecuteQuery(DteDataEngine.java:129)
    at org.eclipse.birt.report.engine.data.dte.DataGenerationEngine.doExecuteQuery(DataGenerationEngine.java:79)
    at org.eclipse.birt.report.engine.data.dte.AbstractDataEngine.execute(AbstractDataEngine.java:253)
    at org.eclipse.birt.report.engine.executor.ExecutionContext.executeQuery(ExecutionContext.java:1755)
    at org.eclipse.birt.report.engine.executor.QueryItemExecutor.executeQuery(QueryItemExecutor.java:77)
    at org.eclipse.birt.report.engine.executor.TableItemExecutor.execute(TableItemExecutor.java:62)
    at org.eclipse.birt.report.engine.internal.executor.wrap.WrappedReportItemExecutor.execute(WrappedReportItemExecutor.java:45)
    at org.eclipse.birt.report.engine.internal.executor.emitter.ReportItemEmitterExecutor.execute(ReportItemEmitterExecutor.java:45)
    at org.eclipse.birt.report.engine.internal.executor.dup.SuppressDuplicateItemExecutor.execute(SuppressDuplicateItemExecutor.java:42)
    at org.eclipse.birt.report.engine.layout.html.HTMLBlockStackingLM.layoutNodes(HTMLBlockStackingLM.java:63)
    at org.eclipse.birt.report.engine.layout.html.HTMLPageLM.layout(HTMLPageLM.java:90)
    at org.eclipse.birt.report.engine.layout.html.HTMLReportLayoutEngine.layout(HTMLReportLayoutEngine.java:101)
    at org.eclipse.birt.report.engine.presentation.ReportDocumentBuilder.build(ReportDocumentBuilder.java:211)
    at org.eclipse.birt.report.engine.api.impl.RunTask.doRun(RunTask.java:237)
    at org.eclipse.birt.report.engine.api.impl.RunTask.run(RunTask.java:90)
    at org.eclipse.birt.report.service.ReportEngineService.runReport(ReportEngineService.java:1246)
    at org.eclipse.birt.report.service.BirtViewerReportService.runReport(BirtViewerReportService.java:155)
    at org.eclipse.birt.report.service.actionhandler.BirtRunReportActionHandler.__execute(BirtRunReportActionHandler.java:81)
    at org.eclipse.birt.report.service.actionhandler.BirtGetPageActionHandler.__checkDocumentExists(BirtGetPageActionHandler.java:58)
    at org.eclipse.birt.report.service.actionhandler.AbstractGetPageActionHandler.prepareParameters(AbstractGetPageActionHandler.java:119)
    at org.eclipse.birt.report.service.actionhandler.AbstractGetPageActionHandler.__execute(AbstractGetPageActionHandler.java:104)
    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.handleGetPage(BirtDocumentProcessor.java:87)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    at java.lang.reflect.Method.invoke(Method.java:585)
    at org.eclipse.birt.report.soapengine.processor.AbstractBaseComponentProcessor.process(AbstractBaseComponentProcessor.java:112)
    at org.eclipse.birt.report.soapengine.endpoint.BirtSoapBindingImpl.getUpdatedObjects(BirtSoapBindingImpl.java:66)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    at java.lang.reflect.Method.invoke(Method.java:585)
    at org.apache.axis.providers.java.RPCProvider.invokeMethod(RPCProvider.java:397)
    at org.apache.axis.providers.java.RPCProvider.processMessage(RPCProvider.java:186)
    at org.apache.axis.providers.java.JavaProvider.invoke(JavaProvider.java:323)
    at org.apache.axis.strategies.InvocationStrategy.visit(InvocationStrategy.java:32)
    at org.apache.axis.SimpleChain.doVisiting(SimpleChain.java:118)
    at org.apache.axis.SimpleChain.invoke(SimpleChain.java:83)
    at org.apache.axis.handlers.soap.SOAPService.invoke(SOAPService.java: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:647)
    at org.apache.axis.transport.http.AxisServletBase.service(AxisServletBase.java:327)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
    at org.eclipse.birt.report.servlet.BirtSoapMessageDispatcherServlet.service(BirtSoapMessageDispatcherServlet.java:122)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
    at org.eclipse.birt.report.filter.ViewerFilter.doFilter(ViewerFilter.java:68)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
    at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
    at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:172)
    at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
    at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
    at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)
    at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:174)
    at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:875)
    at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665)
    at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528)
    at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81)
    at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689)
    at java.lang.Thread.run(Thread.java:595)




One Thing I do:  Forgetting what is behind and straining toward what is ahead, I press on toward the goal...
-------------------
If you learn to trust in the Lord, You will become trustworthy.
If you learn to rely on Him, you will become reliable.
If you learn to lean on God, you will become someone others can lean on.


Reply all
Reply to author
Forward
0 new messages