Table only display single row

Hello,

I have a Scripted Data set that I know is 100% correct (It returns multiple rows when I run the exact same script within TOAD, and the report was behaving correctly yesterday, but not today).

When I place the fields from the dataset into the details section of the table, and I run a preview of the report, I only see the first row of the data set. (I should see 3)

Is there a property of the table that could be set incorrectly that would cause this issue to occur? I am just not sure what could have changed to cause this odd behaviour.

Thanks

P.S. I am using Eclipse with a BIRT add-on

Find more posts tagged with

Comments

mwilliams

If you go into the dataSet editor and select preview results, do you see the expected results?

BIRTNEWB

Hi mwilliams, thanks for the reply.<br />
<br />
Now I am even more confused! <a class='bbc_url' href='http://www.birt-exchange.org/org/forum/public/style_emoticons/'>http://www.birt-exchange.org/org/forum/public/style_emoticons/</a><#EMO_DIR#>/confused.gif <br />
Going into the Preview Results for the Data Set results in an exception being thrown. ("__bm_open()"<br />
"wo_id" is not defined) BUT when I preview the report, I get results and "wo_id" has a value. I've proven that it does by making it an output column for the data set.<br />
<br />
The complete data set script is here.<br />
<br />
<pre class='_prettyXprint _lang-auto _linenums:0'>
maximoDataSet = MXReportDataSetProvider.create(this.getDataSource().getName(), this.getName());
maximoDataSet.open();
var sqlText = new String();
// Add MM-Maximo query to sqlText variable.
sqlText =
" SELECT MA.LOCATION, MA.ASSETNUM, MA.COMMENTS, \'" + wo_id + "\' THING " +
" FROM WORKORDER WO, " +
" MULTIASSETLOCCI MA " +
" WHERE WO.WONUM = MA.RECORDKEY " +
" AND MA.RECORDCLASS = 'WORKORDER' " +
" AND MA.RECORDKEY = \'" + wo_id + "\' " +
" ORDER BY MA.ROWSTAMP";
maximoDataSet.setQuery(sqlText);
</pre>
<br />
This was a project handed to me, so I am not 100% sure where wo_id would be defined (if it acutally is).

mwilliams

Look for it in other script areas by going into your outline to the scripts section and seeing where you have script in your report. Like, a scripted dataSet typically has script in the open and fetch methods. You may also have something in your initialize method of your report. Let me know.

BIRTNEWB

Both the Open and Fetch methods for Script Data Sets that use "wo_id" do not have it declared. The initialize method found inside the Report Design node looks like this...<br />
<br />
<pre class='_prettyXprint _lang-auto _linenums:0'>importPackage(Packages.com.ibm.tivoli.maximo.report.script);
mxReportScriptContext = MXReportScriptContext.initialize(reportContext);</pre>

mwilliams

Can you attach your report design?

BIRTNEWB

I am assuming when you say report deisgn you mean the .rptdesign file?
The reports I am working on are for the Maximo system.

Thanks

mwilliams

Ok, I found wo_id. Check out the WONUM binding in the binding tab of the outer table. This is why you're getting the error in the preview results. The value isn't created cause the other dataSet doesn't run.

As far as the only getting one row in the table that is bound to the dataSet we're talking about, it'll only be getting the rows associated with the WONUM from the outer table, so in this case, do you expect 3 rows still?

BIRTNEWB

Nice!

It was bothering to the n'th degree where that variable belonged thanks alot!

Unfortunately determining where wo_id resides hasn't solved my issue as I am still
expecting 3 rows. The outer table's WONUM is the one side of a one-to-many relationship. The many being the assets.

I know this because I manually replace wo_id with the Work Order # I am testing off of in my SQL editor. When I run the report, I only see the first row, and nothing else gets included. :huh:

thanks.

mwilliams

So, if you manually replace wo_id in your scripted dataSet code with a static value for wo_id, you get 3 rows?

BIRTNEWB

Nope that was the first thing I tried, I get the exact same result.

<br />
<br />
I thought it was spacing, or that a table property is not allowing it to grow. But everything looks fine. I am pretty confident at this point it has something to do with how the report is displaying, as the first time I created the data set, it worked flawlessly. Now, no matter how many times I rebuild the dataset I get the same result.<br />
<br />
<br />
<blockquote class='ipsBlockquote' data-author="'mwilliams'" data-cid="80439" data-time="1311304297" data-date="21 July 2011 - 08:11 PM"><p>
So, if you manually replace wo_id in your scripted dataSet code with a static value for wo_id, you get 3 rows?<br /></p></blockquote>

mwilliams

So, if you're only getting the one value back from the query even with the static value, it's definitely something with the scripted dataSet or with the data. Make sure there isn't an issue with your fetch script that would cause it to only grab one row. If that checks out, double check with your database that there is for sure 3 rows.

BIRTNEWB

