Topic
IC4NOTICE: developerWorks Community will be offline May 29-30, 2015 while we upgrade to the latest version of IBM Connections. For more information, read our upgrade FAQ.
No replies
d143uok
d143uok
1 Post
ACCEPTED ANSWER

Pinned topic TNS:Connect timeout occurred from the WPS to DB

‏2011-01-06T14:45:20Z |
Hi All,
I have a problem, here can you please help me out.

2011-01-06 12:50:11,132 211868264 Servlet.Engine.Transports : 8 FATAL http://IDV_RECORDER.com.abc.ufa.security.services.dataaccess.UpdateService] [ - host: abcId : SYS_002_100Loc : com.abc.ufa.security.services.dataaccess.UpdateService.boolean updateAuthHistory(AuthHistoryVO)[Desc : Throwing DataOracleException: ORA-12170: TNS:Connect timeout occurred
DSRA0010E: SQL State = 66000, Error Code = 12,170DSRA0010E: SQL State = 66000, Error Code = 12,170 Guid = 7077fd32-b10b-11db-998e-010305070809 StackTrace : com.abc.ufa.security.services.dataaccess.dao.exception.DalConnectionException: ORA-12170: TNS:Connect timeout occurred
DSRA0010E: SQL State = 66000, Error Code = 12,170DSRA0010E: SQL State = 66000, Error Code = 12,170
at com.abc.ufa.security.services.dataaccess.dao.jdbc.JdbcAuthHistoryDaoImpl.insertAuthHistory(JdbcAuthHistoryDaoImpl.java(Compiled Code))
at com.abc.ufa.security.services.dataaccess.UpdateService.updateAuthHistory(UpdateService.java(Compiled Code))
at com.abc.ufa.security.utilities.IDVUtils.updateAuthHistory(IDVUtils.java(Compiled Code))
at com.abc.ufa.security.services.authentication.CAM20CAM30LoginModule.commit(CAM20CAM30LoginModule.java(Compiled Code))
at com.ibm.ws.security.common.auth.module.proxy.WSLoginModuleProxy.commit(WSLoginModuleProxy.java(Inlined Compiled Code))
at sun.reflect.GeneratedMethodAccessor510.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java(Compiled Code))
at java.lang.reflect.Method.invoke(Method.java(Compiled Code))
at javax.security.auth.login.LoginContext.invoke(LoginContext.java(Compiled Code))
at javax.security.auth.login.LoginContext.access$000(LoginContext.java(Inlined Compiled Code))
at javax.security.auth.login.LoginContext$4.run(LoginContext.java(Compiled Code))
at java.security.AccessController.doPrivileged1(Native Method)
at java.security.AccessController.doPrivileged(AccessController.java(Compiled Code))
at javax.security.auth.login.LoginContext.invokeModule(LoginContext.java(Compiled Code))
at javax.security.auth.login.LoginContext.login(LoginContext.java(Compiled Code))
at com.abc.ufa.security.services.authentication.CAMAuthenticationService.doAuthentication(CAMAuthenticationService.java(Compiled Code))
at com.abc.ufa.security.commands.AuthenticationCommand.execute(AuthenticationCommand.java(Compiled Code))
at com.abc.ufa.security.core.abcSecurityManager.processSecurityCommand(abcSecurityManager.java(Compiled Code))
at com.abc.ufa.security.channel.abcSessionValidator.doProcessRequest(abcSessionValidator.java(Compiled Code))
at com.abc.ufa.security.channel.abcSessionValidator.execute(abcSessionValidator.java(Compiled Code))
at com.ibm.wps.engine.Command.execute(Command.java(Compiled Code))
at com.ibm.wps.engine.phases.WPActionPhase.processSessionValidation(WPActionPhase.java(Compiled Code))
at com.ibm.wps.engine.phases.WPActionPhase.execute(WPActionPhase.java(Compiled Code))
at com.ibm.wps.state.phases.AbstractActionPhase.next(AbstractActionPhase.java(Compiled Code))
at com.ibm.wps.engine.Servlet.callPortal(Servlet.java(Compiled Code))
at com.ibm.wps.engine.Servlet.doGet(Servlet.java(Compiled Code))
at com.ibm.wps.engine.Servlet.doPost(Servlet.java(Compiled Code))
at javax.servlet.http.HttpServlet.service(HttpServlet.java(Compiled Code))
at javax.servlet.http.HttpServlet.service(HttpServlet.java(Compiled Code))
at com.ibm.ws.webcontainer.servlet.StrictServletInstance.doService(StrictServletInstance.java(Compiled Code))
at com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet._service(StrictLifecycleServlet.java(Compiled Code))
at com.ibm.ws.webcontainer.servlet.ServicingServletState.service(StrictLifecycleServlet.java(Compiled Code))
at com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet.service(StrictLifecycleServlet.java(Inlined Compiled Code))
at com.ibm.ws.webcontainer.servlet.ServletInstance.service(ServletInstance.java(Compiled Code))
at com.ibm.ws.webcontainer.servlet.ValidServletReferenceState.dispatch(ValidServletReferenceState.java(Compiled Code))
at com.ibm.ws.webcontainer.servlet.ServletInstanceReference.dispatch(ServletInstanceReference.java(Inlined Compiled Code))
at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java(Compiled Code))
at com.ibm.wps.state.filter.StateCleanup.doFilter(StateCleanup.java(Compiled Code))
at com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java(Compiled Code))
at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java(Compiled Code))
at com.ibm.wps.mappingurl.impl.URLAnalyzer.doFilter(URLAnalyzer.java(Compiled Code))
at com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java(Compiled Code))
at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java(Compiled Code))
at com.abc.ufa.security.channel.abcFilter.doFilter(abcFilter.java(Compiled Code))
at com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java(Compiled Code))
at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java(Compiled Code))
at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.handleWebAppDispatch(WebAppRequestDispatcher.java(Compiled Code))
at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.dispatch(WebAppRequestDispatcher.java(Compiled Code))
at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.forward(WebAppRequestDispatcher.java(Compiled Code))
at com.ibm.ws.webcontainer.srt.WebAppInvoker.doForward(WebAppInvoker.java(Compiled Code))
at com.ibm.ws.webcontainer.srt.WebAppInvoker.handleInvocationHook(WebAppInvoker.java(Compiled Code))
at com.ibm.ws.webcontainer.cache.invocation.CachedInvocation.handleInvocation(CachedInvocation.java(Compiled Code))
at com.ibm.ws.webcontainer.cache.invocation.CacheableInvocationContext.invoke(CacheableInvocationContext.java(Compiled Code))
at com.ibm.ws.webcontainer.srp.ServletRequestProcessor.dispatchByURI(ServletRequestProcessor.java(Compiled Code))
at com.ibm.ws.webcontainer.oselistener.OSEListenerDispatcher.service(OSEListener.java(Compiled Code))
at com.ibm.ws.webcontainer.http.HttpConnection.handleRequest(HttpConnection.java(Compiled Code))
at com.ibm.ws.http.HttpConnection.readAndHandleRequest(HttpConnection.java(Compiled Code))
at com.ibm.ws.http.HttpConnection.run(HttpConnection.java(Compiled Code))
at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java(Compiled Code))