nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Report Return Empty

adriansit

<div>Report Return Empty</div>
<div>Hello, I am a beginner, and I have designed the report attached. The report was thinked to be used on workorder tracking (cal) module. </div>
<div> </div>
<div>Can anybody help me?</div>
<div>Why the report return empty when I run in Maximo?</div>

Find more posts tagged with

Comments

wwilliams

Does this run in your designer?

adriansit

<blockquote class="ipsBlockquote" data-author="wwilliams" data-cid="131739" data-time="1414670236">
<div>
Does this run in your designer?
</div>
</blockquote>
NO. Present the next error:
 
 
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(); sqlText = "SELECT WORKORDER.WONUM, WORKORDER.STATUS," + " WORKORDER.STATUSDATE, WORKORDER.WORKTYPE, " + " WORKORDER.DESCRIPTION AS wodesc, WORKORDER.LOCATION, " + " WORKORDER.JPNUM, WORKORDER.TARGCOMPDATE, " + " WORKORDER.REPORTEDBY, " + " WORKORDER.REPORTDATE, WORKORDER.ASSETNUM, " + " LOCATIONS.DESCRIPTION AS lodesc," + " ASSET.DESCRIPTION AS assdesc," + " JOBPLAN.DESCRIPTION AS jpdesc, PLUSCWODS.DSPLANNUM, " + " PLUSDSPLAN.DESCRIPTION AS dsdesc, ASSET.PARENT, " + " WORKORDER.ESTDUR" + " FROM WORKORDER, JOBPLAN, LOCATIONS, " + " ASSET, PLUSCWODS, PLUSDSPLAN" + " WHERE WORKORDER.WONUM = PLUSCWODS.WONUM" + " AND WORKORDER.JPNUM = JOBPLAN.JPNUM" + " AND WORKORDER.LOCATION = LOCATIONS.LOCATION" + " AND WORKORDER.ASSETNUM = ASSET.ASSETNUM" + " AND PLUSCWODS.DSPLANNUM = PLUSDSPLAN.DSPLANNUM" + " and " + params["where"] maximoDataSet.setQuery(sqlText); ": {1}.
 
 
Stack Trace:
org.eclipse.birt.report.engine.api.EngineException: There are errors evaluating script "maximoDataSet = MXReportDataSetProvider.create(this.getDataSource().getName(), this.getName());
<div>maximoDataSet.open(); 
var sqlText = new String(); 
sqlText = "SELECT WORKORDER.WONUM, WORKORDER.STATUS," 
+ " WORKORDER.STATUSDATE, WORKORDER.WORKTYPE, " 
+ " WORKORDER.DESCRIPTION AS wodesc, WORKORDER.LOCATION, " 
+ " WORKORDER.JPNUM, WORKORDER.TARGCOMPDATE, " 
+ " WORKORDER.REPORTEDBY, " 
+ " WORKORDER.REPORTDATE, WORKORDER.ASSETNUM, " 
+ " LOCATIONS.DESCRIPTION AS lodesc," 
+ " ASSET.DESCRIPTION AS assdesc," 
+ " JOBPLAN.DESCRIPTION AS jpdesc, PLUSCWODS.DSPLANNUM, " 
+ " PLUSDSPLAN.DESCRIPTION AS dsdesc, ASSET.PARENT, " 
+ " WORKORDER.ESTDUR" 
+ " FROM WORKORDER, JOBPLAN, LOCATIONS, " 
+ " ASSET, PLUSCWODS, PLUSDSPLAN" 
+ " WHERE WORKORDER.WONUM = PLUSCWODS.WONUM" 
+ " AND WORKORDER.JPNUM = JOBPLAN.JPNUM" 
+ " AND WORKORDER.LOCATION = LOCATIONS.LOCATION" 
+ " AND WORKORDER.ASSETNUM = ASSET.ASSETNUM" 
+ " AND PLUSCWODS.DSPLANNUM = PLUSDSPLAN.DSPLANNUM" 
+ " and " + params["where"] 
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(Unknown Source) 
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) 
at java.lang.reflect.Method.invoke(Unknown Source) 
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(Unknown Source) 
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) 
at java.lang.reflect.Method.invoke(Unknown Source) 
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:616) 
at org.apache.axis.transport.http.AxisServletBase.service(AxisServletBase.java:327) 
at javax.servlet.http.HttpServlet.service(HttpServlet.java:689) 
at org.eclipse.birt.report.servlet.BirtSoapMessageDispatcherServlet.service(BirtSoapMessageDispatcherServlet.java:122) 
at org.eclipse.equinox.http.registry.internal.ServletManager$ServletWrapper.service(ServletManager.java:180) 
at org.eclipse.equinox.http.servlet.internal.ServletRegistration.handleRequest(ServletRegistration.java:90) 
at org.eclipse.equinox.http.servlet.internal.ProxyServlet.processAlias(ProxyServlet.java:111) 
at org.eclipse.equinox.http.servlet.internal.ProxyServlet.service(ProxyServlet.java:59) 
at javax.servlet.http.HttpServlet.service(HttpServlet.java:689) 
at org.eclipse.equinox.http.jetty.internal.HttpServerManager$InternalHttpServiceServlet.service(HttpServerManager.java:269) 
at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:428) 
at org.mortbay.jetty.servlet.ServletHandler.dispatch(ServletHandler.java:677) 
at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:568) 
at org.mortbay.http.HttpContext.handle(HttpContext.java:1530) 
at org.mortbay.http.HttpContext.handle(HttpContext.java:1482) 
at org.mortbay.http.HttpServer.service(HttpServer.java:909) 
at org.mortbay.http.HttpConnection.service(HttpConnection.java:820) 
at org.mortbay.http.HttpConnection.handleNext(HttpConnection.java:986) 
at org.mortbay.http.HttpConnection.handle(HttpConnection.java:837) 
at org.mortbay.http.SocketListener.handleConnection(SocketListener.java:245) 
at org.mortbay.util.ThreadedServer.handle(ThreadedServer.java:357) 
at org.mortbay.util.ThreadPool$PoolThread.run(ThreadPool.java:534) 
Caused by: org.eclipse.birt.data.engine.core.DataException: A BIRT exception occurred: There are errors evaluating script "__bm_OPEN()": 
Wrapped com.ibm.tivoli.maximo.report.script.MXReportRuntimeException: java.lang.NullPointerException (#3).. See next exception for more information. 
There are errors evaluating script "__bm_OPEN()": 
Wrapped com.ibm.tivoli.maximo.report.script.MXReportRuntimeException: java.lang.NullPointerException (#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) 
... 76 more 
Caused by: org.eclipse.birt.core.exception.CoreException: There are errors evaluating script "__bm_OPEN()": 
Wrapped com.ibm.tivoli.maximo.report.script.MXReportRuntimeException: java.lang.NullPointerException (#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) 
... 78 more 
Caused by: org.mozilla.javascript.WrappedException: Wrapped com.ibm.tivoli.maximo.report.script.MXReportRuntimeException: java.lang.NullPointerException (#3) 
at org.mozilla.javascript.Context.throwAsScriptRuntimeEx(Context.java:1757) 
at org.mozilla.javascript.MemberBox.invoke(MemberBox.java:170) 
at org.mozilla.javascript.NativeJavaMethod.call(NativeJavaMethod.java:243) 
at org.mozilla.javascript.optimizer.OptRuntime.callProp0(OptRuntime.java:119) 
at org.mozilla.javascript.gen.c8._c1(:3) 
at org.mozilla.javascript.gen.c8.call() 
at org.mozilla.javascript.optimizer.OptRuntime.callName0(OptRuntime.java:108) 
at org.mozilla.javascript.gen.c9._c0(:1) 
at org.mozilla.javascript.gen.c9.call() 
at org.mozilla.javascript.ContextFactory.doTopCall(ContextFactory.java:393) 
at org.mozilla.javascript.ScriptRuntime.doTopCall(ScriptRuntime.java:2834) 
at org.mozilla.javascript.gen.c9.call() 
at org.mozilla.javascript.gen.c9.exec() 
at org.eclipse.birt.core.script.ScriptContext.eval(ScriptContext.java:302) 
... 80 more 
Caused by: com.ibm.tivoli.maximo.report.script.MXReportRuntimeException: java.lang.NullPointerException 
at com.ibm.tivoli.maximo.report.script.MXReportDataSetImpl.open(MXReportDataSetImpl.java:138) 
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) 
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) 
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) 
at java.lang.reflect.Method.invoke(Unknown Source) 
at org.mozilla.javascript.MemberBox.invoke(MemberBox.java:155) 
... 92 more 
Caused by: java.lang.NullPointerException 
at java.lang.Class.forName0(Native Method) 
at java.lang.Class.forName(Unknown Source) 
at com.ibm.tivoli.maximo.report.script.MXReportDataSourceImpl.getDesigntimeConnection(MXReportDataSourceImpl.java:229) 
at com.ibm.tivoli.maximo.report.script.MXReportDataSourceImpl.getConnection(MXReportDataSourceImpl.java:144) 
at com.ibm.tivoli.maximo.report.script.MXReportDataSetImpl.open(MXReportDataSetImpl.java:127) 
... 97 more</div>

wwilliams

I didn't think so,
You need to make sure you leave spaces
this will
+"PLUSCWODS.WONUM" 
+"FROM PLUSCWODS JOIN PLUSDSPLAN
 
equate to PLUSCWODS.WONUMFROM PLUSCWODS JOIN PLUSDSPLAN
 
What is WONUMFROM? Your SQL statement will fail.
<pre class="_prettyXprint">
sqlText ="SELECT PLUSCWODS.DSPLANNUM, PLUSDSPLAN.DESCRIPTION,"
+"PLUSCDSPOINT.POINT, PLUSCDSPOINT.POINTDESCRIPTION,"
+"PLUSCDSPOINT.TOL1LOWER, PLUSCDSPOINT.TOL1UPPER,"
+"PLUSCWODS.WONUM"
+"FROM PLUSCWODS JOIN PLUSDSPLAN ON PLUSCWODS.DSPLANNUM = PLUSDSPLAN.DSPLANNUM JOIN PLUSCDSPOINT ON PLUSCWODS.DSPLANNUM = PLUSCDSPOINT.DSPLANNUM"
+ " where pluscwods.wonum = " + rows[0]["wonum"]
+ " order by pluscwods.wonum ";

</pre>

adriansit

<blockquote class="ipsBlockquote" data-author="wwilliams" data-cid="131745" data-time="1414685229">
<div>
 
I didn't think so,
You need to make sure you leave spaces
this will
+"PLUSCWODS.WONUM" 
+"FROM PLUSCWODS JOIN PLUSDSPLAN
 
equate to PLUSCWODS.WONUMFROM PLUSCWODS JOIN PLUSDSPLAN
 
What is WONUMFROM? Your SQL statement will fail.
<pre class="_prettyXprint">
sqlText ="SELECT PLUSCWODS.DSPLANNUM, PLUSDSPLAN.DESCRIPTION,"
+"PLUSCDSPOINT.POINT, PLUSCDSPOINT.POINTDESCRIPTION,"
+"PLUSCDSPOINT.TOL1LOWER, PLUSCDSPOINT.TOL1UPPER,"
+"PLUSCWODS.WONUM"
+"FROM PLUSCWODS JOIN PLUSDSPLAN ON PLUSCWODS.DSPLANNUM = PLUSDSPLAN.DSPLANNUM JOIN PLUSCDSPOINT ON PLUSCWODS.DSPLANNUM = PLUSCDSPOINT.DSPLANNUM"
+ " where pluscwods.wonum = " + rows[0]["wonum"]
+ " order by pluscwods.wonum ";

</pre>
</div>
</blockquote>
<div>My reports never run in my designer if has a scripted database. </div>
<div> </div>
<div>I have made some adjust to the report (as you said and others) and now run well. </div>
<div> </div>
<div>How I can set up the pages number to show by group?</div>
<div> </div>
<div>Thanks </div>