My FETCH code looks like this<br />
<pre class='_prettyXprint _lang-auto _linenums:0'>if (!maximoDataSet.fetch())
return (false);
// Add a line for each output column
row["LOCATION"] = maximoDataSet.getString("LOCATION");
row["ASSETNUM"] = maximoDataSet.getString("ASSETNUM");
row["COMMENTS"] = maximoDataSet.getFloat("COMMENTS");
return (true);</pre>
<br />
And my OPEN looks like this <br />
<br />
<pre class='_prettyXprint _lang-auto _linenums:0'>
maximoDataSet = MXReportDataSetProvider.create(this.getDataSource().getName(), this.getName());
maximoDataSet.open();
var sqlText = new String();
// Add MM-Maximo query to sqlText variable.
sqlText =
" SELECT MA.LOCATION, MA.ASSETNUM, MA.COMMENTS " +
" FROM WORKORDER WO, " +
" MULTIASSETLOCCI MA " +
" WHERE WO.WONUM = MA.RECORDKEY " +
" AND MA.RECORDCLASS = \'WORKORDER\' " +
" AND MA.RECORDKEY = \'225001\' " +
" ORDER BY MA.ROWSTAMP";
maximoDataSet.setQuery(sqlText);
</pre>
<br />
It's hard for me to confirm if this is a Script Data Set issue or a presentation issue, since everytime I try to run preview results in the edit data source it throws another BIRT exception.<br />
<br />
<span style='color: #FF0000'>A BIRT exception occured: There are errors evaluating script "__bm_fetch":</span><br />
<br />
fetch looks fine though...<br />
<br />
Also, I am starting to think that maybe the DataSource is hitting the wrong database, maybe one of our test schemas. Is there a way to see the connection string of the Data Source?<br />
<br />
<blockquote class='ipsBlockquote' data-author="'mwilliams'" data-cid="80521" data-time="1311609680" data-date="25 July 2011 - 09:01 AM"><p>
So, if you're only getting the one value back from the query even with the static value, it's definitely something with the scripted dataSet or with the data. Make sure there isn't an issue with your fetch script that would cause it to only grab one row. If that checks out, double check with your database that there is for sure 3 rows.<br /></p></blockquote>

mwilliams

What is the rest of the exception that you get?

As for the dataSource, that's probably something you'll have to check in Maximo.

BIRTNEWB

