DZone Forums
Go Back   DZone Forums > Community > Enterprise Development > BI & Reporting
Reload this Page BIRT report with scripted data set does not show in Preview tab
Notices
Reply
 
LinkBack Thread Tools Display Modes
  (#1 (permalink)) Old
Member
 
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Join Date: Mar 2008
Default BIRT report with scripted data set does not show in Preview tab - 03-26-2008, 11:37 AM

Hi All,

Here's my situation:

I am using BIRT 2.1 made available by download in the Rational Software Architect IDE.

I've created a Java project and a class that connects to a DB2 database, retrieves a result set, and stores the results in a vector, very much like the various BIRT tutorials that have to do with Scripted Data Sets. The class was created under a package, and I then exported this package to:
D:\Program Files\IBM\SDP70Shared\plugins\org.eclipse.birt.rep ort.viewer_2.1.2.v20070205-1728\birt\WEB-INF\lib

In BIRT, I create a scripted data source and a scripted data set based on that data source. In the 'open' tab of the script I put the following:

asset = Packages.hwOwnedAssets.BlueboxCandidates();
count = 0;
assetVector = asset.assetQuery();
assetVectorSize = assetVector.size();


In the 'fetch' tab:

if (count > assetVectorSize - 1) {
return false;
} else {
currRow = assetVector.get(count);
row["FunctionGroup"] = currRow[5];
row["ITGroupName"] = currRow[6];
row["LocationType"] = currRow[4];
row["Dept"] = currRow[3];
row["HWClass"] = currRow[7];
count++;
return true;
}


The data set has all of the necessary output columns. When I open the data set in the Data Explorer toolbar and go to 'Preview' the data shows up fine. However when I create a table and drag the data set elements into it, upon clicking the 'Preview' tab in the editor pane (where the Layout, MasterPage, Script, and XML Source tabs are found) the report does not appear. Instead I get this error:

Error.ScriptEvaluationError ( 1 time(s) )
detail : org.eclipse.birt.report.engine.api.EngineException : There are errors evaluating script "asset = Packages.hwOwnedAssets.BlueboxCandidates();count = 0;assetVector = asset.assetQuery();assetVectorSize = assetVector.size();". at org.eclipse.birt.report.engine.script.internal.DtE ScriptExecutor.handleJS(Unknown Source) at org.eclipse.birt.report.engine.script.internal.Dat aSetScriptExecutor.handleJS(Unknown Source) at org.eclipse.birt.report.engine.script.internal.Scr iptDataSetScriptExecutor.handleOpen(Unknown Source) at org.eclipse.birt.data.engine.impl.ScriptDataSetRun time.open(Unknown Source) at org.eclipse.birt.data.engine.impl.PreparedScriptDS Query$ScriptDSQueryExecutor$CustomDataSet.open(Unk nown Source) at org.eclipse.birt.data.engine.impl.PreparedScriptDS Query$ScriptDSQueryExecutor.executeOdiQuery(Unknow n Source) at org.eclipse.birt.data.engine.impl.QueryExecutor.ex ecute(Unknown Source) at org.eclipse.birt.data.engine.impl.ServiceForQueryR esults.executeQuery(Unknown Source) at org.eclipse.birt.data.engine.impl.QueryResults.get ResultIterator(Unknown Source) at org.eclipse.birt.report.engine.data.dte.DteResultS et.<init>(Unknown Source) at org.eclipse.birt.report.engine.data.dte.DteDataEng ine.doExecuteQuery(Unknown Source) at org.eclipse.birt.report.engine.data.dte.AbstractDa taEngine.execute(Unknown Source) at org.eclipse.birt.report.engine.executor.ExecutionC ontext.executeQuery(Unknown Source) at org.eclipse.birt.report.engine.executor.QueryItemE xecutor.executeQuery(Unknown Source) at org.eclipse.birt.report.engine.executor.TableItemE xecutor.execute(Unknown Source) at org.eclipse.birt.report.engine.internal.executor.l 18n.LocalizedReportItemExecutor.execute(Unknown Source) at org.eclipse.birt.report.engine.layout.html.HTMLPag eLM.layoutChildren(Unknown Source) at org.eclipse.birt.report.engine.layout.html.HTMLPag eLM.layout(Unknown Source) at org.eclipse.birt.report.engine.layout.html.HTMLRep ortLayoutEngine.layout(Unknown Source) at org.eclipse.birt.report.engine.api.impl.RunAndRend erTask.doRun(Unknown Source) at org.eclipse.birt.report.engine.api.impl.RunAndRend erTask.run(Unknown Source) at org.eclipse.birt.report.service.ReportEngineServic e.runAndRenderReport(Unknown Source) at org.eclipse.birt.report.service.ReportEngineServic e.runAndRenderReport(Unknown Source) at org.eclipse.birt.report.service.BirtViewerReportSe rvice.runAndRenderReport(Unknown Source) at org.eclipse.birt.report.service.actionhandler.Birt RunAndRenderActionHandler.__execute(Unknown Source) at org.eclipse.birt.report.service.actionhandler.Abst ractBaseActionHandler.execute(Unknown Source) at org.eclipse.birt.report.presentation.aggregation.l ayout.EngineFragment.doService(Unknown Source) at org.eclipse.birt.report.presentation.aggregation.A bstractBaseFragment.service(Unknown Source) at org.eclipse.birt.report.servlet.BirtEngineServlet. __doGet(Unknown Source) at org.eclipse.birt.report.servlet.BaseReportEngineSe rvlet.doGet(Unknown Source) at javax.servlet.http.HttpServlet.service(Unknown Source) at org.apache.axis.transport.http.AxisServletBase.ser vice(Unknown Source) at javax.servlet.http.HttpServlet.service(Unknown Source) at org.apache.catalina.core.ApplicationFilterChain.in ternalDoFilter(Unknown Source) at org.apache.catalina.core.ApplicationFilterChain.do Filter(Unknown Source) at org.apache.catalina.core.StandardWrapperValve.invo ke(Unknown Source) at org.apache.catalina.core.StandardPipeline$Standard PipelineValveContext.invokeNext(Unknown Source) at org.apache.catalina.core.StandardPipeline.invoke(U nknown Source) at org.apache.catalina.core.ContainerBase.invoke(Unkn own Source) at org.apache.catalina.core.StandardContextValve.invo ke(Unknown Source) at org.apache.catalina.core.StandardPipeline$Standard PipelineValveContext.invokeNext(Unknown Source) at org.apache.catalina.valves.CertificatesValve.invok e(Unknown Source) at org.apache.catalina.core.StandardPipeline$Standard PipelineValveContext.invokeNext(Unknown Source) at org.apache.catalina.core.StandardPipeline.invoke(U nknown Source) at org.apache.catalina.core.ContainerBase.invoke(Unkn own Source) at org.apache.catalina.core.StandardContext.invoke(Un known Source) at org.apache.catalina.core.StandardHostValve.invoke( Unknown Source) at org.apache.catalina.core.StandardPipeline$Standard PipelineValveContext.invokeNext(Unknown Source) at org.apache.catalina.valves.ErrorDispatcherValve.in voke(Unknown Source) at org.apache.catalina.core.StandardPipeline$Standard PipelineValveContext.invokeNext(Unknown Source) at org.eclipse.tomcat.internal.EclipseErrorReportValv e.invoke(Unknown Source) at org.apache.catalina.core.StandardPipeline$Standard PipelineValveContext.invokeNext(Unknown Source) at org.apache.catalina.core.StandardPipeline.invoke(U nknown Source) at org.apache.catalina.core.ContainerBase.invoke(Unkn own Source) at org.apache.catalina.core.StandardEngineValve.invok e(Unknown Source) at org.apache.catalina.core.StandardPipeline$Standard PipelineValveContext.invokeNext(Unknown Source) at org.apache.catalina.core.StandardPipeline.invoke(U nknown Source) at org.apache.catalina.core.ContainerBase.invoke(Unkn own Source) at org.apache.coyote.tomcat4.CoyoteAdapter.service(Un known Source) at org.apache.coyote.http11.Http11Processor.process(U nknown Source) at org.apache.coyote.http11.Http11Protocol$Http11Conn ectionHandler.processConnection(Unknown Source) at org.apache.tomcat.util.net.TcpWorkerThread.runIt(U nknown Source) at org.apache.tomcat.util.threads.ThreadPool$ControlR unnable.run(Unknown Source) at java.lang.Thread.run(Unknown Source)Caused by: org.eclipse.birt.data.engine.core.DataException: A BIRT exception occurred: Error evaluating Javascript expression. Script engine error: TypeError: Cannot call method "size" of null Script source: DataSet[Assets].__bm_OPEN, line: 1, text:__bm_OPEN(). See next exception for more information.Error evaluating Javascript expression. Script engine error: TypeError: Cannot call method "size" of null Script source: DataSet[Assets].__bm_OPEN, line: 1, text:__bm_OPEN() at org.eclipse.birt.data.engine.core.DataException.wr ap(Unknown Source) at org.eclipse.birt.data.engine.script.ScriptEvalUtil .evaluateJSAsExpr(Unknown Source) at org.eclipse.birt.data.engine.script.JSMethodRunner .runScript(Unknown Source) ... 64 moreCaused by: org.eclipse.birt.core.exception.CoreException: Error evaluating Javascript expression. Script engine error: TypeError: Cannot call method "size" of null Script source: DataSet[Assets].__bm_OPEN, line: 1, text:__bm_OPEN() at org.eclipse.birt.core.script.JavascriptEvalUtil.wr apRhinoException(Unknown Source) at org.eclipse.birt.core.script.JavascriptEvalUtil.ev aluateRawScript(Unknown Source) at org.eclipse.birt.core.script.JavascriptEvalUtil.ev aluateScript(Unknown Source) ... 66 moreCaused by: org.mozilla.javascript.EcmaError: TypeError: Cannot call method "size" of null at org.mozilla.javascript.ScriptRuntime.constructErro r(Unknown Source) at org.mozilla.javascript.ScriptRuntime.constructErro r(Unknown Source) at org.mozilla.javascript.ScriptRuntime.typeError(Unk nown Source) at org.mozilla.javascript.ScriptRuntime.typeError2(Un known Source) at org.mozilla.javascript.ScriptRuntime.undefCallErro r(Unknown Source) at org.mozilla.javascript.ScriptRuntime.getPropFuncti onAndThis(Unknown Source) at org.mozilla.javascript.optimizer.OptRuntime.callPr op0(Unknown Source) at org.mozilla.javascript.gen.c10._c1(Unknown Source) at org.mozilla.javascript.gen.c10.call(Unknown Source) at org.mozilla.javascript.optimizer.OptRuntime.callNa me0(Unknown Source) at org.mozilla.javascript.gen.c11._c0(Unknown Source) at org.mozilla.javascript.gen.c11.call(Unknown Source) at org.mozilla.javascript.ContextFactory.doTopCall(Un known Source) at org.mozilla.javascript.ScriptRuntime.doTopCall(Unk nown Source) at org.mozilla.javascript.gen.c11.call(Unknown Source) at org.mozilla.javascript.gen.c11.exec(Unknown Source) ... 68 more

What's funny is that this worked just yesterday and then all of a sudden it seems to have stopped working.

Any ideas?
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Views in new perspective don't show up. kaprasanna Eclipse 0 07-25-2008 07:07 AM
BIRT ODA Designer murtuza221 BI & Reporting 0 07-23-2008 05:20 PM
Marker doesn't show up. kaprasanna Eclipse 0 07-22-2008 08:31 AM
Preview/Run function for jsp file in WEB-INF (Eclipse 3.3/WTP) rene10 Eclipse 0 06-25-2008 07:42 PM
Eclipse and j2ee preview MrMiagi Eclipse 6 03-11-2008 06:06 AM


Copyright 1997-2009, DZone, Inc.
vBulletin Skin developed by: vBStyles.com