Maximo Open Forum

Back to discussions
Expand all | Collapse all

BIRT 4.8 Error

  • 1.  BIRT 4.8 Error

    Posted 12-11-2023 09:25

    Good morning, fellow Maximo power-users!

    I hope you are all having an amaiong day! I'm currently facing an issue while working with BIRT 4.8 for Maximo, and I'm reaching out to the community for some assistance.

    In my report script, I'm trying to populate output columns and receiving the following error (I can provide the full output if required, this is just a snippet):

    

    BIRT Error
    

    // Add a line for each output column
// The specific get method should match the data type of the output column.
row["textfield"] = maximoDataSet.getString("textfield");
row["datefield"] = maximoDataSet.getTimestamp("datefield");

    However, I'm encountering an error, and I'm unsure how to resolve it. If anyone has experienced a similar issue or has insights into potential solutions, your assistance would be immensely valuable.

    The error message I'm receiving is not something I have much familiarity with, and I want to make sure I'm handling output columns correctly. Your expertise and guidance on this matter would be greatly appreciated!

    Thank you in advance for your time and assistance. Looking forward to discussing with you.

    I can provide any additional details as needed to help clarify my issue. 

    Thank you very much,

    Phil


    #Analytics
    #Reporting

    ------------------------------
    Philip Marrone
    Boston Children's Hospital
    ------------------------------


  • 2.  RE: BIRT 4.8 Error

    Posted 12-11-2023 11:42

    Hi,

    There doesn't seem to be an attached error. It usually gives you some kind of information on why the report failed.

    All I see is a generic script.



    ------------------------------
    Bob Kraus
    Missouri S&T
    ------------------------------

    Original Message


  • 3.  RE: BIRT 4.8 Error

    Posted 12-11-2023 11:47

    Thank you for your response, the stack trace error says: 
    "org.eclipse.birt.report.engine.api.EngineException: There are errors evaluating script "if (!maximoDataSet.fetch())
    return (false);

    // Add a line for each output column
    // The specific get method should match the data type of the output column.
    row["textfield"] = maximoDataSet.getString("textfield");
    row["datefield"] = maximoDataSet.getTimestamp("datefield");

    return (true);":
    Fail to execute script in function __bm_FETCH(). Source:
    ------
    " + if (!maximoDataSet.fetch())
    return (false);

    // Add a line for each output column
    // The specific get method should match the data type of the output column.
    row["textfield"] = maximoDataSet.getString("textfield");
    row["datefield"] = maximoDataSet.getTimestamp("datefield");

    return (true); + "
    -----
    A BIRT exception occurred. See next exception for more information.
    Wrapped com.ibm.db2.jcc.am.SqlSyntaxErrorException: DB2 SQL Error: SQLCODE=-104, SQLSTATE=42601, SQLERRMC=AS;SELECT w.WONUM ;AND, DRIVER=4.26.14 (/report/data-sets/script-data-set[@id="5"]/method[@name="fetch"]#1).
       at org.eclipse.birt.report.engine.script.internal.DtEScriptExecutor.handleJS(DtEScriptExecutor.java:99)
       at org.eclipse.birt.report.engine.script.internal.DataSetScriptExecutor.handleJS(DataSetScriptExecutor.java:256)
       at org.eclipse.birt.report.engine.script.internal.ScriptDataSetScriptExecutor.handleFetch(ScriptDataSetScriptExecutor.java:143)
       at org.eclipse.birt.data.engine.impl.ScriptDataSetRuntime.fetch(ScriptDataSetRuntime.java:103)
       at org.eclipse.birt.data.engine.impl.PreparedScriptDSQuery$ScriptDSQueryExecutor$CustomDataSet.fetch(PreparedScriptDSQuery.java:260)
       at org.eclipse.birt.data.engine.executor.cache.OdiAdapter.fetch(OdiAdapter.java:226)
       at org.eclipse.birt.data.engine.executor.cache.RowResultSet.fetch(RowResultSet.java:145)
       at org.eclipse.birt.data.engine.executor.cache.RowResultSet.doNext(RowResultSet.java:118)
       at org.eclipse.birt.data.engine.executor.cache.RowResultSet.next(RowResultSet.java:96)
       at org.eclipse.birt.data.engine.executor.cache.ExpandableRowResultSet.next(ExpandableRowResultSet.java:63)
       at org.eclipse.birt.data.engine.executor.cache.SmartCacheHelper.populateData(SmartCacheHelper.java:318)
       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)</init>
    <init>   at org.eclipse.birt.data.engine.executor.transform.pass.PassUtil.populateOdiResultSet(PassUtil.java:110)</init>
    <init>   at org.eclipse.birt.data.engine.executor.transform.pass.PassUtil.pass(PassUtil.java:62)</init>
    <init>   at org.eclipse.birt.data.engine.executor.transform.pass.PassManager.doSinglePass(PassManager.java:170)</init>
    <init>   at org.eclipse.birt.data.engine.executor.transform.pass.PassManager.prepareDataSetResultSet(PassManager.java:94)</init>
    <init>   at org.eclipse.birt.data.engine.executor.transform.pass.PassManager.pass(PassManager.java:134)</init>
    <init>   at org.eclipse.birt.data.engine.executor.transform.pass.PassManager.populateResultSet(PassManager.java:74)</init>
    <init>   at org.eclipse.birt.data.engine.executor.transform.ResultSetPopulator.populateResultSet(ResultSetPopulator.java:218)</init>
    <init>   at org.eclipse.birt.data.engine.executor.transform.CachedResultSet.(CachedResultSet.java:200)</init>
    <init>   at org.eclipse.birt.data.engine.executor.CandidateQuery.execute(CandidateQuery.java:142)</init>
    <init>   at org.eclipse.birt.data.engine.impl.PreparedScriptDSQuery$ScriptDSQueryExecutor.executeOdiQuery(PreparedScriptDSQuery.java:226)</init>
    <init>   at org.eclipse.birt.data.engine.impl.QueryExecutor.execute(QueryExecutor.java:1257)</init>
    <init>   at org.eclipse.birt.data.engine.impl.ServiceForQueryResults.executeQuery(ServiceForQueryResults.java:233)</init>
    <init>   at org.eclipse.birt.data.engine.impl.QueryResults.getResultIterator(QueryResults.java:178)</init>
    <init>   at org.eclipse.birt.report.engine.data.dte.QueryResultSet.(QueryResultSet.java:98)</init>
    <init>   at org.eclipse.birt.report.engine.data.dte.DteDataEngine.doExecuteQuery(DteDataEngine.java:168)</init>
    <init>   at org.eclipse.birt.report.engine.data.dte.DataGenerationEngine.doExecuteQuery(DataGenerationEngine.java:83)</init>
    <init>   at org.eclipse.birt.report.engine.data.dte.AbstractDataEngine.execute(AbstractDataEngine.java:286)</init>
    <init>   at org.eclipse.birt.report.engine.executor.ExecutionContext.executeQuery(ExecutionContext.java:1954)</init>
    <init>   at org.eclipse.birt.report.engine.executor.QueryItemExecutor.executeQuery(QueryItemExecutor.java:80)</init>
    <init>   at org.eclipse.birt.report.engine.executor.TableItemExecutor.execute(TableItemExecutor.java:62)</init>
    <init>   at org.eclipse.birt.report.engine.internal.executor.wrap.WrappedReportItemExecutor.execute(WrappedReportItemExecutor.java:46)</init>
    <init>   at org.eclipse.birt.report.engine.internal.executor.emitter.ReportItemEmitterExecutor.execute(ReportItemEmitterExecutor.java:46)</init>
    <init>   at org.eclipse.birt.report.engine.internal.executor.dup.SuppressDuplicateItemExecutor.execute(SuppressDuplicateItemExecutor.java:43)</init>
    <init>   at org.eclipse.birt.report.engine.layout.html.HTMLBlockStackingLM.layoutNodes(HTMLBlockStackingLM.java:65)</init>
    <init>   at org.eclipse.birt.report.engine.layout.html.HTMLPageLM.layout(HTMLPageLM.java:92)</init>
    <init>   at org.eclipse.birt.report.engine.layout.html.HTMLReportLayoutEngine.layout(HTMLReportLayoutEngine.java:100)</init>
    <init>   at org.eclipse.birt.report.engine.presentation.ReportDocumentBuilder.build(ReportDocumentBuilder.java:258)</init>
    <init>   at org.eclipse.birt.report.engine.api.impl.RunTask.doRun(RunTask.java:273)</init>
    <init>   at org.eclipse.birt.report.engine.api.impl.RunTask.run(RunTask.java:89)</init>
    <init>   at org.eclipse.birt.report.service.ReportEngineService.runReport(ReportEngineService.java:1325)</init>
    <init>   at org.eclipse.birt.report.service.BirtViewerReportService.runReport(BirtViewerReportService.java:159)</init>
    <init>   at org.eclipse.birt.report.service.actionhandler.BirtRunReportActionHandler.__execute(BirtRunReportActionHandler.java:81)</init>
    <init>   at org.eclipse.birt.report.service.actionhandler.BirtChangeParameterActionHandler.runReport(BirtChangeParameterActionHandler.java:58)</init>
    <init>   at org.eclipse.birt.report.service.actionhandler.AbstractChangeParameterActionHandler.__execute(AbstractChangeParameterActionHandler.java:52)</init>
    <init>   at org.eclipse.birt.report.service.actionhandler.AbstractBaseActionHandler.execute(AbstractBaseActionHandler.java:90)</init>
    <init>   at org.eclipse.birt.report.soapengine.processor.AbstractBaseDocumentProcessor.__executeAction(AbstractBaseDocumentProcessor.java:47)</init>
    <init>   at org.eclipse.birt.report.soapengine.processor.AbstractBaseComponentProcessor.executeAction(AbstractBaseComponentProcessor.java:143)</init>
    <init>   at org.eclipse.birt.report.soapengine.processor.BirtDocumentProcessor.handleChangeParameter(BirtDocumentProcessor.java:100)</init>
    <init>   at java.base/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(DirectMethodHandleAccessor.java:104)</init>
    <init>   at java.base/java.lang.reflect.Method.invoke(Method.java:578)</init>
    <init>   at org.eclipse.birt.report.soapengine.processor.AbstractBaseComponentProcessor.process(AbstractBaseComponentProcessor.java:112)</init>
    <init>   at org.eclipse.birt.report.soapengine.endpoint.BirtSoapBindingImpl.getUpdatedObjects(BirtSoapBindingImpl.java:66)</init>
    <init>   at java.base/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(DirectMethodHandleAccessor.java:104)</init>
    <init>   at java.base/java.lang.reflect.Method.invoke(Method.java:578)</init>
    <init>   at org.apache.axis.providers.java.RPCProvider.invokeMethod(RPCProvider.java:397)</init>
    <init>   at org.apache.axis.providers.java.RPCProvider.processMessage(RPCProvider.java:186)</init>
    <init>   at org.apache.axis.providers.java.JavaProvider.invoke(JavaProvider.java:323)</init>
    <init>   at org.apache.axis.strategies.InvocationStrategy.visit(InvocationStrategy.java:32)</init>
    <init>   at org.apache.axis.SimpleChain.doVisiting(SimpleChain.java:118)</init>
    <init>   at org.apache.axis.SimpleChain.invoke(SimpleChain.java:83)</init>
    <init>   at org.apache.axis.handlers.soap.SOAPService.invoke(SOAPService.java:454)</init>
    <init>   at org.apache.axis.server.AxisServer.invoke(AxisServer.java:281)</init>
    <init>   at org.apache.axis.transport.http.AxisServlet.doPost(AxisServlet.java:699)</init>
    <init>   at org.eclipse.birt.report.servlet.BirtSoapMessageDispatcherServlet.doPost(BirtSoapMessageDispatcherServlet.java:265)</init>
    <init>   at javax.servlet.http.HttpServlet.service(HttpServlet.java:707)</init>
    <init>   at org.apache.axis.transport.http.AxisServletBase.service(AxisServletBase.java:327)</init>
    <init>   at javax.servlet.http.HttpServlet.service(HttpServlet.java:790)</init>
    <init>   at org.eclipse.birt.report.servlet.BirtSoapMessageDispatcherServlet.service(BirtSoapMessageDispatcherServlet.java:122)</init>
    <init>   at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:865)</init>
    <init>   at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1655)</init>
    <init>   at org.eclipse.birt.report.filter.ViewerFilter.doFilter(ViewerFilter.java:68)</init>
    <init>   at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1634)</init>
    <init>   at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:533)</init>
    <init>   at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:146)</init>
    <init>   at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:548)</init>
    <init>   at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:132)</init>
    <init>   at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:257)</init>
    <init>   at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:1595)</init>
    <init>   at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:255)</init>
    <init>   at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1253)</init>
    <init>   at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:203)</init>
    <init>   at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:473)</init>
    <init>   at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:1564)</init>
    <init>   at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:201)</init>
    <init>   at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1155)</init>
    <init>   at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:144)</init>
    <init>   at org.eclipse.jetty.server.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:219)</init>
    <init>   at org.eclipse.jetty.server.handler.HandlerCollection.handle(HandlerCollection.java:126)</init>
    <init>   at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:132)</init>
    <init>   at org.eclipse.jetty.server.Server.handle(Server.java:531)</init>
    <init>   at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:352)</init>
    <init>   at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:260)</init>
    <init>   at org.eclipse.jetty.io.AbstractConnection$ReadCallback.succeeded(AbstractConnection.java:281)</init>
    <init>   at org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:102)</init>
    <init>   at org.eclipse.jetty.io.ChannelEndPoint$2.run(ChannelEndPoint.java:118)</init>
    <init>   at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.runTask(EatWhatYouKill.java:333)</init>
    <init>   at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.doProduce(EatWhatYouKill.java:310)</init>
    <init>   at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.tryProduce(EatWhatYouKill.java:168)</init>
    <init>   at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.run(EatWhatYouKill.java:126)</init>
    <init>   at org.eclipse.jetty.util.thread.ReservedThreadExecutor$ReservedThread.run(ReservedThreadExecutor.java:366)</init>
    <init>   at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:760)</init>
    <init>   at org.eclipse.jetty.util.thread.QueuedThreadPool$2.run(QueuedThreadPool.java:678)</init>
    <init>   at java.base/java.lang.Thread.run(Thread.java:1623)</init>
    <init>Caused by: org.eclipse.birt.data.engine.core.DataException: Fail to execute script in function __bm_FETCH(). Source:</init>
    <init>------</init>
    <init>" + if (!maximoDataSet.fetch())</init>
    <init>return (false);</init>

    <init>// Add a line for each output column</init>
    <init>// The specific get method should match the data type of the output column.</init>
    <init>row["textfield"] = maximoDataSet.getString("textfield"); </init>
    <init>row["datefield"] = maximoDataSet.getTimestamp("datefield"); </init>

    <init>return (true); + "</init>
    <init>-----</init>
    <init>A BIRT exception occurred. See next exception for more information.</init>
    <init>Wrapped com.ibm.db2.jcc.am.SqlSyntaxErrorException: DB2 SQL Error: SQLCODE=-104, SQLSTATE=42601, SQLERRMC=AS;SELECT w.WONUM ;AND, DRIVER=4.26.14 (/report/data-sets/script-data-set[@id="5"]/method[@name="fetch"]#1)</init>
    <init>   at org.eclipse.birt.data.engine.script.JSMethodRunner.runScript(JSMethodRunner.java:147)</init>
    <init>   at org.eclipse.birt.report.engine.script.internal.DtEScriptExecutor.handleJS(DtEScriptExecutor.java:90)</init>
    <init>... 106 more</init>
    <init>Caused by: org.eclipse.birt.data.engine.core.DataException: A BIRT exception occurred. See next exception for more information.</init>
    <init>Wrapped com.ibm.db2.jcc.am.SqlSyntaxErrorException: DB2 SQL Error: SQLCODE=-104, SQLSTATE=42601, SQLERRMC=AS;SELECT w.WONUM ;AND, DRIVER=4.26.14 (/report/data-sets/script-data-set[@id="5"]/method[@name="fetch"]#1)</init>
    <init>   at org.eclipse.birt.data.engine.core.DataException.wrap(DataException.java:123)</init>
    <init>   at org.eclipse.birt.data.engine.script.ScriptEvalUtil.evaluateJSAsExpr(ScriptEvalUtil.java:1003)</init>
    <init>   at org.eclipse.birt.data.engine.script.JSMethodRunner.runScript(JSMethodRunner.java:138)</init>
    <init>... 107 more</init>
    <init>Caused by: org.eclipse.birt.core.exception.CoreException: Wrapped com.ibm.db2.jcc.am.SqlSyntaxErrorException: DB2 SQL Error: SQLCODE=-104, SQLSTATE=42601, SQLERRMC=AS;SELECT w.WONUM ;AND, DRIVER=4.26.14 (/report/data-sets/script-data-set[@id="5"]/method[@name="fetch"]#1)</init>
    <init>   at org.eclipse.birt.core.script.JavascriptEvalUtil.wrapRhinoException(JavascriptEvalUtil.java:307)</init>
    <init>   at org.eclipse.birt.core.script.JavascriptEvalUtil.evaluateRawScript(JavascriptEvalUtil.java:106)</init>
    <init>   at org.eclipse.birt.core.script.JavascriptEvalUtil.evaluateScript(JavascriptEvalUtil.java:138)</init>
    <init>   at org.eclipse.birt.data.engine.script.ScriptEvalUtil.evaluateJSAsExpr(ScriptEvalUtil.java:999)</init>
    <init>... 108 more</init>
    <init>Caused by: org.mozilla.javascript.WrappedException: Wrapped com.ibm.db2.jcc.am.SqlSyntaxErrorException: DB2 SQL Error: SQLCODE=-104, SQLSTATE=42601, SQLERRMC=AS;SELECT w.WONUM ;AND, DRIVER=4.26.14 (/report/data-sets/script-data-set[@id="5"]/method[@name="fetch"]#1)</init>
    <init>   at org.mozilla.javascript.Context.throwAsScriptRuntimeEx(Context.java:1754)</init>
    <init>   at org.mozilla.javascript.MemberBox.invoke(MemberBox.java:148)</init>
    <init>   at org.mozilla.javascript.NativeJavaMethod.call(NativeJavaMethod.java:225)</init>
    <init>   at org.mozilla.javascript.optimizer.OptRuntime.callProp0(OptRuntime.java:85)</init>
    <init>   at org.mozilla.javascript.gen._report_data_sets_script_data_set__id__5___method__name__fetch___16._c___bm_FETCH_1(/report/data-sets/script-data-set[@id="5"]/method[@name="fetch"]:1)</init>
    <init>   at org.mozilla.javascript.gen._report_data_sets_script_data_set__id__5___method__name__fetch___16.call(/report/data-sets/script-data-set[@id="5"]/method[@name="fetch"])</init>
    <init>   at org.mozilla.javascript.optimizer.OptRuntime.callName0(OptRuntime.java:74)</init>
    <init>   at org.mozilla.javascript.gen._report_data_sets_script_data_set__id__5___method__name__fetch___17._c_script_0(/report/data-sets/script-data-set[@id="5"]/method[@name="fetch"]:0)</init>
    <init>   at org.mozilla.javascript.gen._report_data_sets_script_data_set__id__5___method__name__fetch___17.call(/report/data-sets/script-data-set[@id="5"]/method[@name="fetch"])</init>
    <init>   at org.mozilla.javascript.ContextFactory.doTopCall(ContextFactory.java:394)</init>
    <init>   at org.mozilla.javascript.ScriptRuntime.doTopCall(ScriptRuntime.java:3091)</init>
    <init>   at org.mozilla.javascript.gen._report_data_sets_script_data_set__id__5___method__name__fetch___17.call(/report/data-sets/script-data-set[@id="5"]/method[@name="fetch"])</init>
    <init>   at org.mozilla.javascript.gen._report_data_sets_script_data_set__id__5___method__name__fetch___17.exec(/report/data-sets/script-data-set[@id="5"]/method[@name="fetch"])</init>
    <init>   at org.eclipse.birt.core.script.JavascriptEvalUtil.evaluateRawScript(JavascriptEvalUtil.java:99)</init>
    <init>... 110 more</init>
    <init>Caused by: com.ibm.db2.jcc.am.SqlSyntaxErrorException: DB2 SQL Error: SQLCODE=-104, SQLSTATE=42601, SQLERRMC=AS;SELECT w.WONUM ;AND, DRIVER=4.26.14</init>
    <init>   at com.ibm.db2.jcc.am.b7.a(b7.java:810)</init>
    <init>   at com.ibm.db2.jcc.am.b7.a(b7.java:66)</init>
    <init>   at com.ibm.db2.jcc.am.b7.a(b7.java:140)</init>
    <init>   at com.ibm.db2.jcc.am.k4.c(k4.java:2824)</init>
    <init>   at com.ibm.db2.jcc.am.k4.d(k4.java:2808)</init>
    <init>   at com.ibm.db2.jcc.am.k4.a(k4.java:2234)</init>
    <init>   at com.ibm.db2.jcc.am.k5.a(k5.java:8242)</init>
    <init>   at com.ibm.db2.jcc.t4.ab.i(ab.java:206)</init>
    <init>   at com.ibm.db2.jcc.t4.ab.b(ab.java:96)</init>
    <init>   at com.ibm.db2.jcc.t4.p.a(p.java:32)</init>
    <init>   at com.ibm.db2.jcc.t4.av.i(av.java:150)</init>
    <init>   at com.ibm.db2.jcc.am.k4.al(k4.java:2203)</init>
    <init>   at com.ibm.db2.jcc.am.k5.bq(k5.java:3730)</init>
    <init>   at com.ibm.db2.jcc.am.k5.a(k5.java:4609)</init>
    <init>   at com.ibm.db2.jcc.am.k5.b(k5.java:4182)</init>
    <init>   at com.ibm.db2.jcc.am.k5.bd(k5.java:780)</init>
    <init>   at com.ibm.db2.jcc.am.k5.executeQuery(k5.java:745)</init>
    <init>   at com.ibm.tivoli.maximo.report.script.MXReportDataSetImpl.fetch(MXReportDataSetImpl.java:329)</init>
    <init>   at java.base/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(DirectMethodHandleAccessor.java:104)</init>
    <init>   at java.base/java.lang.reflect.Method.invoke(Method.java:578)</init>
    <init>   at org.mozilla.javascript.MemberBox.invoke(MemberBox.java:126)</init>
    <init>... 122 more</init>

    org.eclipse.birt.report.engine.api.EngineException: Data Set script method "Fetch" returned null; expected a Boolean value.
       at org.eclipse.birt.report.engine.script.internal.ScriptExecutor.addException(ScriptExecutor.java:249)
       at org.eclipse.birt.report.engine.script.internal.ScriptExecutor.addException(ScriptExecutor.java:238)
       at org.eclipse.birt.report.engine.script.internal.ScriptDataSetScriptExecutor.handleFetch(ScriptDataSetScriptExecutor.java:165)
       at org.eclipse.birt.data.engine.impl.ScriptDataSetRuntime.fetch(ScriptDataSetRuntime.java:103)
       at org.eclipse.birt.data.engine.impl.PreparedScriptDSQuery$ScriptDSQueryExecutor$CustomDataSet.fetch(PreparedScriptDSQuery.java:260)
       at org.eclipse.birt.data.engine.executor.cache.OdiAdapter.fetch(OdiAdapter.java:226)
       at org.eclipse.birt.data.engine.executor.cache.RowResultSet.fetch(RowResultSet.java:145)
       at org.eclipse.birt.data.engine.executor.cache.RowResultSet.doNext(RowResultSet.java:118)
       at org.eclipse.birt.data.engine.executor.cache.RowResultSet.next(RowResultSet.java:96)
       at org.eclipse.birt.data.engine.executor.cache.ExpandableRowResultSet.next(ExpandableRowResultSet.java:63)
       at org.eclipse.birt.data.engine.executor.cache.SmartCacheHelper.populateData(SmartCacheHelper.java:318)
       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)</init>
    <init>   at org.eclipse.birt.data.engine.executor.transform.pass.PassUtil.populateOdiResultSet(PassUtil.java:110)</init>
    <init>   at org.eclipse.birt.data.engine.executor.transform.pass.PassUtil.pass(PassUtil.java:62)</init>
    <init>   at org.eclipse.birt.data.engine.executor.transform.pass.PassManager.doSinglePass(PassManager.java:170)</init>
    <init>   at org.eclipse.birt.data.engine.executor.transform.pass.PassManager.prepareDataSetResultSet(PassManager.java:94)</init>
    <init>   at org.eclipse.birt.data.engine.executor.transform.pass.PassManager.pass(PassManager.java:134)</init>
    <init>   at org.eclipse.birt.data.engine.executor.transform.pass.PassManager.populateResultSet(PassManager.java:74)</init>
    <init>   at org.eclipse.birt.data.engine.executor.transform.ResultSetPopulator.populateResultSet(ResultSetPopulator.java:218)</init>
    <init>   at org.eclipse.birt.data.engine.executor.transform.CachedResultSet.(CachedResultSet.java:200)</init>
    <init>   at org.eclipse.birt.data.engine.executor.CandidateQuery.execute(CandidateQuery.java:142)</init>
    <init>   at org.eclipse.birt.data.engine.impl.PreparedScriptDSQuery$ScriptDSQueryExecutor.executeOdiQuery(PreparedScriptDSQuery.java:226)</init>
    <init>   at org.eclipse.birt.data.engine.impl.QueryExecutor.execute(QueryExecutor.java:1257)</init>
    <init>   at org.eclipse.birt.data.engine.impl.ServiceForQueryResults.executeQuery(ServiceForQueryResults.java:233)</init>
    <init>   at org.eclipse.birt.data.engine.impl.QueryResults.getResultIterator(QueryResults.java:178)</init>
    <init>   at org.eclipse.birt.report.engine.data.dte.QueryResultSet.(QueryResultSet.java:98)</init>
    <init>   at org.eclipse.birt.report.engine.data.dte.DteDataEngine.doExecuteQuery(DteDataEngine.java:168)</init>
    <init>   at org.eclipse.birt.report.engine.data.dte.DataGenerationEngine.doExecuteQuery(DataGenerationEngine.java:83)</init>
    <init>   at org.eclipse.birt.report.engine.data.dte.AbstractDataEngine.execute(AbstractDataEngine.java:286)</init>
    <init>   at org.eclipse.birt.report.engine.executor.ExecutionContext.executeQuery(ExecutionContext.java:1954)</init>
    <init>   at org.eclipse.birt.report.engine.executor.QueryItemExecutor.executeQuery(QueryItemExecutor.java:80)</init>
    <init>   at org.eclipse.birt.report.engine.executor.TableItemExecutor.execute(TableItemExecutor.java:62)</init>
    <init>   at org.eclipse.birt.report.engine.internal.executor.wrap.WrappedReportItemExecutor.execute(WrappedReportItemExecutor.java:46)</init>
    <init>   at org.eclipse.birt.report.engine.internal.executor.emitter.ReportItemEmitterExecutor.execute(ReportItemEmitterExecutor.java:46)</init>
    <init>   at org.eclipse.birt.report.engine.internal.executor.dup.SuppressDuplicateItemExecutor.execute(SuppressDuplicateItemExecutor.java:43)</init>
    <init>   at org.eclipse.birt.report.engine.layout.html.HTMLBlockStackingLM.layoutNodes(HTMLBlockStackingLM.java:65)</init>
    <init>   at org.eclipse.birt.report.engine.layout.html.HTMLPageLM.layout(HTMLPageLM.java:92)</init>
    <init>   at org.eclipse.birt.report.engine.layout.html.HTMLReportLayoutEngine.layout(HTMLReportLayoutEngine.java:100)</init>
    <init>   at org.eclipse.birt.report.engine.presentation.ReportDocumentBuilder.build(ReportDocumentBuilder.java:258)</init>
    <init>   at org.eclipse.birt.report.engine.api.impl.RunTask.doRun(RunTask.java:273)</init>
    <init>   at org.eclipse.birt.report.engine.api.impl.RunTask.run(RunTask.java:89)</init>
    <init>   at org.eclipse.birt.report.service.ReportEngineService.runReport(ReportEngineService.java:1325)</init>
    <init>   at org.eclipse.birt.report.service.BirtViewerReportService.runReport(BirtViewerReportService.java:159)</init>
    <init>   at org.eclipse.birt.report.service.actionhandler.BirtRunReportActionHandler.__execute(BirtRunReportActionHandler.java:81)</init>
    <init>   at org.eclipse.birt.report.service.actionhandler.BirtChangeParameterActionHandler.runReport(BirtChangeParameterActionHandler.java:58)</init>
    <init>   at org.eclipse.birt.report.service.actionhandler.AbstractChangeParameterActionHandler.__execute(AbstractChangeParameterActionHandler.java:52)</init>
    <init>   at org.eclipse.birt.report.service.actionhandler.AbstractBaseActionHandler.execute(AbstractBaseActionHandler.java:90)</init>
    <init>   at org.eclipse.birt.report.soapengine.processor.AbstractBaseDocumentProcessor.__executeAction(AbstractBaseDocumentProcessor.java:47)</init>
    <init>   at org.eclipse.birt.report.soapengine.processor.AbstractBaseComponentProcessor.executeAction(AbstractBaseComponentProcessor.java:143)</init>
    <init>   at org.eclipse.birt.report.soapengine.processor.BirtDocumentProcessor.handleChangeParameter(BirtDocumentProcessor.java:100)</init>
    <init>   at java.base/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(DirectMethodHandleAccessor.java:104)</init>
    <init>   at java.base/java.lang.reflect.Method.invoke(Method.java:578)</init>
    <init>   at org.eclipse.birt.report.soapengine.processor.AbstractBaseComponentProcessor.process(AbstractBaseComponentProcessor.java:112)</init>
    <init>   at org.eclipse.birt.report.soapengine.endpoint.BirtSoapBindingImpl.getUpdatedObjects(BirtSoapBindingImpl.java:66)</init>
    <init>   at java.base/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(DirectMethodHandleAccessor.java:104)</init>
    <init>   at java.base/java.lang.reflect.Method.invoke(Method.java:578)</init>
    <init>   at org.apache.axis.providers.java.RPCProvider.invokeMethod(RPCProvider.java:397)</init>
    <init>   at org.apache.axis.providers.java.RPCProvider.processMessage(RPCProvider.java:186)</init>
    <init>   at org.apache.axis.providers.java.JavaProvider.invoke(JavaProvider.java:323)</init>
    <init>   at org.apache.axis.strategies.InvocationStrategy.visit(InvocationStrategy.java:32)</init>
    <init>   at org.apache.axis.SimpleChain.doVisiting(SimpleChain.java:118)</init>
    <init>   at org.apache.axis.SimpleChain.invoke(SimpleChain.java:83)</init>
    <init>   at org.apache.axis.handlers.soap.SOAPService.invoke(SOAPService.java:454)</init>
    <init>   at org.apache.axis.server.AxisServer.invoke(AxisServer.java:281)</init>
    <init>   at org.apache.axis.transport.http.AxisServlet.doPost(AxisServlet.java:699)</init>
    <init>   at org.eclipse.birt.report.servlet.BirtSoapMessageDispatcherServlet.doPost(BirtSoapMessageDispatcherServlet.java:265)</init>
    <init>   at javax.servlet.http.HttpServlet.service(HttpServlet.java:707)</init>
    <init>   at org.apache.axis.transport.http.AxisServletBase.service(AxisServletBase.java:327)</init>
    <init>   at javax.servlet.http.HttpServlet.service(HttpServlet.java:790)</init>
    <init>   at org.eclipse.birt.report.servlet.BirtSoapMessageDispatcherServlet.service(BirtSoapMessageDispatcherServlet.java:122)</init>
    <init>   at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:865)</init>
    <init>   at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1655)</init>
    <init>   at org.eclipse.birt.report.filter.ViewerFilter.doFilter(ViewerFilter.java:68)</init>
    <init>   at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1634)</init>
    <init>   at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:533)</init>
    <init>   at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:146)</init>
    <init>   at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:548)</init>
    <init>   at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:132)</init>
    <init>   at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:257)</init>
    <init>   at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:1595)</init>
    <init>   at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:255)</init>
    <init>   at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1253)</init>
    <init>   at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:203)</init>
    <init>   at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:473)</init>
    <init>   at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:1564)</init>
    <init>   at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:201)</init>
    <init>   at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1155)</init>
    <init>   at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:144)</init>
    <init>   at org.eclipse.jetty.server.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:219)</init>
    <init>   at org.eclipse.jetty.server.handler.HandlerCollection.handle(HandlerCollection.java:126)</init>
    <init>   at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:132)</init>
    <init>   at org.eclipse.jetty.server.Server.handle(Server.java:531)</init>
    <init>   at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:352)</init>
    <init>   at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:260)</init>
    <init>   at org.eclipse.jetty.io.AbstractConnection$ReadCallback.succeeded(AbstractConnection.java:281)</init>
    <init>   at org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:102)</init>
    <init>   at org.eclipse.jetty.io.ChannelEndPoint$2.run(ChannelEndPoint.java:118)</init>
    <init>   at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.runTask(EatWhatYouKill.java:333)</init>
    <init>   at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.doProduce(EatWhatYouKill.java:310)</init>
    <init>   at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.tryProduce(EatWhatYouKill.java:168)</init>
    <init>   at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.run(EatWhatYouKill.java:126)</init>
    <init>   at org.eclipse.jetty.util.thread.ReservedThreadExecutor$ReservedThread.run(ReservedThreadExecutor.java:366)</init>
    <init>   at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:760)</init>
    <init>   at org.eclipse.jetty.util.thread.QueuedThreadPool$2.run(QueuedThreadPool.java:678)</init>
    <init>   at java.base/java.lang.Thread.run(Thread.java:1623)</init>
    <init>Caused by: org.eclipse.birt.data.engine.core.DataException: Data Set script method "Fetch" returned null; expected a Boolean value.</init>
    <init>   at org.eclipse.birt.report.engine.script.internal.ScriptDataSetScriptExecutor.handleFetch(ScriptDataSetScriptExecutor.java:153)</init>
    <init><init><init>... 104 more</init></init></init>    "


    ------------------------------
    Philip Marrone
    Boston Children's Hospital
    ------------------------------

    Original Message


  • 4.  RE: BIRT 4.8 Error

    Posted 12-11-2023 12:01

    I would suggest making sure that your data fields, sql select statement  and fetch script all match.

     To me it looks like you haven't set up your fetch script yet.



    ------------------------------
    Bob Kraus
    Missouri S&T
    ------------------------------

    Original Message


  • 5.  RE: BIRT 4.8 Error

    Posted 12-11-2023 12:40

    Thank you Bob for the feedback. I have the following script written (see below), and this is my first report that I have attempted from scratch so I appreciate any advice you may offer. 

    maximoDataSet = MXReportDataSetProvider.create(this.getDataSource().getName(), this.getName());
    maximoDataSet.open();
     
    var shopwhere = "1=1";
    if (params["shop"].value) {
      shopwhere += " AND " + MXReportSqlFormat.createParamWhereClause("shop.BCH_PARshop", params["shop"]);
    }
     
    var datewhere = "1=1";
    datewhere += " AND week(w.TARGSTARTDATE) = (week(sysdate) - 1) AND year(w.SCHEDSTART) = year(sysdate)";
    if (params["startdate"].value) {
      datewhere += " AND w.TARGSTARTDATE >= " + MXReportSqlFormat.getStartDayTimestampFunction(params["startdate"]);
    }
    if (params["enddate"].value) {
      datewhere += " AND w.TARGSTARTDATE <= " + MXReportSqlFormat.getEndDayTimestampFunction(params["enddate"]);
    }
     
    var sqlText = "SELECT "
      + "w.WONUM AS 'Work Order', "
      + "PM.FREQUENCY AS 'Frequency', "
      + "PM.FREQUNIT AS 'Interval', "
      + "w.LOCATION AS 'ROOM', "
      + "TO_CHAR(w.SCHEDSTART, 'MM/DD/YY') AS 'Scheduled Start', "
      + "TO_CHAR(w.REPORTDATE, 'MM/DD/YY') AS 'Reported Date', "
      + "UPPER(w.DESCRIPTION) AS 'Description', "
      + "shop.BCH_PARshop AS 'Parent shop', "
      + "w.PERSONGROUP AS 'Shop', "
      + "w.ASSETNUM AS 'Equipment', "
      + "w.Status AS 'Status', "
      + "w.LEAD AS 'Assigned To', "
      + "pm.BCH_PMREG AS 'Compliance', "
      + "w.PMNUM AS 'PM', "
      + "shop.BCH_GRPLDR AS 'Group Leader', "
      + "shop.BCH_shopSUP AS 'Supervisor' "
      + "FROM WORKORDER AS w "
      + "LEFT JOIN MAXIMO.PM AS PM ON w.PMNUM = PM.PMNUM "
      + "LEFT JOIN Maximo.PERSONGROUP AS shop ON PM.PERSONGROUP = shop.PERSONGROUP "
      + "LEFT JOIN Maximo.WOSTATUS AS status ON w.WONUM = status.WONUM "
      + "WHERE PM.FREQUNIT = 'WEEKS' "
      + "AND w.status NOT IN ('COMP-TECH', 'COMP-SUPV','CLOSE','COMP','COMP-REVIEWED', 'CAN') "
      + "AND PM.BCH_PMREG = 'TJC' "
      + "AND w.TARGSTARTDATE BETWEEN DATE('2023-12-03') AND DATE('2023-12-09') "
      + "AND " + shopwhere + " "
      + "AND " + datewhere;
     
    maximoDataSet.setQuery(sqlText);

    What does the fetch script contain and where do I find it in the designer? (sorry) Please advise, thank you so much for your help so far.



    ------------------------------
    Philip Marrone
    Boston Children's Hospital
    ------------------------------

    Original Message


  • 6.  RE: BIRT 4.8 Error

    Posted 12-11-2023 13:42

    Select the Dataset on the left, then from the drop-down, select the fetch script.
    Then, make sure that the data fields from the Dataset are the same in the fetch script.



    ------------------------------
    Bob Kraus
    Missouri S&T
    ------------------------------

    Original Message


  • 7.  RE: BIRT 4.8 Error

    Posted 12-11-2023 15:44

    Thank you Bob, I am working on this now and will update the thread with my progess. You have been very helpful, I greatly appreciate your efforts on my behalf.



    ------------------------------
    Philip Marrone
    Boston Children's Hospital
    ------------------------------

    Original Message


  • 8.  RE: BIRT 4.8 Error

    Posted 12-11-2023 16:13

    Hi Bob,

    I weorked on the fetch script and received the following error, I am unsure how to proceed: 

    "

    org.eclipse.birt.report.engine.api.EngineException: There are errors evaluating script "maximoDataSet = MXReportDataSetProvider.create(this.getDataSource().getName(), this.getName());
    maximoDataSet.open();

    var shopwhere = "1=1";
    if (params["shop"].value) {
    shopwhere += " AND " + MXReportSqlFormat.createParamWhereClause("shop.BCH_PARshop", params["shop"]);
    }

    var datewhere = "1=1";
    datewhere += " AND week(w.TARGSTARTDATE) = (week(sysdate) - 1) AND year(w.SCHEDSTART) = year(sysdate)";
    if (params["startdate"].value) {
    datewhere += " AND w.TARGSTARTDATE >= " + MXReportSqlFormat.getStartDayTimestampFunction(params["startdate"]);
    }
    if (params["enddate"].value) {
    datewhere += " AND w.TARGSTARTDATE <= " + MXReportSqlFormat.getEndDayTimestampFunction(params["enddate"]);
    }

    var sqlText = "SELECT "
    + "w.WONUM, "
    + "PM.FREQUENCY, "
    + "PM.FREQUNIT, "
    + "TO_CHAR(w.SCHEDSTART, 'MM/DD/YY'), "
    + "TO_CHAR(w.REPORTDATE, 'MM/DD/YY')', "
    + "UPPER(w.DESCRIPTION), "
    + "shop.BCH_PARshop', "
    + "w.PERSONGROUP, "
    + "w.ASSETNUM
    + "w.LEAD', "
    + "pm.BCH_PMREG, "
    + "w.PMNUM, "
    + "shop.BCH_GRPLDR', "
    + "shop.BCH_shopSUP' "
    + "FROM WORKORDER AS w "
    + "LEFT JOIN MAXIMO.PM AS PM ON w.PMNUM = PM.PMNUM "
    + "LEFT JOIN Maximo.PERSONGROUP AS shop ON PM.PERSONGROUP = shop.PERSONGROUP "
    + "LEFT JOIN Maximo.WOSTATUS AS status ON w.WONUM = status.WONUM "
    + "WHERE PM.FREQUNIT = 'WEEKS' "
    + "AND w.status NOT IN ('COMP-TECH', 'COMP-SUPV','CLOSE','COMP','COMP-REVIEWED', 'CAN') "
    + "AND PM.BCH_PMREG = 'TJC' "
    + "AND w.TARGSTARTDATE BETWEEN DATE('2023-12-03') AND DATE('2023-12-09') "
    + "AND " + shopwhere + " "
    + "AND " + datewhere;

    maximoDataSet.setQuery(sqlText);":
    Fail to execute script in function __bm_OPEN(). Source:
    ------
    " + maximoDataSet = MXReportDataSetProvider.create(this.getDataSource().getName(), this.getName());
    maximoDataSet.open();

    var shopwhere = "1=1";
    if (params["shop"].value) {
    shopwhere += " AND " + MXReportSqlFormat.createParamWhereClause("shop.BCH_PARshop", params["shop"]);
    }

    var datewhere = "1=1";
    datewhere += " AND week(w.TARGSTARTDATE) = (week(sysdate) - 1) AND year(w.SCHEDSTART) = year(sysdate)";
    if (params["startdate"].value) {
    datewhere += " AND w.TARGSTARTDATE >= " + MXReportSqlFormat.getStartDayTimestampFunction(params["startdate"]);
    }
    if (params["enddate"].value) {
    datewhere += " AND w.TARGSTARTDATE <= " + MXReportSqlFormat.getEndDayTimestampFunction(params["enddate"]);
    }

    var sqlText = "SELECT "
    + "w.WONUM, "
    + "PM.FREQUENCY, "
    + "PM.FREQUNIT, "
    + "TO_CHAR(w.SCHEDSTART, 'MM/DD/YY'), "
    + "TO_CHAR(w.REPORTDATE, 'MM/DD/YY')', "
    + "UPPER(w.DESCRIPTION), "
    + "shop.BCH_PARshop', "
    + "w.PERSONGROUP, "
    + "w.ASSETNUM
    + "w.LEAD', "
    + "pm.BCH_PMREG, "
    + "w.PMNUM, "
    + "shop.BCH_GRPLDR', "
    + "shop.BCH_shopSUP' "
    + "FROM WORKORDER AS w "
    + "LEFT JOIN MAXIMO.PM AS PM ON w.PMNUM = PM.PMNUM "
    + "LEFT JOIN Maximo.PERSONGROUP AS shop ON PM.PERSONGROUP = shop.PERSONGROUP "
    + "LEFT JOIN Maximo.WOSTATUS AS status ON w.WONUM = status.WONUM "
    + "WHERE PM.FREQUNIT = 'WEEKS' "
    + "AND w.status NOT IN ('COMP-TECH', 'COMP-SUPV','CLOSE','COMP','COMP-REVIEWED', 'CAN') "
    + "AND PM.BCH_PMREG = 'TJC' "
    + "AND w.TARGSTARTDATE BETWEEN DATE('2023-12-03') AND DATE('2023-12-09') "
    + "AND " + shopwhere + " "
    + "AND " + datewhere;

    maximoDataSet.setQuery(sqlText); + "
    -----
    A BIRT exception occurred. See next exception for more information.
    unterminated string literal (/report/data-sets/script-data-set[@id="5"]/method[@name="open"]#27).
       at org.eclipse.birt.report.engine.script.internal.DtEScriptExecutor.handleJS(DtEScriptExecutor.java:99)
       at org.eclipse.birt.report.engine.script.internal.DataSetScriptExecutor.handleJS(DataSetScriptExecutor.java:256)
       at org.eclipse.birt.report.engine.script.internal.ScriptDataSetScriptExecutor.handleOpen(ScriptDataSetScriptExecutor.java:98)
       at org.eclipse.birt.data.engine.impl.ScriptDataSetRuntime.open(ScriptDataSetRuntime.java:80)
       at org.eclipse.birt.data.engine.impl.PreparedScriptDSQuery$ScriptDSQueryExecutor$CustomDataSet.open(PreparedScriptDSQuery.java:247)
       at org.eclipse.birt.data.engine.impl.PreparedScriptDSQuery$ScriptDSQueryExecutor.executeOdiQuery(PreparedScriptDSQuery.java:223)
       at org.eclipse.birt.data.engine.impl.QueryExecutor.execute(QueryExecutor.java:1257)
       at org.eclipse.birt.data.engine.impl.ServiceForQueryResults.executeQuery(ServiceForQueryResults.java:233)
       at org.eclipse.birt.data.engine.impl.QueryResults.getResultIterator(QueryResults.java:178)
       at org.eclipse.birt.report.engine.data.dte.QueryResultSet.<init>(QueryResultSet.java:98)</init>
    <init>   at org.eclipse.birt.report.engine.data.dte.DteDataEngine.doExecuteQuery(DteDataEngine.java:168)</init>
    <init>   at org.eclipse.birt.report.engine.data.dte.DataGenerationEngine.doExecuteQuery(DataGenerationEngine.java:83)</init>
    <init>   at org.eclipse.birt.report.engine.data.dte.AbstractDataEngine.execute(AbstractDataEngine.java:286)</init>
    <init>   at org.eclipse.birt.report.engine.executor.ExecutionContext.executeQuery(ExecutionContext.java:1954)</init>
    <init>   at org.eclipse.birt.report.engine.executor.QueryItemExecutor.executeQuery(QueryItemExecutor.java:80)</init>
    <init>   at org.eclipse.birt.report.engine.executor.TableItemExecutor.execute(TableItemExecutor.java:62)</init>
    <init>   at org.eclipse.birt.report.engine.internal.executor.wrap.WrappedReportItemExecutor.execute(WrappedReportItemExecutor.java:46)</init>
    <init>   at org.eclipse.birt.report.engine.internal.executor.emitter.ReportItemEmitterExecutor.execute(ReportItemEmitterExecutor.java:46)</init>
    <init>   at org.eclipse.birt.report.engine.internal.executor.dup.SuppressDuplicateItemExecutor.execute(SuppressDuplicateItemExecutor.java:43)</init>
    <init>   at org.eclipse.birt.report.engine.layout.html.HTMLBlockStackingLM.layoutNodes(HTMLBlockStackingLM.java:65)</init>
    <init>   at org.eclipse.birt.report.engine.layout.html.HTMLPageLM.layout(HTMLPageLM.java:92)</init>
    <init>   at org.eclipse.birt.report.engine.layout.html.HTMLReportLayoutEngine.layout(HTMLReportLayoutEngine.java:100)</init>
    <init>   at org.eclipse.birt.report.engine.presentation.ReportDocumentBuilder.build(ReportDocumentBuilder.java:258)</init>
    <init>   at org.eclipse.birt.report.engine.api.impl.RunTask.doRun(RunTask.java:273)</init>
    <init>   at org.eclipse.birt.report.engine.api.impl.RunTask.run(RunTask.java:89)</init>
    <init>   at org.eclipse.birt.report.service.ReportEngineService.runReport(ReportEngineService.java:1325)</init>
    <init>   at org.eclipse.birt.report.service.BirtViewerReportService.runReport(BirtViewerReportService.java:159)</init>
    <init>   at org.eclipse.birt.report.service.actionhandler.BirtRunReportActionHandler.__execute(BirtRunReportActionHandler.java:81)</init>
    <init>   at org.eclipse.birt.report.service.actionhandler.BirtChangeParameterActionHandler.runReport(BirtChangeParameterActionHandler.java:58)</init>
    <init>   at org.eclipse.birt.report.service.actionhandler.AbstractChangeParameterActionHandler.__execute(AbstractChangeParameterActionHandler.java:52)</init>
    <init>   at org.eclipse.birt.report.service.actionhandler.AbstractBaseActionHandler.execute(AbstractBaseActionHandler.java:90)</init>
    <init>   at org.eclipse.birt.report.soapengine.processor.AbstractBaseDocumentProcessor.__executeAction(AbstractBaseDocumentProcessor.java:47)</init>
    <init>   at org.eclipse.birt.report.soapengine.processor.AbstractBaseComponentProcessor.executeAction(AbstractBaseComponentProcessor.java:143)</init>
    <init>   at org.eclipse.birt.report.soapengine.processor.BirtDocumentProcessor.handleChangeParameter(BirtDocumentProcessor.java:100)</init>
    <init>   at java.base/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(DirectMethodHandleAccessor.java:104)</init>
    <init>   at java.base/java.lang.reflect.Method.invoke(Method.java:578)</init>
    <init>   at org.eclipse.birt.report.soapengine.processor.AbstractBaseComponentProcessor.process(AbstractBaseComponentProcessor.java:112)</init>
    <init>   at org.eclipse.birt.report.soapengine.endpoint.BirtSoapBindingImpl.getUpdatedObjects(BirtSoapBindingImpl.java:66)</init>
    <init>   at java.base/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(DirectMethodHandleAccessor.java:104)</init>
    <init>   at java.base/java.lang.reflect.Method.invoke(Method.java:578)</init>
    <init>   at org.apache.axis.providers.java.RPCProvider.invokeMethod(RPCProvider.java:397)</init>
    <init>   at org.apache.axis.providers.java.RPCProvider.processMessage(RPCProvider.java:186)</init>
    <init>   at org.apache.axis.providers.java.JavaProvider.invoke(JavaProvider.java:323)</init>
    <init>   at org.apache.axis.strategies.InvocationStrategy.visit(InvocationStrategy.java:32)</init>
    <init>   at org.apache.axis.SimpleChain.doVisiting(SimpleChain.java:118)</init>
    <init>   at org.apache.axis.SimpleChain.invoke(SimpleChain.java:83)</init>
    <init>   at org.apache.axis.handlers.soap.SOAPService.invoke(SOAPService.java:454)</init>
    <init>   at org.apache.axis.server.AxisServer.invoke(AxisServer.java:281)</init>
    <init>   at org.apache.axis.transport.http.AxisServlet.doPost(AxisServlet.java:699)</init>
    <init>   at org.eclipse.birt.report.servlet.BirtSoapMessageDispatcherServlet.doPost(BirtSoapMessageDispatcherServlet.java:265)</init>
    <init>   at javax.servlet.http.HttpServlet.service(HttpServlet.java:707)</init>
    <init>   at org.apache.axis.transport.http.AxisServletBase.service(AxisServletBase.java:327)</init>
    <init>   at javax.servlet.http.HttpServlet.service(HttpServlet.java:790)</init>
    <init>   at org.eclipse.birt.report.servlet.BirtSoapMessageDispatcherServlet.service(BirtSoapMessageDispatcherServlet.java:122)</init>
    <init>   at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:865)</init>
    <init>   at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1655)</init>
    <init>   at org.eclipse.birt.report.filter.ViewerFilter.doFilter(ViewerFilter.java:68)</init>
    <init>   at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1634)</init>
    <init>   at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:533)</init>
    <init>   at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:146)</init>
    <init>   at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:548)</init>
    <init>   at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:132)</init>
    <init>   at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:257)</init>
    <init>   at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:1595)</init>
    <init>   at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:255)</init>
    <init>   at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1253)</init>
    <init>   at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:203)</init>
    <init>   at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:473)</init>
    <init>   at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:1564)</init>
    <init>   at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:201)</init>
    <init>   at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1155)</init>
    <init>   at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:144)</init>
    <init>   at org.eclipse.jetty.server.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:219)</init>
    <init>   at org.eclipse.jetty.server.handler.HandlerCollection.handle(HandlerCollection.java:126)</init>
    <init>   at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:132)</init>
    <init>   at org.eclipse.jetty.server.Server.handle(Server.java:531)</init>
    <init>   at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:352)</init>
    <init>   at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:260)</init>
    <init>   at org.eclipse.jetty.io.AbstractConnection$ReadCallback.succeeded(AbstractConnection.java:281)</init>
    <init>   at org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:102)</init>
    <init>   at org.eclipse.jetty.io.ChannelEndPoint$2.run(ChannelEndPoint.java:118)</init>
    <init>   at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.runTask(EatWhatYouKill.java:333)</init>
    <init>   at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.doProduce(EatWhatYouKill.java:310)</init>
    <init>   at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.tryProduce(EatWhatYouKill.java:168)</init>
    <init>   at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.run(EatWhatYouKill.java:126)</init>
    <init>   at org.eclipse.jetty.util.thread.ReservedThreadExecutor$ReservedThread.run(ReservedThreadExecutor.java:366)</init>
    <init>   at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:760)</init>
    <init>   at org.eclipse.jetty.util.thread.QueuedThreadPool$2.run(QueuedThreadPool.java:678)</init>
    <init>   at java.base/java.lang.Thread.run(Thread.java:1623)</init>
    <init>Caused by: org.eclipse.birt.data.engine.core.DataException: Fail to execute script in function __bm_OPEN(). Source:</init>
    <init>------</init>
    <init>" + maximoDataSet = MXReportDataSetProvider.create(this.getDataSource().getName(), this.getName());</init>
    <init>maximoDataSet.open();</init>

    <init>var shopwhere = "1=1";</init>
    <init>if (params["shop"].value) {</init>
    <init>shopwhere += " AND " + MXReportSqlFormat.createParamWhereClause("shop.BCH_PARshop", params["shop"]);</init>
    <init>}</init>

    <init>var datewhere = "1=1";</init>
    <init>datewhere += " AND week(w.TARGSTARTDATE) = (week(sysdate) - 1) AND year(w.SCHEDSTART) = year(sysdate)";</init>
    <init>if (params["startdate"].value) {</init>
    <init>datewhere += " AND w.TARGSTARTDATE >= " + MXReportSqlFormat.getStartDayTimestampFunction(params["startdate"]);</init>
    <init>}</init>
    <init>if (params["enddate"].value) {</init>
    <init>datewhere += " AND w.TARGSTARTDATE <= " + MXReportSqlFormat.getEndDayTimestampFunction(params["enddate"]);</init>
    <init>}</init>

    <init>var sqlText = "SELECT "</init>
    <init>+ "w.WONUM, "</init>
    <init>+ "PM.FREQUENCY, "</init>
    <init>+ "PM.FREQUNIT, "</init>
    <init>+ "TO_CHAR(w.SCHEDSTART, 'MM/DD/YY'), "</init>
    <init>+ "TO_CHAR(w.REPORTDATE, 'MM/DD/YY')', "</init>
    <init>+ "UPPER(w.DESCRIPTION), "</init>
    <init>+ "shop.BCH_PARshop', "</init>
    <init>+ "w.PERSONGROUP, "</init>
    <init>+ "w.ASSETNUM</init>
    <init>+ "w.LEAD', "</init>
    <init>+ "pm.BCH_PMREG, "</init>
    <init>+ "w.PMNUM, "</init>
    <init>+ "shop.BCH_GRPLDR', "</init>
    <init>+ "shop.BCH_shopSUP' "</init>
    <init>+ "FROM WORKORDER AS w "</init>
    <init>+ "LEFT JOIN MAXIMO.PM AS PM ON w.PMNUM = PM.PMNUM "</init>
    <init>+ "LEFT JOIN Maximo.PERSONGROUP AS shop ON PM.PERSONGROUP = shop.PERSONGROUP "</init>
    <init>+ "LEFT JOIN Maximo.WOSTATUS AS status ON w.WONUM = status.WONUM "</init>
    <init>+ "WHERE PM.FREQUNIT = 'WEEKS' "</init>
    <init>+ "AND w.status NOT IN ('COMP-TECH', 'COMP-SUPV','CLOSE','COMP','COMP-REVIEWED', 'CAN') "</init>
    <init>+ "AND PM.BCH_PMREG = 'TJC' "</init>
    <init>+ "AND w.TARGSTARTDATE BETWEEN DATE('2023-12-03') AND DATE('2023-12-09') "</init>
    <init>+ "AND " + shopwhere + " "</init>
    <init>+ "AND " + datewhere;</init>

    <init>maximoDataSet.setQuery(sqlText); + "</init>
    <init>-----</init>
    <init>A BIRT exception occurred. See next exception for more information.</init>
    <init>unterminated string literal (/report/data-sets/script-data-set[@id="5"]/method[@name="open"]#27)</init>
    <init>   at org.eclipse.birt.data.engine.script.JSMethodRunner.runScript(JSMethodRunner.java:147)</init>
    <init>   at org.eclipse.birt.report.engine.script.internal.DtEScriptExecutor.handleJS(DtEScriptExecutor.java:90)</init>
    <init>... 88 more</init>
    <init>Caused by: org.eclipse.birt.data.engine.core.DataException: A BIRT exception occurred. See next exception for more information.</init>
    <init>unterminated string literal (/report/data-sets/script-data-set[@id="5"]/method[@name="open"]#27)</init>
    <init>   at org.eclipse.birt.data.engine.core.DataException.wrap(DataException.java:123)</init>
    <init>   at org.eclipse.birt.data.engine.script.ScriptEvalUtil.evaluateJSAsExpr(ScriptEvalUtil.java:1003)</init>
    <init>   at org.eclipse.birt.data.engine.script.JSMethodRunner.runScript(JSMethodRunner.java:128)</init>
    <init>... 89 more</init>
    <init>Caused by: org.eclipse.birt.core.exception.CoreException: unterminated string literal (/report/data-sets/script-data-set[@id="5"]/method[@name="open"]#27)</init>
    <init>   at org.eclipse.birt.core.script.JavascriptEvalUtil.wrapRhinoException(JavascriptEvalUtil.java:307)</init>
    <init>   at org.eclipse.birt.core.script.JavascriptEvalUtil.evaluateRawScript(JavascriptEvalUtil.java:106)</init>
    <init>   at org.eclipse.birt.core.script.JavascriptEvalUtil.evaluateScript(JavascriptEvalUtil.java:138)</init>
    <init>   at org.eclipse.birt.data.engine.script.ScriptEvalUtil.evaluateJSAsExpr(ScriptEvalUtil.java:999)</init>
    <init>... 90 more</init>
    <init>Caused by: org.mozilla.javascript.EvaluatorException: unterminated string literal (/report/data-sets/script-data-set[@id="5"]/method[@name="open"]#27)</init>
    <init>   at org.mozilla.javascript.DefaultErrorReporter.runtimeError(DefaultErrorReporter.java:77)</init>
    <init>   at org.mozilla.javascript.DefaultErrorReporter.error(DefaultErrorReporter.java:64)</init>
    <init>   at org.mozilla.javascript.Parser.addError(Parser.java:188)</init>
    <init>   at org.mozilla.javascript.Parser.addError(Parser.java:166)</init>
    <init>   at org.mozilla.javascript.Parser.addError(Parser.java:162)</init>
    <init>   at org.mozilla.javascript.TokenStream.getToken(TokenStream.java:516)</init>
    <init>   at org.mozilla.javascript.Parser.peekToken(Parser.java:296)</init>
    <init>   at org.mozilla.javascript.Parser.unaryExpr(Parser.java:2249)</init>
    <init>   at org.mozilla.javascript.Parser.mulExpr(Parser.java:2229)</init>
    <init>   at org.mozilla.javascript.Parser.addExpr(Parser.java:2218)</init>
    <init>   at org.mozilla.javascript.Parser.shiftExpr(Parser.java:2194)</init>
    <init>   at org.mozilla.javascript.Parser.relExpr(Parser.java:2169)</init>
    <init>   at org.mozilla.javascript.Parser.eqExpr(Parser.java:2141)</init>
    <init>   at org.mozilla.javascript.Parser.bitAndExpr(Parser.java:2130)</init>
    <init>   at org.mozilla.javascript.Parser.bitXorExpr(Parser.java:2119)</init>
    <init>   at org.mozilla.javascript.Parser.bitOrExpr(Parser.java:2108)</init>
    <init>   at org.mozilla.javascript.Parser.andExpr(Parser.java:2097)</init>
    <init>   at org.mozilla.javascript.Parser.orExpr(Parser.java:2086)</init>
    <init>   at org.mozilla.javascript.Parser.condExpr(Parser.java:2062)</init>
    <init>   at org.mozilla.javascript.Parser.assignExpr(Parser.java:2033)</init>
    <init>   at org.mozilla.javascript.Parser.variables(Parser.java:1870)</init>
    <init>   at org.mozilla.javascript.Parser.statementHelper(Parser.java:986)</init>
    <init>   at org.mozilla.javascript.Parser.statement(Parser.java:901)</init>
    <init>   at org.mozilla.javascript.Parser.parseFunctionBody(Parser.java:634)</init>
    <init>   at org.mozilla.javascript.Parser.function(Parser.java:795)</init>
    <init>   at org.mozilla.javascript.Parser.parse(Parser.java:533)</init>
    <init>   at org.mozilla.javascript.Parser.parse(Parser.java:478)</init>
    <init>   at org.mozilla.javascript.Context.compileImpl(Context.java:2348)</init>
    <init>   at org.mozilla.javascript.Context.compileString(Context.java:1335)</init>
    <init>   at org.mozilla.javascript.Context.compileString(Context.java:1324)</init>
    <init>   at org.eclipse.birt.core.script.JavascriptEvalUtil.getCompiledScript(JavascriptEvalUtil.java:156)</init>
    <init>   at org.eclipse.birt.core.script.JavascriptEvalUtil.evaluateRawScript(JavascriptEvalUtil.java:95)</init>
    <init>... 92 more</init>
    org.eclipse.birt.report.engine.api.EngineException: There are errors evaluating script "if (!maximoDataSet.fetch())
    return (false);

    // Add a line for each output column
    // The specific get method should match the data type of the output column.
    row["WONUM"] = maximoDataSet.getInteger("WONUM");
    row["STATUS"] = maximoDataSet.getString("STATUS");
    row["SCHEDSTART"] = maximoDataSet.getDateTime("SCHEDSTART");
    row["FREQUENCY"] = maximoDataSet.getDecimal("FREQUENCY");
    row["FREQUNIT"] = maximoDataSet.getString("FREQUNIT");
    row["LOCATION"] = maximoDataSet.getString("LOCATION");
    row["DESCRIPTION"] = maximoDataSet.getString("DESCRIPTION");
    row["BCH_PARSHOP"] = maximoDataSet.getString("BCH_PARSHOP");
    row["ASSETNUM"] = maximoDataSet.getString("ASSETNUM");
    row["LEAD"] = maximoDataSet.getString("LEAD");
    row["BCH_PMREG"] = maximoDataSet.getString("BCH_PMREG");
    row["PMNUM"] = maximoDataSet.getString("PMNUM");
    row["BCH_GRPLDR"] = maximoDataSet.getString("BCH_GRPLDR");
    row["BCH_SHOPSUP"] = maximoDataSet.getString("BCH_SHOPSUP");
    row["REPORTDATE"] = maximoDataSet.getDateTime("REPORTDATE");

    return (true);":
    Fail to execute script in function __bm_FETCH(). Source:
    ------
    " + if (!maximoDataSet.fetch())
    return (false);

    // Add a line for each output column
    // The specific get method should match the data type of the output column.
    row["WONUM"] = maximoDataSet.getInteger("WONUM");
    row["STATUS"] = maximoDataSet.getString("STATUS");
    row["SCHEDSTART"] = maximoDataSet.getDateTime("SCHEDSTART");
    row["FREQUENCY"] = maximoDataSet.getDecimal("FREQUENCY");
    row["FREQUNIT"] = maximoDataSet.getString("FREQUNIT");
    row["LOCATION"] = maximoDataSet.getString("LOCATION");
    row["DESCRIPTION"] = maximoDataSet.getString("DESCRIPTION");
    row["BCH_PARSHOP"] = maximoDataSet.getString("BCH_PARSHOP");
    row["ASSETNUM"] = maximoDataSet.getString("ASSETNUM");
    row["LEAD"] = maximoDataSet.getString("LEAD");
    row["BCH_PMREG"] = maximoDataSet.getString("BCH_PMREG");
    row["PMNUM"] = maximoDataSet.getString("PMNUM");
    row["BCH_GRPLDR"] = maximoDataSet.getString("BCH_GRPLDR");
    row["BCH_SHOPSUP"] = maximoDataSet.getString("BCH_SHOPSUP");
    row["REPORTDATE"] = maximoDataSet.getDateTime("REPORTDATE");

    return (true); + "
    -----
    A BIRT exception occurred. See next exception for more information.
    ReferenceError: "maximoDataSet" is not defined. (/report/data-sets/script-data-set[@id="5"]/method[@name="fetch"]#1).
       at org.eclipse.birt.report.engine.script.internal.DtEScriptExecutor.handleJS(DtEScriptExecutor.java:99)
       at org.eclipse.birt.report.engine.script.internal.DataSetScriptExecutor.handleJS(DataSetScriptExecutor.java:256)
       at org.eclipse.birt.report.engine.script.internal.ScriptDataSetScriptExecutor.handleFetch(ScriptDataSetScriptExecutor.java:143)
       at org.eclipse.birt.data.engine.impl.ScriptDataSetRuntime.fetch(ScriptDataSetRuntime.java:103)
       at org.eclipse.birt.data.engine.impl.PreparedScriptDSQuery$ScriptDSQueryExecutor$CustomDataSet.fetch(PreparedScriptDSQuery.java:260)
       at org.eclipse.birt.data.engine.executor.cache.OdiAdapter.fetch(OdiAdapter.java:226)
       at org.eclipse.birt.data.engine.executor.cache.RowResultSet.fetch(RowResultSet.java:145)
       at org.eclipse.birt.data.engine.executor.cache.RowResultSet.doNext(RowResultSet.java:118)
       at org.eclipse.birt.data.engine.executor.cache.RowResultSet.next(RowResultSet.java:96)
       at org.eclipse.birt.data.engine.executor.cache.ExpandableRowResultSet.next(ExpandableRowResultSet.java:63)
       at org.eclipse.birt.data.engine.executor.cache.SmartCacheHelper.populateData(SmartCacheHelper.java:318)
       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)</init>
    <init>   at org.eclipse.birt.data.engine.executor.transform.pass.PassUtil.populateOdiResultSet(PassUtil.java:110)</init>
    <init>   at org.eclipse.birt.data.engine.executor.transform.pass.PassUtil.pass(PassUtil.java:62)</init>
    <init>   at org.eclipse.birt.data.engine.executor.transform.pass.PassManager.doSinglePass(PassManager.java:170)</init>
    <init>   at org.eclipse.birt.data.engine.executor.transform.pass.PassManager.prepareDataSetResultSet(PassManager.java:94)</init>
    <init>   at org.eclipse.birt.data.engine.executor.transform.pass.PassManager.pass(PassManager.java:134)</init>
    <init>   at org.eclipse.birt.data.engine.executor.transform.pass.PassManager.populateResultSet(PassManager.java:74)</init>
    <init>   at org.eclipse.birt.data.engine.executor.transform.ResultSetPopulator.populateResultSet(ResultSetPopulator.java:218)</init>
    <init>   at org.eclipse.birt.data.engine.executor.transform.CachedResultSet.(CachedResultSet.java:200)</init>
    <init>   at org.eclipse.birt.data.engine.executor.CandidateQuery.execute(CandidateQuery.java:142)</init>
    <init>   at org.eclipse.birt.data.engine.impl.PreparedScriptDSQuery$ScriptDSQueryExecutor.executeOdiQuery(PreparedScriptDSQuery.java:226)</init>
    <init>   at org.eclipse.birt.data.engine.impl.QueryExecutor.execute(QueryExecutor.java:1257)</init>
    <init>   at org.eclipse.birt.data.engine.impl.ServiceForQueryResults.executeQuery(ServiceForQueryResults.java:233)</init>
    <init>   at org.eclipse.birt.data.engine.impl.QueryResults.getResultIterator(QueryResults.java:178)</init>
    <init>   at org.eclipse.birt.report.engine.data.dte.QueryResultSet.(QueryResultSet.java:98)</init>
    <init>   at org.eclipse.birt.report.engine.data.dte.DteDataEngine.doExecuteQuery(DteDataEngine.java:168)</init>
    <init>   at org.eclipse.birt.report.engine.data.dte.DataGenerationEngine.doExecuteQuery(DataGenerationEngine.java:83)</init>
    <init>   at org.eclipse.birt.report.engine.data.dte.AbstractDataEngine.execute(AbstractDataEngine.java:286)</init>
    <init>   at org.eclipse.birt.report.engine.executor.ExecutionContext.executeQuery(ExecutionContext.java:1954)</init>
    <init>   at org.eclipse.birt.report.engine.executor.QueryItemExecutor.executeQuery(QueryItemExecutor.java:80)</init>
    <init>   at org.eclipse.birt.report.engine.executor.TableItemExecutor.execute(TableItemExecutor.java:62)</init>
    <init>   at org.eclipse.birt.report.engine.internal.executor.wrap.WrappedReportItemExecutor.execute(WrappedReportItemExecutor.java:46)</init>
    <init>   at org.eclipse.birt.report.engine.internal.executor.emitter.ReportItemEmitterExecutor.execute(ReportItemEmitterExecutor.java:46)</init>
    <init>   at org.eclipse.birt.report.engine.internal.executor.dup.SuppressDuplicateItemExecutor.execute(SuppressDuplicateItemExecutor.java:43)</init>
    <init>   at org.eclipse.birt.report.engine.layout.html.HTMLBlockStackingLM.layoutNodes(HTMLBlockStackingLM.java:65)</init>
    <init>   at org.eclipse.birt.report.engine.layout.html.HTMLPageLM.layout(HTMLPageLM.java:92)</init>
    <init>   at org.eclipse.birt.report.engine.layout.html.HTMLReportLayoutEngine.layout(HTMLReportLayoutEngine.java:100)</init>
    <init>   at org.eclipse.birt.report.engine.presentation.ReportDocumentBuilder.build(ReportDocumentBuilder.java:258)</init>
    <init>   at org.eclipse.birt.report.engine.api.impl.RunTask.doRun(RunTask.java:273)</init>
    <init>   at org.eclipse.birt.report.engine.api.impl.RunTask.run(RunTask.java:89)</init>
    <init>   at org.eclipse.birt.report.service.ReportEngineService.runReport(ReportEngineService.java:1325)</init>
    <init>   at org.eclipse.birt.report.service.BirtViewerReportService.runReport(BirtViewerReportService.java:159)</init>
    <init>   at org.eclipse.birt.report.service.actionhandler.BirtRunReportActionHandler.__execute(BirtRunReportActionHandler.java:81)</init>
    <init>   at org.eclipse.birt.report.service.actionhandler.BirtChangeParameterActionHandler.runReport(BirtChangeParameterActionHandler.java:58)</init>
    <init>   at org.eclipse.birt.report.service.actionhandler.AbstractChangeParameterActionHandler.__execute(AbstractChangeParameterActionHandler.java:52)</init>
    <init>   at org.eclipse.birt.report.service.actionhandler.AbstractBaseActionHandler.execute(AbstractBaseActionHandler.java:90)</init>
    <init>   at org.eclipse.birt.report.soapengine.processor.AbstractBaseDocumentProcessor.__executeAction(AbstractBaseDocumentProcessor.java:47)</init>
    <init>   at org.eclipse.birt.report.soapengine.processor.AbstractBaseComponentProcessor.executeAction(AbstractBaseComponentProcessor.java:143)</init>
    <init>   at org.eclipse.birt.report.soapengine.processor.BirtDocumentProcessor.handleChangeParameter(BirtDocumentProcessor.java:100)</init>
    <init>   at java.base/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(DirectMethodHandleAccessor.java:104)</init>
    <init>   at java.base/java.lang.reflect.Method.invoke(Method.java:578)</init>
    <init>   at org.eclipse.birt.report.soapengine.processor.AbstractBaseComponentProcessor.process(AbstractBaseComponentProcessor.java:112)</init>
    <init>   at org.eclipse.birt.report.soapengine.endpoint.BirtSoapBindingImpl.getUpdatedObjects(BirtSoapBindingImpl.java:66)</init>
    <init>   at java.base/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(DirectMethodHandleAccessor.java:104)</init>
    <init>   at java.base/java.lang.reflect.Method.invoke(Method.java:578)</init>
    <init>   at org.apache.axis.providers.java.RPCProvider.invokeMethod(RPCProvider.java:397)</init>
    <init>   at org.apache.axis.providers.java.RPCProvider.processMessage(RPCProvider.java:186)</init>
    <init>   at org.apache.axis.providers.java.JavaProvider.invoke(JavaProvider.java:323)</init>
    <init>   at org.apache.axis.strategies.InvocationStrategy.visit(InvocationStrategy.java:32)</init>
    <init>   at org.apache.axis.SimpleChain.doVisiting(SimpleChain.java:118)</init>
    <init>   at org.apache.axis.SimpleChain.invoke(SimpleChain.java:83)</init>
    <init>   at org.apache.axis.handlers.soap.SOAPService.invoke(SOAPService.java:454)</init>
    <init>   at org.apache.axis.server.AxisServer.invoke(AxisServer.java:281)</init>
    <init>   at org.apache.axis.transport.http.AxisServlet.doPost(AxisServlet.java:699)</init>
    <init>   at org.eclipse.birt.report.servlet.BirtSoapMessageDispatcherServlet.doPost(BirtSoapMessageDispatcherServlet.java:265)</init>
    <init>   at javax.servlet.http.HttpServlet.service(HttpServlet.java:707)</init>
    <init>   at org.apache.axis.transport.http.AxisServletBase.service(AxisServletBase.java:327)</init>
    <init>   at javax.servlet.http.HttpServlet.service(HttpServlet.java:790)</init>
    <init>   at org.eclipse.birt.report.servlet.BirtSoapMessageDispatcherServlet.service(BirtSoapMessageDispatcherServlet.java:122)</init>
    <init>   at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:865)</init>
    <init>   at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1655)</init>
    <init>   at org.eclipse.birt.report.filter.ViewerFilter.doFilter(ViewerFilter.java:68)</init>
    <init>   at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1634)</init>
    <init>   at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:533)</init>
    <init>   at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:146)</init>
    <init>   at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:548)</init>
    <init>   at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:132)</init>
    <init>   at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:257)</init>
    <init>   at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:1595)</init>
    <init>   at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:255)</init>
    <init>   at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1253)</init>
    <init>   at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:203)</init>
    <init>   at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:473)</init>
    <init>   at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:1564)</init>
    <init>   at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:201)</init>
    <init>   at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1155)</init>
    <init>   at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:144)</init>
    <init>   at org.eclipse.jetty.server.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:219)</init>
    <init>   at org.eclipse.jetty.server.handler.HandlerCollection.handle(HandlerCollection.java:126)</init>
    <init>   at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:132)</init>
    <init>   at org.eclipse.jetty.server.Server.handle(Server.java:531)</init>
    <init>   at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:352)</init>
    <init>   at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:260)</init>
    <init>   at org.eclipse.jetty.io.AbstractConnection$ReadCallback.succeeded(AbstractConnection.java:281)</init>
    <init>   at org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:102)</init>
    <init>   at org.eclipse.jetty.io.ChannelEndPoint$2.run(ChannelEndPoint.java:118)</init>
    <init>   at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.runTask(EatWhatYouKill.java:333)</init>
    <init>   at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.doProduce(EatWhatYouKill.java:310)</init>
    <init>   at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.tryProduce(EatWhatYouKill.java:168)</init>
    <init>   at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.run(EatWhatYouKill.java:126)</init>
    <init>   at org.eclipse.jetty.util.thread.ReservedThreadExecutor$ReservedThread.run(ReservedThreadExecutor.java:366)</init>
    <init>   at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:760)</init>
    <init>   at org.eclipse.jetty.util.thread.QueuedThreadPool$2.run(QueuedThreadPool.java:678)</init>
    <init>   at java.base/java.lang.Thread.run(Thread.java:1623)</init>
    <init>Caused by: org.eclipse.birt.data.engine.core.DataException: Fail to execute script in function __bm_FETCH(). Source:</init>
    <init>------</init>
    <init>" + if (!maximoDataSet.fetch())</init>
    <init>return (false);</init>

    <init>// Add a line for each output column</init>
    <init>// The specific get method should match the data type of the output column.</init>
    <init>row["WONUM"] = maximoDataSet.getInteger("WONUM"); </init>
    <init>row["STATUS"] = maximoDataSet.getString("STATUS");</init>
    <init>row["SCHEDSTART"] = maximoDataSet.getDateTime("SCHEDSTART"); </init>
    <init>row["FREQUENCY"] = maximoDataSet.getDecimal("FREQUENCY");</init>
    <init>row["FREQUNIT"] = maximoDataSet.getString("FREQUNIT");</init>
    <init>row["LOCATION"] = maximoDataSet.getString("LOCATION"); </init>
    <init>row["DESCRIPTION"] = maximoDataSet.getString("DESCRIPTION");</init>
    <init>row["BCH_PARSHOP"] = maximoDataSet.getString("BCH_PARSHOP"); </init>
    <init>row["ASSETNUM"] = maximoDataSet.getString("ASSETNUM");</init>
    <init>row["LEAD"] = maximoDataSet.getString("LEAD");</init>
    <init>row["BCH_PMREG"] = maximoDataSet.getString("BCH_PMREG"); </init>
    <init>row["PMNUM"] = maximoDataSet.getString("PMNUM");</init>
    <init>row["BCH_GRPLDR"] = maximoDataSet.getString("BCH_GRPLDR"); </init>
    <init>row["BCH_SHOPSUP"] = maximoDataSet.getString("BCH_SHOPSUP");</init>
    <init>row["REPORTDATE"] = maximoDataSet.getDateTime("REPORTDATE");</init>

    <init>return (true); + "</init>
    <init>-----</init>
    <init>A BIRT exception occurred. See next exception for more information.</init>
    <init>ReferenceError: "maximoDataSet" is not defined. (/report/data-sets/script-data-set[@id="5"]/method[@name="fetch"]#1)</init>
    <init>   at org.eclipse.birt.data.engine.script.JSMethodRunner.runScript(JSMethodRunner.java:147)</init>
    <init>   at org.eclipse.birt.report.engine.script.internal.DtEScriptExecutor.handleJS(DtEScriptExecutor.java:90)</init>
    <init>... 106 more</init>
    <init>Caused by: org.eclipse.birt.data.engine.core.DataException: A BIRT exception occurred. See next exception for more information.</init>
    <init>ReferenceError: "maximoDataSet" is not defined. (/report/data-sets/script-data-set[@id="5"]/method[@name="fetch"]#1)</init>
    <init>   at org.eclipse.birt.data.engine.core.DataException.wrap(DataException.java:123)</init>
    <init>   at org.eclipse.birt.data.engine.script.ScriptEvalUtil.evaluateJSAsExpr(ScriptEvalUtil.java:1003)</init>
    <init>   at org.eclipse.birt.data.engine.script.JSMethodRunner.runScript(JSMethodRunner.java:138)</init>
    <init>... 107 more</init>
    <init>Caused by: org.eclipse.birt.core.exception.CoreException: ReferenceError: "maximoDataSet" is not defined. (/report/data-sets/script-data-set[@id="5"]/method[@name="fetch"]#1)</init>
    <init>   at org.eclipse.birt.core.script.JavascriptEvalUtil.wrapRhinoException(JavascriptEvalUtil.java:307)</init>
    <init>   at org.eclipse.birt.core.script.JavascriptEvalUtil.evaluateRawScript(JavascriptEvalUtil.java:106)</init>
    <init>   at org.eclipse.birt.core.script.JavascriptEvalUtil.evaluateScript(JavascriptEvalUtil.java:138)</init>
    <init>   at org.eclipse.birt.data.engine.script.ScriptEvalUtil.evaluateJSAsExpr(ScriptEvalUtil.java:999)</init>
    <init>... 108 more</init>
    <init>Caused by: org.mozilla.javascript.EcmaError: ReferenceError: "maximoDataSet" is not defined. (/report/data-sets/script-data-set[@id="5"]/method[@name="fetch"]#1)</init>
    <init>   at org.mozilla.javascript.ScriptRuntime.constructError(ScriptRuntime.java:3687)</init>
    <init>   at org.mozilla.javascript.ScriptRuntime.constructError(ScriptRuntime.java:3665)</init>
    <init>   at org.mozilla.javascript.ScriptRuntime.notFoundError(ScriptRuntime.java:3750)</init>
    <init>   at org.mozilla.javascript.ScriptRuntime.nameOrFunction(ScriptRuntime.java:1794)</init>
    <init>   at org.mozilla.javascript.ScriptRuntime.name(ScriptRuntime.java:1733)</init>
    <init>   at org.mozilla.javascript.gen._report_data_sets_script_data_set__id__5___method__name__fetch___60._c___bm_FETCH_1(/report/data-sets/script-data-set[@id="5"]/method[@name="fetch"]:1)</init>
    <init>   at org.mozilla.javascript.gen._report_data_sets_script_data_set__id__5___method__name__fetch___60.call(/report/data-sets/script-data-set[@id="5"]/method[@name="fetch"])</init>
    <init>   at org.mozilla.javascript.optimizer.OptRuntime.callName0(OptRuntime.java:74)</init>
    <init>   at org.mozilla.javascript.gen._report_data_sets_script_data_set__id__5___method__name__fetch___17._c_script_0(/report/data-sets/script-data-set[@id="5"]/method[@name="fetch"]:0)</init>
    <init>   at org.mozilla.javascript.gen._report_data_sets_script_data_set__id__5___method__name__fetch___17.call(/report/data-sets/script-data-set[@id="5"]/method[@name="fetch"])</init>
    <init>   at org.mozilla.javascript.ContextFactory.doTopCall(ContextFactory.java:394)</init>
    <init>   at org.mozilla.javascript.ScriptRuntime.doTopCall(ScriptRuntime.java:3091)</init>
    <init>   at org.mozilla.javascript.gen._report_data_sets_script_data_set__id__5___method__name__fetch___17.call(/report/data-sets/script-data-set[@id="5"]/method[@name="fetch"])</init>
    <init>   at org.mozilla.javascript.gen._report_data_sets_script_data_set__id__5___method__name__fetch___17.exec(/report/data-sets/script-data-set[@id="5"]/method[@name="fetch"])</init>
    <init>   at org.eclipse.birt.core.script.JavascriptEvalUtil.evaluateRawScript(JavascriptEvalUtil.java:99)</init>
    <init>... 110 more</init>
    org.eclipse.birt.report.engine.api.EngineException: Data Set script method "Fetch" returned null; expected a Boolean value.
       at org.eclipse.birt.report.engine.script.internal.ScriptExecutor.addException(ScriptExecutor.java:249)
       at org.eclipse.birt.report.engine.script.internal.ScriptExecutor.addException(ScriptExecutor.java:238)
       at org.eclipse.birt.report.engine.script.internal.ScriptDataSetScriptExecutor.handleFetch(ScriptDataSetScriptExecutor.java:165)
       at org.eclipse.birt.data.engine.impl.ScriptDataSetRuntime.fetch(ScriptDataSetRuntime.java:103)
       at org.eclipse.birt.data.engine.impl.PreparedScriptDSQuery$ScriptDSQueryExecutor$CustomDataSet.fetch(PreparedScriptDSQuery.java:260)
       at org.eclipse.birt.data.engine.executor.cache.OdiAdapter.fetch(OdiAdapter.java:226)
       at org.eclipse.birt.data.engine.executor.cache.RowResultSet.fetch(RowResultSet.java:145)
       at org.eclipse.birt.data.engine.executor.cache.RowResultSet.doNext(RowResultSet.java:118)
       at org.eclipse.birt.data.engine.executor.cache.RowResultSet.next(RowResultSet.java:96)
       at org.eclipse.birt.data.engine.executor.cache.ExpandableRowResultSet.next(ExpandableRowResultSet.java:63)
       at org.eclipse.birt.data.engine.executor.cache.SmartCacheHelper.populateData(SmartCacheHelper.java:318)
       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)</init>
    <init>   at org.eclipse.birt.data.engine.executor.transform.pass.PassUtil.populateOdiResultSet(PassUtil.java:110)</init>
    <init>   at org.eclipse.birt.data.engine.executor.transform.pass.PassUtil.pass(PassUtil.java:62)</init>
    <init>   at org.eclipse.birt.data.engine.executor.transform.pass.PassManager.doSinglePass(PassManager.java:170)</init>
    <init>   at org.eclipse.birt.data.engine.executor.transform.pass.PassManager.prepareDataSetResultSet(PassManager.java:94)</init>
    <init>   at org.eclipse.birt.data.engine.executor.transform.pass.PassManager.pass(PassManager.java:134)</init>
    <init>   at org.eclipse.birt.data.engine.executor.transform.pass.PassManager.populateResultSet(PassManager.java:74)</init>
    <init>   at org.eclipse.birt.data.engine.executor.transform.ResultSetPopulator.populateResultSet(ResultSetPopulator.java:218)</init>
    <init>   at org.eclipse.birt.data.engine.executor.transform.CachedResultSet.(CachedResultSet.java:200)</init>
    <init>   at org.eclipse.birt.data.engine.executor.CandidateQuery.execute(CandidateQuery.java:142)</init>
    <init>   at org.eclipse.birt.data.engine.impl.PreparedScriptDSQuery$ScriptDSQueryExecutor.executeOdiQuery(PreparedScriptDSQuery.java:226)</init>
    <init>   at org.eclipse.birt.data.engine.impl.QueryExecutor.execute(QueryExecutor.java:1257)</init>
    <init>   at org.eclipse.birt.data.engine.impl.ServiceForQueryResults.executeQuery(ServiceForQueryResults.java:233)</init>
    <init>   at org.eclipse.birt.data.engine.impl.QueryResults.getResultIterator(QueryResults.java:178)</init>
    <init>   at org.eclipse.birt.report.engine.data.dte.QueryResultSet.(QueryResultSet.java:98)</init>
    <init>   at org.eclipse.birt.report.engine.data.dte.DteDataEngine.doExecuteQuery(DteDataEngine.java:168)</init>
    <init>   at org.eclipse.birt.report.engine.data.dte.DataGenerationEngine.doExecuteQuery(DataGenerationEngine.java:83)</init>
    <init>   at org.eclipse.birt.report.engine.data.dte.AbstractDataEngine.execute(AbstractDataEngine.java:286)</init>
    <init>   at org.eclipse.birt.report.engine.executor.ExecutionContext.executeQuery(ExecutionContext.java:1954)</init>
    <init>   at org.eclipse.birt.report.engine.executor.QueryItemExecutor.executeQuery(QueryItemExecutor.java:80)</init>
    <init>   at org.eclipse.birt.report.engine.executor.TableItemExecutor.execute(TableItemExecutor.java:62)</init>
    <init>   at org.eclipse.birt.report.engine.internal.executor.wrap.WrappedReportItemExecutor.execute(WrappedReportItemExecutor.java:46)</init>
    <init>   at org.eclipse.birt.report.engine.internal.executor.emitter.ReportItemEmitterExecutor.execute(ReportItemEmitterExecutor.java:46)</init>
    <init>   at org.eclipse.birt.report.engine.internal.executor.dup.SuppressDuplicateItemExecutor.execute(SuppressDuplicateItemExecutor.java:43)</init>
    <init>   at org.eclipse.birt.report.engine.layout.html.HTMLBlockStackingLM.layoutNodes(HTMLBlockStackingLM.java:65)</init>
    <init>   at org.eclipse.birt.report.engine.layout.html.HTMLPageLM.layout(HTMLPageLM.java:92)</init>
    <init>   at org.eclipse.birt.report.engine.layout.html.HTMLReportLayoutEngine.layout(HTMLReportLayoutEngine.java:100)</init>
    <init>   at org.eclipse.birt.report.engine.presentation.ReportDocumentBuilder.build(ReportDocumentBuilder.java:258)</init>
    <init>   at org.eclipse.birt.report.engine.api.impl.RunTask.doRun(RunTask.java:273)</init>
    <init>   at org.eclipse.birt.report.engine.api.impl.RunTask.run(RunTask.java:89)</init>
    <init>   at org.eclipse.birt.report.service.ReportEngineService.runReport(ReportEngineService.java:1325)</init>
    <init>   at org.eclipse.birt.report.service.BirtViewerReportService.runReport(BirtViewerReportService.java:159)</init>
    <init>   at org.eclipse.birt.report.service.actionhandler.BirtRunReportActionHandler.__execute(BirtRunReportActionHandler.java:81)</init>
    <init>   at org.eclipse.birt.report.service.actionhandler.BirtChangeParameterActionHandler.runReport(BirtChangeParameterActionHandler.java:58)</init>
    <init>   at org.eclipse.birt.report.service.actionhandler.AbstractChangeParameterActionHandler.__execute(AbstractChangeParameterActionHandler.java:52)</init>
    <init>   at org.eclipse.birt.report.service.actionhandler.AbstractBaseActionHandler.execute(AbstractBaseActionHandler.java:90)</init>
    <init>   at org.eclipse.birt.report.soapengine.processor.AbstractBaseDocumentProcessor.__executeAction(AbstractBaseDocumentProcessor.java:47)</init>
    <init>   at org.eclipse.birt.report.soapengine.processor.AbstractBaseComponentProcessor.executeAction(AbstractBaseComponentProcessor.java:143)</init>
    <init>   at org.eclipse.birt.report.soapengine.processor.BirtDocumentProcessor.handleChangeParameter(BirtDocumentProcessor.java:100)</init>
    <init>   at java.base/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(DirectMethodHandleAccessor.java:104)</init>
    <init>   at java.base/java.lang.reflect.Method.invoke(Method.java:578)</init>
    <init>   at org.eclipse.birt.report.soapengine.processor.AbstractBaseComponentProcessor.process(AbstractBaseComponentProcessor.java:112)</init>
    <init>   at org.eclipse.birt.report.soapengine.endpoint.BirtSoapBindingImpl.getUpdatedObjects(BirtSoapBindingImpl.java:66)</init>
    <init>   at java.base/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(DirectMethodHandleAccessor.java:104)</init>
    <init>   at java.base/java.lang.reflect.Method.invoke(Method.java:578)</init>
    <init>   at org.apache.axis.providers.java.RPCProvider.invokeMethod(RPCProvider.java:397)</init>
    <init>   at org.apache.axis.providers.java.RPCProvider.processMessage(RPCProvider.java:186)</init>
    <init>   at org.apache.axis.providers.java.JavaProvider.invoke(JavaProvider.java:323)</init>
    <init>   at org.apache.axis.strategies.InvocationStrategy.visit(InvocationStrategy.java:32)</init>
    <init>   at org.apache.axis.SimpleChain.doVisiting(SimpleChain.java:118)</init>
    <init>   at org.apache.axis.SimpleChain.invoke(SimpleChain.java:83)</init>
    <init>   at org.apache.axis.handlers.soap.SOAPService.invoke(SOAPService.java:454)</init>
    <init>   at org.apache.axis.server.AxisServer.invoke(AxisServer.java:281)</init>
    <init>   at org.apache.axis.transport.http.AxisServlet.doPost(AxisServlet.java:699)</init>
    <init>   at org.eclipse.birt.report.servlet.BirtSoapMessageDispatcherServlet.doPost(BirtSoapMessageDispatcherServlet.java:265)</init>
    <init>   at javax.servlet.http.HttpServlet.service(HttpServlet.java:707)</init>
    <init>   at org.apache.axis.transport.http.AxisServletBase.service(AxisServletBase.java:327)</init>
    <init>   at javax.servlet.http.HttpServlet.service(HttpServlet.java:790)</init>
    <init>   at org.eclipse.birt.report.servlet.BirtSoapMessageDispatcherServlet.service(BirtSoapMessageDispatcherServlet.java:122)</init>
    <init>   at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:865)</init>
    <init>   at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1655)</init>
    <init>   at org.eclipse.birt.report.filter.ViewerFilter.doFilter(ViewerFilter.java:68)</init>
    <init>   at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1634)</init>
    <init>   at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:533)</init>
    <init>   at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:146)</init>
    <init>   at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:548)</init>
    <init>   at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:132)</init>
    <init>   at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:257)</init>
    <init>   at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:1595)</init>
    <init>   at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:255)</init>
    <init>   at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1253)</init>
    <init>   at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:203)</init>
    <init>   at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:473)</init>
    <init>   at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:1564)</init>
    <init>   at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:201)</init>
    <init>   at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1155)</init>
    <init>   at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:144)</init>
    <init>   at org.eclipse.jetty.server.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:219)</init>
    <init>   at org.eclipse.jetty.server.handler.HandlerCollection.handle(HandlerCollection.java:126)</init>
    <init>   at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:132)</init>
    <init>   at org.eclipse.jetty.server.Server.handle(Server.java:531)</init>
    <init>   at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:352)</init>
    <init>   at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:260)</init>
    <init>   at org.eclipse.jetty.io.AbstractConnection$ReadCallback.succeeded(AbstractConnection.java:281)</init>
    <init>   at org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:102)</init>
    <init>   at org.eclipse.jetty.io.ChannelEndPoint$2.run(ChannelEndPoint.java:118)</init>
    <init>   at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.runTask(EatWhatYouKill.java:333)</init>
    <init>   at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.doProduce(EatWhatYouKill.java:310)</init>
    <init>   at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.tryProduce(EatWhatYouKill.java:168)</init>
    <init>   at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.run(EatWhatYouKill.java:126)</init>
    <init>   at org.eclipse.jetty.util.thread.ReservedThreadExecutor$ReservedThread.run(ReservedThreadExecutor.java:366)</init>
    <init>   at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:760)</init>
    <init>   at org.eclipse.jetty.util.thread.QueuedThreadPool$2.run(QueuedThreadPool.java:678)</init>
    <init>   at java.base/java.lang.Thread.run(Thread.java:1623)</init>
    <init>Caused by: org.eclipse.birt.data.engine.core.DataException: Data Set script method "Fetch" returned null; expected a Boolean value.</init>
    <init>   at org.eclipse.birt.report.engine.script.internal.ScriptDataSetScriptExecutor.handleFetch(ScriptDataSetScriptExecutor.java:153)</init>
    <init>... 104 more</init>
    org.eclipse.birt.report.engine.api.EngineException: Column binding "Work Order" has referred to a data set column "Work Order" which does not exist.
       at org.eclipse.birt.report.engine.executor.ExecutionContext.addException(ExecutionContext.java:1252)
       at org.eclipse.birt.report.engine.executor.ExecutionContext.addException(ExecutionContext.java:1231)
       at org.eclipse.birt.report.engine.executor.QueryItemExecutor.executeQuery(QueryItemExecutor.java:96)
       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:46)
       at org.eclipse.birt.report.engine.internal.executor.emitter.ReportItemEmitterExecutor.execute(ReportItemEmitterExecutor.java:46)
       at org.eclipse.birt.report.engine.internal.executor.dup.SuppressDuplicateItemExecutor.execute(SuppressDuplicateItemExecutor.java:43)
       at org.eclipse.birt.report.engine.layout.html.HTMLBlockStackingLM.layoutNodes(HTMLBlockStackingLM.java:65)
       at org.eclipse.birt.report.engine.layout.html.HTMLPageLM.layout(HTMLPageLM.java:92)
       at org.eclipse.birt.report.engine.layout.html.HTMLReportLayoutEngine.layout(HTMLReportLayoutEngine.java:100)
       at org.eclipse.birt.report.engine.presentation.ReportDocumentBuilder.build(ReportDocumentBuilder.java:258)
       at org.eclipse.birt.report.engine.api.impl.RunTask.doRun(RunTask.java:273)
       at org.eclipse.birt.report.engine.api.impl.RunTask.run(RunTask.java:89)
       at org.eclipse.birt.report.service.ReportEngineService.runReport(ReportEngineService.java:1325)
       at org.eclipse.birt.report.service.BirtViewerReportService.runReport(BirtViewerReportService.java:159)
       at org.eclipse.birt.report.service.actionhandler.BirtRunReportActionHandler.__execute(BirtRunReportActionHandler.java:81)
       at org.eclipse.birt.report.service.actionhandler.BirtChangeParameterActionHandler.runReport(BirtChangeParameterActionHandler.java:58)
       at org.eclipse.birt.report.service.actionhandler.AbstractChangeParameterActionHandler.__execute(AbstractChangeParameterActionHandler.java:52)
       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.handleChangeParameter(BirtDocumentProcessor.java:100)
       at java.base/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(DirectMethodHandleAccessor.java:104)
       at java.base/java.lang.reflect.Method.invoke(Method.java:578)
       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 java.base/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(DirectMethodHandleAccessor.java:104)
       at java.base/java.lang.reflect.Method.invoke(Method.java:578)
       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:707)
       at org.apache.axis.transport.http.AxisServletBase.service(AxisServletBase.java:327)
       at javax.servlet.http.HttpServlet.service(HttpServlet.java:790)
       at org.eclipse.birt.report.servlet.BirtSoapMessageDispatcherServlet.service(BirtSoapMessageDispatcherServlet.java:122)
       at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:865)
       at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1655)
       at org.eclipse.birt.report.filter.ViewerFilter.doFilter(ViewerFilter.java:68)
       at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1634)
       at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:533)
       at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:146)
       at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:548)
       at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:132)
       at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:257)
       at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:1595)
       at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:255)
       at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1253)
       at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:203)
       at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:473)
       at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:1564)
       at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:201)
       at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1155)
       at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:144)
       at org.eclipse.jetty.server.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:219)
       at org.eclipse.jetty.server.handler.HandlerCollection.handle(HandlerCollection.java:126)
       at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:132)
       at org.eclipse.jetty.server.Server.handle(Server.java:531)
       at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:352)
       at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:260)
       at org.eclipse.jetty.io.AbstractConnection$ReadCallback.succeeded(AbstractConnection.java:281)
       at org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:102)
       at org.eclipse.jetty.io.ChannelEndPoint$2.run(ChannelEndPoint.java:118)
       at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.runTask(EatWhatYouKill.java:333)
       at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.doProduce(EatWhatYouKill.java:310)
       at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.tryProduce(EatWhatYouKill.java:168)
       at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.run(EatWhatYouKill.java:126)
       at org.eclipse.jetty.util.thread.ReservedThreadExecutor$ReservedThread.run(ReservedThreadExecutor.java:366)
       at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:760)
       at org.eclipse.jetty.util.thread.QueuedThreadPool$2.run(QueuedThreadPool.java:678)
       at java.base/java.lang.Thread.run(Thread.java:1623)
    Caused by: org.eclipse.birt.data.engine.core.DataException: Column binding "Work Order" has referred to a data set column "Work Order" which does not exist.
       at org.eclipse.birt.data.engine.impl.ResultIterator.validateManualBindingExpressions(ResultIterator.java:380)
       at org.eclipse.birt.data.engine.impl.ResultIterator.<init>(ResultIterator.java:148)</init>
    <init>   at org.eclipse.birt.data.engine.impl.QueryResults.getResultIterator(QueryResults.java:222)</init>
    <init>   at org.eclipse.birt.report.engine.data.dte.QueryResultSet.(QueryResultSet.java:98)</init>
    <init>   at org.eclipse.birt.report.engine.data.dte.DteDataEngine.doExecuteQuery(DteDataEngine.java:168)</init>
    <init>   at org.eclipse.birt.report.engine.data.dte.DataGenerationEngine.doExecuteQuery(DataGenerationEngine.java:83)</init>
    <init>   at org.eclipse.birt.report.engine.data.dte.AbstractDataEngine.execute(AbstractDataEngine.java:286)</init>
    <init>   at org.eclipse.birt.report.engine.executor.ExecutionContext.executeQuery(ExecutionContext.java:1954)</init>
    <init>   at org.eclipse.birt.report.engine.executor.QueryItemExecutor.executeQuery(QueryItemExecutor.java:80)</init>
    <init><init>... 74 more</init></init>    "


    ------------------------------
    Philip Marrone
    Boston Children's Hospital
    ------------------------------

    Original Message


  • 9.  RE: BIRT 4.8 Error

    Posted 12-11-2023 16:22

    Fix your Select statement. I see missing commas and extra single quotes here and there.

    shop.BCH_PARshop',

     w.ASSETNUM

    w.LEAD',

    shop.BCH_GRPLDR',

    etc.



    ------------------------------
    Bob Kraus
    Missouri S&T
    ------------------------------

    Original Message


  • 10.  RE: BIRT 4.8 Error

    Posted 12-11-2023 16:41

    Thank you. I fixed that and received an error: "org.eclipse.birt.report.engine.api.EngineException: Column binding "Work Order" has referred to a data set column "Work Order" which does not exist,'"

    I only reference WONUM in the report and not "Work Order". For reference, here are my layout, output columns, parameters, and fetch script.

    if (!maximoDataSet.fetch())
    return (false);
     
    // Add a line for each output column
    // The specific get method should match the data type of the output column.
    row["WONUM"] = maximoDataSet.getInteger("WONUM");
    row["STATUS"] = maximoDataSet.getString("STATUS");
    row["SCHEDSTART"] = maximoDataSet.getDateTime("SCHEDSTART");
    row["FREQUENCY"] = maximoDataSet.getDecimal("FREQUENCY");
    row["FREQUNIT"] = maximoDataSet.getString("FREQUNIT");
    row["LOCATION"] = maximoDataSet.getString("LOCATION");
    row["DESCRIPTION"] = maximoDataSet.getString("DESCRIPTION");
    row["BCH_PARSHOP"] = maximoDataSet.getString("BCH_PARSHOP");
    row["ASSETNUM"] = maximoDataSet.getString("ASSETNUM");
    row["LEAD"] = maximoDataSet.getString("LEAD");
    row["BCH_PMREG"] = maximoDataSet.getString("BCH_PMREG");
    row["PMNUM"] = maximoDataSet.getString("PMNUM");
    row["BCH_GRPLDR"] = maximoDataSet.getString("BCH_GRPLDR");
    row["BCH_SHOPSUP"] = maximoDataSet.getString("BCH_SHOPSUP");
    row["REPORTDATE"] = maximoDataSet.getDateTime("REPORTDATE");
     
    return (true);


    ------------------------------
    Philip Marrone
    Boston Children's Hospital
    ------------------------------

    Original Message


  • 11.  RE: BIRT 4.8 Error

    Posted 12-12-2023 09:07

    Show me your Data Set

     

    Bob Kraus

    Senior Business Services Consultant  |  Facilities Services  |  Missouri S&T

    General Services Bldg, 1701 Spruce Dr, Rolla, MO 65409

     

    Email: krausr@mst.edu   Phone: 573-341-7288   Site: facilitiesoperations.mst.edu  

     

    Missouri S&T - Solving For Tomorrow

     

    Social: YouTube

     

     




    Original Message


  • 12.  RE: BIRT 4.8 Error

    Posted 12-12-2023 09:51

    Sure thing. Here is my data set. Below, I believe I found the culprit in the maintable, although I do not know how to remove it.

    Please see the below where I believe I may have found the issue:



    ------------------------------
    Philip Marrone
    Boston Children's Hospital
    ------------------------------

    Original Message


  • 13.  RE: BIRT 4.8 Error

    Posted 12-12-2023 10:02

    Go to the Layout Tab.

     

    Click the corner of the layout and click on Table (not Grid)

     

    Click on the Binding Tab. Here you can add, remove etc.

     

     

     

     

    Bob Kraus

    Senior Business Services Consultant  |  Facilities Services  |  Missouri S&T

    General Services Bldg, 1701 Spruce Dr, Rolla, MO 65409

     

    Email: krausr@mst.edu   Phone: 573-341-7288   Site: facilitiesoperations.mst.edu  

     

    Missouri S&T - Solving For Tomorrow

     

    Social: YouTube

     

     




    Original Message


  • 14.  RE: BIRT 4.8 Error

    Posted 12-12-2023 11:25

    Thank you, good sir. I have gotten further than before, but the report comes up blank:

    I thought perhaps that something was wrong with my column bindings, but from my limited knowledge they appear to be okay:

    Fetch script, just incase it is relevant here: 



    ------------------------------
    Philip Marrone
    Boston Children's Hospital
    ------------------------------

    Original Message


  • 15.  RE: BIRT 4.8 Error

    Posted 12-12-2023 11:35

    If your result comes up blank without any errors, recheck your SQL select statement.

    Can you clean it and run it in SQL to see what the number of records should be?

     

     

     

    Bob Kraus

    Senior Business Services Consultant  |  Facilities Services  |  Missouri S&T

    General Services Bldg, 1701 Spruce Dr, Rolla, MO 65409

     

    Email: krausr@mst.edu   Phone: 573-341-7288   Site: facilitiesoperations.mst.edu  

     

    Missouri S&T - Solving For Tomorrow

     

    Social: YouTube

     

     




    Original Message


  • 16.  RE: BIRT 4.8 Error

    Posted 12-12-2023 11:53

    Hello again,

    I ran in SQL and get 25 records. However, when I went back to run it again it runs as though the fetch script is null, even though I have not changed anything since the last time testing the report. Fetch script is still as I captured above (when it did work), and now I get the following stack trace error:

    org.eclipse.birt.report.engine.api.EngineException: There are errors evaluating script "if (!maximoDataSet.fetch())
    return (false);

    // Add a line for each output column
    // The specific get method should match the data type of the output column.
    row["WONUM"] = maximoDataSet.getInteger("WONUM");
    row["STATUS"] = maximoDataSet.getString("STATUS");
    row["SCHEDSTART"] = maximoDataSet.getDateTime("SCHEDSTART");
    row["FREQUENCY"] = maximoDataSet.getDecimal("FREQUENCY");
    row["FREQUNIT"] = maximoDataSet.getString("FREQUNIT");
    row["LOCATION"] = maximoDataSet.getString("LOCATION");
    row["DESCRIPTION"] = maximoDataSet.getString("DESCRIPTION");
    row["BCH_PARSHOP"] = maximoDataSet.getString("BCH_PARSHOP");
    row["ASSETNUM"] = maximoDataSet.getString("ASSETNUM");
    row["LEAD"] = maximoDataSet.getString("LEAD");
    row["BCH_PMREG"] = maximoDataSet.getString("BCH_PMREG");
    row["PMNUM"] = maximoDataSet.getString("PMNUM");
    row["BCH_GRPLDR"] = maximoDataSet.getString("BCH_GRPLDR");
    row["BCH_SHOPSUP"] = maximoDataSet.getString("BCH_SHOPSUP");
    row["REPORTDATE"] = maximoDataSet.getDateTime("REPORTDATE");

    return (true);":
    Fail to execute script in function __bm_FETCH(). Source:
    ------
    " + if (!maximoDataSet.fetch())
    return (false);

    // Add a line for each output column
    // The specific get method should match the data type of the output column.
    row["WONUM"] = maximoDataSet.getInteger("WONUM");
    row["STATUS"] = maximoDataSet.getString("STATUS");
    row["SCHEDSTART"] = maximoDataSet.getDateTime("SCHEDSTART");
    row["FREQUENCY"] = maximoDataSet.getDecimal("FREQUENCY");
    row["FREQUNIT"] = maximoDataSet.getString("FREQUNIT");
    row["LOCATION"] = maximoDataSet.getString("LOCATION");
    row["DESCRIPTION"] = maximoDataSet.getString("DESCRIPTION");
    row["BCH_PARSHOP"] = maximoDataSet.getString("BCH_PARSHOP");
    row["ASSETNUM"] = maximoDataSet.getString("ASSETNUM");
    row["LEAD"] = maximoDataSet.getString("LEAD");
    row["BCH_PMREG"] = maximoDataSet.getString("BCH_PMREG");
    row["PMNUM"] = maximoDataSet.getString("PMNUM");
    row["BCH_GRPLDR"] = maximoDataSet.getString("BCH_GRPLDR");
    row["BCH_SHOPSUP"] = maximoDataSet.getString("BCH_SHOPSUP");
    row["REPORTDATE"] = maximoDataSet.getDateTime("REPORTDATE");

    return (true); + "
    -----
    A BIRT exception occurred. See next exception for more information.
    Wrapped com.ibm.tivoli.maximo.report.script.MXReportRuntimeException: com.ibm.db2.jcc.am.SqlException: [jcc][10150][10300][4.26.14] Invalid parameter: Unknown column name STATUS. ERRORCODE=-4460, SQLSTATE=null (/report/data-sets/script-data-set[@id="5"]/method[@name="fetch"]#7).
       at org.eclipse.birt.report.engine.script.internal.DtEScriptExecutor.handleJS(DtEScriptExecutor.java:99)
       at org.eclipse.birt.report.engine.script.internal.DataSetScriptExecutor.handleJS(DataSetScriptExecutor.java:256)
       at org.eclipse.birt.report.engine.script.internal.ScriptDataSetScriptExecutor.handleFetch(ScriptDataSetScriptExecutor.java:143)
       at org.eclipse.birt.data.engine.impl.ScriptDataSetRuntime.fetch(ScriptDataSetRuntime.java:103)
       at org.eclipse.birt.data.engine.impl.PreparedScriptDSQuery$ScriptDSQueryExecutor$CustomDataSet.fetch(PreparedScriptDSQuery.java:260)
       at org.eclipse.birt.data.engine.executor.cache.OdiAdapter.fetch(OdiAdapter.java:226)
       at org.eclipse.birt.data.engine.executor.cache.RowResultSet.fetch(RowResultSet.java:145)
       at org.eclipse.birt.data.engine.executor.cache.RowResultSet.doNext(RowResultSet.java:118)
       at org.eclipse.birt.data.engine.executor.cache.RowResultSet.next(RowResultSet.java:96)
       at org.eclipse.birt.data.engine.executor.cache.ExpandableRowResultSet.next(ExpandableRowResultSet.java:63)
       at org.eclipse.birt.data.engine.executor.cache.SmartCacheHelper.populateData(SmartCacheHelper.java:318)
       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)</init>
    <init>   at org.eclipse.birt.data.engine.executor.transform.pass.PassUtil.populateOdiResultSet(PassUtil.java:110)</init>
    <init>   at org.eclipse.birt.data.engine.executor.transform.pass.PassUtil.pass(PassUtil.java:62)</init>
    <init>   at org.eclipse.birt.data.engine.executor.transform.pass.PassManager.doSinglePass(PassManager.java:170)</init>
    <init>   at org.eclipse.birt.data.engine.executor.transform.pass.PassManager.prepareDataSetResultSet(PassManager.java:94)</init>
    <init>   at org.eclipse.birt.data.engine.executor.transform.pass.PassManager.pass(PassManager.java:134)</init>
    <init>   at org.eclipse.birt.data.engine.executor.transform.pass.PassManager.populateResultSet(PassManager.java:74)</init>
    <init>   at org.eclipse.birt.data.engine.executor.transform.ResultSetPopulator.populateResultSet(ResultSetPopulator.java:218)</init>
    <init>   at org.eclipse.birt.data.engine.executor.transform.CachedResultSet.(CachedResultSet.java:200)</init>
    <init>   at org.eclipse.birt.data.engine.executor.CandidateQuery.execute(CandidateQuery.java:142)</init>
    <init>   at org.eclipse.birt.data.engine.impl.PreparedScriptDSQuery$ScriptDSQueryExecutor.executeOdiQuery(PreparedScriptDSQuery.java:226)</init>
    <init>   at org.eclipse.birt.data.engine.impl.QueryExecutor.execute(QueryExecutor.java:1257)</init>
    <init>   at org.eclipse.birt.data.engine.impl.ServiceForQueryResults.executeQuery(ServiceForQueryResults.java:233)</init>
    <init>   at org.eclipse.birt.data.engine.impl.QueryResults.getResultIterator(QueryResults.java:178)</init>
    <init>   at org.eclipse.birt.report.engine.data.dte.QueryResultSet.(QueryResultSet.java:98)</init>
    <init>   at org.eclipse.birt.report.engine.data.dte.DteDataEngine.doExecuteQuery(DteDataEngine.java:168)</init>
    <init>   at org.eclipse.birt.report.engine.data.dte.DataGenerationEngine.doExecuteQuery(DataGenerationEngine.java:83)</init>
    <init>   at org.eclipse.birt.report.engine.data.dte.AbstractDataEngine.execute(AbstractDataEngine.java:286)</init>
    <init>   at org.eclipse.birt.report.engine.executor.ExecutionContext.executeQuery(ExecutionContext.java:1954)</init>
    <init>   at org.eclipse.birt.report.engine.executor.QueryItemExecutor.executeQuery(QueryItemExecutor.java:80)</init>
    <init>   at org.eclipse.birt.report.engine.executor.TableItemExecutor.execute(TableItemExecutor.java:62)</init>
    <init>   at org.eclipse.birt.report.engine.internal.executor.wrap.WrappedReportItemExecutor.execute(WrappedReportItemExecutor.java:46)</init>
    <init>   at org.eclipse.birt.report.engine.internal.executor.emitter.ReportItemEmitterExecutor.execute(ReportItemEmitterExecutor.java:46)</init>
    <init>   at org.eclipse.birt.report.engine.internal.executor.dup.SuppressDuplicateItemExecutor.execute(SuppressDuplicateItemExecutor.java:43)</init>
    <init>   at org.eclipse.birt.report.engine.layout.html.HTMLBlockStackingLM.layoutNodes(HTMLBlockStackingLM.java:65)</init>
    <init>   at org.eclipse.birt.report.engine.layout.html.HTMLPageLM.layout(HTMLPageLM.java:92)</init>
    <init>   at org.eclipse.birt.report.engine.layout.html.HTMLReportLayoutEngine.layout(HTMLReportLayoutEngine.java:100)</init>
    <init>   at org.eclipse.birt.report.engine.presentation.ReportDocumentBuilder.build(ReportDocumentBuilder.java:258)</init>
    <init>   at org.eclipse.birt.report.engine.api.impl.RunTask.doRun(RunTask.java:273)</init>
    <init>   at org.eclipse.birt.report.engine.api.impl.RunTask.run(RunTask.java:89)</init>
    <init>   at org.eclipse.birt.report.service.ReportEngineService.runReport(ReportEngineService.java:1325)</init>
    <init>   at org.eclipse.birt.report.service.BirtViewerReportService.runReport(BirtViewerReportService.java:159)</init>
    <init>   at org.eclipse.birt.report.service.actionhandler.BirtRunReportActionHandler.__execute(BirtRunReportActionHandler.java:81)</init>
    <init>   at org.eclipse.birt.report.service.actionhandler.BirtChangeParameterActionHandler.runReport(BirtChangeParameterActionHandler.java:58)</init>
    <init>   at org.eclipse.birt.report.service.actionhandler.AbstractChangeParameterActionHandler.__execute(AbstractChangeParameterActionHandler.java:52)</init>
    <init>   at org.eclipse.birt.report.service.actionhandler.AbstractBaseActionHandler.execute(AbstractBaseActionHandler.java:90)</init>
    <init>   at org.eclipse.birt.report.soapengine.processor.AbstractBaseDocumentProcessor.__executeAction(AbstractBaseDocumentProcessor.java:47)</init>
    <init>   at org.eclipse.birt.report.soapengine.processor.AbstractBaseComponentProcessor.executeAction(AbstractBaseComponentProcessor.java:143)</init>
    <init>   at org.eclipse.birt.report.soapengine.processor.BirtDocumentProcessor.handleChangeParameter(BirtDocumentProcessor.java:100)</init>
    <init>   at java.base/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(DirectMethodHandleAccessor.java:104)</init>
    <init>   at java.base/java.lang.reflect.Method.invoke(Method.java:578)</init>
    <init>   at org.eclipse.birt.report.soapengine.processor.AbstractBaseComponentProcessor.process(AbstractBaseComponentProcessor.java:112)</init>
    <init>   at org.eclipse.birt.report.soapengine.endpoint.BirtSoapBindingImpl.getUpdatedObjects(BirtSoapBindingImpl.java:66)</init>
    <init>   at java.base/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(DirectMethodHandleAccessor.java:104)</init>
    <init>   at java.base/java.lang.reflect.Method.invoke(Method.java:578)</init>
    <init>   at org.apache.axis.providers.java.RPCProvider.invokeMethod(RPCProvider.java:397)</init>
    <init>   at org.apache.axis.providers.java.RPCProvider.processMessage(RPCProvider.java:186)</init>
    <init>   at org.apache.axis.providers.java.JavaProvider.invoke(JavaProvider.java:323)</init>
    <init>   at org.apache.axis.strategies.InvocationStrategy.visit(InvocationStrategy.java:32)</init>
    <init>   at org.apache.axis.SimpleChain.doVisiting(SimpleChain.java:118)</init>
    <init>   at org.apache.axis.SimpleChain.invoke(SimpleChain.java:83)</init>
    <init>   at org.apache.axis.handlers.soap.SOAPService.invoke(SOAPService.java:454)</init>
    <init>   at org.apache.axis.server.AxisServer.invoke(AxisServer.java:281)</init>
    <init>   at org.apache.axis.transport.http.AxisServlet.doPost(AxisServlet.java:699)</init>
    <init>   at org.eclipse.birt.report.servlet.BirtSoapMessageDispatcherServlet.doPost(BirtSoapMessageDispatcherServlet.java:265)</init>
    <init>   at javax.servlet.http.HttpServlet.service(HttpServlet.java:707)</init>
    <init>   at org.apache.axis.transport.http.AxisServletBase.service(AxisServletBase.java:327)</init>
    <init>   at javax.servlet.http.HttpServlet.service(HttpServlet.java:790)</init>
    <init>   at org.eclipse.birt.report.servlet.BirtSoapMessageDispatcherServlet.service(BirtSoapMessageDispatcherServlet.java:122)</init>
    <init>   at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:865)</init>
    <init>   at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1655)</init>
    <init>   at org.eclipse.birt.report.filter.ViewerFilter.doFilter(ViewerFilter.java:68)</init>
    <init>   at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1634)</init>
    <init>   at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:533)</init>
    <init>   at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:146)</init>
    <init>   at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:548)</init>
    <init>   at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:132)</init>
    <init>   at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:257)</init>
    <init>   at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:1595)</init>
    <init>   at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:255)</init>
    <init>   at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1253)</init>
    <init>   at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:203)</init>
    <init>   at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:473)</init>
    <init>   at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:1564)</init>
    <init>   at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:201)</init>
    <init>   at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1155)</init>
    <init>   at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:144)</init>
    <init>   at org.eclipse.jetty.server.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:219)</init>
    <init>   at org.eclipse.jetty.server.handler.HandlerCollection.handle(HandlerCollection.java:126)</init>
    <init>   at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:132)</init>
    <init>   at org.eclipse.jetty.server.Server.handle(Server.java:531)</init>
    <init>   at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:352)</init>
    <init>   at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:260)</init>
    <init>   at org.eclipse.jetty.io.AbstractConnection$ReadCallback.succeeded(AbstractConnection.java:281)</init>
    <init>   at org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:102)</init>
    <init>   at org.eclipse.jetty.io.ChannelEndPoint$2.run(ChannelEndPoint.java:118)</init>
    <init>   at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.runTask(EatWhatYouKill.java:333)</init>
    <init>   at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.doProduce(EatWhatYouKill.java:310)</init>
    <init>   at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.tryProduce(EatWhatYouKill.java:168)</init>
    <init>   at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.run(EatWhatYouKill.java:126)</init>
    <init>   at org.eclipse.jetty.util.thread.ReservedThreadExecutor$ReservedThread.run(ReservedThreadExecutor.java:366)</init>
    <init>   at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:760)</init>
    <init>   at org.eclipse.jetty.util.thread.QueuedThreadPool$2.run(QueuedThreadPool.java:678)</init>
    <init>   at java.base/java.lang.Thread.run(Thread.java:1623)</init>
    <init>Caused by: org.eclipse.birt.data.engine.core.DataException: Fail to execute script in function __bm_FETCH(). Source:</init>
    <init>------</init>
    <init>" + if (!maximoDataSet.fetch())</init>
    <init>return (false);</init>

    <init>// Add a line for each output column</init>
    <init>// The specific get method should match the data type of the output column.</init>
    <init>row["WONUM"] = maximoDataSet.getInteger("WONUM"); </init>
    <init>row["STATUS"] = maximoDataSet.getString("STATUS");</init>
    <init>row["SCHEDSTART"] = maximoDataSet.getDateTime("SCHEDSTART"); </init>
    <init>row["FREQUENCY"] = maximoDataSet.getDecimal("FREQUENCY");</init>
    <init>row["FREQUNIT"] = maximoDataSet.getString("FREQUNIT");</init>
    <init>row["LOCATION"] = maximoDataSet.getString("LOCATION"); </init>
    <init>row["DESCRIPTION"] = maximoDataSet.getString("DESCRIPTION");</init>
    <init>row["BCH_PARSHOP"] = maximoDataSet.getString("BCH_PARSHOP"); </init>
    <init>row["ASSETNUM"] = maximoDataSet.getString("ASSETNUM");</init>
    <init>row["LEAD"] = maximoDataSet.getString("LEAD");</init>
    <init>row["BCH_PMREG"] = maximoDataSet.getString("BCH_PMREG"); </init>
    <init>row["PMNUM"] = maximoDataSet.getString("PMNUM");</init>
    <init>row["BCH_GRPLDR"] = maximoDataSet.getString("BCH_GRPLDR"); </init>
    <init>row["BCH_SHOPSUP"] = maximoDataSet.getString("BCH_SHOPSUP");</init>
    <init>row["REPORTDATE"] = maximoDataSet.getDateTime("REPORTDATE");</init>

    <init>return (true); + "</init>
    <init>-----</init>
    <init>A BIRT exception occurred. See next exception for more information.</init>
    <init>Wrapped com.ibm.tivoli.maximo.report.script.MXReportRuntimeException: com.ibm.db2.jcc.am.SqlException: [jcc][10150][10300][4.26.14] Invalid parameter: Unknown column name STATUS. ERRORCODE=-4460, SQLSTATE=null (/report/data-sets/script-data-set[@id="5"]/method[@name="fetch"]#7)</init>
    <init>   at org.eclipse.birt.data.engine.script.JSMethodRunner.runScript(JSMethodRunner.java:147)</init>
    <init>   at org.eclipse.birt.report.engine.script.internal.DtEScriptExecutor.handleJS(DtEScriptExecutor.java:90)</init>
    <init>... 106 more</init>
    <init>Caused by: org.eclipse.birt.data.engine.core.DataException: A BIRT exception occurred. See next exception for more information.</init>
    <init>Wrapped com.ibm.tivoli.maximo.report.script.MXReportRuntimeException: com.ibm.db2.jcc.am.SqlException: [jcc][10150][10300][4.26.14] Invalid parameter: Unknown column name STATUS. ERRORCODE=-4460, SQLSTATE=null (/report/data-sets/script-data-set[@id="5"]/method[@name="fetch"]#7)</init>
    <init>   at org.eclipse.birt.data.engine.core.DataException.wrap(DataException.java:123)</init>
    <init>   at org.eclipse.birt.data.engine.script.ScriptEvalUtil.evaluateJSAsExpr(ScriptEvalUtil.java:1003)</init>
    <init>   at org.eclipse.birt.data.engine.script.JSMethodRunner.runScript(JSMethodRunner.java:138)</init>
    <init>... 107 more</init>
    <init>Caused by: org.eclipse.birt.core.exception.CoreException: Wrapped com.ibm.tivoli.maximo.report.script.MXReportRuntimeException: com.ibm.db2.jcc.am.SqlException: [jcc][10150][10300][4.26.14] Invalid parameter: Unknown column name STATUS. ERRORCODE=-4460, SQLSTATE=null (/report/data-sets/script-data-set[@id="5"]/method[@name="fetch"]#7)</init>
    <init>   at org.eclipse.birt.core.script.JavascriptEvalUtil.wrapRhinoException(JavascriptEvalUtil.java:307)</init>
    <init>   at org.eclipse.birt.core.script.JavascriptEvalUtil.evaluateRawScript(JavascriptEvalUtil.java:106)</init>
    <init>   at org.eclipse.birt.core.script.JavascriptEvalUtil.evaluateScript(JavascriptEvalUtil.java:138)</init>
    <init>   at org.eclipse.birt.data.engine.script.ScriptEvalUtil.evaluateJSAsExpr(ScriptEvalUtil.java:999)</init>
    <init>... 108 more</init>
    <init>Caused by: org.mozilla.javascript.WrappedException: Wrapped com.ibm.tivoli.maximo.report.script.MXReportRuntimeException: com.ibm.db2.jcc.am.SqlException: [jcc][10150][10300][4.26.14] Invalid parameter: Unknown column name STATUS. ERRORCODE=-4460, SQLSTATE=null (/report/data-sets/script-data-set[@id="5"]/method[@name="fetch"]#7)</init>
    <init>   at org.mozilla.javascript.Context.throwAsScriptRuntimeEx(Context.java:1754)</init>
    <init>   at org.mozilla.javascript.MemberBox.invoke(MemberBox.java:148)</init>
    <init>   at org.mozilla.javascript.NativeJavaMethod.call(NativeJavaMethod.java:225)</init>
    <init>   at org.mozilla.javascript.optimizer.OptRuntime.call1(OptRuntime.java:32)</init>
    <init>   at org.mozilla.javascript.gen._report_data_sets_script_data_set__id__5___method__name__fetch___60._c___bm_FETCH_1(/report/data-sets/script-data-set[@id="5"]/method[@name="fetch"]:7)</init>
    <init>   at org.mozilla.javascript.gen._report_data_sets_script_data_set__id__5___method__name__fetch___60.call(/report/data-sets/script-data-set[@id="5"]/method[@name="fetch"])</init>
    <init>   at org.mozilla.javascript.optimizer.OptRuntime.callName0(OptRuntime.java:74)</init>
    <init>   at org.mozilla.javascript.gen._report_data_sets_script_data_set__id__5___method__name__fetch___17._c_script_0(/report/data-sets/script-data-set[@id="5"]/method[@name="fetch"]:0)</init>
    <init>   at org.mozilla.javascript.gen._report_data_sets_script_data_set__id__5___method__name__fetch___17.call(/report/data-sets/script-data-set[@id="5"]/method[@name="fetch"])</init>
    <init>   at org.mozilla.javascript.ContextFactory.doTopCall(ContextFactory.java:394)</init>
    <init>   at org.mozilla.javascript.ScriptRuntime.doTopCall(ScriptRuntime.java:3091)</init>
    <init>   at org.mozilla.javascript.gen._report_data_sets_script_data_set__id__5___method__name__fetch___17.call(/report/data-sets/script-data-set[@id="5"]/method[@name="fetch"])</init>
    <init>   at org.mozilla.javascript.gen._report_data_sets_script_data_set__id__5___method__name__fetch___17.exec(/report/data-sets/script-data-set[@id="5"]/method[@name="fetch"])</init>
    <init>   at org.eclipse.birt.core.script.JavascriptEvalUtil.evaluateRawScript(JavascriptEvalUtil.java:99)</init>
    <init>... 110 more</init>
    <init>Caused by: com.ibm.tivoli.maximo.report.script.MXReportRuntimeException: com.ibm.db2.jcc.am.SqlException: [jcc][10150][10300][4.26.14] Invalid parameter: Unknown column name STATUS. ERRORCODE=-4460, SQLSTATE=null</init>
    <init>   at com.ibm.tivoli.maximo.report.script.MXReportDataSetImpl.getString(MXReportDataSetImpl.java:456)</init>
    <init>   at java.base/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(DirectMethodHandleAccessor.java:104)</init>
    <init>   at java.base/java.lang.reflect.Method.invoke(Method.java:578)</init>
    <init>   at org.mozilla.javascript.MemberBox.invoke(MemberBox.java:126)</init>
    <init>... 122 more</init>
    <init>Caused by: com.ibm.db2.jcc.am.SqlException: [jcc][10150][10300][4.26.14] Invalid parameter: Unknown column name STATUS. ERRORCODE=-4460, SQLSTATE=null</init>
    <init>   at com.ibm.db2.jcc.am.b7.a(b7.java:794)</init>
    <init>   at com.ibm.db2.jcc.am.b7.a(b7.java:66)</init>
    <init>   at com.ibm.db2.jcc.am.b7.a(b7.java:116)</init>
    <init>   at com.ibm.db2.jcc.am.ao.a(ao.java:2139)</init>
    <init>   at com.ibm.db2.jcc.am.ResultSet.findColumnX(ResultSet.java:2076)</init>
    <init>   at com.ibm.db2.jcc.am.ResultSet.getString(ResultSet.java:1787)</init>
    <init>   at com.ibm.tivoli.maximo.report.script.MXReportResultSet.getString(MXReportResultSet.java:541)</init>
    <init>   at com.ibm.tivoli.maximo.report.script.MXReportDataSetImpl.getString(MXReportDataSetImpl.java:438)</init>
    <init>... 125 more</init>
    org.eclipse.birt.report.engine.api.EngineException: Data Set script method "Fetch" returned null; expected a Boolean value.
       at org.eclipse.birt.report.engine.script.internal.ScriptExecutor.addException(ScriptExecutor.java:249)
       at org.eclipse.birt.report.engine.script.internal.ScriptExecutor.addException(ScriptExecutor.java:238)
       at org.eclipse.birt.report.engine.script.internal.ScriptDataSetScriptExecutor.handleFetch(ScriptDataSetScriptExecutor.java:165)
       at org.eclipse.birt.data.engine.impl.ScriptDataSetRuntime.fetch(ScriptDataSetRuntime.java:103)
       at org.eclipse.birt.data.engine.impl.PreparedScriptDSQuery$ScriptDSQueryExecutor$CustomDataSet.fetch(PreparedScriptDSQuery.java:260)
       at org.eclipse.birt.data.engine.executor.cache.OdiAdapter.fetch(OdiAdapter.java:226)
       at org.eclipse.birt.data.engine.executor.cache.RowResultSet.fetch(RowResultSet.java:145)
       at org.eclipse.birt.data.engine.executor.cache.RowResultSet.doNext(RowResultSet.java:118)
       at org.eclipse.birt.data.engine.executor.cache.RowResultSet.next(RowResultSet.java:96)
       at org.eclipse.birt.data.engine.executor.cache.ExpandableRowResultSet.next(ExpandableRowResultSet.java:63)
       at org.eclipse.birt.data.engine.executor.cache.SmartCacheHelper.populateData(SmartCacheHelper.java:318)
       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)</init>
    <init>   at org.eclipse.birt.data.engine.executor.transform.pass.PassUtil.populateOdiResultSet(PassUtil.java:110)</init>
    <init>   at org.eclipse.birt.data.engine.executor.transform.pass.PassUtil.pass(PassUtil.java:62)</init>
    <init>   at org.eclipse.birt.data.engine.executor.transform.pass.PassManager.doSinglePass(PassManager.java:170)</init>
    <init>   at org.eclipse.birt.data.engine.executor.transform.pass.PassManager.prepareDataSetResultSet(PassManager.java:94)</init>
    <init>   at org.eclipse.birt.data.engine.executor.transform.pass.PassManager.pass(PassManager.java:134)</init>
    <init>   at org.eclipse.birt.data.engine.executor.transform.pass.PassManager.populateResultSet(PassManager.java:74)</init>
    <init>   at org.eclipse.birt.data.engine.executor.transform.ResultSetPopulator.populateResultSet(ResultSetPopulator.java:218)</init>
    <init>   at org.eclipse.birt.data.engine.executor.transform.CachedResultSet.(CachedResultSet.java:200)</init>
    <init>   at org.eclipse.birt.data.engine.executor.CandidateQuery.execute(CandidateQuery.java:142)</init>
    <init>   at org.eclipse.birt.data.engine.impl.PreparedScriptDSQuery$ScriptDSQueryExecutor.executeOdiQuery(PreparedScriptDSQuery.java:226)</init>
    <init>   at org.eclipse.birt.data.engine.impl.QueryExecutor.execute(QueryExecutor.java:1257)</init>
    <init>   at org.eclipse.birt.data.engine.impl.ServiceForQueryResults.executeQuery(ServiceForQueryResults.java:233)</init>
    <init>   at org.eclipse.birt.data.engine.impl.QueryResults.getResultIterator(QueryResults.java:178)</init>
    <init>   at org.eclipse.birt.report.engine.data.dte.QueryResultSet.(QueryResultSet.java:98)</init>
    <init>   at org.eclipse.birt.report.engine.data.dte.DteDataEngine.doExecuteQuery(DteDataEngine.java:168)</init>
    <init>   at org.eclipse.birt.report.engine.data.dte.DataGenerationEngine.doExecuteQuery(DataGenerationEngine.java:83)</init>
    <init>   at org.eclipse.birt.report.engine.data.dte.AbstractDataEngine.execute(AbstractDataEngine.java:286)</init>
    <init>   at org.eclipse.birt.report.engine.executor.ExecutionContext.executeQuery(ExecutionContext.java:1954)</init>
    <init>   at org.eclipse.birt.report.engine.executor.QueryItemExecutor.executeQuery(QueryItemExecutor.java:80)</init>
    <init>   at org.eclipse.birt.report.engine.executor.TableItemExecutor.execute(TableItemExecutor.java:62)</init>
    <init>   at org.eclipse.birt.report.engine.internal.executor.wrap.WrappedReportItemExecutor.execute(WrappedReportItemExecutor.java:46)</init>
    <init>   at org.eclipse.birt.report.engine.internal.executor.emitter.ReportItemEmitterExecutor.execute(ReportItemEmitterExecutor.java:46)</init>
    <init>   at org.eclipse.birt.report.engine.internal.executor.dup.SuppressDuplicateItemExecutor.execute(SuppressDuplicateItemExecutor.java:43)</init>
    <init>   at org.eclipse.birt.report.engine.layout.html.HTMLBlockStackingLM.layoutNodes(HTMLBlockStackingLM.java:65)</init>
    <init>   at org.eclipse.birt.report.engine.layout.html.HTMLPageLM.layout(HTMLPageLM.java:92)</init>
    <init>   at org.eclipse.birt.report.engine.layout.html.HTMLReportLayoutEngine.layout(HTMLReportLayoutEngine.java:100)</init>
    <init>   at org.eclipse.birt.report.engine.presentation.ReportDocumentBuilder.build(ReportDocumentBuilder.java:258)</init>
    <init>   at org.eclipse.birt.report.engine.api.impl.RunTask.doRun(RunTask.java:273)</init>
    <init>   at org.eclipse.birt.report.engine.api.impl.RunTask.run(RunTask.java:89)</init>
    <init>   at org.eclipse.birt.report.service.ReportEngineService.runReport(ReportEngineService.java:1325)</init>
    <init>   at org.eclipse.birt.report.service.BirtViewerReportService.runReport(BirtViewerReportService.java:159)</init>
    <init>   at org.eclipse.birt.report.service.actionhandler.BirtRunReportActionHandler.__execute(BirtRunReportActionHandler.java:81)</init>
    <init>   at org.eclipse.birt.report.service.actionhandler.BirtChangeParameterActionHandler.runReport(BirtChangeParameterActionHandler.java:58)</init>
    <init>   at org.eclipse.birt.report.service.actionhandler.AbstractChangeParameterActionHandler.__execute(AbstractChangeParameterActionHandler.java:52)</init>
    <init>   at org.eclipse.birt.report.service.actionhandler.AbstractBaseActionHandler.execute(AbstractBaseActionHandler.java:90)</init>
    <init>   at org.eclipse.birt.report.soapengine.processor.AbstractBaseDocumentProcessor.__executeAction(AbstractBaseDocumentProcessor.java:47)</init>
    <init>   at org.eclipse.birt.report.soapengine.processor.AbstractBaseComponentProcessor.executeAction(AbstractBaseComponentProcessor.java:143)</init>
    <init>   at org.eclipse.birt.report.soapengine.processor.BirtDocumentProcessor.handleChangeParameter(BirtDocumentProcessor.java:100)</init>
    <init>   at java.base/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(DirectMethodHandleAccessor.java:104)</init>
    <init>   at java.base/java.lang.reflect.Method.invoke(Method.java:578)</init>
    <init>   at org.eclipse.birt.report.soapengine.processor.AbstractBaseComponentProcessor.process(AbstractBaseComponentProcessor.java:112)</init>
    <init>   at org.eclipse.birt.report.soapengine.endpoint.BirtSoapBindingImpl.getUpdatedObjects(BirtSoapBindingImpl.java:66)</init>
    <init>   at java.base/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(DirectMethodHandleAccessor.java:104)</init>
    <init>   at java.base/java.lang.reflect.Method.invoke(Method.java:578)</init>
    <init>   at org.apache.axis.providers.java.RPCProvider.invokeMethod(RPCProvider.java:397)</init>
    <init>   at org.apache.axis.providers.java.RPCProvider.processMessage(RPCProvider.java:186)</init>
    <init>   at org.apache.axis.providers.java.JavaProvider.invoke(JavaProvider.java:323)</init>
    <init>   at org.apache.axis.strategies.InvocationStrategy.visit(InvocationStrategy.java:32)</init>
    <init>   at org.apache.axis.SimpleChain.doVisiting(SimpleChain.java:118)</init>
    <init>   at org.apache.axis.SimpleChain.invoke(SimpleChain.java:83)</init>
    <init>   at org.apache.axis.handlers.soap.SOAPService.invoke(SOAPService.java:454)</init>
    <init>   at org.apache.axis.server.AxisServer.invoke(AxisServer.java:281)</init>
    <init>   at org.apache.axis.transport.http.AxisServlet.doPost(AxisServlet.java:699)</init>
    <init>   at org.eclipse.birt.report.servlet.BirtSoapMessageDispatcherServlet.doPost(BirtSoapMessageDispatcherServlet.java:265)</init>
    <init>   at javax.servlet.http.HttpServlet.service(HttpServlet.java:707)</init>
    <init>   at org.apache.axis.transport.http.AxisServletBase.service(AxisServletBase.java:327)</init>
    <init>   at javax.servlet.http.HttpServlet.service(HttpServlet.java:790)</init>
    <init>   at org.eclipse.birt.report.servlet.BirtSoapMessageDispatcherServlet.service(BirtSoapMessageDispatcherServlet.java:122)</init>
    <init>   at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:865)</init>
    <init>   at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1655)</init>
    <init>   at org.eclipse.birt.report.filter.ViewerFilter.doFilter(ViewerFilter.java:68)</init>
    <init>   at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1634)</init>
    <init>   at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:533)</init>
    <init>   at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:146)</init>
    <init>   at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:548)</init>
    <init>   at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:132)</init>
    <init>   at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:257)</init>
    <init>   at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:1595)</init>
    <init>   at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:255)</init>
    <init>   at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1253)</init>
    <init>   at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:203)</init>
    <init>   at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:473)</init>
    <init>   at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:1564)</init>
    <init>   at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:201)</init>
    <init>   at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1155)</init>
    <init>   at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:144)</init>
    <init>   at org.eclipse.jetty.server.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:219)</init>
    <init>   at org.eclipse.jetty.server.handler.HandlerCollection.handle(HandlerCollection.java:126)</init>
    <init>   at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:132)</init>
    <init>   at org.eclipse.jetty.server.Server.handle(Server.java:531)</init>
    <init>   at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:352)</init>
    <init>   at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:260)</init>
    <init>   at org.eclipse.jetty.io.AbstractConnection$ReadCallback.succeeded(AbstractConnection.java:281)</init>
    <init>   at org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:102)</init>
    <init>   at org.eclipse.jetty.io.ChannelEndPoint$2.run(ChannelEndPoint.java:118)</init>
    <init>   at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.runTask(EatWhatYouKill.java:333)</init>
    <init>   at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.doProduce(EatWhatYouKill.java:310)</init>
    <init>   at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.tryProduce(EatWhatYouKill.java:168)</init>
    <init>   at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.run(EatWhatYouKill.java:126)</init>
    <init>   at org.eclipse.jetty.util.thread.ReservedThreadExecutor$ReservedThread.run(ReservedThreadExecutor.java:366)</init>
    <init>   at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:760)</init>
    <init>   at org.eclipse.jetty.util.thread.QueuedThreadPool$2.run(QueuedThreadPool.java:678)</init>
    <init>   at java.base/java.lang.Thread.run(Thread.java:1623)</init>
    <init>Caused by: org.eclipse.birt.data.engine.core.DataException: Data Set script method "Fetch" returned null; expected a Boolean value.</init>
    <init>   at org.eclipse.birt.report.engine.script.internal.ScriptDataSetScriptExecutor.handleFetch(ScriptDataSetScriptExecutor.java:153)</init>
    <init>... 104 more</init>
    org.eclipse.birt.report.engine.api.EngineException: There are errors evaluating script "if (!maximoDataSet.fetch())
    return (false);

    // Add a line for each output column
    // The specific get method should match the data type of the output column.
    row["WONUM"] = maximoDataSet.getInteger("WONUM");
    row["STATUS"] = maximoDataSet.getString("STATUS");
    row["SCHEDSTART"] = maximoDataSet.getDateTime("SCHEDSTART");
    row["FREQUENCY"] = maximoDataSet.getDecimal("FREQUENCY");
    row["FREQUNIT"] = maximoDataSet.getString("FREQUNIT");
    row["LOCATION"] = maximoDataSet.getString("LOCATION");
    row["DESCRIPTION"] = maximoDataSet.getString("DESCRIPTION");
    row["BCH_PARSHOP"] = maximoDataSet.getString("BCH_PARSHOP");
    row["ASSETNUM"] = maximoDataSet.getString("ASSETNUM");
    row["LEAD"] = maximoDataSet.getString("LEAD");
    row["BCH_PMREG"] = maximoDataSet.getString("BCH_PMREG");
    row["PMNUM"] = maximoDataSet.getString("PMNUM");
    row["BCH_GRPLDR"] = maximoDataSet.getString("BCH_GRPLDR");
    row["BCH_SHOPSUP"] = maximoDataSet.getString("BCH_SHOPSUP");
    row["REPORTDATE"] = maximoDataSet.getDateTime("REPORTDATE");

    return (true);":
    Fail to execute script in function __bm_FETCH(). Source:
    ------
    " + if (!maximoDataSet.fetch())
    return (false);

    // Add a line for each output column
    // The specific get method should match the data type of the output column.
    row["WONUM"] = maximoDataSet.getInteger("WONUM");
    row["STATUS"] = maximoDataSet.getString("STATUS");
    row["SCHEDSTART"] = maximoDataSet.getDateTime("SCHEDSTART");
    row["FREQUENCY"] = maximoDataSet.getDecimal("FREQUENCY");
    row["FREQUNIT"] = maximoDataSet.getString("FREQUNIT");
    row["LOCATION"] = maximoDataSet.getString("LOCATION");
    row["DESCRIPTION"] = maximoDataSet.getString("DESCRIPTION");
    row["BCH_PARSHOP"] = maximoDataSet.getString("BCH_PARSHOP");
    row["ASSETNUM"] = maximoDataSet.getString("ASSETNUM");
    row["LEAD"] = maximoDataSet.getString("LEAD");
    row["BCH_PMREG"] = maximoDataSet.getString("BCH_PMREG");
    row["PMNUM"] = maximoDataSet.getString("PMNUM");
    row["BCH_GRPLDR"] = maximoDataSet.getString("BCH_GRPLDR");
    row["BCH_SHOPSUP"] = maximoDataSet.getString("BCH_SHOPSUP");
    row["REPORTDATE"] = maximoDataSet.getDateTime("REPORTDATE");

    return (true); + "
    -----
    A BIRT exception occurred. See next exception for more information.
    Wrapped com.ibm.tivoli.maximo.report.script.MXReportRuntimeException: com.ibm.db2.jcc.am.SqlException: [jcc][10150][10300][4.26.14] Invalid parameter: Unknown column name STATUS. ERRORCODE=-4460, SQLSTATE=null (/report/data-sets/script-data-set[@id="5"]/method[@name="fetch"]#7).
       at org.eclipse.birt.report.engine.script.internal.DtEScriptExecutor.handleJS(DtEScriptExecutor.java:99)
       at org.eclipse.birt.report.engine.script.internal.DataSetScriptExecutor.handleJS(DataSetScriptExecutor.java:256)
       at org.eclipse.birt.report.engine.script.internal.ScriptDataSetScriptExecutor.handleFetch(ScriptDataSetScriptExecutor.java:143)
       at org.eclipse.birt.data.engine.impl.ScriptDataSetRuntime.fetch(ScriptDataSetRuntime.java:103)
       at org.eclipse.birt.data.engine.impl.PreparedScriptDSQuery$ScriptDSQueryExecutor$CustomDataSet.fetch(PreparedScriptDSQuery.java:260)
       at org.eclipse.birt.data.engine.executor.cache.OdiAdapter.fetch(OdiAdapter.java:226)
       at org.eclipse.birt.data.engine.executor.cache.RowResultSet.fetch(RowResultSet.java:145)
       at org.eclipse.birt.data.engine.executor.cache.RowResultSet.doNext(RowResultSet.java:118)
       at org.eclipse.birt.data.engine.executor.cache.RowResultSet.next(RowResultSet.java:96)
       at org.eclipse.birt.data.engine.executor.cache.ExpandableRowResultSet.next(ExpandableRowResultSet.java:63)
       at org.eclipse.birt.data.engine.executor.cache.SmartCacheHelper.populateData(SmartCacheHelper.java:318)
       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)</init>
    <init>   at org.eclipse.birt.data.engine.executor.transform.pass.PassUtil.populateOdiResultSet(PassUtil.java:110)</init>
    <init>   at org.eclipse.birt.data.engine.executor.transform.pass.PassUtil.pass(PassUtil.java:62)</init>
    <init>   at org.eclipse.birt.data.engine.executor.transform.pass.PassManager.doSinglePass(PassManager.java:170)</init>
    <init>   at org.eclipse.birt.data.engine.executor.transform.pass.PassManager.prepareDataSetResultSet(PassManager.java:94)</init>
    <init>   at org.eclipse.birt.data.engine.executor.transform.pass.PassManager.pass(PassManager.java:134)</init>
    <init>   at org.eclipse.birt.data.engine.executor.transform.pass.PassManager.populateResultSet(PassManager.java:74)</init>
    <init>   at org.eclipse.birt.data.engine.executor.transform.ResultSetPopulator.populateResultSet(ResultSetPopulator.java:218)</init>
    <init>   at org.eclipse.birt.data.engine.executor.transform.CachedResultSet.(CachedResultSet.java:200)</init>
    <init>   at org.eclipse.birt.data.engine.executor.CandidateQuery.execute(CandidateQuery.java:142)</init>
    <init>   at org.eclipse.birt.data.engine.impl.PreparedScriptDSQuery$ScriptDSQueryExecutor.executeOdiQuery(PreparedScriptDSQuery.java:226)</init>
    <init>   at org.eclipse.birt.data.engine.impl.QueryExecutor.execute(QueryExecutor.java:1257)</init>
    <init>   at org.eclipse.birt.data.engine.impl.ServiceForQueryResults.executeQuery(ServiceForQueryResults.java:233)</init>
    <init>   at org.eclipse.birt.data.engine.impl.QueryResults.getResultIterator(QueryResults.java:178)</init>
    <init>   at org.eclipse.birt.report.engine.data.dte.QueryResultSet.(QueryResultSet.java:115)</init>
    <init>   at org.eclipse.birt.report.engine.data.dte.DteDataEngine.doExecuteQuery(DteDataEngine.java:176)</init>
    <init>   at org.eclipse.birt.report.engine.data.dte.DataGenerationEngine.doExecuteQuery(DataGenerationEngine.java:83)</init>
    <init>   at org.eclipse.birt.report.engine.data.dte.AbstractDataEngine.execute(AbstractDataEngine.java:286)</init>
    <init>   at org.eclipse.birt.report.engine.executor.ExecutionContext.executeQuery(ExecutionContext.java:1954)</init>
    <init>   at org.eclipse.birt.report.engine.executor.QueryItemExecutor.executeQuery(QueryItemExecutor.java:80)</init>
    <init>   at org.eclipse.birt.report.engine.executor.DataItemExecutor.execute(DataItemExecutor.java:75)</init>
    <init>   at org.eclipse.birt.report.engine.internal.executor.wrap.WrappedReportItemExecutor.execute(WrappedReportItemExecutor.java:46)</init>
    <init>   at org.eclipse.birt.report.engine.internal.executor.emitter.ReportItemEmitterExecutor.execute(ReportItemEmitterExecutor.java:46)</init>
    <init>   at org.eclipse.birt.report.engine.internal.executor.dup.SuppressDuplicateItemExecutor.execute(SuppressDuplicateItemExecutor.java:43)</init>
    <init>   at org.eclipse.birt.report.engine.layout.html.HTMLAbstractLM.execute(HTMLAbstractLM.java:468)</init>
    <init>   at org.eclipse.birt.report.engine.layout.html.HTMLAbstractLM.execute(HTMLAbstractLM.java:476)</init>
    <init>   at org.eclipse.birt.report.engine.layout.html.HTMLAbstractLM.execute(HTMLAbstractLM.java:476)</init>
    <init>   at org.eclipse.birt.report.engine.layout.html.HTMLAbstractLM.execute(HTMLAbstractLM.java:476)</init>
    <init>   at org.eclipse.birt.report.engine.layout.html.HTMLAbstractLM.execute(HTMLAbstractLM.java:476)</init>
    <init>   at org.eclipse.birt.report.engine.layout.html.HTMLAbstractLM.execute(HTMLAbstractLM.java:476)</init>
    <init>   at org.eclipse.birt.report.engine.layout.html.HTMLListingBandLM.intializeHeaderContent(HTMLListingBandLM.java:98)</init>
    <init>   at org.eclipse.birt.report.engine.layout.html.HTMLListingBandLM.initialize(HTMLListingBandLM.java:50)</init>
    <init>   at org.eclipse.birt.report.engine.layout.html.HTMLTableBandLM.initialize(HTMLTableBandLM.java:44)</init>
    <init>   at org.eclipse.birt.report.engine.layout.html.HTMLLayoutManagerFactory.createLayoutManager(HTMLLayoutManagerFactory.java:40)</init>
    <init>   at org.eclipse.birt.report.engine.layout.html.HTMLReportLayoutEngine.createLayoutManager(HTMLReportLayoutEngine.java:138)</init>
    <init>   at org.eclipse.birt.report.engine.layout.html.HTMLBlockStackingLM.layoutNodes(HTMLBlockStackingLM.java:68)</init>
    <init>   at org.eclipse.birt.report.engine.layout.html.HTMLStackingLM.layoutChildren(HTMLStackingLM.java:26)</init>
    <init>   at org.eclipse.birt.report.engine.layout.html.HTMLRepeatHeaderLM.layoutChildren(HTMLRepeatHeaderLM.java:46)</init>
    <init>   at org.eclipse.birt.report.engine.layout.html.HTMLAbstractLM.layout(HTMLAbstractLM.java:140)</init>
    <init>   at org.eclipse.birt.report.engine.layout.html.HTMLBlockStackingLM.layoutNodes(HTMLBlockStackingLM.java:71)</init>
    <init>   at org.eclipse.birt.report.engine.layout.html.HTMLPageLM.layout(HTMLPageLM.java:92)</init>
    <init>   at org.eclipse.birt.report.engine.layout.html.HTMLReportLayoutEngine.layout(HTMLReportLayoutEngine.java:100)</init>
    <init>   at org.eclipse.birt.report.engine.presentation.ReportDocumentBuilder.build(ReportDocumentBuilder.java:258)</init>
    <init>   at org.eclipse.birt.report.engine.api.impl.RunTask.doRun(RunTask.java:273)</init>
    <init>   at org.eclipse.birt.report.engine.api.impl.RunTask.run(RunTask.java:89)</init>
    <init>   at org.eclipse.birt.report.service.ReportEngineService.runReport(ReportEngineService.java:1325)</init>
    <init>   at org.eclipse.birt.report.service.BirtViewerReportService.runReport(BirtViewerReportService.java:159)</init>
    <init>   at org.eclipse.birt.report.service.actionhandler.BirtRunReportActionHandler.__execute(BirtRunReportActionHandler.java:81)</init>
    <init>   at org.eclipse.birt.report.service.actionhandler.BirtChangeParameterActionHandler.runReport(BirtChangeParameterActionHandler.java:58)</init>
    <init>   at org.eclipse.birt.report.service.actionhandler.AbstractChangeParameterActionHandler.__execute(AbstractChangeParameterActionHandler.java:52)</init>
    <init>   at org.eclipse.birt.report.service.actionhandler.AbstractBaseActionHandler.execute(AbstractBaseActionHandler.java:90)</init>
    <init>   at org.eclipse.birt.report.soapengine.processor.AbstractBaseDocumentProcessor.__executeAction(AbstractBaseDocumentProcessor.java:47)</init>
    <init>   at org.eclipse.birt.report.soapengine.processor.AbstractBaseComponentProcessor.executeAction(AbstractBaseComponentProcessor.java:143)</init>
    <init>   at org.eclipse.birt.report.soapengine.processor.BirtDocumentProcessor.handleChangeParameter(BirtDocumentProcessor.java:100)</init>
    <init>   at java.base/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(DirectMethodHandleAccessor.java:104)</init>
    <init>   at java.base/java.lang.reflect.Method.invoke(Method.java:578)</init>
    <init>   at org.eclipse.birt.report.soapengine.processor.AbstractBaseComponentProcessor.process(AbstractBaseComponentProcessor.java:112)</init>
    <init>   at org.eclipse.birt.report.soapengine.endpoint.BirtSoapBindingImpl.getUpdatedObjects(BirtSoapBindingImpl.java:66)</init>
    <init>   at java.base/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(DirectMethodHandleAccessor.java:104)</init>
    <init>   at java.base/java.lang.reflect.Method.invoke(Method.java:578)</init>
    <init>   at org.apache.axis.providers.java.RPCProvider.invokeMethod(RPCProvider.java:397)</init>
    <init>   at org.apache.axis.providers.java.RPCProvider.processMessage(RPCProvider.java:186)</init>
    <init>   at org.apache.axis.providers.java.JavaProvider.invoke(JavaProvider.java:323)</init>
    <init>   at org.apache.axis.strategies.InvocationStrategy.visit(InvocationStrategy.java:32)</init>
    <init>   at org.apache.axis.SimpleChain.doVisiting(SimpleChain.java:118)</init>
    <init>   at org.apache.axis.SimpleChain.invoke(SimpleChain.java:83)</init>
    <init>   at org.apache.axis.handlers.soap.SOAPService.invoke(SOAPService.java:454)</init>
    <init>   at org.apache.axis.server.AxisServer.invoke(AxisServer.java:281)</init>
    <init>   at org.apache.axis.transport.http.AxisServlet.doPost(AxisServlet.java:699)</init>
    <init>   at org.eclipse.birt.report.servlet.BirtSoapMessageDispatcherServlet.doPost(BirtSoapMessageDispatcherServlet.java:265)</init>
    <init>   at javax.servlet.http.HttpServlet.service(HttpServlet.java:707)</init>
    <init>   at org.apache.axis.transport.http.AxisServletBase.service(AxisServletBase.java:327)</init>
    <init>   at javax.servlet.http.HttpServlet.service(HttpServlet.java:790)</init>
    <init>   at org.eclipse.birt.report.servlet.BirtSoapMessageDispatcherServlet.service(BirtSoapMessageDispatcherServlet.java:122)</init>
    <init>   at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:865)</init>
    <init>   at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1655)</init>
    <init>   at org.eclipse.birt.report.filter.ViewerFilter.doFilter(ViewerFilter.java:68)</init>
    <init>   at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1634)</init>
    <init>   at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:533)</init>
    <init>   at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:146)</init>
    <init>   at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:548)</init>
    <init>   at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:132)</init>
    <init>   at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:257)</init>
    <init>   at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:1595)</init>
    <init>   at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:255)</init>
    <init>   at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1253)</init>
    <init>   at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:203)</init>
    <init>   at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:473)</init>
    <init>   at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:1564)</init>
    <init>   at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:201)</init>
    <init>   at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1155)</init>
    <init>   at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:144)</init>
    <init>   at org.eclipse.jetty.server.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:219)</init>
    <init>   at org.eclipse.jetty.server.handler.HandlerCollection.handle(HandlerCollection.java:126)</init>
    <init>   at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:132)</init>
    <init>   at org.eclipse.jetty.server.Server.handle(Server.java:531)</init>
    <init>   at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:352)</init>
    <init>   at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:260)</init>
    <init>   at org.eclipse.jetty.io.AbstractConnection$ReadCallback.succeeded(AbstractConnection.java:281)</init>
    <init>   at org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:102)</init>
    <init>   at org.eclipse.jetty.io.ChannelEndPoint$2.run(ChannelEndPoint.java:118)</init>
    <init>   at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.runTask(EatWhatYouKill.java:333)</init>
    <init>   at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.doProduce(EatWhatYouKill.java:310)</init>
    <init>   at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.tryProduce(EatWhatYouKill.java:168)</init>
    <init>   at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.run(EatWhatYouKill.java:126)</init>
    <init>   at org.eclipse.jetty.util.thread.ReservedThreadExecutor$ReservedThread.run(ReservedThreadExecutor.java:366)</init>
    <init>   at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:760)</init>
    <init>   at org.eclipse.jetty.util.thread.QueuedThreadPool$2.run(QueuedThreadPool.java:678)</init>
    <init>   at java.base/java.lang.Thread.run(Thread.java:1623)</init>
    <init>Caused by: org.eclipse.birt.data.engine.core.DataException: Fail to execute script in function __bm_FETCH(). Source:</init>
    <init>------</init>
    <init>" + if (!maximoDataSet.fetch())</init>
    <init>return (false);</init>

    <init>// Add a line for each output column</init>
    <init>// The specific get method should match the data type of the output column.</init>
    <init>row["WONUM"] = maximoDataSet.getInteger("WONUM"); </init>
    <init>row["STATUS"] = maximoDataSet.getString("STATUS");</init>
    <init>row["SCHEDSTART"] = maximoDataSet.getDateTime("SCHEDSTART"); </init>
    <init>row["FREQUENCY"] = maximoDataSet.getDecimal("FREQUENCY");</init>
    <init>row["FREQUNIT"] = maximoDataSet.getString("FREQUNIT");</init>
    <init>row["LOCATION"] = maximoDataSet.getString("LOCATION"); </init>
    <init>row["DESCRIPTION"] = maximoDataSet.getString("DESCRIPTION");</init>
    <init>row["BCH_PARSHOP"] = maximoDataSet.getString("BCH_PARSHOP"); </init>
    <init>row["ASSETNUM"] = maximoDataSet.getString("ASSETNUM");</init>
    <init>row["LEAD"] = maximoDataSet.getString("LEAD");</init>
    <init>row["BCH_PMREG"] = maximoDataSet.getString("BCH_PMREG"); </init>
    <init>row["PMNUM"] = maximoDataSet.getString("PMNUM");</init>
    <init>row["BCH_GRPLDR"] = maximoDataSet.getString("BCH_GRPLDR"); </init>
    <init>row["BCH_SHOPSUP"] = maximoDataSet.getString("BCH_SHOPSUP");</init>
    <init>row["REPORTDATE"] = maximoDataSet.getDateTime("REPORTDATE");</init>

    <init>return (true); + "</init>
    <init>-----</init>
    <init>A BIRT exception occurred. See next exception for more information.</init>
    <init>Wrapped com.ibm.tivoli.maximo.report.script.MXReportRuntimeException: com.ibm.db2.jcc.am.SqlException: [jcc][10150][10300][4.26.14] Invalid parameter: Unknown column name STATUS. ERRORCODE=-4460, SQLSTATE=null (/report/data-sets/script-data-set[@id="5"]/method[@name="fetch"]#7)</init>
    <init>   at org.eclipse.birt.data.engine.script.JSMethodRunner.runScript(JSMethodRunner.java:147)</init>
    <init>   at org.eclipse.birt.report.engine.script.internal.DtEScriptExecutor.handleJS(DtEScriptExecutor.java:90)</init>
    <init>... 121 more</init>
    <init>Caused by: org.eclipse.birt.data.engine.core.DataException: A BIRT exception occurred. See next exception for more information.</init>
    <init>Wrapped com.ibm.tivoli.maximo.report.script.MXReportRuntimeException: com.ibm.db2.jcc.am.SqlException: [jcc][10150][10300][4.26.14] Invalid parameter: Unknown column name STATUS. ERRORCODE=-4460, SQLSTATE=null (/report/data-sets/script-data-set[@id="5"]/method[@name="fetch"]#7)</init>
    <init>   at org.eclipse.birt.data.engine.core.DataException.wrap(DataException.java:123)</init>
    <init>   at org.eclipse.birt.data.engine.script.ScriptEvalUtil.evaluateJSAsExpr(ScriptEvalUtil.java:1003)</init>
    <init>   at org.eclipse.birt.data.engine.script.JSMethodRunner.runScript(JSMethodRunner.java:138)</init>
    <init>... 122 more</init>
    <init>Caused by: org.eclipse.birt.core.exception.CoreException: Wrapped com.ibm.tivoli.maximo.report.script.MXReportRuntimeException: com.ibm.db2.jcc.am.SqlException: [jcc][10150][10300][4.26.14] Invalid parameter: Unknown column name STATUS. ERRORCODE=-4460, SQLSTATE=null (/report/data-sets/script-data-set[@id="5"]/method[@name="fetch"]#7)</init>
    <init>   at org.eclipse.birt.core.script.JavascriptEvalUtil.wrapRhinoException(JavascriptEvalUtil.java:307)</init>
    <init>   at org.eclipse.birt.core.script.JavascriptEvalUtil.evaluateRawScript(JavascriptEvalUtil.java:106)</init>
    <init>   at org.eclipse.birt.core.script.JavascriptEvalUtil.evaluateScript(JavascriptEvalUtil.java:138)</init>
    <init>   at org.eclipse.birt.data.engine.script.ScriptEvalUtil.evaluateJSAsExpr(ScriptEvalUtil.java:999)</init>
    <init>... 123 more</init>
    <init>Caused by: org.mozilla.javascript.WrappedException: Wrapped com.ibm.tivoli.maximo.report.script.MXReportRuntimeException: com.ibm.db2.jcc.am.SqlException: [jcc][10150][10300][4.26.14] Invalid parameter: Unknown column name STATUS. ERRORCODE=-4460, SQLSTATE=null (/report/data-sets/script-data-set[@id="5"]/method[@name="fetch"]#7)</init>
    <init>   at org.mozilla.javascript.Context.throwAsScriptRuntimeEx(Context.java:1754)</init>
    <init>   at org.mozilla.javascript.MemberBox.invoke(MemberBox.java:148)</init>
    <init>   at org.mozilla.javascript.NativeJavaMethod.call(NativeJavaMethod.java:225)</init>
    <init>   at org.mozilla.javascript.optimizer.OptRuntime.call1(OptRuntime.java:32)</init>
    <init>   at org.mozilla.javascript.gen._report_data_sets_script_data_set__id__5___method__name__fetch___60._c___bm_FETCH_1(/report/data-sets/script-data-set[@id="5"]/method[@name="fetch"]:7)</init>
    <init>   at org.mozilla.javascript.gen._report_data_sets_script_data_set__id__5___method__name__fetch___60.call(/report/data-sets/script-data-set[@id="5"]/method[@name="fetch"])</init>
    <init>   at org.mozilla.javascript.optimizer.OptRuntime.callName0(OptRuntime.java:74)</init>
    <init>   at org.mozilla.javascript.gen._report_data_sets_script_data_set__id__5___method__name__fetch___17._c_script_0(/report/data-sets/script-data-set[@id="5"]/method[@name="fetch"]:0)</init>
    <init>   at org.mozilla.javascript.gen._report_data_sets_script_data_set__id__5___method__name__fetch___17.call(/report/data-sets/script-data-set[@id="5"]/method[@name="fetch"])</init>
    <init>   at org.mozilla.javascript.ContextFactory.doTopCall(ContextFactory.java:394)</init>
    <init>   at org.mozilla.javascript.ScriptRuntime.doTopCall(ScriptRuntime.java:3091)</init>
    <init>   at org.mozilla.javascript.gen._report_data_sets_script_data_set__id__5___method__name__fetch___17.call(/report/data-sets/script-data-set[@id="5"]/method[@name="fetch"])</init>
    <init>   at org.mozilla.javascript.gen._report_data_sets_script_data_set__id__5___method__name__fetch___17.exec(/report/data-sets/script-data-set[@id="5"]/method[@name="fetch"])</init>
    <init>   at org.eclipse.birt.core.script.JavascriptEvalUtil.evaluateRawScript(JavascriptEvalUtil.java:99)</init>
    <init>... 125 more</init>
    <init>Caused by: com.ibm.tivoli.maximo.report.script.MXReportRuntimeException: com.ibm.db2.jcc.am.SqlException: [jcc][10150][10300][4.26.14] Invalid parameter: Unknown column name STATUS. ERRORCODE=-4460, SQLSTATE=null</init>
    <init>   at com.ibm.tivoli.maximo.report.script.MXReportDataSetImpl.getString(MXReportDataSetImpl.java:456)</init>
    <init>   at java.base/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(DirectMethodHandleAccessor.java:104)</init>
    <init>   at java.base/java.lang.reflect.Method.invoke(Method.java:578)</init>
    <init>   at org.mozilla.javascript.MemberBox.invoke(MemberBox.java:126)</init>
    <init>... 137 more</init>
    <init>Caused by: com.ibm.db2.jcc.am.SqlException: [jcc][10150][10300][4.26.14] Invalid parameter: Unknown column name STATUS. ERRORCODE=-4460, SQLSTATE=null</init>
    <init>   at com.ibm.db2.jcc.am.b7.a(b7.java:794)</init>
    <init>   at com.ibm.db2.jcc.am.b7.a(b7.java:66)</init>
    <init>   at com.ibm.db2.jcc.am.b7.a(b7.java:116)</init>
    <init>   at com.ibm.db2.jcc.am.ao.a(ao.java:2139)</init>
    <init>   at com.ibm.db2.jcc.am.ResultSet.findColumnX(ResultSet.java:2076)</init>
    <init>   at com.ibm.db2.jcc.am.ResultSet.getString(ResultSet.java:1787)</init>
    <init>   at com.ibm.tivoli.maximo.report.script.MXReportResultSet.getString(MXReportResultSet.java:541)</init>
    <init>   at com.ibm.tivoli.maximo.report.script.MXReportDataSetImpl.getString(MXReportDataSetImpl.java:438)</init>
    <init>... 140 more</init>
    org.eclipse.birt.report.engine.api.EngineException: Data Set script method "Fetch" returned null; expected a Boolean value.
       at org.eclipse.birt.report.engine.script.internal.ScriptExecutor.addException(ScriptExecutor.java:249)
       at org.eclipse.birt.report.engine.script.internal.ScriptExecutor.addException(ScriptExecutor.java:238)
       at org.eclipse.birt.report.engine.script.internal.ScriptDataSetScriptExecutor.handleFetch(ScriptDataSetScriptExecutor.java:165)
       at org.eclipse.birt.data.engine.impl.ScriptDataSetRuntime.fetch(ScriptDataSetRuntime.java:103)
       at org.eclipse.birt.data.engine.impl.PreparedScriptDSQuery$ScriptDSQueryExecutor$CustomDataSet.fetch(PreparedScriptDSQuery.java:260)
       at org.eclipse.birt.data.engine.executor.cache.OdiAdapter.fetch(OdiAdapter.java:226)
       at org.eclipse.birt.data.engine.executor.cache.RowResultSet.fetch(RowResultSet.java:145)
       at org.eclipse.birt.data.engine.executor.cache.RowResultSet.doNext(RowResultSet.java:118)
       at org.eclipse.birt.data.engine.executor.cache.RowResultSet.next(RowResultSet.java:96)
       at org.eclipse.birt.data.engine.executor.cache.ExpandableRowResultSet.next(ExpandableRowResultSet.java:63)
       at org.eclipse.birt.data.engine.executor.cache.SmartCacheHelper.populateData(SmartCacheHelper.java:318)
       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)</init>
    <init>   at org.eclipse.birt.data.engine.executor.transform.pass.PassUtil.populateOdiResultSet(PassUtil.java:110)</init>
    <init>   at org.eclipse.birt.data.engine.executor.transform.pass.PassUtil.pass(PassUtil.java:62)</init>
    <init>   at org.eclipse.birt.data.engine.executor.transform.pass.PassManager.doSinglePass(PassManager.java:170)</init>
    <init>   at org.eclipse.birt.data.engine.executor.transform.pass.PassManager.prepareDataSetResultSet(PassManager.java:94)</init>
    <init>   at org.eclipse.birt.data.engine.executor.transform.pass.PassManager.pass(PassManager.java:134)</init>
    <init>   at org.eclipse.birt.data.engine.executor.transform.pass.PassManager.populateResultSet(PassManager.java:74)</init>
    <init>   at org.eclipse.birt.data.engine.executor.transform.ResultSetPopulator.populateResultSet(ResultSetPopulator.java:218)</init>
    <init>   at org.eclipse.birt.data.engine.executor.transform.CachedResultSet.(CachedResultSet.java:200)</init>
    <init>   at org.eclipse.birt.data.engine.executor.CandidateQuery.execute(CandidateQuery.java:142)</init>
    <init>   at org.eclipse.birt.data.engine.impl.PreparedScriptDSQuery$ScriptDSQueryExecutor.executeOdiQuery(PreparedScriptDSQuery.java:226)</init>
    <init>   at org.eclipse.birt.data.engine.impl.QueryExecutor.execute(QueryExecutor.java:1257)</init>
    <init>   at org.eclipse.birt.data.engine.impl.ServiceForQueryResults.executeQuery(ServiceForQueryResults.java:233)</init>
    <init>   at org.eclipse.birt.data.engine.impl.QueryResults.getResultIterator(QueryResults.java:178)</init>
    <init>   at org.eclipse.birt.report.engine.data.dte.QueryResultSet.(QueryResultSet.java:115)</init>
    <init>   at org.eclipse.birt.report.engine.data.dte.DteDataEngine.doExecuteQuery(DteDataEngine.java:176)</init>
    <init>   at org.eclipse.birt.report.engine.data.dte.DataGenerationEngine.doExecuteQuery(DataGenerationEngine.java:83)</init>
    <init>   at org.eclipse.birt.report.engine.data.dte.AbstractDataEngine.execute(AbstractDataEngine.java:286)</init>
    <init>   at org.eclipse.birt.report.engine.executor.ExecutionContext.executeQuery(ExecutionContext.java:1954)</init>
    <init>   at org.eclipse.birt.report.engine.executor.QueryItemExecutor.executeQuery(QueryItemExecutor.java:80)</init>
    <init>   at org.eclipse.birt.report.engine.executor.DataItemExecutor.execute(DataItemExecutor.java:75)</init>
    <init>   at org.eclipse.birt.report.engine.internal.executor.wrap.WrappedReportItemExecutor.execute(WrappedReportItemExecutor.java:46)</init>
    <init>   at org.eclipse.birt.report.engine.internal.executor.emitter.ReportItemEmitterExecutor.execute(ReportItemEmitterExecutor.java:46)</init>
    <init>   at org.eclipse.birt.report.engine.internal.executor.dup.SuppressDuplicateItemExecutor.execute(SuppressDuplicateItemExecutor.java:43)</init>
    <init>   at org.eclipse.birt.report.engine.layout.html.HTMLAbstractLM.execute(HTMLAbstractLM.java:468)</init>
    <init>   at org.eclipse.birt.report.engine.layout.html.HTMLAbstractLM.execute(HTMLAbstractLM.java:476)</init>
    <init>   at org.eclipse.birt.report.engine.layout.html.HTMLAbstractLM.execute(HTMLAbstractLM.java:476)</init>
    <init>   at org.eclipse.birt.report.engine.layout.html.HTMLAbstractLM.execute(HTMLAbstractLM.java:476)</init>
    <init>   at org.eclipse.birt.report.engine.layout.html.HTMLAbstractLM.execute(HTMLAbstractLM.java:476)</init>
    <init>   at org.eclipse.birt.report.engine.layout.html.HTMLAbstractLM.execute(HTMLAbstractLM.java:476)</init>
    <init>   at org.eclipse.birt.report.engine.layout.html.HTMLListingBandLM.intializeHeaderContent(HTMLListingBandLM.java:98)</init>
    <init>   at org.eclipse.birt.report.engine.layout.html.HTMLListingBandLM.initialize(HTMLListingBandLM.java:50)</init>
    <init>   at org.eclipse.birt.report.engine.layout.html.HTMLTableBandLM.initialize(HTMLTableBandLM.java:44)</init>
    <init>   at org.eclipse.birt.report.engine.layout.html.HTMLLayoutManagerFactory.createLayoutManager(HTMLLayoutManagerFactory.java:40)</init>
    <init>   at org.eclipse.birt.report.engine.layout.html.HTMLReportLayoutEngine.createLayoutManager(HTMLReportLayoutEngine.java:138)</init>
    <init>   at org.eclipse.birt.report.engine.layout.html.HTMLBlockStackingLM.layoutNodes(HTMLBlockStackingLM.java:68)</init>
    <init>   at org.eclipse.birt.report.engine.layout.html.HTMLStackingLM.layoutChildren(HTMLStackingLM.java:26)</init>
    <init>   at org.eclipse.birt.report.engine.layout.html.HTMLRepeatHeaderLM.layoutChildren(HTMLRepeatHeaderLM.java:46)</init>
    <init>   at org.eclipse.birt.report.engine.layout.html.HTMLAbstractLM.layout(HTMLAbstractLM.java:140)</init>
    <init>   at org.eclipse.birt.report.engine.layout.html.HTMLBlockStackingLM.layoutNodes(HTMLBlockStackingLM.java:71)</init>
    <init>   at org.eclipse.birt.report.engine.layout.html.HTMLPageLM.layout(HTMLPageLM.java:92)</init>
    <init>   at org.eclipse.birt.report.engine.layout.html.HTMLReportLayoutEngine.layout(HTMLReportLayoutEngine.java:100)</init>
    <init>   at org.eclipse.birt.report.engine.presentation.ReportDocumentBuilder.build(ReportDocumentBuilder.java:258)</init>
    <init>   at org.eclipse.birt.report.engine.api.impl.RunTask.doRun(RunTask.java:273)</init>
    <init>   at org.eclipse.birt.report.engine.api.impl.RunTask.run(RunTask.java:89)</init>
    <init>   at org.eclipse.birt.report.service.ReportEngineService.runReport(ReportEngineService.java:1325)</init>
    <init>   at org.eclipse.birt.report.service.BirtViewerReportService.runReport(BirtViewerReportService.java:159)</init>
    <init>   at org.eclipse.birt.report.service.actionhandler.BirtRunReportActionHandler.__execute(BirtRunReportActionHandler.java:81)</init>
    <init>   at org.eclipse.birt.report.service.actionhandler.BirtChangeParameterActionHandler.runReport(BirtChangeParameterActionHandler.java:58)</init>
    <init>   at org.eclipse.birt.report.service.actionhandler.AbstractChangeParameterActionHandler.__execute(AbstractChangeParameterActionHandler.java:52)</init>
    <init>   at org.eclipse.birt.report.service.actionhandler.AbstractBaseActionHandler.execute(AbstractBaseActionHandler.java:90)</init>
    <init>   at org.eclipse.birt.report.soapengine.processor.AbstractBaseDocumentProcessor.__executeAction(AbstractBaseDocumentProcessor.java:47)</init>
    <init>   at org.eclipse.birt.report.soapengine.processor.AbstractBaseComponentProcessor.executeAction(AbstractBaseComponentProcessor.java:143)</init>
    <init>   at org.eclipse.birt.report.soapengine.processor.BirtDocumentProcessor.handleChangeParameter(BirtDocumentProcessor.java:100)</init>
    <init>   at java.base/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(DirectMethodHandleAccessor.java:104)</init>
    <init>   at java.base/java.lang.reflect.Method.invoke(Method.java:578)</init>
    <init>   at org.eclipse.birt.report.soapengine.processor.AbstractBaseComponentProcessor.process(AbstractBaseComponentProcessor.java:112)</init>
    <init>   at org.eclipse.birt.report.soapengine.endpoint.BirtSoapBindingImpl.getUpdatedObjects(BirtSoapBindingImpl.java:66)</init>
    <init>   at java.base/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(DirectMethodHandleAccessor.java:104)</init>
    <init>   at java.base/java.lang.reflect.Method.invoke(Method.java:578)</init>
    <init>   at org.apache.axis.providers.java.RPCProvider.invokeMethod(RPCProvider.java:397)</init>
    <init>   at org.apache.axis.providers.java.RPCProvider.processMessage(RPCProvider.java:186)</init>
    <init>   at org.apache.axis.providers.java.JavaProvider.invoke(JavaProvider.java:323)</init>
    <init>   at org.apache.axis.strategies.InvocationStrategy.visit(InvocationStrategy.java:32)</init>
    <init>   at org.apache.axis.SimpleChain.doVisiting(SimpleChain.java:118)</init>
    <init>   at org.apache.axis.SimpleChain.invoke(SimpleChain.java:83)</init>
    <init>   at org.apache.axis.handlers.soap.SOAPService.invoke(SOAPService.java:454)</init>
    <init>   at org.apache.axis.server.AxisServer.invoke(AxisServer.java:281)</init>
    <init>   at org.apache.axis.transport.http.AxisServlet.doPost(AxisServlet.java:699)</init>
    <init>   at org.eclipse.birt.report.servlet.BirtSoapMessageDispatcherServlet.doPost(BirtSoapMessageDispatcherServlet.java:265)</init>
    <init>   at javax.servlet.http.HttpServlet.service(HttpServlet.java:707)</init>
    <init>   at org.apache.axis.transport.http.AxisServletBase.service(AxisServletBase.java:327)</init>
    <init>   at javax.servlet.http.HttpServlet.service(HttpServlet.java:790)</init>
    <init>   at org.eclipse.birt.report.servlet.BirtSoapMessageDispatcherServlet.service(BirtSoapMessageDispatcherServlet.java:122)</init>
    <init>   at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:865)</init>
    <init>   at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1655)</init>
    <init>   at org.eclipse.birt.report.filter.ViewerFilter.doFilter(ViewerFilter.java:68)</init>
    <init>   at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1634)</init>
    <init>   at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:533)</init>
    <init>   at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:146)</init>
    <init>   at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:548)</init>
    <init>   at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:132)</init>
    <init>   at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:257)</init>
    <init>   at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:1595)</init>
    <init>   at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:255)</init>
    <init>   at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1253)</init>
    <init>   at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:203)</init>
    <init>   at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:473)</init>
    <init>   at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:1564)</init>
    <init>   at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:201)</init>
    <init>   at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1155)</init>
    <init>   at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:144)</init>
    <init>   at org.eclipse.jetty.server.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:219)</init>
    <init>   at org.eclipse.jetty.server.handler.HandlerCollection.handle(HandlerCollection.java:126)</init>
    <init>   at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:132)</init>
    <init>   at org.eclipse.jetty.server.Server.handle(Server.java:531)</init>
    <init>   at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:352)</init>
    <init>   at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:260)</init>
    <init>   at org.eclipse.jetty.io.AbstractConnection$ReadCallback.succeeded(AbstractConnection.java:281)</init>
    <init>   at org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:102)</init>
    <init>   at org.eclipse.jetty.io.ChannelEndPoint$2.run(ChannelEndPoint.java:118)</init>
    <init>   at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.runTask(EatWhatYouKill.java:333)</init>
    <init>   at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.doProduce(EatWhatYouKill.java:310)</init>
    <init>   at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.tryProduce(EatWhatYouKill.java:168)</init>
    <init>   at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.run(EatWhatYouKill.java:126)</init>
    <init>   at org.eclipse.jetty.util.thread.ReservedThreadExecutor$ReservedThread.run(ReservedThreadExecutor.java:366)</init>
    <init>   at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:760)</init>
    <init>   at org.eclipse.jetty.util.thread.QueuedThreadPool$2.run(QueuedThreadPool.java:678)</init>
    <init>   at java.base/java.lang.Thread.run(Thread.java:1623)</init>
    <init>Caused by: org.eclipse.birt.data.engine.core.DataException: Data Set script method "Fetch" returned null; expected a Boolean value.</init>
    <init>   at org.eclipse.birt.report.engine.script.internal.ScriptDataSetScriptExecutor.handleFetch(ScriptDataSetScriptExecutor.java:153)</init>
    <init>... 119 more</init>
    org.eclipse.birt.report.engine.api.EngineException: There are errors evaluating script "if (!maximoDataSet.fetch())
    return (false);

    // Add a line for each output column
    // The specific get method should match the data type of the output column.
    row["WONUM"] = maximoDataSet.getInteger("WONUM");
    row["STATUS"] = maximoDataSet.getString("STATUS");
    row["SCHEDSTART"] = maximoDataSet.getDateTime("SCHEDSTART");
    row["FREQUENCY"] = maximoDataSet.getDecimal("FREQUENCY");
    row["FREQUNIT"] = maximoDataSet.getString("FREQUNIT");
    row["LOCATION"] = maximoDataSet.getString("LOCATION");
    row["DESCRIPTION"] = maximoDataSet.getString("DESCRIPTION");
    row["BCH_PARSHOP"] = maximoDataSet.getString("BCH_PARSHOP");
    row["ASSETNUM"] = maximoDataSet.getString("ASSETNUM");
    row["LEAD"] = maximoDataSet.getString("LEAD");
    row["BCH_PMREG"] = maximoDataSet.getString("BCH_PMREG");
    row["PMNUM"] = maximoDataSet.getString("PMNUM");
    row["BCH_GRPLDR"] = maximoDataSet.getString("BCH_GRPLDR");
    row["BCH_SHOPSUP"] = maximoDataSet.getString("BCH_SHOPSUP");
    row["REPORTDATE"] = maximoDataSet.getDateTime("REPORTDATE");

    return (true);":
    Fail to execute script in function __bm_FETCH(). Source:
    ------
    " + if (!maximoDataSet.fetch())
    return (false);

    // Add a line for each output column
    // The specific get method should match the data type of the output column.
    row["WONUM"] = maximoDataSet.getInteger("WONUM");
    row["STATUS"] = maximoDataSet.getString("STATUS");
    row["SCHEDSTART"] = maximoDataSet.getDateTime("SCHEDSTART");
    row["FREQUENCY"] = maximoDataSet.getDecimal("FREQUENCY");
    row["FREQUNIT"] = maximoDataSet.getString("FREQUNIT");
    row["LOCATION"] = maximoDataSet.getString("LOCATION");
    row["DESCRIPTION"] = maximoDataSet.getString("DESCRIPTION");
    row["BCH_PARSHOP"] = maximoDataSet.getString("BCH_PARSHOP");
    row["ASSETNUM"] = maximoDataSet.getString("ASSETNUM");
    row["LEAD"] = maximoDataSet.getString("LEAD");
    row["BCH_PMREG"] = maximoDataSet.getString("BCH_PMREG");
    row["PMNUM"] = maximoDataSet.getString("PMNUM");
    row["BCH_GRPLDR"] = maximoDataSet.getString("BCH_GRPLDR");
    row["BCH_SHOPSUP"] = maximoDataSet.getString("BCH_SHOPSUP");
    row["REPORTDATE"] = maximoDataSet.getDateTime("REPORTDATE");

    return (true); + "
    -----
    A BIRT exception occurred. See next exception for more information.
    Wrapped com.ibm.tivoli.maximo.report.script.MXReportRuntimeException: com.ibm.db2.jcc.am.SqlException: [jcc][10150][10300][4.26.14] Invalid parameter: Unknown column name STATUS. ERRORCODE=-4460, SQLSTATE=null (/report/data-sets/script-data-set[@id="5"]/method[@name="fetch"]#7).
       at org.eclipse.birt.report.engine.script.internal.DtEScriptExecutor.handleJS(DtEScriptExecutor.java:99)
       at org.eclipse.birt.report.engine.script.internal.DataSetScriptExecutor.handleJS(DataSetScriptExecutor.java:256)
       at org.eclipse.birt.report.engine.script.internal.ScriptDataSetScriptExecutor.handleFetch(ScriptDataSetScriptExecutor.java:143)
       at org.eclipse.birt.data.engine.impl.ScriptDataSetRuntime.fetch(ScriptDataSetRuntime.java:103)
       at org.eclipse.birt.data.engine.impl.PreparedScriptDSQuery$ScriptDSQueryExecutor$CustomDataSet.fetch(PreparedScriptDSQuery.java:260)
       at org.eclipse.birt.data.engine.executor.cache.OdiAdapter.fetch(OdiAdapter.java:226)
       at org.eclipse.birt.data.engine.executor.cache.RowResultSet.fetch(RowResultSet.java:145)
       at org.eclipse.birt.data.engine.executor.cache.RowResultSet.doNext(RowResultSet.java:118)
       at org.eclipse.birt.data.engine.executor.cache.RowResultSet.next(RowResultSet.java:96)
       at org.eclipse.birt.data.engine.executor.cache.ExpandableRowResultSet.next(ExpandableRowResultSet.java:63)
       at org.eclipse.birt.data.engine.executor.cache.SmartCacheHelper.populateData(SmartCacheHelper.java:318)
       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)</init>
    <init>   at org.eclipse.birt.data.engine.executor.transform.pass.PassUtil.populateOdiResultSet(PassUtil.java:110)</init>
    <init>   at org.eclipse.birt.data.engine.executor.transform.pass.PassUtil.pass(PassUtil.java:62)</init>
    <init>   at org.eclipse.birt.data.engine.executor.transform.pass.PassManager.doSinglePass(PassManager.java:170)</init>
    <init>   at org.eclipse.birt.data.engine.executor.transform.pass.PassManager.prepareDataSetResultSet(PassManager.java:94)</init>
    <init>   at org.eclipse.birt.data.engine.executor.transform.pass.PassManager.pass(PassManager.java:134)</init>
    <init>   at org.eclipse.birt.data.engine.executor.transform.pass.PassManager.populateResultSet(PassManager.java:74)</init>
    <init>   at org.eclipse.birt.data.engine.executor.transform.ResultSetPopulator.populateResultSet(ResultSetPopulator.java:218)</init>
    <init>   at org.eclipse.birt.data.engine.executor.transform.CachedResultSet.(CachedResultSet.java:200)</init>
    <init>   at org.eclipse.birt.data.engine.executor.CandidateQuery.execute(CandidateQuery.java:142)</init>
    <init>   at org.eclipse.birt.data.engine.impl.PreparedScriptDSQuery$ScriptDSQueryExecutor.executeOdiQuery(PreparedScriptDSQuery.java:226)</init>
    <init>   at org.eclipse.birt.data.engine.impl.QueryExecutor.execute(QueryExecutor.java:1257)</init>
    <init>   at org.eclipse.birt.data.engine.impl.ServiceForQueryResults.executeQuery(ServiceForQueryResults.java:233)</init>
    <init>   at org.eclipse.birt.data.engine.impl.QueryResults.getResultIterator(QueryResults.java:178)</init>
    <init>   at org.eclipse.birt.report.engine.data.dte.QueryResultSet.(QueryResultSet.java:115)</init>
    <init>   at org.eclipse.birt.report.engine.data.dte.DteDataEngine.doExecuteQuery(DteDataEngine.java:176)</init>
    <init>   at org.eclipse.birt.report.engine.data.dte.DataGenerationEngine.doExecuteQuery(DataGenerationEngine.java:83)</init>
    <init>   at org.eclipse.birt.report.engine.data.dte.AbstractDataEngine.execute(AbstractDataEngine.java:286)</init>
    <init>   at org.eclipse.birt.report.engine.executor.ExecutionContext.executeQuery(ExecutionContext.java:1954)</init>
    <init>   at org.eclipse.birt.report.engine.executor.QueryItemExecutor.executeQuery(QueryItemExecutor.java:80)</init>
    <init>   at org.eclipse.birt.report.engine.executor.DataItemExecutor.execute(DataItemExecutor.java:75)</init>
    <init>   at org.eclipse.birt.report.engine.internal.executor.wrap.WrappedReportItemExecutor.execute(WrappedReportItemExecutor.java:46)</init>
    <init>   at org.eclipse.birt.report.engine.internal.executor.emitter.ReportItemEmitterExecutor.execute(ReportItemEmitterExecutor.java:46)</init>
    <init>   at org.eclipse.birt.report.engine.internal.executor.dup.SuppressDuplicateItemExecutor.execute(SuppressDuplicateItemExecutor.java:43)</init>
    <init>   at org.eclipse.birt.report.engine.layout.html.HTMLBlockStackingLM.layoutNodes(HTMLBlockStackingLM.java:65)</init>
    <init>   at org.eclipse.birt.report.engine.layout.html.HTMLStackingLM.layoutChildren(HTMLStackingLM.java:26)</init>
    <init>   at org.eclipse.birt.report.engine.layout.html.HTMLAbstractLM.layout(HTMLAbstractLM.java:140)</init>
    <init>   at org.eclipse.birt.report.engine.layout.html.HTMLInlineStackingLM.resumeLayout(HTMLInlineStackingLM.java:111)</init>
    <init>   at org.eclipse.birt.report.engine.layout.html.HTMLInlineStackingLM.layoutNodes(HTMLInlineStackingLM.java:160)</init>
    <init>   at org.eclipse.birt.report.engine.layout.html.HTMLStackingLM.layoutChildren(HTMLStackingLM.java:26)</init>
    <init>   at org.eclipse.birt.report.engine.layout.html.HTMLAbstractLM.layout(HTMLAbstractLM.java:140)</init>
    <init>   at org.eclipse.birt.report.engine.layout.html.HTMLBlockStackingLM.layoutNodes(HTMLBlockStackingLM.java:71)</init>
    <init>   at org.eclipse.birt.report.engine.layout.html.HTMLStackingLM.layoutChildren(HTMLStackingLM.java:26)</init>
    <init>   at org.eclipse.birt.report.engine.layout.html.HTMLRepeatHeaderLM.layoutChildren(HTMLRepeatHeaderLM.java:46)</init>
    <init>   at org.eclipse.birt.report.engine.layout.html.HTMLAbstractLM.layout(HTMLAbstractLM.java:140)</init>
    <init>   at org.eclipse.birt.report.engine.layout.html.HTMLBlockStackingLM.layoutNodes(HTMLBlockStackingLM.java:71)</init>
    <init>   at org.eclipse.birt.report.engine.layout.html.HTMLStackingLM.layoutChildren(HTMLStackingLM.java:26)</init>
    <init>   at org.eclipse.birt.report.engine.layout.html.HTMLAbstractLM.layout(HTMLAbstractLM.java:140)</init>
    <init>   at org.eclipse.birt.report.engine.layout.html.HTMLInlineStackingLM.resumeLayout(HTMLInlineStackingLM.java:111)</init>
    <init>   at org.eclipse.birt.report.engine.layout.html.HTMLInlineStackingLM.layoutNodes(HTMLInlineStackingLM.java:160)</init>
    <init>   at org.eclipse.birt.report.engine.layout.html.HTMLStackingLM.layoutChildren(HTMLStackingLM.java:26)</init>
    <init>   at org.eclipse.birt.report.engine.layout.html.HTMLAbstractLM.layout(HTMLAbstractLM.java:140)</init>
    <init>   at org.eclipse.birt.report.engine.layout.html.HTMLBlockStackingLM.layoutNodes(HTMLBlockStackingLM.java:71)</init>
    <init>   at org.eclipse.birt.report.engine.layout.html.HTMLStackingLM.layoutChildren(HTMLStackingLM.java:26)</init>
    <init>   at org.eclipse.birt.report.engine.layout.html.HTMLTableBandLM.layoutChildren(HTMLTableBandLM.java:67)</init>
    <init>   at org.eclipse.birt.report.engine.layout.html.HTMLAbstractLM.layout(HTMLAbstractLM.java:140)</init>
    <init>   at org.eclipse.birt.report.engine.layout.html.HTMLBlockStackingLM.layoutNodes(HTMLBlockStackingLM.java:71)</init>
    <init>   at org.eclipse.birt.report.engine.layout.html.HTMLStackingLM.layoutChildren(HTMLStackingLM.java:26)</init>
    <init>   at org.eclipse.birt.report.engine.layout.html.HTMLRepeatHeaderLM.layoutChildren(HTMLRepeatHeaderLM.java:46)</init>
    <init>   at org.eclipse.birt.report.engine.layout.html.HTMLAbstractLM.layout(HTMLAbstractLM.java:140)</init>
    <init>   at org.eclipse.birt.report.engine.layout.html.HTMLBlockStackingLM.layoutNodes(HTMLBlockStackingLM.java:71)</init>
    <init>   at org.eclipse.birt.report.engine.layout.html.HTMLPageLM.layout(HTMLPageLM.java:92)</init>
    <init>   at org.eclipse.birt.report.engine.layout.html.HTMLReportLayoutEngine.layout(HTMLReportLayoutEngine.java:100)</init>
    <init>   at org.eclipse.birt.report.engine.presentation.ReportDocumentBuilder.build(ReportDocumentBuilder.java:258)</init>
    <init>   at org.eclipse.birt.report.engine.api.impl.RunTask.doRun(RunTask.java:273)</init>
    <init>   at org.eclipse.birt.report.engine.api.impl.RunTask.run(RunTask.java:89)</init>
    <init>   at org.eclipse.birt.report.service.ReportEngineService.runReport(ReportEngineService.java:1325)</init>
    <init>   at org.eclipse.birt.report.service.BirtViewerReportService.runReport(BirtViewerReportService.java:159)</init>
    <init>   at org.eclipse.birt.report.service.actionhandler.BirtRunReportActionHandler.__execute(BirtRunReportActionHandler.java:81)</init>
    <init>   at org.eclipse.birt.report.service.actionhandler.BirtChangeParameterActionHandler.runReport(BirtChangeParameterActionHandler.java:58)</init>
    <init>   at org.eclipse.birt.report.service.actionhandler.AbstractChangeParameterActionHandler.__execute(AbstractChangeParameterActionHandler.java:52)</init>
    <init>   at org.eclipse.birt.report.service.actionhandler.AbstractBaseActionHandler.execute(AbstractBaseActionHandler.java:90)</init>
    <init>   at org.eclipse.birt.report.soapengine.processor.AbstractBaseDocumentProcessor.__executeAction(AbstractBaseDocumentProcessor.java:47)</init>
    <init>   at org.eclipse.birt.report.soapengine.processor.AbstractBaseComponentProcessor.executeAction(AbstractBaseComponentProcessor.java:143)</init>
    <init>   at org.eclipse.birt.report.soapengine.processor.BirtDocumentProcessor.handleChangeParameter(BirtDocumentProcessor.java:100)</init>
    <init>   at java.base/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(DirectMethodHandleAccessor.java:104)</init>
    <init>   at java.base/java.lang.reflect.Method.invoke(Method.java:578)</init>
    <init>   at org.eclipse.birt.report.soapengine.processor.AbstractBaseComponentProcessor.process(AbstractBaseComponentProcessor.java:112)</init>
    <init>   at org.eclipse.birt.report.soapengine.endpoint.BirtSoapBindingImpl.getUpdatedObjects(BirtSoapBindingImpl.java:66)</init>
    <init>   at java.base/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(DirectMethodHandleAccessor.java:104)</init>
    <init>   at java.base/java.lang.reflect.Method.invoke(Method.java:578)</init>
    <init>   at org.apache.axis.providers.java.RPCProvider.invokeMethod(RPCProvider.java:397)</init>
    <init>   at org.apache.axis.providers.java.RPCProvider.processMessage(RPCProvider.java:186)</init>
    <init>   at org.apache.axis.providers.java.JavaProvider.invoke(JavaProvider.java:323)</init>
    <init>   at org.apache.axis.strategies.InvocationStrategy.visit(InvocationStrategy.java:32)</init>
    <init>   at org.apache.axis.SimpleChain.doVisiting(SimpleChain.java:118)</init>
    <init>   at org.apache.axis.SimpleChain.invoke(SimpleChain.java:83)</init>
    <init>   at org.apache.axis.handlers.soap.SOAPService.invoke(SOAPService.java:454)</init>
    <init>   at org.apache.axis.server.AxisServer.invoke(AxisServer.java:281)</init>
    <init>   at org.apache.axis.transport.http.AxisServlet.doPost(AxisServlet.java:699)</init>
    <init>   at org.eclipse.birt.report.servlet.BirtSoapMessageDispatcherServlet.doPost(BirtSoapMessageDispatcherServlet.java:265)</init>
    <init>   at javax.servlet.http.HttpServlet.service(HttpServlet.java:707)</init>
    <init>   at org.apache.axis.transport.http.AxisServletBase.service(AxisServletBase.java:327)</init>
    <init>   at javax.servlet.http.HttpServlet.service(HttpServlet.java:790)</init>
    <init>   at org.eclipse.birt.report.servlet.BirtSoapMessageDispatcherServlet.service(BirtSoapMessageDispatcherServlet.java:122)</init>
    <init>   at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:865)</init>
    <init>   at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1655)</init>
    <init>   at org.eclipse.birt.report.filter.ViewerFilter.doFilter(ViewerFilter.java:68)</init>
    <init>   at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1634)</init>
    <init>   at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:533)</init>
    <init>   at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:146)</init>
    <init>   at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:548)</init>
    <init>   at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:132)</init>
    <init>   at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:257)</init>
    <init>   at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:1595)</init>
    <init>   at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:255)</init>
    <init>   at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1253)</init>
    <init>   at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:203)</init>
    <init>   at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:473)</init>
    <init>   at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:1564)</init>
    <init>   at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:201)</init>
    <init>   at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1155)</init>
    <init>   at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:144)</init>
    <init>   at org.eclipse.jetty.server.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:219)</init>
    <init>   at org.eclipse.jetty.server.handler.HandlerCollection.handle(HandlerCollection.java:126)</init>
    <init>   at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:132)</init>
    <init>   at org.eclipse.jetty.server.Server.handle(Server.java:531)</init>
    <init>   at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:352)</init>
    <init>   at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:260)</init>
    <init>   at org.eclipse.jetty.io.AbstractConnection$ReadCallback.succeeded(AbstractConnection.java:281)</init>
    <init>   at org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:102)</init>
    <init>   at org.eclipse.jetty.io.ChannelEndPoint$2.run(ChannelEndPoint.java:118)</init>
    <init>   at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.runTask(EatWhatYouKill.java:333)</init>
    <init>   at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.doProduce(EatWhatYouKill.java:310)</init>
    <init>   at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.tryProduce(EatWhatYouKill.java:168)</init>
    <init>   at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.run(EatWhatYouKill.java:126)</init>
    <init>   at org.eclipse.jetty.util.thread.ReservedThreadExecutor$ReservedThread.run(ReservedThreadExecutor.java:366)</init>
    <init>   at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:760)</init>
    <init>   at org.eclipse.jetty.util.thread.QueuedThreadPool$2.run(QueuedThreadPool.java:678)</init>
    <init>   at java.base/java.lang.Thread.run(Thread.java:1623)</init>
    <init>Caused by: org.eclipse.birt.data.engine.core.DataException: Fail to execute script in function __bm_FETCH(). Source:</init>
    <init>------</init>
    <init>" + if (!maximoDataSet.fetch())</init>
    <init>return (false);</init>

    <init>// Add a line for each output column</init>
    <init>// The specific get method should match the data type of the output column.</init>
    <init>row["WONUM"] = maximoDataSet.getInteger("WONUM"); </init>
    <init>row["STATUS"] = maximoDataSet.getString("STATUS");</init>
    <init>row["SCHEDSTART"] = maximoDataSet.getDateTime("SCHEDSTART"); </init>
    <init>row["FREQUENCY"] = maximoDataSet.getDecimal("FREQUENCY");</init>
    <init>row["FREQUNIT"] = maximoDataSet.getString("FREQUNIT");</init>
    <init>row["LOCATION"] = maximoDataSet.getString("LOCATION"); </init>
    <init>row["DESCRIPTION"] = maximoDataSet.getString("DESCRIPTION");</init>
    <init>row["BCH_PARSHOP"] = maximoDataSet.getString("BCH_PARSHOP"); </init>
    <init>row["ASSETNUM"] = maximoDataSet.getString("ASSETNUM");</init>
    <init>row["LEAD"] = maximoDataSet.getString("LEAD");</init>
    <init>row["BCH_PMREG"] = maximoDataSet.getString("BCH_PMREG"); </init>
    <init>row["PMNUM"] = maximoDataSet.getString("PMNUM");</init>
    <init>row["BCH_GRPLDR"] = maximoDataSet.getString("BCH_GRPLDR"); </init>
    <init>row["BCH_SHOPSUP"] = maximoDataSet.getString("BCH_SHOPSUP");</init>
    <init>row["REPORTDATE"] = maximoDataSet.getDateTime("REPORTDATE");</init>

    <init>return (true); + "</init>
    <init>-----</init>
    <init>A BIRT exception occurred. See next exception for more information.</init>
    <init>Wrapped com.ibm.tivoli.maximo.report.script.MXReportRuntimeException: com.ibm.db2.jcc.am.SqlException: [jcc][10150][10300][4.26.14] Invalid parameter: Unknown column name STATUS. ERRORCODE=-4460, SQLSTATE=null (/report/data-sets/script-data-set[@id="5"]/method[@name="fetch"]#7)</init>
    <init>   at org.eclipse.birt.data.engine.script.JSMethodRunner.runScript(JSMethodRunner.java:147)</init>
    <init>   at org.eclipse.birt.report.engine.script.internal.DtEScriptExecutor.handleJS(DtEScriptExecutor.java:90)</init>
    <init>... 132 more</init>
    <init>Caused by: org.eclipse.birt.data.engine.core.DataException: A BIRT exception occurred. See next exception for more information.</init>
    <init>Wrapped com.ibm.tivoli.maximo.report.script.MXReportRuntimeException: com.ibm.db2.jcc.am.SqlException: [jcc][10150][10300][4.26.14] Invalid parameter: Unknown column name STATUS. ERRORCODE=-4460, SQLSTATE=null (/report/data-sets/script-data-set[@id="5"]/method[@name="fetch"]#7)</init>
    <init>   at org.eclipse.birt.data.engine.core.DataException.wrap(DataException.java:123)</init>
    <init>   at org.eclipse.birt.data.engine.script.ScriptEvalUtil.evaluateJSAsExpr(ScriptEvalUtil.java:1003)</init>
    <init>   at org.eclipse.birt.data.engine.script.JSMethodRunner.runScript(JSMethodRunner.java:138)</init>
    <init>... 133 more</init>
    <init>Caused by: org.eclipse.birt.core.exception.CoreException: Wrapped com.ibm.tivoli.maximo.report.script.MXReportRuntimeException: com.ibm.db2.jcc.am.SqlException: [jcc][10150][10300][4.26.14] Invalid parameter: Unknown column name STATUS. ERRORCODE=-4460, SQLSTATE=null (/report/data-sets/script-data-set[@id="5"]/method[@name="fetch"]#7)</init>
    <init>   at org.eclipse.birt.core.script.JavascriptEvalUtil.wrapRhinoException(JavascriptEvalUtil.java:307)</init>
    <init>   at org.eclipse.birt.core.script.JavascriptEvalUtil.evaluateRawScript(JavascriptEvalUtil.java:106)</init>
    <init>   at org.eclipse.birt.core.script.JavascriptEvalUtil.evaluateScript(JavascriptEvalUtil.java:138)</init>
    <init>   at org.eclipse.birt.data.engine.script.ScriptEvalUtil.evaluateJSAsExpr(ScriptEvalUtil.java:999)</init>
    <init>... 134 more</init>
    <init>Caused by: org.mozilla.javascript.WrappedException: Wrapped com.ibm.tivoli.maximo.report.script.MXReportRuntimeException: com.ibm.db2.jcc.am.SqlException: [jcc][10150][10300][4.26.14] Invalid parameter: Unknown column name STATUS. ERRORCODE=-4460, SQLSTATE=null (/report/data-sets/script-data-set[@id="5"]/method[@name="fetch"]#7)</init>
    <init>   at org.mozilla.javascript.Context.throwAsScriptRuntimeEx(Context.java:1754)</init>
    <init>   at org.mozilla.javascript.MemberBox.invoke(MemberBox.java:148)</init>
    <init>   at org.mozilla.javascript.NativeJavaMethod.call(NativeJavaMethod.java:225)</init>
    <init>   at org.mozilla.javascript.optimizer.OptRuntime.call1(OptRuntime.java:32)</init>
    <init>   at org.mozilla.javascript.gen._report_data_sets_script_data_set__id__5___method__name__fetch___60._c___bm_FETCH_1(/report/data-sets/script-data-set[@id="5"]/method[@name="fetch"]:7)</init>
    <init>   at org.mozilla.javascript.gen._report_data_sets_script_data_set__id__5___method__name__fetch___60.call(/report/data-sets/script-data-set[@id="5"]/method[@name="fetch"])</init>
    <init>   at org.mozilla.javascript.optimizer.OptRuntime.callName0(OptRuntime.java:74)</init>
    <init>   at org.mozilla.javascript.gen._report_data_sets_script_data_set__id__5___method__name__fetch___17._c_script_0(/report/data-sets/script-data-set[@id="5"]/method[@name="fetch"]:0)</init>
    <init>   at org.mozilla.javascript.gen._report_data_sets_script_data_set__id__5___method__name__fetch___17.call(/report/data-sets/script-data-set[@id="5"]/method[@name="fetch"])</init>
    <init>   at org.mozilla.javascript.ContextFactory.doTopCall(ContextFactory.java:394)</init>
    <init>   at org.mozilla.javascript.ScriptRuntime.doTopCall(ScriptRuntime.java:3091)</init>
    <init>   at org.mozilla.javascript.gen._report_data_sets_script_data_set__id__5___method__name__fetch___17.call(/report/data-sets/script-data-set[@id="5"]/method[@name="fetch"])</init>
    <init>   at org.mozilla.javascript.gen._report_data_sets_script_data_set__id__5___method__name__fetch___17.exec(/report/data-sets/script-data-set[@id="5"]/method[@name="fetch"])</init>
    <init>   at org.eclipse.birt.core.script.JavascriptEvalUtil.evaluateRawScript(JavascriptEvalUtil.java:99)</init>
    <init>... 136 more</init>
    <init>Caused by: com.ibm.tivoli.maximo.report.script.MXReportRuntimeException: com.ibm.db2.jcc.am.SqlException: [jcc][10150][10300][4.26.14] Invalid parameter: Unknown column name STATUS. ERRORCODE=-4460, SQLSTATE=null</init>
    <init>   at com.ibm.tivoli.maximo.report.script.MXReportDataSetImpl.getString(MXReportDataSetImpl.java:456)</init>
    <init>   at java.base/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(DirectMethodHandleAccessor.java:104)</init>
    <init>   at java.base/java.lang.reflect.Method.invoke(Method.java:578)</init>
    <init>   at org.mozilla.javascript.MemberBox.invoke(MemberBox.java:126)</init>
    <init>... 148 more</init>
    <init>Caused by: com.ibm.db2.jcc.am.SqlException: [jcc][10150][10300][4.26.14] Invalid parameter: Unknown column name STATUS. ERRORCODE=-4460, SQLSTATE=null</init>
    <init>   at com.ibm.db2.jcc.am.b7.a(b7.java:794)</init>
    <init>   at com.ibm.db2.jcc.am.b7.a(b7.java:66)</init>
    <init>   at com.ibm.db2.jcc.am.b7.a(b7.java:116)</init>
    <init>   at com.ibm.db2.jcc.am.ao.a(ao.java:2139)</init>
    <init>   at com.ibm.db2.jcc.am.ResultSet.findColumnX(ResultSet.java:2076)</init>
    <init>   at com.ibm.db2.jcc.am.ResultSet.getString(ResultSet.java:1787)</init>
    <init>   at com.ibm.tivoli.maximo.report.script.MXReportResultSet.getString(MXReportResultSet.java:541)</init>
    <init>   at com.ibm.tivoli.maximo.report.script.MXReportDataSetImpl.getString(MXReportDataSetImpl.java:438)</init>
    <init>... 151 more</init>
    org.eclipse.birt.report.engine.api.EngineException: Data Set script method "Fetch" returned null; expected a Boolean value.
       at org.eclipse.birt.report.engine.script.internal.ScriptExecutor.addException(ScriptExecutor.java:249)
       at org.eclipse.birt.report.engine.script.internal.ScriptExecutor.addException(ScriptExecutor.java:238)
       at org.eclipse.birt.report.engine.script.internal.ScriptDataSetScriptExecutor.handleFetch(ScriptDataSetScriptExecutor.java:165)
       at org.eclipse.birt.data.engine.impl.ScriptDataSetRuntime.fetch(ScriptDataSetRuntime.java:103)
       at org.eclipse.birt.data.engine.impl.PreparedScriptDSQuery$ScriptDSQueryExecutor$CustomDataSet.fetch(PreparedScriptDSQuery.java:260)
       at org.eclipse.birt.data.engine.executor.cache.OdiAdapter.fetch(OdiAdapter.java:226)
       at org.eclipse.birt.data.engine.executor.cache.RowResultSet.fetch(RowResultSet.java:145)
       at org.eclipse.birt.data.engine.executor.cache.RowResultSet.doNext(RowResultSet.java:118)
       at org.eclipse.birt.data.engine.executor.cache.RowResultSet.next(RowResultSet.java:96)
       at org.eclipse.birt.data.engine.executor.cache.ExpandableRowResultSet.next(ExpandableRowResultSet.java:63)
       at org.eclipse.birt.data.engine.executor.cache.SmartCacheHelper.populateData(SmartCacheHelper.java:318)
       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)</init>
    <init>   at org.eclipse.birt.data.engine.executor.transform.pass.PassUtil.populateOdiResultSet(PassUtil.java:110)</init>
    <init>   at org.eclipse.birt.data.engine.executor.transform.pass.PassUtil.pass(PassUtil.java:62)</init>
    <init>   at org.eclipse.birt.data.engine.executor.transform.pass.PassManager.doSinglePass(PassManager.java:170)</init>
    <init>   at org.eclipse.birt.data.engine.executor.transform.pass.PassManager.prepareDataSetResultSet(PassManager.java:94)</init>
    <init>   at org.eclipse.birt.data.engine.executor.transform.pass.PassManager.pass(PassManager.java:134)</init>
    <init>   at org.eclipse.birt.data.engine.executor.transform.pass.PassManager.populateResultSet(PassManager.java:74)</init>
    <init>   at org.eclipse.birt.data.engine.executor.transform.ResultSetPopulator.populateResultSet(ResultSetPopulator.java:218)</init>
    <init>   at org.eclipse.birt.data.engine.executor.transform.CachedResultSet.(CachedResultSet.java:200)</init>
    <init>   at org.eclipse.birt.data.engine.executor.CandidateQuery.execute(CandidateQuery.java:142)</init>
    <init>   at org.eclipse.birt.data.engine.impl.PreparedScriptDSQuery$ScriptDSQueryExecutor.executeOdiQuery(PreparedScriptDSQuery.java:226)</init>
    <init>   at org.eclipse.birt.data.engine.impl.QueryExecutor.execute(QueryExecutor.java:1257)</init>
    <init>   at org.eclipse.birt.data.engine.impl.ServiceForQueryResults.executeQuery(ServiceForQueryResults.java:233)</init>
    <init>   at org.eclipse.birt.data.engine.impl.QueryResults.getResultIterator(QueryResults.java:178)</init>
    <init>   at org.eclipse.birt.report.engine.data.dte.QueryResultSet.(QueryResultSet.java:115)</init>
    <init>   at org.eclipse.birt.report.engine.data.dte.DteDataEngine.doExecuteQuery(DteDataEngine.java:176)</init>
    <init>   at org.eclipse.birt.report.engine.data.dte.DataGenerationEngine.doExecuteQuery(DataGenerationEngine.java:83)</init>
    <init>   at org.eclipse.birt.report.engine.data.dte.AbstractDataEngine.execute(AbstractDataEngine.java:286)</init>
    <init>   at org.eclipse.birt.report.engine.executor.ExecutionContext.executeQuery(ExecutionContext.java:1954)</init>
    <init>   at org.eclipse.birt.report.engine.executor.QueryItemExecutor.executeQuery(QueryItemExecutor.java:80)</init>
    <init>   at org.eclipse.birt.report.engine.executor.DataItemExecutor.execute(DataItemExecutor.java:75)</init>
    <init>   at org.eclipse.birt.report.engine.internal.executor.wrap.WrappedReportItemExecutor.execute(WrappedReportItemExecutor.java:46)</init>
    <init>   at org.eclipse.birt.report.engine.internal.executor.emitter.ReportItemEmitterExecutor.execute(ReportItemEmitterExecutor.java:46)</init>
    <init>   at org.eclipse.birt.report.engine.internal.executor.dup.SuppressDuplicateItemExecutor.execute(SuppressDuplicateItemExecutor.java:43)</init>
    <init>   at org.eclipse.birt.report.engine.layout.html.HTMLBlockStackingLM.layoutNodes(HTMLBlockStackingLM.java:65)</init>
    <init>   at org.eclipse.birt.report.engine.layout.html.HTMLStackingLM.layoutChildren(HTMLStackingLM.java:26)</init>
    <init>   at org.eclipse.birt.report.engine.layout.html.HTMLAbstractLM.layout(HTMLAbstractLM.java:140)</init>
    <init>   at org.eclipse.birt.report.engine.layout.html.HTMLInlineStackingLM.resumeLayout(HTMLInlineStackingLM.java:111)</init>
    <init>   at org.eclipse.birt.report.engine.layout.html.HTMLInlineStackingLM.layoutNodes(HTMLInlineStackingLM.java:160)</init>
    <init>   at org.eclipse.birt.report.engine.layout.html.HTMLStackingLM.layoutChildren(HTMLStackingLM.java:26)</init>
    <init>   at org.eclipse.birt.report.engine.layout.html.HTMLAbstractLM.layout(HTMLAbstractLM.java:140)</init>
    <init>   at org.eclipse.birt.report.engine.layout.html.HTMLBlockStackingLM.layoutNodes(HTMLBlockStackingLM.java:71)</init>
    <init>   at org.eclipse.birt.report.engine.layout.html.HTMLStackingLM.layoutChildren(HTMLStackingLM.java:26)</init>
    <init>   at org.eclipse.birt.report.engine.layout.html.HTMLRepeatHeaderLM.layoutChildren(HTMLRepeatHeaderLM.java:46)</init>
    <init>   at org.eclipse.birt.report.engine.layout.html.HTMLAbstractLM.layout(HTMLAbstractLM.java:140)</init>
    <init>   at org.eclipse.birt.report.engine.layout.html.HTMLBlockStackingLM.layoutNodes(HTMLBlockStackingLM.java:71)</init>
    <init>   at org.eclipse.birt.report.engine.layout.html.HTMLStackingLM.layoutChildren(HTMLStackingLM.java:26)</init>
    <init>   at org.eclipse.birt.report.engine.layout.html.HTMLAbstractLM.layout(HTMLAbstractLM.java:140)</init>
    <init>   at org.eclipse.birt.report.engine.layout.html.HTMLInlineStackingLM.resumeLayout(HTMLInlineStackingLM.java:111)</init>
    <init>   at org.eclipse.birt.report.engine.layout.html.HTMLInlineStackingLM.layoutNodes(HTMLInlineStackingLM.java:160)</init>
    <init>   at org.eclipse.birt.report.engine.layout.html.HTMLStackingLM.layoutChildren(HTMLStackingLM.java:26)</init>
    <init>   at org.eclipse.birt.report.engine.layout.html.HTMLAbstractLM.layout(HTMLAbstractLM.java:140)</init>
    <init>   at org.eclipse.birt.report.engine.layout.html.HTMLBlockStackingLM.layoutNodes(HTMLBlockStackingLM.java:71)</init>
    <init>   at org.eclipse.birt.report.engine.layout.html.HTMLStackingLM.layoutChildren(HTMLStackingLM.java:26)</init>
    <init>   at org.eclipse.birt.report.engine.layout.html.HTMLTableBandLM.layoutChildren(HTMLTableBandLM.java:67)</init>
    <init>   at org.eclipse.birt.report.engine.layout.html.HTMLAbstractLM.layout(HTMLAbstractLM.java:140)</init>
    <init>   at org.eclipse.birt.report.engine.layout.html.HTMLBlockStackingLM.layoutNodes(HTMLBlockStackingLM.java:71)</init>
    <init>   at org.eclipse.birt.report.engine.layout.html.HTMLStackingLM.layoutChildren(HTMLStackingLM.java:26)</init>
    <init>   at org.eclipse.birt.report.engine.layout.html.HTMLRepeatHeaderLM.layoutChildren(HTMLRepeatHeaderLM.java:46)</init>
    <init>   at org.eclipse.birt.report.engine.layout.html.HTMLAbstractLM.layout(HTMLAbstractLM.java:140)</init>
    <init>   at org.eclipse.birt.report.engine.layout.html.HTMLBlockStackingLM.layoutNodes(HTMLBlockStackingLM.java:71)</init>
    <init>   at org.eclipse.birt.report.engine.layout.html.HTMLPageLM.layout(HTMLPageLM.java:92)</init>
    <init>   at org.eclipse.birt.report.engine.layout.html.HTMLReportLayoutEngine.layout(HTMLReportLayoutEngine.java:100)</init>
    <init>   at org.eclipse.birt.report.engine.presentation.ReportDocumentBuilder.build(ReportDocumentBuilder.java:258)</init>
    <init>   at org.eclipse.birt.report.engine.api.impl.RunTask.doRun(RunTask.java:273)</init>
    <init>   at org.eclipse.birt.report.engine.api.impl.RunTask.run(RunTask.java:89)</init>
    <init>   at org.eclipse.birt.report.service.ReportEngineService.runReport(ReportEngineService.java:1325)</init>
    <init>   at org.eclipse.birt.report.service.BirtViewerReportService.runReport(BirtViewerReportService.java:159)</init>
    <init>   at org.eclipse.birt.report.service.actionhandler.BirtRunReportActionHandler.__execute(BirtRunReportActionHandler.java:81)</init>
    <init>   at org.eclipse.birt.report.service.actionhandler.BirtChangeParameterActionHandler.runReport(BirtChangeParameterActionHandler.java:58)</init>
    <init>   at org.eclipse.birt.report.service.actionhandler.AbstractChangeParameterActionHandler.__execute(AbstractChangeParameterActionHandler.java:52)</init>
    <init>   at org.eclipse.birt.report.service.actionhandler.AbstractBaseActionHandler.execute(AbstractBaseActionHandler.java:90)</init>
    <init>   at org.eclipse.birt.report.soapengine.processor.AbstractBaseDocumentProcessor.__executeAction(AbstractBaseDocumentProcessor.java:47)</init>
    <init>   at org.eclipse.birt.report.soapengine.processor.AbstractBaseComponentProcessor.executeAction(AbstractBaseComponentProcessor.java:143)</init>
    <init>   at org.eclipse.birt.report.soapengine.processor.BirtDocumentProcessor.handleChangeParameter(BirtDocumentProcessor.java:100)</init>
    <init>   at java.base/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(DirectMethodHandleAccessor.java:104)</init>
    <init>   at java.base/java.lang.reflect.Method.invoke(Method.java:578)</init>
    <init>   at org.eclipse.birt.report.soapengine.processor.AbstractBaseComponentProcessor.process(AbstractBaseComponentProcessor.java:112)</init>
    <init>   at org.eclipse.birt.report.soapengine.endpoint.BirtSoapBindingImpl.getUpdatedObjects(BirtSoapBindingImpl.java:66)</init>
    <init>   at java.base/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(DirectMethodHandleAccessor.java:104)</init>
    <init>   at java.base/java.lang.reflect.Method.invoke(Method.java:578)</init>
    <init>   at org.apache.axis.providers.java.RPCProvider.invokeMethod(RPCProvider.java:397)</init>
    <init>   at org.apache.axis.providers.java.RPCProvider.processMessage(RPCProvider.java:186)</init>
    <init>   at org.apache.axis.providers.java.JavaProvider.invoke(JavaProvider.java:323)</init>
    <init>   at org.apache.axis.strategies.InvocationStrategy.visit(InvocationStrategy.java:32)</init>
    <init>   at org.apache.axis.SimpleChain.doVisiting(SimpleChain.java:118)</init>
    <init>   at org.apache.axis.SimpleChain.invoke(SimpleChain.java:83)</init>
    <init>   at org.apache.axis.handlers.soap.SOAPService.invoke(SOAPService.java:454)</init>
    <init>   at org.apache.axis.server.AxisServer.invoke(AxisServer.java:281)</init>
    <init>   at org.apache.axis.transport.http.AxisServlet.doPost(AxisServlet.java:699)</init>
    <init>   at org.eclipse.birt.report.servlet.BirtSoapMessageDispatcherServlet.doPost(BirtSoapMessageDispatcherServlet.java:265)</init>
    <init>   at javax.servlet.http.HttpServlet.service(HttpServlet.java:707)</init>
    <init>   at org.apache.axis.transport.http.AxisServletBase.service(AxisServletBase.java:327)</init>
    <init>   at javax.servlet.http.HttpServlet.service(HttpServlet.java:790)</init>
    <init>   at org.eclipse.birt.report.servlet.BirtSoapMessageDispatcherServlet.service(BirtSoapMessageDispatcherServlet.java:122)</init>
    <init>   at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:865)</init>
    <init>   at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1655)</init>
    <init>   at org.eclipse.birt.report.filter.ViewerFilter.doFilter(ViewerFilter.java:68)</init>
    <init>   at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1634)</init>
    <init>   at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:533)</init>
    <init>   at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:146)</init>
    <init>   at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:548)</init>
    <init>   at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:132)</init>
    <init>   at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:257)</init>
    <init>   at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:1595)</init>
    <init>   at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:255)</init>
    <init>   at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1253)</init>
    <init>   at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:203)</init>
    <init>   at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:473)</init>
    <init>   at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:1564)</init>
    <init>   at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:201)</init>
    <init>   at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1155)</init>
    <init>   at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:144)</init>
    <init>   at org.eclipse.jetty.server.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:219)</init>
    <init>   at org.eclipse.jetty.server.handler.HandlerCollection.handle(HandlerCollection.java:126)</init>
    <init>   at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:132)</init>
    <init>   at org.eclipse.jetty.server.Server.handle(Server.java:531)</init>
    <init>   at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:352)</init>
    <init>   at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:260)</init>
    <init>   at org.eclipse.jetty.io.AbstractConnection$ReadCallback.succeeded(AbstractConnection.java:281)</init>
    <init>   at org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:102)</init>
    <init>   at org.eclipse.jetty.io.ChannelEndPoint$2.run(ChannelEndPoint.java:118)</init>
    <init>   at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.runTask(EatWhatYouKill.java:333)</init>
    <init>   at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.doProduce(EatWhatYouKill.java:310)</init>
    <init>   at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.tryProduce(EatWhatYouKill.java:168)</init>
    <init>   at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.run(EatWhatYouKill.java:126)</init>
    <init>   at org.eclipse.jetty.util.thread.ReservedThreadExecutor$ReservedThread.run(ReservedThreadExecutor.java:366)</init>
    <init>   at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:760)</init>
    <init>   at org.eclipse.jetty.util.thread.QueuedThreadPool$2.run(QueuedThreadPool.java:678)</init>
    <init>   at java.base/java.lang.Thread.run(Thread.java:1623)</init>
    <init>Caused by: org.eclipse.birt.data.engine.core.DataException: Data Set script method "Fetch" returned null; expected a Boolean value.</init>
    <init>   at org.eclipse.birt.report.engine.script.internal.ScriptDataSetScriptExecutor.handleFetch(ScriptDataSetScriptExecutor.java:153)</init>
    <init><init><init>... 130 more</init></init></init>



    ------------------------------
    Philip Marrone
    Boston Children's Hospital
    ------------------------------

    Original Message


  • 17.  RE: BIRT 4.8 Error

    Posted 12-12-2023 12:21

    WONUM is not GetInteger, it is GetString.

     

    Bob Kraus

    Senior Business Services Consultant  |  Facilities Services  |  Missouri S&T

    General Services Bldg, 1701 Spruce Dr, Rolla, MO 65409

     

    Email: krausr@mst.edu   Phone: 573-341-7288   Site: facilitiesoperations.mst.edu  

     

    Missouri S&T - Solving For Tomorrow

     

    Social: YouTube

     

     




    Original Message


  • 18.  RE: BIRT 4.8 Error

    Posted 12-12-2023 12:36

    Alright, thanks once again for your help. I can consistently get it to run now but unfortunately without any results. As I said there should be 25 results.



    ------------------------------
    Philip Marrone
    Boston Children's Hospital
    ------------------------------

    Original Message


  • 19.  RE: BIRT 4.8 Error

    Posted 12-12-2023 13:04

    I know that BIRT plays a little differently than SQL.

    You might try:

    1. Instead of assigning an alias to the tables (w.wonum) use the full name (workorder.wonum)
    2. Try using '01-JAN-23' instead of '2023-01-01' for dates
    3. Try LEFT OUTER JOIN instead of LEFT JOIN

     

     

    Bob Kraus

    Senior Business Services Consultant  |  Facilities Services  |  Missouri S&T

    General Services Bldg, 1701 Spruce Dr, Rolla, MO 65409

     

    Email: krausr@mst.edu   Phone: 573-341-7288   Site: facilitiesoperations.mst.edu  

     

    Missouri S&T - Solving For Tomorrow

     

    Social: YouTube

     

     




    Original Message


  • 20.  RE: BIRT 4.8 Error

    Posted 12-12-2023 13:39

    I tried this and updated the above. I am not sure. When I did my fetch script, I noticed that there is also an "OnFetch", is that something I need to develop also? Just thinking what I might be doing wrong. Thanks so much for your help thus far.



    ------------------------------
    Philip Marrone
    Boston Children's Hospital
    ------------------------------

    Original Message


  • 21.  RE: BIRT 4.8 Error

    Posted 12-12-2023 14:33

    That's about all I know.

    Good Luck.

     

     

     

    Bob Kraus

    Senior Business Services Consultant  |  Facilities Services  |  Missouri S&T

    General Services Bldg, 1701 Spruce Dr, Rolla, MO 65409

     

    Email: krausr@mst.edu   Phone: 573-341-7288   Site: facilitiesoperations.mst.edu  

     

    Missouri S&T - Solving For Tomorrow

     

    Social: YouTube

     

     




    Original Message


  • 22.  RE: BIRT 4.8 Error

    Posted 12-12-2023 15:32

    Thanks for all of your help, it got me this far and is much appreciated.



    ------------------------------
    Philip Marrone
    Boston Children's Hospital
    ------------------------------

    Original Message


  • 23.  RE: BIRT 4.8 Error

    Posted 12-13-2023 08:46

    Hi Phil,

    Did you get this report working?  Or are you still receiving the following error?

    A BIRT exception occurred. See next exception for more information.
    Wrapped com.ibm.tivoli.maximo.report.script.MXReportRuntimeException: com.ibm.db2.jcc.am.SqlException: [jcc][10150][10300][4.26.14] Invalid parameter: Unknown column name STATUS. ERRORCODE=-4460, SQLSTATE=null (/report/data-sets/script-data-set[@id="5"]/method[@name="fetch"]#7).

    If you are receiving the error or blank data you may want to check your SQL at:

    + "LEFT JOIN Maximo.WOSTATUS AS status ON w.WONUM = status.WONUM "

    The problem may be your label of status.  That is a valid column name in the workorder table and may not be able to be used as a label for WOSTATUS.



    ------------------------------
    Jim Robb
    Axient
    ------------------------------

    Original Message


  • 24.  RE: BIRT 4.8 Error

    Posted 01-12-2024 17:44

    what does your dataset fetch look like?

    I am guessing you need to comment those two lines out or remove then.



    ------------------------------
    Wes Williams
    Northrop Grumman
    ------------------------------

    Original Message


  • 25.  RE: BIRT 4.8 Error

    Posted 12-13-2023 17:56

    Hi Phillip

    Firstly, have you read all of the Maximo76_Designer431_Report 20Development Guide_Rev8.pdf?

    So, let's review.  There is an open is where the SQL to pulls the data from the database. Then the fetch is to map the SQL columns into the report columns.  Then you need to map those column outputs to the column in BIRT making sure that you assign the correct BIRT data type i.e. a wonum is string not integer.  Then on the layout you take the mapped column onto the layout.  Seems simple and seems like your doing the same thing three times.

    Also, I didn't get an impression whether you've embedded a debug statement like below as the SQL supplied is either from the code or a SQL tool rather than the output.

    Dates

    Please check out Section 6 fro discussion about dates.  I'd also suggest that you look at other reports that also use data parameters such as the Asset Availability report.  This is a much better way for self education.

    Firstly, ensure that you have defined the parameter date Data type=date

    Then in the open, you need to convert the date parameters into the JDBC format.  An example is from the Asset Availability report

    startdt_jdbc = MXReportSqlFormat.getDateFunction(params["startdate"]);
    startdt = params["startdate"];
    enddt_jdbc = MXReportSqlFormat.getDateFunction(params["enddate"]);
    enddt = params["enddate"];

    and this is the altered SQL in the Open

    + " and workperiod.workdate between " + startdt_jdbc + " and " + enddt_jdbc

    I hope that this helps.



    ------------------------------
    Regards,
    Craig Kokay
    ISW
    Maximo Practice Manager
    eMail: ckokay@isw.net.au
    Phone: +61-411-682-040

    #IBMChampion2023
    ------------------------------

    Original Message


Related Content