Skip to main content

Hi All,

IN IFS 7.5 SP6 env  i am unable to execute in application - HIGH PRIORITY. PLease help us to overcome this issue

 

 

Ifs.Fnd.FndSystemException: Explorer: An Unhandled Exception has occurred ---> Ifs.Fnd.FndSystemException: Unexpected error while calling server method PrintReport/ReportFormatRequest ---> ORA-12535: TNS:operation timed out

 

   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.application.applicationsupport.impl.StandardEntityHandlerImpl.invoke(Unknown Source)

   at ifs.application.applicationsupport.impl.StandardEntityHandlerBean.invoke(Unknown Source)

   at sun.reflect.GeneratedMethodAccessor456.invoke(Unknown Source)

   at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

   at java.lang.reflect.Method.invoke(Method.java:601)

   at org.jboss.invocation.Invocation.performCall(Invocation.java:386)

   at org.jboss.ejb.StatelessSessionContainer$ContainerInterceptor.invoke(StatelessSessionContainer.java:233)

   at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invoke(CachedConnectionInterceptor.java:156)

   at org.jboss.ejb.plugins.StatelessSessionInstanceInterceptor.invoke(StatelessSessionInstanceInterceptor.java:173)

   at org.jboss.ejb.plugins.CallValidationInterceptor.invoke(CallValidationInterceptor.java:63)

   at org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.java:121)

   at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:435)

   at org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:181)

   at org.jboss.ejb.plugins.SecurityInterceptor.process(SecurityInterceptor.java:228)

   at org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:211)

   at org.jboss.ejb.plugins.security.PreSecurityInterceptor.process(PreSecurityInterceptor.java:100)

   at org.jboss.ejb.plugins.security.PreSecurityInterceptor.invoke(PreSecurityInterceptor.java:84)

   at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:205)

   at org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invoke(ProxyFactoryFinderInterceptor.java:138)

   at org.jboss.ejb.SessionContainer.internalInvoke(SessionContainer.java:650)

   at org.jboss.ejb.Container.invoke(Container.java:1092)

   at org.jboss.ejb.plugins.local.BaseLocalProxyFactory.invoke(BaseLocalProxyFactory.java:436)

   at org.jboss.ejb.plugins.local.StatelessSessionProxy.invoke(StatelessSessionProxy.java:103)

   at $Proxy626.invoke(Unknown Source)

   at ifs.fnd.sf.storage.FndPlsqlAccess.invoke(Unknown Source)

   at ifs.fnd.services.plsqlserver.FndAbstractPlsqlWrapper.executePLSQLMethod(Unknown Source)

   at ifs.fnd.services.plsqlserver.FndAbstractPlsqlWrapper.execute(Unknown Source)

   at ifs.application.infoservices.ReportUtilitiesImplBase.requestFormatting(Unknown Source)

   at ifs.application.infoservices.ReportUtilitiesBean.requestFormatting(Unknown Source)

   at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

   at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)

   at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

   at java.lang.reflect.Method.invoke(Method.java:601)

   at org.jboss.invocation.Invocation.performCall(Invocation.java:386)

   at org.jboss.ejb.StatelessSessionContainer$ContainerInterceptor.invoke(StatelessSessionContainer.java:233)

   at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invoke(CachedConnectionInterceptor.java:156)

   at org.jboss.ejb.plugins.StatelessSessionInstanceInterceptor.invoke(StatelessSessionInstanceInterceptor.java:173)

   at org.jboss.ejb.plugins.CallValidationInterceptor.invoke(CallValidationInterceptor.java:63)

   at org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.java:121)

   at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:350)

   at org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:181)

   at org.jboss.ejb.plugins.SecurityInterceptor.process(SecurityInterceptor.java:268)

   at org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:211)

   at org.jboss.ejb.plugins.security.PreSecurityInterceptor.process(PreSecurityInterceptor.java:167)

   at org.jboss.ejb.plugins.security.PreSecurityInterceptor.invoke(PreSecurityInterceptor.java:84)

   at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:205)

   at org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invoke(ProxyFactoryFinderInterceptor.java:138)

   at org.jboss.ejb.SessionContainer.internalInvoke(SessionContainer.java:650)

   at org.jboss.ejb.Container.invoke(Container.java:1092)

   at org.jboss.ejb.plugins.local.BaseLocalProxyFactory.invoke(BaseLocalProxyFactory.java:436)

   at org.jboss.ejb.plugins.local.StatelessSessionProxy.invoke(StatelessSessionProxy.java:103)

   at $Proxy1256.requestFormatting(Unknown Source)

   at ifs.application.infoservices.impl.PrintReportImpl.requestFormatting(Unknown Source)

   at ifs.application.infoservices.PrintReportWrapper.requestFormatting(Unknown Source)

   at ifs.application.infoservices.impl.PrintReportImpl.reportFormatRequest(Unknown Source)

   at ifs.application.infoservices.PrintReportWrapper.reportFormatRequest(Unknown Source)

   at ifs.application.infoservices.InfoServicesBean.printReport_ReportFormatRequest(Unknown Source)

   at ifs.application.infoservices.InfoServicesBean.printReport_ReportFormatRequest(Unknown Source)

   at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

   at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)

   at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

   at java.lang.reflect.Method.invoke(Method.java:601)

   at org.jboss.invocation.Invocation.performCall(Invocation.java:386)

   at org.jboss.ejb.StatelessSessionContainer$ContainerInterceptor.invoke(StatelessSessionContainer.java:233)

   at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invoke(CachedConnectionInterceptor.java:156)

   at org.jboss.ejb.plugins.StatelessSessionInstanceInterceptor.invoke(StatelessSessionInstanceInterceptor.java:173)

   at org.jboss.ejb.plugins.CallValidationInterceptor.invoke(CallValidationInterceptor.java:63)

   at org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.java:121)

   at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:350)

   at org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:181)

   at org.jboss.ejb.plugins.SecurityInterceptor.process(SecurityInterceptor.java:268)

   at org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:211)

   at org.jboss.ejb.plugins.security.PreSecurityInterceptor.process(PreSecurityInterceptor.java:167)

   at org.jboss.ejb.plugins.security.PreSecurityInterceptor.invoke(PreSecurityInterceptor.java:84)

   at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:205)

   at org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invoke(ProxyFactoryFinderInterceptor.java:138)

   at org.jboss.ejb.SessionContainer.internalInvoke(SessionContainer.java:650)

   at org.jboss.ejb.Container.invoke(Container.java:1092)

   at sun.reflect.GeneratedMethodAccessor448.invoke(Unknown Source)

   at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

   at java.lang.reflect.Method.invoke(Method.java:601)

   at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:157)

   at org.jboss.mx.server.Invocation.dispatch(Invocation.java:96)

   at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)

   at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)

   at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:668)

   at org.jboss.invocation.local.LocalInvoker$MBeanServerAction.invoke(LocalInvoker.java:169)

   at org.jboss.invocation.local.LocalInvoker.invoke(LocalInvoker.java:118)

   at org.jboss.invocation.InvokerInterceptor.invokeLocal(InvokerInterceptor.java:260)

   at org.jboss.invocation.InvokerInterceptor.invoke(InvokerInterceptor.java:246)

   at org.jboss.proxy.TransactionInterceptor.invoke(TransactionInterceptor.java:61)

   at org.jboss.proxy.ejb.SecurityContextInterceptor.invoke(SecurityContextInterceptor.java:64)

   at org.jboss.proxy.SecurityInterceptor.invoke(SecurityInterceptor.java:68)

   at org.jboss.proxy.ejb.StatelessSessionInterceptor.invoke(StatelessSessionInterceptor.java:112)

   at org.jboss.proxy.ClientContainer.invoke(ClientContainer.java:101)

   at $Proxy1251.printReport_ReportFormatRequest(Unknown Source)

   at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

   at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)

   at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

   at java.lang.reflect.Method.invoke(Method.java:601)

   at ifs.fnd.gateway.client.EJBServerConnection.invoke(EJBServerConnection.java:126)

   at ifs.fnd.gateway.client.ServerCommunicator.invoke(ServerCommunicator.java:237)

   at ifs.fnd.gateway.client.ServerCommunicator.invoke(ServerCommunicator.java:133)

   at ifs.fnd.gateway.client.IfsClientGateway.doPost(IfsClientGateway.java:575)

   at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)

   at ifs.fnd.gateway.IfsAbstractGateway.service(IfsAbstractGateway.java:160)

   at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)

   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:235)

   at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)

   at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:183)

   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:95)

   at org.jboss.web.tomcat.security.SecurityContextEstablishmentValve.process(SecurityContextEstablishmentValve.java:126)

   at org.jboss.web.tomcat.security.SecurityContextEstablishmentValve.invoke(SecurityContextEstablishmentValve.java:70)

   at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)

   at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)

   at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:566)

   at org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:158)

   at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)

   at org.jboss.web.tomcat.service.request.ActiveRequestResponseCacheValve.internalProcess(ActiveRequestResponseCacheValve.java:74)

   at org.jboss.web.tomcat.service.request.ActiveRequestResponseCacheValve.invoke(ActiveRequestResponseCacheValve.java:47)

   at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:330)

   at org.apache.coyote.ajp.AjpProcessor.process(AjpProcessor.java:436)

   at org.apache.coyote.ajp.AjpProtocol$AjpConnectionHandler.process(AjpProtocol.java:385)

   at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:451)

   at java.lang.Thread.run(Thread.java:722)

 

   ### 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.Invoke(String intface, String operation, Object requestBody, Object responseBody)

   at Ifs.Fnd.AccessProvider.Activity.FndActivityContext.Invoke(String intface, String operation, Object request, Object response)

   at Ifs.Fnd.AccessProvider.Activity.FndActivityCommand.ExecuteNonQuery(Object body)

   at Ifs.Fnd.Explorer.Extenders.InfoServices.ServerInterface.Ifs.Fnd.Explorer.Extenders.InfoServices.IPrintReport.ReportFormatRequest(Double resultKey, String formatRequest, String langCode, String& pDFFile, Byten]& pDF)

   at Ifs.Fnd.Explorer.Extenders.InfoServices.PrintDialog.ReportFormatRequest(PrintInstance instance, String& filename, Bytes]& pdfData)

   at Ifs.Fnd.Explorer.Extenders.InfoServices.PrintDialog.PreviewReport(PrintInstance instance)

   at Ifs.Fnd.Explorer.Extenders.InfoServices.PrintDialog.FormatPrintRequest(Boolean print)

   at Ifs.Fnd.Explorer.Extenders.InfoServices.PrintDialog.cmdPreview_Execute(Object sender, FndCommandExecuteEventArgs e)

   at Ifs.Fnd.Windows.Forms.FndCommand.OnExecute(Component component)

   at Ifs.Fnd.Windows.Forms.FndCommandButton.OnClick(EventArgs e)

   at System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent)

   at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)

   at System.Windows.Forms.Control.WndProc(Message& m)

   at System.Windows.Forms.ButtonBase.WndProc(Message& m)

   at System.Windows.Forms.Button.WndProc(Message& m)

   at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)

   at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)

   at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

   --- End of inner exception stack trace ---

 

 

Reagdrs,

Vivek NR.

 


IN IFS 7.5 SP6 env  i am unable to execute even single reports. Please help us to overcome this issue


Has something changed on your network?

 

It would appear the database TNS can not be contacted


Can you check the “Application Monitoring Console” page in Solution Manager. The indicator for “PL/SQL Access Provider configuration test” should be green.