EDIT***<br />
<br />
A BIRT exception occurred.<br />
Plug-in Provider:Eclipse.org<br />
Plug-in Name:BIRT Data Engine<br />
Plug-in ID:org.eclipse.birt.data<br />
Version:2.3.2.r232_v20090211<br />
Error Code:A BIRT exception occurred: There are errors evaluating script "__bm_fetch()":<br />
Wrapped com.ibm.tivoli.maximo.report.script.MXReportRuntimeException: java.sql.SQLException: Fail to convert to internal representation (<inline>#7).. See next exception for more information.<br />
There are errors evaluating script "__bm_fetch()":<br />
Wrapped com.ibm.tivoli.maximo.report.script.MXReportRuntimeException: java.sql.SQLException: Fail to convert to internal representation (<inline>#7).<br />
Error Message:A BIRT exception occurred: There are errors evaluating script "__bm_fetch()":<br />
Wrapped com.ibm.tivoli.maximo.report.script.MXReportRuntimeException: java.sql.SQLException: Fail to convert to internal representation (<inline>#7).. See next exception for more information.<br />
There are errors evaluating script "__bm_fetch()":<br />
Wrapped com.ibm.tivoli.maximo.report.script.MXReportRuntimeException: java.sql.SQLException: Fail to convert to internal representation (<inline>#7).<br />
<br />
EDIT***<br />
<br />
I am able to add assets to the work order in the Maximo Front end, run the query in the database, and see the changes take place (I now have 4 records). So I know I am touching the right tables. I just can't get BIRT (either in the Report Preview tab, or in the "Preview Results" in the Edit Data Source) so show what my database has.<br />
<br />
This is my oracle SQL translated from BIRT<br />
<br />
<pre class='_prettyXprint _lang-auto _linenums:0'>SELECT MA.LOCATION, MA.ASSETNUM, MA.COMMENTS
FROM WORKORDER WO,
MULTIASSETLOCCI MA
WHERE WO.WONUM = MA.RECORDKEY
AND MA.RECORDCLASS = 'WORKORDER'
AND MA.RECORDKEY = '225001'
ORDER BY MA.ROWSTAMP</pre>
<br />
So either BIRT's data source is pointing to a schema that I am not aware of or it's a presentation issue.

mwilliams

Looking at the above, I'd guess that maybe calling getFloat of a column called comments is where you're getting this error from. It seems like this should be a string, but maybe the comments are floats and I just don't know the data.

BIRTNEWB

<blockquote class='ipsBlockquote' data-author="'mwilliams'" data-cid="80535" data-time="1311613052" data-date="25 July 2011 - 09:57 AM"><p>
What is the rest of the exception that you get?<br />
<br />
As for the dataSource, that's probably something you'll have to check in Maximo.<br /></p></blockquote>
<br />
The report isn't being tested in Maximo, it's being tested within BIRT, so the .RPTDESIGN file would have it's datasource pointed to a particular oracle schema. Is a way within BIRT to determine a data source's configuration?<br />
<br />
Thanks

BIRTNEWB

who'd a thunk it! I've always been a firm believer that a fresh set of eyes when debugging can save hours. (No matter how convinced I think it's something else)

Thanks you so much for your help. That in fact was the issue, changing the getFloat to getString solved the exception, and the single-row issue.

I wonder why the Preview tab didn't show all the rows? Regardless, that's a gotcha I now know to look out for. And will validate all my data sets via the Preview Results in the Edit Data Set instead of the Preview Tab.

mwilliams

Glad to help. Let us know whenever you have questions!

deepikapc

<p>hi</p>
<p> </p>
<p>admin/Williams</p>
<p> </p>
<p>please i have query when i run the report in maximo system it showing the error.</p>
<p> </p>
<div>and i have attached file please check it and thanks for support</div>
<div> </div>
<div> </div>
<div>Multiple exceptions occurred.</div>
<div>Hide Exception Stack Trace</div>
<div>Stack Trace:</div>
<div>org.eclipse.birt.report.engine.api.EngineException: There are errors evaluating script "if (!maximoDataSet.fetch())</div>
<div>return (false);</div>
<div> </div>
<div>// Add a line for each output column</div>
<div>// The specific get method should match the data type of the output column.</div>
<div>row["projectnum"] = maximoDataSet.getString("projectnum");</div>
<div>row["description"] = maximoDataSet.getString("description");</div>
<div>row["projecttype"] = maximoDataSet.getString("projecttype");</div>
<div>row["budgetamount"] = maximoDataSet.getString("budgetamount");</div>
<div>row["committedamount"] = maximoDataSet.getString("committedamount");</div>
<div>row["availableamount"] = maximoDataSet.getString("availableamount");</div>
<div>row["glaccount"] = maximoDataSet.getString("glaccount");</div>
<div>row["actualamount"] = maximoDataSet.getString("actualamount");</div>
<div>row["status"] = maximoDataSet.getString("status");</div>
<div>row["costcenter"] = maximoDataSet.getString("costcenter");</div>
<div>row["projectowner"] = maximoDataSet.getString("projectowner");</div>
<div>row["project"] = maximoDataSet.getString("project");</div>
<div>row["amount"] = maximoDataSet.getString("amount");</div>
<div>row["enteredby"] = maximoDataSet.getString("enteredby");</div>
<div>row["entereddate"] = maximoDataSet.getString("entereddate");</div>
<div>row["mrnum"] = maximoDataSet.getString("mrnum");</div>
<div>row["mdescrption"] = maximoDataSet.getString("mdescrption");</div>
<div>row["mrcost"] = maximoDataSet.getString("mrcost");</div>
<div>row["mrdate"] = maximoDataSet.getString("mrdate");</div>
<div>row["buyer"] = maximoDataSet.getString("buyer");</div>
<div>row["mrstatus"] = maximoDataSet.getString("mrstatus");</div>
<div>row["prnum"] = maximoDataSet.getString("prnum");</div>
<div>row["prcost"] = maximoDataSet.getString("prcost");</div>
<div>row["prdescription"] = maximoDataSet.getString("prdescription");</div>
<div>row["prstatus"] = maximoDataSet.getString("prstatus");</div>
<div>row["issuedate"] = maximoDataSet.getString("issuedate");</div>
<div>row["ponum"] = maximoDataSet.getString("ponum");</div>
<div>row["pdescription"] = maximoDataSet.getString("pdescription");</div>
<div>row["pstatus"] = maximoDataSet.getString("pstatus");</div>
<div>row["potype"] = maximoDataSet.getString("potype");</div>
<div>row["vendor"] = maximoDataSet.getString("vendor");</div>
<div>row["pocost"] = maximoDataSet.getString("pocost");</div>
<div>row["orderdate"] = maximoDataSet.getString("orderdate");</div>
<div>row["poactualamount"] = maximoDataSet.getString("poactualamount");</div>
<div>row["pocommittedamount"] = maximoDataSet.getString("pocommittedamount");</div>
<div>row["iponum"] = maximoDataSet.getString("iponum");</div>
<div>row["invoicenum"] = maximoDataSet.getString("invoicenum");</div>
<div>row["vendorinvoicenum"] = maximoDataSet.getString("vendorinvoicenum");</div>
<div>row["invoicedate"] = maximoDataSet.getString("invoicedate");</div>
<div>row["idescription"] = maximoDataSet.getString("idescription");</div>
<div>row["itype"] = maximoDataSet.getString("itype");</div>
<div>row["icost"] = maximoDataSet.getString("icost");</div>
<div>row["istatus"] = maximoDataSet.getString("istatus");</div>
<div>row["prodescription"] = maximoDataSet.getString("prodescription");</div>
<div>return (true);":</div>
<div>{1}.</div>
<div> at org.eclipse.birt.report.engine.script.internal.DtEScriptExecutor.handleJS(DtEScriptExecutor.java:77)</div>
<div> at org.eclipse.birt.report.engine.script.internal.DataSetScriptExecutor.handleJS(DataSetScriptExecutor.java:196)</div>
<div> at org.eclipse.birt.report.engine.script.internal.ScriptDataSetScriptExecutor.handleFetch(ScriptDataSetScriptExecutor.java:119)</div>
<div> at org.eclipse.birt.data.engine.impl.ScriptDataSetRuntime.fetch(ScriptDataSetRuntime.java:102)</div>
<div> at org.eclipse.birt.data.engine.impl.PreparedScriptDSQuery$ScriptDSQueryExecutor$CustomDataSet.fetch(PreparedScriptDSQuery.java:257)</div>
<div> at org.eclipse.birt.data.engine.executor.cache.OdiAdapter.fetch(OdiAdapter.java:153)</div>
<div> at org.eclipse.birt.data.engine.executor.cache.RowResultSet.next(RowResultSet.java:102)</div>
<div> at org.eclipse.birt.data.engine.executor.cache.ExpandableRowResultSet.next(ExpandableRowResultSet.java:64)</div>
<div> at org.eclipse.birt.data.engine.executor.cache.SmartCacheHelper.populateData(SmartCacheHelper.java:313)</div>
<div> at org.eclipse.birt.data.engine.executor.cache.SmartCacheHelper.initInstance(SmartCacheHelper.java:285)</div>
<div> at org.eclipse.birt.data.engine.executor.cache.SmartCacheHelper.getResultSetCache(SmartCacheHelper.java:246)</div>
<div> at org.eclipse.birt.data.engine.executor.cache.SmartCache.(SmartCache.java:74)</div>
<div> at org.eclipse.birt.data.engine.executor.transform.pass.PassUtil.populateOdiResultSet(PassUtil.java:111)</div>
<div> at org.eclipse.birt.data.engine.executor.transform.pass.PassUtil.pass(PassUtil.java:62)</div>
<div> at org.eclipse.birt.data.engine.executor.transform.pass.PassManager.doSinglePass(PassManager.java:181)</div>
<div> at org.eclipse.birt.data.engine.executor.transform.pass.PassManager.pass(PassManager.java:89)</div>
<div> at org.eclipse.birt.data.engine.executor.transform.pass.PassManager.populateResultSet(PassManager.java:70)</div>
<div> at org.eclipse.birt.data.engine.executor.transform.ResultSetPopulator.populateResultSet(ResultSetPopulator.java:196)</div>
<div> at org.eclipse.birt.data.engine.executor.transform.CachedResultSet.(CachedResultSet.java:156)</div>
<div> at org.eclipse.birt.data.engine.executor.CandidateQuery.execute(CandidateQuery.java:108)</div>
<div> at org.eclipse.birt.data.engine.impl.PreparedScriptDSQuery$ScriptDSQueryExecutor.executeOdiQuery(PreparedScriptDSQuery.java:223)</div>
<div> at org.eclipse.birt.data.engine.impl.QueryExecutor.execute(QueryExecutor.java:945)</div>
<div> at org.eclipse.birt.data.engine.impl.ServiceForQueryResults.executeQuery(ServiceForQueryResults.java:233)</div>
<div> at org.eclipse.birt.data.engine.impl.QueryResults.getResultIterator(QueryResults.java:160)</div>
<div> at org.eclipse.birt.report.engine.data.dte.QueryResultSet.(QueryResultSet.java:92)</div>
<div> at org.eclipse.birt.report.engine.data.dte.DteDataEngine.doExecuteQuery(DteDataEngine.java:129)</div>
<div> at org.eclipse.birt.report.engine.data.dte.DataGenerationEngine.doExecuteQuery(DataGenerationEngine.java:79)</div>
<div> at org.eclipse.birt.report.engine.data.dte.AbstractDataEngine.execute(AbstractDataEngine.java:253)</div>
<div> at org.eclipse.birt.report.engine.executor.ExecutionContext.executeQuery(ExecutionContext.java:1755)</div>
<div> at org.eclipse.birt.report.engine.executor.QueryItemExecutor.executeQuery(QueryItemExecutor.java:77)</div>
<div> at org.eclipse.birt.report.engine.executor.TableItemExecutor.execute(TableItemExecutor.java:62)</div>
<div> at org.eclipse.birt.report.engine.internal.executor.wrap.WrappedReportItemExecutor.execute(WrappedReportItemExecutor.java:45)</div>
<div> at org.eclipse.birt.report.engine.internal.executor.emitter.ReportItemEmitterExecutor.execute(ReportItemEmitterExecutor.java:45)</div>
<div> at org.eclipse.birt.report.engine.internal.executor.dup.SuppressDuplicateItemExecutor.execute(SuppressDuplicateItemExecutor.java:42)</div>
<div> at org.eclipse.birt.report.engine.layout.html.HTMLBlockStackingLM.layoutNodes(HTMLBlockStackingLM.java:63)</div>
<div> at org.eclipse.birt.report.engine.layout.html.HTMLPageLM.layout(HTMLPageLM.java:90)</div>
<div> at org.eclipse.birt.report.engine.layout.html.HTMLReportLayoutEngine.layout(HTMLReportLayoutEngine.java:101)</div>
<div> at org.eclipse.birt.report.engine.presentation.ReportDocumentBuilder.build(ReportDocumentBuilder.java:211)</div>
<div> at org.eclipse.birt.report.engine.api.impl.RunTask.doRun(RunTask.java:237)</div>
<div> at org.eclipse.birt.report.engine.api.impl.RunTask.run(RunTask.java:90)</div>
<div> at org.eclipse.birt.report.service.ReportEngineService.runReport(ReportEngineService.java:1246)</div>
<div> at org.eclipse.birt.report.service.BirtViewerReportService.runReport(BirtViewerReportService.java:155)</div>
<div> at org.eclipse.birt.report.service.actionhandler.BirtRunReportActionHandler.__execute(BirtRunReportActionHandler.java:81)</div>
<div> at org.eclipse.birt.report.service.actionhandler.BirtGetPageActionHandler.__checkDocumentExists(BirtGetPageActionHandler.java:58)</div>
<div> at org.eclipse.birt.report.service.actionhandler.AbstractGetPageActionHandler.prepareParameters(AbstractGetPageActionHandler.java:119)</div>
<div> at org.eclipse.birt.report.service.actionhandler.AbstractGetPageActionHandler.__execute(AbstractGetPageActionHandler.java:104)</div>
<div> at org.eclipse.birt.report.service.actionhandler.AbstractBaseActionHandler.execute(AbstractBaseActionHandler.java:90)</div>
<div> at org.eclipse.birt.report.soapengine.processor.AbstractBaseDocumentProcessor.__executeAction(AbstractBaseDocumentProcessor.java:47)</div>
<div> at org.eclipse.birt.report.soapengine.processor.AbstractBaseComponentProcessor.executeAction(AbstractBaseComponentProcessor.java:143)</div>
<div> at org.eclipse.birt.report.soapengine.processor.BirtDocumentProcessor.handleGetPage(BirtDocumentProcessor.java:87)</div>
<div> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)</div>
<div> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:60)</div>
<div> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37)</div>
<div> at java.lang.reflect.Method.invoke(Method.java:611)</div>
<div> at org.eclipse.birt.report.soapengine.processor.AbstractBaseComponentProcessor.process(AbstractBaseComponentProcessor.java:112)</div>
<div> at org.eclipse.birt.report.soapengine.endpoint.BirtSoapBindingImpl.getUpdatedObjects(BirtSoapBindingImpl.java:66)</div>
<div> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)</div>
<div> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:60)</div>
<div> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37)</div>
<div> at java.lang.reflect.Method.invoke(Method.java:611)</div>
<div> at org.apache.axis.providers.java.RPCProvider.invokeMethod(RPCProvider.java:397)</div>
<div> at org.apache.axis.providers.java.RPCProvider.processMessage(RPCProvider.java:186)</div>
<div> at org.apache.axis.providers.java.JavaProvider.invoke(JavaProvider.java:323)</div>
<div> at org.apache.axis.strategies.InvocationStrategy.visit(InvocationStrategy.java:32)</div>
<div> at org.apache.axis.SimpleChain.doVisiting(SimpleChain.java:118)</div>
<div> at org.apache.axis.SimpleChain.invoke(SimpleChain.java:83)</div>
<div> at org.apache.axis.handlers.soap.SOAPService.invoke(SOAPService.java:453)</div>
<div> at org.apache.axis.server.AxisServer.invoke(AxisServer.java:281)</div>
<div> at org.apache.axis.transport.http.AxisServlet.doPost(AxisServlet.java:699)</div>
<div> at org.eclipse.birt.report.servlet.BirtSoapMessageDispatcherServlet.doPost(BirtSoapMessageDispatcherServlet.java:265)</div>
<div> at javax.servlet.http.HttpServlet.service(HttpServlet.java:738)</div>
<div> at org.apache.axis.transport.http.AxisServletBase.service(AxisServletBase.java:327)</div>
<div> at javax.servlet.http.HttpServlet.service(HttpServlet.java:831)</div>
<div> at org.eclipse.birt.report.servlet.BirtSoapMessageDispatcherServlet.service(BirtSoapMessageDispatcherServlet.java:122)</div>
<div> at org.eclipse.equinox.http.servlet.internal.ServletRegistration.handleRequest(ServletRegistration.java:91)</div>
<div> at org.eclipse.equinox.http.servlet.internal.ProxyServlet.processAlias(ProxyServlet.java:110)</div>
<div> at org.eclipse.equinox.http.servlet.internal.ProxyServlet.service(ProxyServlet.java:60)</div>
<div> at javax.servlet.http.HttpServlet.service(HttpServlet.java:831)</div>
<div> at com.ibm.tivoli.maximo.report.birt.bridge.launcher.BridgeServlet.service(BridgeServlet.java:106)</div>
<div> at javax.servlet.http.HttpServlet.service(HttpServlet.java:831)</div>
<div> at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1657)</div>
<div> at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1597)</div>
<div> at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:104)</div>
<div> at com.ibm.ws.webcontainer.filter.WebAppFilterChain._doFilter(WebAppFilterChain.java:77)</div>
<div> at com.ibm.ws.webcontainer.filter.WebAppFilterManager.doFilter(WebAppFilterManager.java:908)</div>
<div> at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:934)</div>
<div> at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:502)</div>
<div> at com.ibm.ws.webcontainer.servlet.ServletWrapperImpl.handleRequest(ServletWrapperImpl.java:179)</div>
<div> at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.forward(WebAppRequestDispatcher.java:353)</div>
<div> at com.ibm.tivoli.maximo.report.birt.servlet.ReportRequestProcessServlet.processReportRequest(ReportRequestProcessServlet.java:653)</div>
<div> at com.ibm.tivoli.maximo.report.birt.servlet.ReportRequestProcessServlet.doPost(ReportRequestProcessServlet.java:121)</div>
<div> at javax.servlet.http.HttpServlet.service(HttpServlet.java:738)</div>
<div> at javax.servlet.http.HttpServlet.service(HttpServlet.java:831)</div>
<div> at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1657)</div>
<div> at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1597)</div>
<div> at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:104)</div>
<div> at com.ibm.ws.webcontainer.filter.WebAppFilterChain._doFilter(WebAppFilterChain.java:77)</div>
<div> at com.ibm.ws.webcontainer.filter.WebAppFilterManager.doFilter(WebAppFilterManager.java:908)</div>
<div> at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:934)</div>
<div> at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:502)</div>
<div> at com.ibm.ws.webcontainer.servlet.ServletWrapperImpl.handleRequest(ServletWrapperImpl.java:179)</div>
<div> at com.ibm.ws.webcontainer.servlet.CacheServletWrapper.handleRequest(CacheServletWrapper.java:91)</div>
<div> at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:864)</div>
<div> at com.ibm.ws.webcontainer.WSWebContainer.handleRequest(WSWebContainer.java:1583)</div>
<div> at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:186)</div>
<div> at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:445)</div>
<div> at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewRequest(HttpInboundLink.java:504)</div>
<div> at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.processRequest(HttpInboundLink.java:301)</div>
<div> at com.ibm.ws.http.channel.inbound.impl.HttpICLReadCallback.complete(HttpICLReadCallback.java:83)</div>
<div> at com.ibm.ws.tcp.channel.impl.AioReadCompletionListener.futureCompleted(AioReadCompletionListener.java:165)</div>
<div> at com.ibm.io.async.AbstractAsyncFuture.invokeCallback(AbstractAsyncFuture.java:217)</div>
<div> at com.ibm.io.async.AsyncChannelFuture.fireCompletionActions(AsyncChannelFuture.java:161)</div>
<div> at com.ibm.io.async.AsyncFuture.completed(AsyncFuture.java:138)</div>
<div> at com.ibm.io.async.ResultHandler.complete(ResultHandler.java:204)</div>
<div> at com.ibm.io.async.ResultHandler.runEventProcessingLoop(ResultHandler.java:775)</div>
<div> at com.ibm.io.async.ResultHandler$2.run(ResultHandler.java:905)</div>
<div> at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1604)</div>
<div>Caused by: org.eclipse.birt.data.engine.core.DataException: A BIRT exception occurred: There are errors evaluating script "__bm_FETCH()":</div>
<div>Wrapped com.ibm.tivoli.maximo.report.script.MXReportRuntimeException: java.sql.SQLException: Invalid column name (#9).. See next exception for more information.</div>
<div>There are errors evaluating script "__bm_FETCH()":</div>
<div>Wrapped com.ibm.tivoli.maximo.report.script.MXReportRuntimeException: java.sql.SQLException: Invalid column name (#9).</div>
<div> at org.eclipse.birt.data.engine.core.DataException.wrap(DataException.java:118)</div>
<div> at org.eclipse.birt.data.engine.script.ScriptEvalUtil.evaluateJSAsExpr(ScriptEvalUtil.java:717)</div>
<div> at org.eclipse.birt.data.engine.script.JSMethodRunner.runScript(JSMethodRunner.java:76)</div>
<div> at org.eclipse.birt.report.engine.script.internal.DtEScriptExecutor.handleJS(DtEScriptExecutor.java:71)</div>
<div>... 116 more</div>
<div>Caused by: org.eclipse.birt.core.exception.CoreException: There are errors evaluating script "__bm_FETCH()":</div>
<div>Wrapped com.ibm.tivoli.maximo.report.script.MXReportRuntimeException: java.sql.SQLException: Invalid column name (#9).</div>
<div> at org.eclipse.birt.core.script.ScriptContext.eval(ScriptContext.java:307)</div>
<div> at org.eclipse.birt.core.script.ScriptContext.eval(ScriptContext.java:268)</div>
<div> at org.eclipse.birt.data.engine.script.ScriptEvalUtil.evaluateJSAsExpr(ScriptEvalUtil.java:713)</div>
<div>... 118 more</div>
<div>Caused by: org.mozilla.javascript.WrappedException: Wrapped com.ibm.tivoli.maximo.report.script.MXReportRuntimeException: java.sql.SQLException: Invalid column name (#9) <span> </span></div>
<div> at org.mozilla.javascript.Context.throwAsScriptRuntimeEx(Context.java:1757)</div>
<div> at org.mozilla.javascript.MemberBox.invoke(MemberBox.java:170)</div>
<div> at org.mozilla.javascript.NativeJavaMethod.call(NativeJavaMethod.java:243)</div>
<div> at org.mozilla.javascript.optimizer.OptRuntime.call1(OptRuntime.java:66)</div>
<div> at org.mozilla.javascript.gen.c587._c1(:9)</div>
<div> at org.mozilla.javascript.gen.c587.call()</div>
<div> at org.mozilla.javascript.optimizer.OptRuntime.callName0(OptRuntime.java:108)</div>
<div> at org.mozilla.javascript.gen.c588._c0(:1)</div>
<div> at org.mozilla.javascript.gen.c588.call()</div>
<div> at org.mozilla.javascript.ContextFactory.doTopCall(ContextFactory.java:393)</div>
<div> at org.mozilla.javascript.ScriptRuntime.doTopCall(ScriptRuntime.java:2834)</div>
<div> at org.mozilla.javascript.gen.c588.call()</div>
<div> at org.mozilla.javascript.gen.c588.exec()</div>
<div> at org.eclipse.birt.core.script.ScriptContext.eval(ScriptContext.java:302)</div>
<div>... 120 more</div>
<div>Caused by: com.ibm.tivoli.maximo.report.script.MXReportRuntimeException: java.sql.SQLException: Invalid column name</div>
<div> at com.ibm.tivoli.maximo.report.script.MXReportDataSetImpl.getString(MXReportDataSetImpl.java:354)</div>
<div> at sun.reflect.GeneratedMethodAccessor370.invoke(Unknown Source)</div>
<div> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37)</div>
<div> at java.lang.reflect.Method.invoke(Method.java:611)</div>
<div> at org.mozilla.javascript.MemberBox.invoke(MemberBox.java:155)</div>
<div>... 132 more</div>
<div>Caused by: java.sql.SQLException: Invalid column name</div>
<div> at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:70)</div>
<div> at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:131)</div>
<div> at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:197)</div>
<div> at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:261)</div>
<div> at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:269)</div>
<div> at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:490)</div>
<div> at oracle.jdbc.driver.OracleStatement.getColumnIndex(OracleStatement.java:3353)</div>
<div> at oracle.jdbc.driver.OracleResultSetImpl.findColumn(OracleResultSetImpl.java:1883)</div>
<div> at oracle.jdbc.driver.OracleResultSet.getString(OracleResultSet.java)</div>
<div> at com.ibm.tivoli.maximo.report.script.MXReportResultSet.getString(MXReportResultSet.java:231)</div>
<div> at com.ibm.tivoli.maximo.report.script.MXReportDataSetImpl.getString(MXReportDataSetImpl.java:342)</div>
<div>... 136 more</div>
<div>org.eclipse.birt.report.engine.api.EngineException: Unhandled exception when executing script.</div>
<div> at org.eclipse.birt.report.engine.script.internal.ScriptExecutor.addException(ScriptExecutor.java:187)</div>
<div> at org.eclipse.birt.report.engine.script.internal.ScriptExecutor.addException(ScriptExecutor.java:170)</div>
<div> at org.eclipse.birt.report.engine.script.internal.ScriptDataSetScriptExecutor.handleFetch(ScriptDataSetScriptExecutor.java:139)</div>
<div> at org.eclipse.birt.data.engine.impl.ScriptDataSetRuntime.fetch(ScriptDataSetRuntime.java:102)</div>
<div> at org.eclipse.birt.data.engine.impl.PreparedScriptDSQuery$ScriptDSQueryExecutor$CustomDataSet.fetch(PreparedScriptDSQuery.java:257)</div>
<div> at org.eclipse.birt.data.engine.executor.cache.OdiAdapter.fetch(OdiAdapter.java:153)</div>
<div> at org.eclipse.birt.data.engine.executor.cache.RowResultSet.next(RowResultSet.java:102)</div>
<div> at org.eclipse.birt.data.engine.executor.cache.ExpandableRowResultSet.next(ExpandableRowResultSet.java:64)</div>
<div> at org.eclipse.birt.data.engine.executor.cache.SmartCacheHelper.populateData(SmartCacheHelper.java:313)</div>
<div> at org.eclipse.birt.data.engine.executor.cache.SmartCacheHelper.initInstance(SmartCacheHelper.java:285)</div>
<div> at org.eclipse.birt.data.engine.executor.cache.SmartCacheHelper.getResultSetCache(SmartCacheHelper.java:246)</div>
<div> at org.eclipse.birt.data.engine.executor.cache.SmartCache.(SmartCache.java:74)</div>
<div> at org.eclipse.birt.data.engine.executor.transform.pass.PassUtil.populateOdiResultSet(PassUtil.java:111)</div>
<div> at org.eclipse.birt.data.engine.executor.transform.pass.PassUtil.pass(PassUtil.java:62)</div>
<div> at org.eclipse.birt.data.engine.executor.transform.pass.PassManager.doSinglePass(PassManager.java:181)</div>
<div> at org.eclipse.birt.data.engine.executor.transform.pass.PassManager.pass(PassManager.java:89)</div>
<div> at org.eclipse.birt.data.engine.executor.transform.pass.PassManager.populateResultSet(PassManager.java:70)</div>
<div> at org.eclipse.birt.data.engine.executor.transform.ResultSetPopulator.populateResultSet(ResultSetPopulator.java:196)</div>
<div> at org.eclipse.birt.data.engine.executor.transform.CachedResultSet.(CachedResultSet.java:156)</div>
<div> at org.eclipse.birt.data.engine.executor.CandidateQuery.execute(CandidateQuery.java:108)</div>
<div> at org.eclipse.birt.data.engine.impl.PreparedScriptDSQuery$ScriptDSQueryExecutor.executeOdiQuery(PreparedScriptDSQuery.java:223)</div>
<div> at org.eclipse.birt.data.engine.impl.QueryExecutor.execute(QueryExecutor.java:945)</div>
<div> at org.eclipse.birt.data.engine.impl.ServiceForQueryResults.executeQuery(ServiceForQueryResults.java:233)</div>
<div> at org.eclipse.birt.data.engine.impl.QueryResults.getResultIterator(QueryResults.java:160)</div>
<div> at org.eclipse.birt.report.engine.data.dte.QueryResultSet.(QueryResultSet.java:92)</div>
<div> at org.eclipse.birt.report.engine.data.dte.DteDataEngine.doExecuteQuery(DteDataEngine.java:129)</div>
<div> at org.eclipse.birt.report.engine.data.dte.DataGenerationEngine.doExecuteQuery(DataGenerationEngine.java:79)</div>
<div> at org.eclipse.birt.report.engine.data.dte.AbstractDataEngine.execute(AbstractDataEngine.java:253)</div>
<div> at org.eclipse.birt.report.engine.executor.ExecutionContext.executeQuery(ExecutionContext.java:1755)</div>
<div> at org.eclipse.birt.report.engine.executor.QueryItemExecutor.executeQuery(QueryItemExecutor.java:77)</div>
<div> at org.eclipse.birt.report.engine.executor.TableItemExecutor.execute(TableItemExecutor.java:62)</div>
<div> at org.eclipse.birt.report.engine.internal.executor.wrap.WrappedReportItemExecutor.execute(WrappedReportItemExecutor.java:45)</div>
<div> at org.eclipse.birt.report.engine.internal.executor.emitter.ReportItemEmitterExecutor.execute(ReportItemEmitterExecutor.java:45)</div>
<div> at org.eclipse.birt.report.engine.internal.executor.dup.SuppressDuplicateItemExecutor.execute(SuppressDuplicateItemExecutor.java:42)</div>
<div> at org.eclipse.birt.report.engine.layout.html.HTMLBlockStackingLM.layoutNodes(HTMLBlockStackingLM.java:63)</div>
<div> at org.eclipse.birt.report.engine.layout.html.HTMLPageLM.layout(HTMLPageLM.java:90)</div>
<div> at org.eclipse.birt.report.engine.layout.html.HTMLReportLayoutEngine.layout(HTMLReportLayoutEngine.java:101)</div>
<div> at org.eclipse.birt.report.engine.presentation.ReportDocumentBuilder.build(ReportDocumentBuilder.java:211)</div>
<div> at org.eclipse.birt.report.engine.api.impl.RunTask.doRun(RunTask.java:237)</div>
<div> at org.eclipse.birt.report.engine.api.impl.RunTask.run(RunTask.java:90)</div>
<div> at org.eclipse.birt.report.service.ReportEngineService.runReport(ReportEngineService.java:1246)</div>
<div> at org.eclipse.birt.report.service.BirtViewerReportService.runReport(BirtViewerReportService.java:155)</div>
<div> at org.eclipse.birt.report.service.actionhandler.BirtRunReportActionHandler.__execute(BirtRunReportActionHandler.java:81)</div>
<div> at org.eclipse.birt.report.service.actionhandler.BirtGetPageActionHandler.__checkDocumentExists(BirtGetPageActionHandler.java:58)</div>
<div> at org.eclipse.birt.report.service.actionhandler.AbstractGetPageActionHandler.prepareParameters(AbstractGetPageActionHandler.java:119)</div>
<div> at org.eclipse.birt.report.service.actionhandler.AbstractGetPageActionHandler.__execute(AbstractGetPageActionHandler.java:104)</div>
<div> at org.eclipse.birt.report.service.actionhandler.AbstractBaseActionHandler.execute(AbstractBaseActionHandler.java:90)</div>
<div> at org.eclipse.birt.report.soapengine.processor.AbstractBaseDocumentProcessor.__executeAction(AbstractBaseDocumentProcessor.java:47)</div>
<div> at org.eclipse.birt.report.soapengine.processor.AbstractBaseComponentProcessor.executeAction(AbstractBaseComponentProcessor.java:143)</div>
<div> at org.eclipse.birt.report.soapengine.processor.BirtDocumentProcessor.handleGetPage(BirtDocumentProcessor.java:87)</div>
<div> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)</div>
<div> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:60)</div>
<div> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37)</div>
<div> at java.lang.reflect.Method.invoke(Method.java:611)</div>
<div> at org.eclipse.birt.report.soapengine.processor.AbstractBaseComponentProcessor.process(AbstractBaseComponentProcessor.java:112)</div>
<div> at org.eclipse.birt.report.soapengine.endpoint.BirtSoapBindingImpl.getUpdatedObjects(BirtSoapBindingImpl.java:66)</div>
<div> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)</div>
<div> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:60)</div>
<div> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37)</div>
<div> at java.lang.reflect.Method.invoke(Method.java:611)</div>
<div> at org.apache.axis.providers.java.RPCProvider.invokeMethod(RPCProvider.java:397)</div>
<div> at org.apache.axis.providers.java.RPCProvider.processMessage(RPCProvider.java:186)</div>
<div> at org.apache.axis.providers.java.JavaProvider.invoke(JavaProvider.java:323)</div>
<div> at org.apache.axis.strategies.InvocationStrategy.visit(InvocationStrategy.java:32)</div>
<div> at org.apache.axis.SimpleChain.doVisiting(SimpleChain.java:118)</div>
<div> at org.apache.axis.SimpleChain.invoke(SimpleChain.java:83)</div>
<div> at org.apache.axis.handlers.soap.SOAPService.invoke(SOAPService.java:453)</div>
<div> at org.apache.axis.server.AxisServer.invoke(AxisServer.java:281)</div>
<div> at org.apache.axis.transport.http.AxisServlet.doPost(AxisServlet.java:699)</div>
<div> at org.eclipse.birt.report.servlet.BirtSoapMessageDispatcherServlet.doPost(BirtSoapMessageDispatcherServlet.java:265)</div>
<div> at javax.servlet.http.HttpServlet.service(HttpServlet.java:738)</div>
<div> at org.apache.axis.transport.http.AxisServletBase.service(AxisServletBase.java:327)</div>
<div> at javax.servlet.http.HttpServlet.service(HttpServlet.java:831)</div>
<div> at org.eclipse.birt.report.servlet.BirtSoapMessageDispatcherServlet.service(BirtSoapMessageDispatcherServlet.java:122)</div>
<div> at org.eclipse.equinox.http.servlet.internal.ServletRegistration.handleRequest(ServletRegistration.java:91)</div>
<div> at org.eclipse.equinox.http.servlet.internal.ProxyServlet.processAlias(ProxyServlet.java:110)</div>
<div> at org.eclipse.equinox.http.servlet.internal.ProxyServlet.service(ProxyServlet.java:60)</div>
<div> at javax.servlet.http.HttpServlet.service(HttpServlet.java:831)</div>
<div> at com.ibm.tivoli.maximo.report.birt.bridge.launcher.BridgeServlet.service(BridgeServlet.java:106)</div>
<div> at javax.servlet.http.HttpServlet.service(HttpServlet.java:831)</div>
<div> at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1657)</div>
<div> at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1597)</div>
<div> at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:104)</div>
<div> at com.ibm.ws.webcontainer.filter.WebAppFilterChain._doFilter(WebAppFilterChain.java:77)</div>
<div> at com.ibm.ws.webcontainer.filter.WebAppFilterManager.doFilter(WebAppFilterManager.java:908)</div>
<div> at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:934)</div>
<div> at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:502)</div>
<div> at com.ibm.ws.webcontainer.servlet.ServletWrapperImpl.handleRequest(ServletWrapperImpl.java:179)</div>
<div> at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.forward(WebAppRequestDispatcher.java:353)</div>
<div> at com.ibm.tivoli.maximo.report.birt.servlet.ReportRequestProcessServlet.processReportRequest(ReportRequestProcessServlet.java:653)</div>
<div> at com.ibm.tivoli.maximo.report.birt.servlet.ReportRequestProcessServlet.doPost(ReportRequestProcessServlet.java:121)</div>
<div> at javax.servlet.http.HttpServlet.service(HttpServlet.java:738)</div>
<div> at javax.servlet.http.HttpServlet.service(HttpServlet.java:831)</div>
<div> at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1657)</div>
<div> at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1597)</div>
<div> at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:104)</div>
<div> at com.ibm.ws.webcontainer.filter.WebAppFilterChain._doFilter(WebAppFilterChain.java:77)</div>
<div> at com.ibm.ws.webcontainer.filter.WebAppFilterManager.doFilter(WebAppFilterManager.java:908)</div>
<div> at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:934)</div>
<div> at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:502)</div>
<div> at com.ibm.ws.webcontainer.servlet.ServletWrapperImpl.handleRequest(ServletWrapperImpl.java:179)</div>
<div> at com.ibm.ws.webcontainer.servlet.CacheServletWrapper.handleRequest(CacheServletWrapper.java:91)</div>
<div> at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:864)</div>
<div> at com.ibm.ws.webcontainer.WSWebContainer.handleRequest(WSWebContainer.java:1583)</div>
<div> at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:186)</div>
<div> at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:445)</div>
<div> at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewRequest(HttpInboundLink.java:504)</div>
<div> at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.processRequest(HttpInboundLink.java:301)</div>
<div> at com.ibm.ws.http.channel.inbound.impl.HttpICLReadCallback.complete(HttpICLReadCallback.java:83)</div>
<div> at com.ibm.ws.tcp.channel.impl.AioReadCompletionListener.futureCompleted(AioReadCompletionListener.java:165)</div>
<div> at com.ibm.io.async.AbstractAsyncFuture.invokeCallback(AbstractAsyncFuture.java:217)</div>
<div> at com.ibm.io.async.AsyncChannelFuture.fireCompletionActions(AsyncChannelFuture.java:161)</div>
<div> at com.ibm.io.async.AsyncFuture.completed(AsyncFuture.java:138)</div>
<div> at com.ibm.io.async.ResultHandler.complete(ResultHandler.java:204)</div>
<div> at com.ibm.io.async.ResultHandler.runEventProcessingLoop(ResultHandler.java:775)</div>
<div> at com.ibm.io.async.ResultHandler$2.run(ResultHandler.java:905)</div>
<div> at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1604)</div>
<div>Caused by: org.eclipse.birt.data.engine.core.DataException: data.engine.BadFetchScriptReturnType</div>
<div> at org.eclipse.birt.report.engine.script.internal.ScriptDataSetScriptExecutor.handleFetch(ScriptDataSetScriptExecutor.java:129)</div>
<div>... 114 more</div>
<div> </div>
<div> </div>
<div> <span> </span> <span> </span> <span> </span> <span> </span></div>
<div> </div>
<div> </div>