Dears,
We are encountering the following error message in several IFS windows, including Shop Order and Active Work Orders:
Error Message:
nIfs.Fnd.FndSystemException: Unexpected error while calling server method AccessPlsql/Invoke ---> Unable to close statement. (.DATABASE]SOracle JDBC Driver] Object has been closed.) .DATABASE]SOracle JDBC Driver] Object has been closed.
at ifs.fnd.services.plsqlserver.service.PlsqlInvocationProcessor.convertError(Unknown Source)
at ifs.fnd.services.plsqlserver.service.PlsqlInvocationProcessor.invokeImpl(Unknown Source)
at ifs.fnd.services.plsqlserver.service.PlsqlInvocationProcessor.invoke(Unknown Source)
at ifs.fnd.services.plsqlserver.service.PlsqlProxy.invoke(Unknown Source)
at ifs.fnd.services.plsqlserver.service.PlsqlProxy.invoke(Unknown Source)
at ifs.fnd.services.plsqlserver.service.PlsqlProxy.invoke(Unknown Source)
at ifs.fnd.gateway.client.IfsClientGateway.doPost(IfsClientGateway.java:566)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:710)
at ifs.fnd.gateway.IfsAbstractGateway.service(IfsAbstractGateway.java:160)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:230)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:179)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:525)
at org.jboss.web.tomcat.security.BasicAuthValve.invoke(BasicAuthValve.java:75)
at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:84)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:104)
at org.jboss.web.tomcat.service.sso.ClusteredSingleSignOn.invoke(ClusteredSingleSignOn.java:676)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:241)
at org.apache.coyote.ajp.AjpProcessor.process(AjpProcessor.java:437)
at org.apache.coyote.ajp.AjpProtocol$AjpConnectionHandler.process(AjpProtocol.java:381)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
at java.lang.Thread.run(Thread.java:619)
### client/server border ###
at Ifs.Fnd.AccessProvider.FndConnection.ParseErrorHeader(FndBuffer buffer, FndManualDecisionCollection decisions)
at Ifs.Fnd.AccessProvider.FndConnection.UnMarshalResponseHeader(Stream responseStream, FndManualDecisionCollection decisions)
at Ifs.Fnd.AccessProvider.FndConnection.HandleHttpSuccessResult(HttpWebResponse result, FndManualDecisionCollection decisions, String operation, FndBodyType responseBodyType, Object responseBody)
at Ifs.Fnd.AccessProvider.FndConnection.InvokeInternal(Object requestBody, Object responseBody, String intface, String operation, FndRequestContext requestContext, FndManualDecisionCollection decisions, Boolean forcedSync)
--- End of inner exception stack trace ---
at Ifs.Fnd.AccessProvider.FndConnection.InvokeInternal(Object requestBody, Object responseBody, String intface, String operation, FndRequestContext requestContext, FndManualDecisionCollection decisions, Boolean forcedSync)
at Ifs.Fnd.AccessProvider.FndConnection.InvokeInternal(String intface, String operation, Object requestBody, Object responseBody, FndRequestContext requestContext, Boolean forcedSync)
at Ifs.Fnd.AccessProvider.FndConnection.InvokeSync(String intface, String operation, Object requestBody, Object responseBody)
at Ifs.Fnd.AccessProvider.PLSQL.FndPLSQLCommandCollection.Invoke()
at Ifs.Fnd.AccessProvider.PLSQL.FndPLSQLCommand.ExecuteNonQuery()
at Ifs.Fnd.AccessProvider.PLSQL.FndPLSQLSelectCommand.ExecuteReader(String recordType)
at Ifs.Fnd.AccessProvider.PLSQL.FndPLSQLSelectCommandReader.Read(Boolean prepare)
at Ifs.Fnd.AccessProvider.PLSQL.FndPLSQLSelectCommandReader..ctor(FndPLSQLSelectCommand command, Int32 fetchSize)
at Ifs.Fnd.AccessProvider.PLSQL.FndPLSQLSelectCommand.ExecuteCursorReader(String recordType, Int32 fetchSize)
at Ifs.Fnd.Data.ADONetProvider.FndAPCommand.ExecuteDbDataReader(CommandBehavior behavior)]
Could you please investigate the root cause of this error message and assist with how to resolve it?
Thanks and regards