<pre class="_prettyXprint _lang-sql">
org.eclipse.birt.report.engine.api.EngineException: There are errors evaluating script "maximoDataSet = MXReportDataSetProvider.create(this.getDataSource().getName(), this.getName()); maximoDataSet.open(); var sqlText = new String(); // Add query to sqlText variable. sqlText = " SELECT DISTINCT proj.projectnum,Proj.Description, Proj.Changedate,Proj.Budgetamount,Proj.Actualamount,Proj.Committedamount,Proj.Availableamount,"+ " Proj.Status,Proj.Ownerdept AS costcenter,Proj.Glaccount,Proj.Projectowner,pro.projectnum as project,pro.amount,pro.enteredby,PRO.ENTEREDDATE,"+ " pro.description as prodescription,pol.ponum,m.mrnum,M.DESCRIPTION as mdescription,M.TOTALCOST AS MRCOST,M.MRDATE,M.MRTYPE, M.BUYER_CODE as buyer,M.STATUS AS MRSTATUS,pr.prnum,"+ " PR.TOTALCOST AS PRCOST,pr.description as prdescription,PR.STATUS AS PRSTATUS,PR.ISSUEDATE,P.Ponum,p.description as pdescription,P.Status,p.potype,P.VENDOR,P.POTYPE,P.TOTALCOST AS POCOST,P.ORDERDATE,"+ " V.Actreceiptamt AS POACTUALAMOUNT,P.TOTALCOST-V.Actreceiptamt AS POCOMMITTEDAMOUNT,I.Ponum,I.Invoicenum,i.vendorinvoicenum,i.invoicedate,i.description as idescription,i.status as istatus,i.documenttype as itype,"+ " i.ponum as iponum,i.totalcost as icost FROM poline pol,"+ " FULL OUTER JOIN Projectbudg proj ON proj.projectnum=pol.projectnum "+ " FULL OUTER JOIN(SELECT ponum,status,TOTALCOST,ORDERDATE,POTYPE,VENDOR,description FROM po WHERE status NOT IN ('WAPPR','CAN','REVISD') ) p ON pol.ponum=p.ponum "+ " FULL OUTER JOIN(SELECT invoicenum,ponum,vendorinvoicenum,invoicedate,description,status,documenttype,totalcost FROM invoice) i ON i.ponum=p.ponum "+ " FULL OUTER JOIN(SELECT projectnum,PROJCHARGESID,amount,enteredby,description,ENTEREDDATE FROM Projcharges) pro ON Pro.Projectnum=proj.projectnum "+ " FULL OUTER JOIN(SELECT mrnum,PROJECTNUM, TOTALCOST,MRDATE,BUYER_CODE,MRTYPE,DESCRIPTION,STATUS FROM mr) m ON m.mrnum=pol.mrnum "+ " FULL OUTER JOIN(SELECT mrnum,prnum FROM mrline ) mrl ON mrl.mrnum=m.mrnum "+ " FULL OUTER JOIN(SELECT prnum FROM prline ) prl ON prl.prnum=mrl.prnum "+ " FULL OUTER JOIN(SELECT prnum,TOTALCOST,STATUS,ISSUEDATE,description FROM pr) pr ON pr.prnum=prl.prnum "+ " FULL OUTER JOIN(SELECT PONUM,Actreceiptamt FROM POVIEW) V ON V.PONUM=P.PONUM "+ + " where " + params["ProjectNo"] ; //sqlText = sqlText.replace("****", params["ProjectNo"].value.join("','")); mysqlText=sqlTextt; maximoDataSet.setQuery(sqlText); ": {1}.
Hide Exception Stack Trace
Stack Trace:
org.eclipse.birt.report.engine.api.EngineException: There are errors evaluating script "maximoDataSet = MXReportDataSetProvider.create(this.getDataSource().getName(), this.getName());
maximoDataSet.open();
var sqlText = new String();
// Add query to sqlText variable.
sqlText = " SELECT DISTINCT proj.projectnum,Proj.Description, Proj.Changedate,Proj.Budgetamount,Proj.Actualamount,Proj.Committedamount,Proj.Availableamount,"+
" Proj.Status,Proj.Ownerdept AS costcenter,Proj.Glaccount,Proj.Projectowner,pro.projectnum as project,pro.amount,pro.enteredby,PRO.ENTEREDDATE,"+
" pro.description as prodescription,pol.ponum,m.mrnum,M.DESCRIPTION as mdescription,M.TOTALCOST AS MRCOST,M.MRDATE,M.MRTYPE, M.BUYER_CODE as buyer,M.STATUS AS MRSTATUS,pr.prnum,"+
" PR.TOTALCOST AS PRCOST,pr.description as prdescription,PR.STATUS AS PRSTATUS,PR.ISSUEDATE,P.Ponum,p.description as pdescription,P.Status,p.potype,P.VENDOR,P.POTYPE,P.TOTALCOST AS POCOST,P.ORDERDATE,"+
" V.Actreceiptamt AS POACTUALAMOUNT,P.TOTALCOST-V.Actreceiptamt AS POCOMMITTEDAMOUNT,I.Ponum,I.Invoicenum,i.vendorinvoicenum,i.invoicedate,i.description as idescription,i.status as istatus,i.documenttype as itype,"+
" i.ponum as iponum,i.totalcost as icost FROM poline pol,"+
" FULL OUTER JOIN Projectbudg proj ON proj.projectnum=pol.projectnum "+
" FULL OUTER JOIN(SELECT ponum,status,TOTALCOST,ORDERDATE,POTYPE,VENDOR,description FROM po WHERE status NOT IN ('WAPPR','CAN','REVISD') ) p ON pol.ponum=p.ponum "+
" FULL OUTER JOIN(SELECT invoicenum,ponum,vendorinvoicenum,invoicedate,description,status,documenttype,totalcost FROM invoice) i ON i.ponum=p.ponum "+
" FULL OUTER JOIN(SELECT projectnum,PROJCHARGESID,amount,enteredby,description,ENTEREDDATE FROM Projcharges) pro ON Pro.Projectnum=proj.projectnum "+
" FULL OUTER JOIN(SELECT mrnum,PROJECTNUM, TOTALCOST,MRDATE,BUYER_CODE,MRTYPE,DESCRIPTION,STATUS FROM mr) m ON m.mrnum=pol.mrnum "+
" FULL OUTER JOIN(SELECT mrnum,prnum FROM mrline ) mrl ON mrl.mrnum=m.mrnum "+
" FULL OUTER JOIN(SELECT prnum FROM prline ) prl ON prl.prnum=mrl.prnum "+
" FULL OUTER JOIN(SELECT prnum,TOTALCOST,STATUS,ISSUEDATE,description FROM pr) pr ON pr.prnum=prl.prnum "+
" FULL OUTER JOIN(SELECT PONUM,Actreceiptamt FROM POVIEW) V ON V.PONUM=P.PONUM "+
+ " where " + params["ProjectNo"]
;
//sqlText = sqlText.replace("****", params["ProjectNo"].value.join("','"));
mysqlText=sqlTextt;
maximoDataSet.setQuery(sqlText);
":
{1}.
at org.eclipse.birt.report.engine.script.internal.DtEScriptExecutor.handleJS(DtEScriptExecutor.java:77)
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.(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:60)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37)
at java.lang.reflect.Method.invoke(Method.java:611)
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:60)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37)
at java.lang.reflect.Method.invoke(Method.java:611)
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:453)
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:738)
at org.apache.axis.transport.http.AxisServletBase.service(AxisServletBase.java:327)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:831)
at org.eclipse.birt.report.servlet.BirtSoapMessageDispatcherServlet.service(BirtSoapMessageDispatcherServlet.java:122)
at org.eclipse.equinox.http.servlet.internal.ServletRegistration.handleRequest(ServletRegistration.java:91)
at org.eclipse.equinox.http.servlet.internal.ProxyServlet.processAlias(ProxyServlet.java:110)
at org.eclipse.equinox.http.servlet.internal.ProxyServlet.service(ProxyServlet.java:60)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:831)
at com.ibm.tivoli.maximo.report.birt.bridge.launcher.BridgeServlet.service(BridgeServlet.java:106)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:831)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1657)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1597)
at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:104)
at com.ibm.ws.webcontainer.filter.WebAppFilterChain._doFilter(WebAppFilterChain.java:77)
at com.ibm.ws.webcontainer.filter.WebAppFilterManager.doFilter(WebAppFilterManager.java:908)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:934)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:502)
at com.ibm.ws.webcontainer.servlet.ServletWrapperImpl.handleRequest(ServletWrapperImpl.java:179)
at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.forward(WebAppRequestDispatcher.java:353)
at com.ibm.tivoli.maximo.report.birt.servlet.ReportRequestProcessServlet.processReportRequest(ReportRequestProcessServlet.java:653)
at com.ibm.tivoli.maximo.report.birt.servlet.ReportRequestProcessServlet.doPost(ReportRequestProcessServlet.java:121)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:738)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:831)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1657)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1597)
at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:104)
at com.ibm.ws.webcontainer.filter.WebAppFilterChain._doFilter(WebAppFilterChain.java:77)
at com.ibm.ws.webcontainer.filter.WebAppFilterManager.doFilter(WebAppFilterManager.java:908)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:934)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:502)
at com.ibm.ws.webcontainer.servlet.ServletWrapperImpl.handleRequest(ServletWrapperImpl.java:179)
at com.ibm.ws.webcontainer.servlet.CacheServletWrapper.handleRequest(CacheServletWrapper.java:91)
at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:864)
at com.ibm.ws.webcontainer.WSWebContainer.handleRequest(WSWebContainer.java:1583)
at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:186)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:445)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewRequest(HttpInboundLink.java:504)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.processRequest(HttpInboundLink.java:301)
at com.ibm.ws.http.channel.inbound.impl.HttpICLReadCallback.complete(HttpICLReadCallback.java:83)
at com.ibm.ws.tcp.channel.impl.AioReadCompletionListener.futureCompleted(AioReadCompletionListener.java:165)
at com.ibm.io.async.AbstractAsyncFuture.invokeCallback(AbstractAsyncFuture.java:217)
at com.ibm.io.async.AsyncChannelFuture.fireCompletionActions(AsyncChannelFuture.java:161)
at com.ibm.io.async.AsyncFuture.completed(AsyncFuture.java:138)
at com.ibm.io.async.ResultHandler.complete(ResultHandler.java:204)
at com.ibm.io.async.ResultHandler.runEventProcessingLoop(ResultHandler.java:775)
at com.ibm.io.async.ResultHandler$2.run(ResultHandler.java:905)
at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1604)
Caused by: org.eclipse.birt.data.engine.core.DataException: A BIRT exception occurred: There are errors evaluating script "__bm_OPEN()":
ReferenceError: "sqlTextt" is not defined. (#29).. See next exception for more information.
There are errors evaluating script "__bm_OPEN()":
ReferenceError: "sqlTextt" is not defined. (#29).
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)
... 101 more
Caused by: org.eclipse.birt.core.exception.CoreException: There are errors evaluating script "__bm_OPEN()":
ReferenceError: "sqlTextt" is not defined. (#29).
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)
... 103 more
Caused by: org.mozilla.javascript.EcmaError: ReferenceError: "sqlTextt" is not defined. (#29)
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.c184._c1(:29)
at org.mozilla.javascript.gen.c184.call()
at org.mozilla.javascript.optimizer.OptRuntime.callName0(OptRuntime.java:108)
at org.mozilla.javascript.gen.c185._c0(:1)
at org.mozilla.javascript.gen.c185.call()
at org.mozilla.javascript.ContextFactory.doTopCall(ContextFactory.java:393)
at org.mozilla.javascript.ScriptRuntime.doTopCall(ScriptRuntime.java:2834)
at org.mozilla.javascript.gen.c185.call()
at org.mozilla.javascript.gen.c185.exec()
at org.eclipse.birt.core.script.ScriptContext.eval(ScriptContext.java:302)
... 105 more
Page
</pre>
<p>in maximo birt report I could see only header and footer</p>
<p> </p>
<p>data is not displaying in report.</p>
<p> </p>
<p>please check the attached file.</p>
<p> </p>
<p> </p>
<p>and it shows the error like</p>
<p> </p>
<p> </p>
