Maximo Open Forum

 View Only

Related Content

  • 1.  Print report with attachment problem.

    Posted 12-18-2023 03:29

    Hi All,

    I have Maximo 7.6.1.2 environment. I created and cofigured a new report with "Print with Attachment?", "Limit Records?" checked. But when I run report in application, maximo raised an error like below:

    Caused by: 
    Error : 904, Position : 104, Sql = select * from reportdesign  where reportname= 'xxxxx.rptdesign'  and appname= 'PLUSGWO', OriginalSql = select * from reportdesign  where reportname= 'xxxxx.rptdesign'  and appname= 'PLUSGWO', Error Msg = ORA-00904: "APPNAME": invalid identifier
     
    [12/18/23 11:28:39:014 ICT] 000004da SystemOut     O 18 Dec 2023 11:28:39:013 [ERROR] [MXServer_01] [] BMXAA6713E - The MBO fetch operation failed in the mboset with the SQL error code 904. The record could not be retrieved from the database. See the log file for more details about the error.
    java.sql.SQLSyntaxErrorException: ORA-00904: "APPNAME": invalid identifier
    Any help would be appreciated.
    Thanks.

    #EverythingMaximo
    #Reporting

    ------------------------------
    [Acey] [Nguyen]
    [NGS]
    ------------------------------


  • 2.  RE: Print report with attachment problem.

    Posted 12-18-2023 08:12

    Do you have anything else in the logs like a stack trace of the code that is executing this logic exactly? appname is an invalid column for reportdesign out of box so I would be surprised if it was coming from something we had written. I tried to do a quick search for defects but was unable to find anything about this problem. With the stack trace, I should be able to better pinpoint where the appname piece is coming from (such as a data restriction). 



    ------------------------------
    Steven Shull
    IBM
    ------------------------------



  • 3.  RE: Print report with attachment problem.

    Posted 12-18-2023 22:14

    Hi Steven Shull, thank you for your consideration.

    These are more log in SystemOut.log file:

    [12/19/23 9:57:21:340 ICT] 000004dc SystemOut     O 19 Dec 2023 09:57:21:340 [ERROR] [MXServer_01] [] BMXAA6714E - The data for the next record in the mboset could not be retrieved for the SQL query select * from reportdesign  where reportname= 'xxxxx.rptdesign'  and appname= 'PLUSGWO'. See the log file for more details about the error.
    java.sql.SQLSyntaxErrorException: ORA-00904: "APPNAME": invalid identifier
     
    at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:509)
    at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:461)
    at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1104)
    at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:550)
    at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:268)
    at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:655)
    at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:229)
    at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:41)
    at oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:765)
    at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:983)
    at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1168)
    at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1362)
    at oracle.jdbc.driver.OracleStatementWrapper.executeQuery(OracleStatementWrapper.java:369)
    at psdi.mbo.MboSet.getNextRecordData(MboSet.java:3340)
    at psdi.mbo.MboSet.fetchMbosActual(MboSet.java:2948)
    at psdi.mbo.MboSet.fetchMbos(MboSet.java:2905)
    at psdi.mbo.MboSet.getMbo(MboSet.java:2121)
    at psdi.mbo.Mbo.getMboForAttribute(Mbo.java:1631)
    at psdi.mbo.Mbo.getMboValueData(Mbo.java:1402)
    at psdi.mbo.MboData.<init>(MboData.java:98)
    at psdi.mbo.Mbo.getMboData(Mbo.java:1527)
    at psdi.webclient.system.beans.DataBean.setCurrentRecordData(DataBean.java:3242)
    at psdi.webclient.system.beans.DataBean.fetchRecordData(DataBean.java:4685)
    at psdi.webclient.controls.TabGroup.setCurrentTab(TabGroup.java:281)
    at psdi.webclient.controls.TabGroup.setCurrentTab(TabGroup.java:218)
    at psdi.webclient.controls.TabGroup.setCurrentTab(TabGroup.java:207)
    at psdi.webclient.system.controller.PageInstance.gotoTab(PageInstance.java:536)
    at psdi.webclient.system.beans.ResultsBean.selectrecord(ResultsBean.java:344)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:90)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:55)
    at java.lang.reflect.Method.invoke(Method.java:508)
    at psdi.webclient.system.session.WebClientSession.defaultHandler(WebClientSession.java:1510)
    at psdi.webclient.system.session.WebClientSession.handleEvent(WebClientSession.java:1403)
    at psdi.webclient.system.session.WebClientSession.processRequestEvent(WebClientSession.java:6219)
    at psdi.webclient.system.session.WebClientSession.handleClientSideQueueRequest(WebClientSession.java:6175)
    at psdi.webclient.system.session.WebClientSession.handleRequest(WebClientSession.java:892)
    at psdi.webclient.system.session.AsyncRequestManager.handleRequest(AsyncRequestManager.java:555)
    at psdi.webclient.system.session.AsyncRequestManager.manageRequest(AsyncRequestManager.java:253)
    at psdi.webclient.system.controller.RequestManager.manageRequest(RequestManager.java:290)
    at psdi.webclient.servlet.WebClientServlet.handleRequest(WebClientServlet.java:141)
    at psdi.webclient.servlet.WebClientServlet.doPost(WebClientServlet.java:52)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:707)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:790)
    at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1235)
    at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:779)
    at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:478)
    at com.ibm.ws.webcontainer.servlet.ServletWrapperImpl.handleRequest(ServletWrapperImpl.java:179)
    at com.ibm.ws.webcontainer.filter.WebAppFilterChain.invokeTarget(WebAppFilterChain.java:143)
    at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:96)
    at psdi.webclient.system.filter.HttpCrossSiteScriptingSecurity.doFilter(HttpCrossSiteScriptingSecurity.java:66)
    at com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java:197)
    at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:90)
    at psdi.webclient.system.filter.MXCorrelationFilter.doFilter(MXCorrelationFilter.java:137)
    at com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java:197)
    at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:90)
    at psdi.webclient.system.filter.PerformanceMonitor.doFilter(PerformanceMonitor.java:126)
    at com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java:197)
    at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:90)
    at psdi.webclient.system.filter.HttpXFrameOptionsFilter.doFilter(HttpXFrameOptionsFilter.java:38)
    at com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java:197)
    at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:90)
    at psdi.webclient.system.filter.MTContextFilter.doFilter(MTContextFilter.java:53)
    at com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java:197)
    at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:90)
    at com.ibm.ws.webcontainer.filter.WebAppFilterManager.doFilter(WebAppFilterManager.java:979)
    at com.ibm.ws.webcontainer.filter.WebAppFilterManager.invokeFilters(WebAppFilterManager.java:1119)
    at com.ibm.ws.webcontainer.servlet.CacheServletWrapper.handleRequest(CacheServletWrapper.java:82)
    at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:966)
    at com.ibm.ws.webcontainer.WSWebContainer.handleRequest(WSWebContainer.java:1817)
    at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:382)
    at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:465)
    at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewRequest(HttpInboundLink.java:532)
    at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.processRequest(HttpInboundLink.java:318)
    at com.ibm.ws.http.channel.inbound.impl.HttpICLReadCallback.complete(HttpICLReadCallback.java:88)
    at com.ibm.ws.tcp.channel.impl.AioReadCompletionListener.futureCompleted(AioReadCompletionListener.java:175)
    at com.ibm.io.async.AbstractAsyncFuture.invokeCallback(AbstractAsyncFuture.java:217)
    at com.ibm.io.async.AsyncChannelFuture.fireCompletionActions(AsyncChannelFuture.java:161)
    at com.ibm.io.async.AsyncFuture.completed(AsyncFuture.java:138)
    at com.ibm.io.async.ResultHandler.complete(ResultHandler.java:204)
    at com.ibm.io.async.ResultHandler.runEventProcessingLoop(ResultHandler.java:775)
    at com.ibm.io.async.ResultHandler$2.run(ResultHandler.java:905)
    at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1909)
    Caused by: 
    Error : 904, Position : 104, Sql = select * from reportdesign  where reportname= 'xxxxx.rptdesign'  and appname= 'PLUSGWO', OriginalSql = select * from reportdesign  where reportname= 'xxxxx.rptdesign'  and appname= 'PLUSGWO', Error Msg = ORA-00904: "APPNAME": invalid identifier
     
    at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:513)
    ... 82 more
    [12/19/23 9:57:21:340 ICT] 000004dc SystemOut     O 19 Dec 2023 09:57:21:340 [ERROR] [MXServer_01] [] BMXAA6713E - The MBO fetch operation failed in the mboset with the SQL error code 904. The record could not be retrieved from the database. See the log file for more details about the error.
    java.sql.SQLSyntaxErrorException: ORA-00904: "APPNAME": invalid identifier
     
    at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:509)
    at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:461)
    at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1104)
    at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:550)
    at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:268)
    at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:655)
    at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:229)
    at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:41)
    at oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:765)
    at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:983)
    at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1168)
    at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1362)
    at oracle.jdbc.driver.OracleStatementWrapper.executeQuery(OracleStatementWrapper.java:369)
    at psdi.mbo.MboSet.getNextRecordData(MboSet.java:3340)
    at psdi.mbo.MboSet.fetchMbosActual(MboSet.java:2948)
    at psdi.mbo.MboSet.fetchMbos(MboSet.java:2905)
    at psdi.mbo.MboSet.getMbo(MboSet.java:2121)
    at psdi.mbo.Mbo.getMboForAttribute(Mbo.java:1631)
    at psdi.mbo.Mbo.getMboValueData(Mbo.java:1402)
    at psdi.mbo.MboData.<init>(MboData.java:98)
    at psdi.mbo.Mbo.getMboData(Mbo.java:1527)
    at psdi.webclient.system.beans.DataBean.setCurrentRecordData(DataBean.java:3242)
    at psdi.webclient.system.beans.DataBean.fetchRecordData(DataBean.java:4685)
    at psdi.webclient.controls.TabGroup.setCurrentTab(TabGroup.java:281)
    at psdi.webclient.controls.TabGroup.setCurrentTab(TabGroup.java:218)
    at psdi.webclient.controls.TabGroup.setCurrentTab(TabGroup.java:207)
    at psdi.webclient.system.controller.PageInstance.gotoTab(PageInstance.java:536)
    at psdi.webclient.system.beans.ResultsBean.selectrecord(ResultsBean.java:344)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:90)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:55)
    at java.lang.reflect.Method.invoke(Method.java:508)
    at psdi.webclient.system.session.WebClientSession.defaultHandler(WebClientSession.java:1510)
    at psdi.webclient.system.session.WebClientSession.handleEvent(WebClientSession.java:1403)
    at psdi.webclient.system.session.WebClientSession.processRequestEvent(WebClientSession.java:6219)
    at psdi.webclient.system.session.WebClientSession.handleClientSideQueueRequest(WebClientSession.java:6175)
    at psdi.webclient.system.session.WebClientSession.handleRequest(WebClientSession.java:892)
    at psdi.webclient.system.session.AsyncRequestManager.handleRequest(AsyncRequestManager.java:555)
    at psdi.webclient.system.session.AsyncRequestManager.manageRequest(AsyncRequestManager.java:253)
    at psdi.webclient.system.controller.RequestManager.manageRequest(RequestManager.java:290)
    at psdi.webclient.servlet.WebClientServlet.handleRequest(WebClientServlet.java:141)
    at psdi.webclient.servlet.WebClientServlet.doPost(WebClientServlet.java:52)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:707)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:790)
    at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1235)
    at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:779)
    at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:478)
    at com.ibm.ws.webcontainer.servlet.ServletWrapperImpl.handleRequest(ServletWrapperImpl.java:179)
    at com.ibm.ws.webcontainer.filter.WebAppFilterChain.invokeTarget(WebAppFilterChain.java:143)
    at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:96)
    at psdi.webclient.system.filter.HttpCrossSiteScriptingSecurity.doFilter(HttpCrossSiteScriptingSecurity.java:66)
    at com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java:197)
    at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:90)
    at psdi.webclient.system.filter.MXCorrelationFilter.doFilter(MXCorrelationFilter.java:137)
    at com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java:197)
    at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:90)
    at psdi.webclient.system.filter.PerformanceMonitor.doFilter(PerformanceMonitor.java:126)
    at com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java:197)
    at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:90)
    at psdi.webclient.system.filter.HttpXFrameOptionsFilter.doFilter(HttpXFrameOptionsFilter.java:38)
    at com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java:197)
    at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:90)
    at psdi.webclient.system.filter.MTContextFilter.doFilter(MTContextFilter.java:53)
    at com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java:197)
    at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:90)
    at com.ibm.ws.webcontainer.filter.WebAppFilterManager.doFilter(WebAppFilterManager.java:979)
    at com.ibm.ws.webcontainer.filter.WebAppFilterManager.invokeFilters(WebAppFilterManager.java:1119)
    at com.ibm.ws.webcontainer.servlet.CacheServletWrapper.handleRequest(CacheServletWrapper.java:82)
    at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:966)
    at com.ibm.ws.webcontainer.WSWebContainer.handleRequest(WSWebContainer.java:1817)
    at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:382)
    at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:465)
    at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewRequest(HttpInboundLink.java:532)
    at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.processRequest(HttpInboundLink.java:318)
    at com.ibm.ws.http.channel.inbound.impl.HttpICLReadCallback.complete(HttpICLReadCallback.java:88)
    at com.ibm.ws.tcp.channel.impl.AioReadCompletionListener.futureCompleted(AioReadCompletionListener.java:175)
    at com.ibm.io.async.AbstractAsyncFuture.invokeCallback(AbstractAsyncFuture.java:217)
    at com.ibm.io.async.AsyncChannelFuture.fireCompletionActions(AsyncChannelFuture.java:161)
    at com.ibm.io.async.AsyncFuture.completed(AsyncFuture.java:138)
    at com.ibm.io.async.ResultHandler.complete(ResultHandler.java:204)
    at com.ibm.io.async.ResultHandler.runEventProcessingLoop(ResultHandler.java:775)
    at com.ibm.io.async.ResultHandler$2.run(ResultHandler.java:905)
    at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1909)
    Caused by: 
    Error : 904, Position : 104, Sql = select * from reportdesign  where reportname= 'xxxxx.rptdesign'  and appname= 'PLUSGWO', OriginalSql = select * from reportdesign  where reportname= 'xxxxx.rptdesign'  and appname= 'PLUSGWO', Error Msg = ORA-00904: "APPNAME": invalid identifier
     
    at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:513)
    ... 82 more
    [12/19/23 9:57:21:340 ICT] 000004dc SystemOut     O 19 Dec 2023 09:57:21:340 [ERROR] [MXServer_01] [] BMXAA6713E - The MBO fetch operation failed in the mboset with the SQL error code 904. The record could not be retrieved from the database. See the log file for more details about the error.
    java.sql.SQLSyntaxErrorException: ORA-00904: "APPNAME": invalid identifier
     
    at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:509)
    at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:461)
    at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1104)
    at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:550)
    at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:268)
    at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:655)
    at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:229)
    at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:41)
    at oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:765)
    at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:983)
    at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1168)
    at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1362)
    at oracle.jdbc.driver.OracleStatementWrapper.executeQuery(OracleStatementWrapper.java:369)
    at psdi.mbo.MboSet.getNextRecordData(MboSet.java:3340)
    at psdi.mbo.MboSet.fetchMbosActual(MboSet.java:2948)
    at psdi.mbo.MboSet.fetchMbos(MboSet.java:2905)
    at psdi.mbo.MboSet.getMbo(MboSet.java:2121)
    at psdi.mbo.Mbo.getMboForAttribute(Mbo.java:1631)
    at psdi.mbo.Mbo.getMboValueData(Mbo.java:1402)
    at psdi.mbo.MboData.<init>(MboData.java:98)
    at psdi.mbo.Mbo.getMboData(Mbo.java:1527)
    at psdi.webclient.system.beans.DataBean.setCurrentRecordData(DataBean.java:3242)
    at psdi.webclient.system.beans.DataBean.fetchRecordData(DataBean.java:4685)
    at psdi.webclient.controls.TabGroup.setCurrentTab(TabGroup.java:281)
    at psdi.webclient.controls.TabGroup.setCurrentTab(TabGroup.java:218)
    at psdi.webclient.controls.TabGroup.setCurrentTab(TabGroup.java:207)
    at psdi.webclient.system.controller.PageInstance.gotoTab(PageInstance.java:536)
    at psdi.webclient.system.beans.ResultsBean.selectrecord(ResultsBean.java:344)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:90)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:55)
    at java.lang.reflect.Method.invoke(Method.java:508)
    at psdi.webclient.system.session.WebClientSession.defaultHandler(WebClientSession.java:1510)
    at psdi.webclient.system.session.WebClientSession.handleEvent(WebClientSession.java:1403)
    at psdi.webclient.system.session.WebClientSession.processRequestEvent(WebClientSession.java:6219)
    at psdi.webclient.system.session.WebClientSession.handleClientSideQueueRequest(WebClientSession.java:6175)
    at psdi.webclient.system.session.WebClientSession.handleRequest(WebClientSession.java:892)
    at psdi.webclient.system.session.AsyncRequestManager.handleRequest(AsyncRequestManager.java:555)
    at psdi.webclient.system.session.AsyncRequestManager.manageRequest(AsyncRequestManager.java:253)
    at psdi.webclient.system.controller.RequestManager.manageRequest(RequestManager.java:290)
    at psdi.webclient.servlet.WebClientServlet.handleRequest(WebClientServlet.java:141)
    at psdi.webclient.servlet.WebClientServlet.doPost(WebClientServlet.java:52)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:707)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:790)
    at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1235)
    at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:779)
    at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:478)
    at com.ibm.ws.webcontainer.servlet.ServletWrapperImpl.handleRequest(ServletWrapperImpl.java:179)
    at com.ibm.ws.webcontainer.filter.WebAppFilterChain.invokeTarget(WebAppFilterChain.java:143)
    at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:96)
    at psdi.webclient.system.filter.HttpCrossSiteScriptingSecurity.doFilter(HttpCrossSiteScriptingSecurity.java:66)
    at com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java:197)
    at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:90)
    at psdi.webclient.system.filter.MXCorrelationFilter.doFilter(MXCorrelationFilter.java:137)
    at com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java:197)
    at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:90)
    at psdi.webclient.system.filter.PerformanceMonitor.doFilter(PerformanceMonitor.java:126)
    at com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java:197)
    at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:90)
    at psdi.webclient.system.filter.HttpXFrameOptionsFilter.doFilter(HttpXFrameOptionsFilter.java:38)
    at com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java:197)
    at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:90)
    at psdi.webclient.system.filter.MTContextFilter.doFilter(MTContextFilter.java:53)
    at com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java:197)
    at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:90)
    at com.ibm.ws.webcontainer.filter.WebAppFilterManager.doFilter(WebAppFilterManager.java:979)
    at com.ibm.ws.webcontainer.filter.WebAppFilterManager.invokeFilters(WebAppFilterManager.java:1119)
    at com.ibm.ws.webcontainer.servlet.CacheServletWrapper.handleRequest(CacheServletWrapper.java:82)
    at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:966)
    at com.ibm.ws.webcontainer.WSWebContainer.handleRequest(WSWebContainer.java:1817)
    at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:382)
    at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:465)
    at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewRequest(HttpInboundLink.java:532)
    at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.processRequest(HttpInboundLink.java:318)
    at com.ibm.ws.http.channel.inbound.impl.HttpICLReadCallback.complete(HttpICLReadCallback.java:88)
    at com.ibm.ws.tcp.channel.impl.AioReadCompletionListener.futureCompleted(AioReadCompletionListener.java:175)
    at com.ibm.io.async.AbstractAsyncFuture.invokeCallback(AbstractAsyncFuture.java:217)
    at com.ibm.io.async.AsyncChannelFuture.fireCompletionActions(AsyncChannelFuture.java:161)
    at com.ibm.io.async.AsyncFuture.completed(AsyncFuture.java:138)
    at com.ibm.io.async.ResultHandler.complete(ResultHandler.java:204)
    at com.ibm.io.async.ResultHandler.runEventProcessingLoop(ResultHandler.java:775)
    at com.ibm.io.async.ResultHandler$2.run(ResultHandler.java:905)
    at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1909)
    Caused by: 
    Error : 904, Position : 104, Sql = select * from reportdesign  where reportname= 'xxxxx.rptdesign'  and appname= 'PLUSGWO', OriginalSql = select * from reportdesign  where reportname= 'xxxxx.rptdesign'  and appname= 'PLUSGWO', Error Msg = ORA-00904: "APPNAME": invalid identifier
     
    at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:513)
    ... 82 more
    [12/19/23 9:57:21:340 ICT] 000004dc SystemOut     O 19 Dec 2023 09:57:21:340 [INFO] [MXServer_01] [] BMXAA6719I - USER = (MAXADMIN) SPID = (847) app (null) object (REPORTDESIGN) : select * from reportdesign  where reportname= 'xxxxx.rptdesign'



    ------------------------------
    [Acey] [Nguyen]
    [NGS]
    ------------------------------

    Original Message