Transaction Exeception

[Fep Canh]

In production environment we are gettin the below error kindly help. The Production Env in AIX and APP Server : Websphere.

The Connection test is successfull in the application server. Also for archi view, the Application server is in different location and DB server is in a different location.

The Same application works fine in UAT...

org.hibernate.TransactionException: JDBC begin failed:
at org.hibernate.transaction.JDBCTransaction.begin(JDBCTransaction.java(Compiled Code))
at org.hibernate.impl.SessionImpl.beginTransac tion(SessionImpl.java(Compiled Code))
at org.springframework.orm.hibernate3.HibernateTransactionManager.doBegin(HibernateTransactionManager.java(Compiled Code))
at org.springframework.transaction.support.AbstractPlatformTransactionManager.getTransaction(AbstractPlatformTransactionManager.java(Compiled Code))
at org.springframework.transaction.interceptor.TransactionAspectSupport.createTransactionIfNecessary(TransactionAspectSupport.java(Compiled Code))
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java(Compiled Code))
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java(Compiled Code))
at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java(Compiled Code))
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java(Compiled Code))
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java(Compiled Code))
at $Proxy84.getRcptDetails(Unknown Source)
at com.inil.ins.fep.collections.processor.RcptRetrieveDepoDetailsRequestProcessor.process(RcptRetrieveDepoDetailsRequestProcessor.java:119)
at com.hsbc.esf.requestprocessing.eventmapping.impl.ProcessorEventMappingAction.execute(ProcessorEventMappingAction.java(Compiled Code))
at com.hsbc.esf.requestprocessing.eventmapping.impl.DefaultEventMapping.process(DefaultEventMapping.java(Compiled Code))
at com.hsbc.esf.requestprocessing.flow.eventmapping.FlowEventMappingHandler.doProcess(FlowEventMappingHandler.java(Compiled Code))
at com.hsbc.esf.requestprocessing.flow.eventmapping.FlowEventMappingHandler.process(FlowEventMappingHandler.java(Compiled Code))
at com.hsbc.esf.jsf.requestprocessing.lifecycle.portlet.impl.AbstractLifecycle.executePhase(AbstractLifecycle.java(Compiled Code))
at com.hsbc.esf.jsf.requestprocessing.lifecycle.portlet.impl.AbstractLifecycle.execute(AbstractLifecycle.java(Compiled Code))
at com.hsbc.esf.jsf.requestprocessing.eventmapping.portlet.AbstractJSFEventMappingHandler.processAction(AbstractJSFEventMappingHandler.java(Compiled Code))
at com.hsbc.esf.jsf.requestprocessing.eventmapping.portlet.AbstractJSFEventMappingHandler.process(AbstractJSFEventMappingHandler.java(Compiled Code))
at com.hsbc.esf.requestprocessing.eventmapping.impl.ProcessorInvokerInterceptor.preProcess(ProcessorInvokerInterceptor.java(Compiled Code))
at com.hsbc.esf.requestprocessing.impl.AbstractInterceptor.process(AbstractInterceptor.java(Compiled Code))
at com.hsbc.esf.requestprocessing.impl.AbstractInterceptor.process(AbstractInterceptor.java(Compiled Code))
at com.hsbc.esf.requestprocessing.impl.AbstractInterceptor.process(AbstractInterceptor.java(Compiled Code))
at com.hsbc.esf.requestprocessing.impl.InterceptorChain.process(InterceptorChain.java(Compiled Code))
at com.hsbc.esf.requestprocessing.portlet.impl.PortletFrontController.processActionRequest(PortletFrontController.java(Compiled Code))
at com.hsbc.esf.requestprocessing.portlet.impl.PortletFrontController.doActionService(PortletFrontController.java(Compiled Code))
at org.springframework.web.portlet.FrameworkPortlet.processRequest(FrameworkPortlet.java(Compiled Code))
at org.springframework.web.portlet.FrameworkPortlet.processAction(FrameworkPortlet.java(Compiled Code))
at com.ibm.wps.pe.pc.std.cmpf.impl.PortletFilterChainImpl.processAction(PortletFilterChainImpl.java(Compiled Code))
at com.ibm.wps.propertybroker.standard.filter.PropertyBrokerActionFilter.processAction(PropertyBrokerActionFilter.java(Compiled Code))
at com.ibm.wps.pe.pc.std.cmpf.impl.PortletFilterChainImpl.processAction(PortletFilterChainImpl.java(Compiled Code))
at com.ibm.wps.pe.pc.std.invoker.impl.PortletServlet.dispatch(PortletServlet.java(Compiled Code))
at com.ibm.wps.pe.pc.std.invoker.impl.PortletServlet.doPost(PortletServlet.java(Compiled Code))
at javax.servlet.http.HttpServlet.service(HttpServlet.java(Compiled Code))
at com.ibm.wps.pe.pc.std.cache.CacheablePortlet.service(CacheablePortlet.java(Compiled Code))
at javax.servlet.http.HttpServlet.service(HttpServlet.java(Compiled Code))
at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java(Compiled Code))
at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java(Compiled Code))
at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.include(WebAppRequestDispatcher.java(Compiled Code))
at com.ibm.wps.pe.om.definition.impl.ServletDefinitionImpl$RDWrapper.include(ServletDefinitionImpl.java(Compiled Code))
at com.ibm.wps.pe.pc.std.invoker.impl.PortletInvokerImpl.invoke(PortletInvokerImpl.java(Compiled Code))
at com.ibm.wps.pe.pc.std.invoker.impl.PortletInvokerImpl.invoke(PortletInvokerImpl.java(Compiled Code))
at com.ibm.wps.pe.pc.std.invoker.impl.PortletInvokerImpl.action(PortletInvokerImpl.java(Compiled Code))
at com.ibm.wps.pe.pc.std.event.ActionEvent.execute(ActionEvent.java(Compiled Code))
at com.ibm.wps.pe.pc.std.event.EventQueueManager.processEventLoop(EventQueueManager.java(Compiled Code))
at com.ibm.wps.pe.pc.std.PortletContainerImpl.performEvents(PortletContainerImpl.java(Compiled Code))
at com.ibm.wps.pe.pc.PortletContainerImpl.performEvents(PortletContainerImpl.java(Compiled Code))
at com.ibm.wps.engine.phases.WPActionPhase.processPortlets(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.ServletWrapper.service(ServletWrapper.java(Compiled Code))
at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java(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.ibm.catalog.servlet.filter.ParameterFilter.doFilter(ParameterFilter.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.filter.WebAppFilterChain._doFilter(WebAppFilterChain.java(Compiled Code))
at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java(Compiled Code))
at com.ibm.ws.webcontainer.webapp.WebApp.handleRequest(WebApp.java(Compiled Code))
at com.ibm.ws.webcontainer.webapp.WebGroup.handleRequest(WebGroup.java(Compiled Code))
at com.ibm.ws.webcontainer.VirtualHost.handleRequest(VirtualHost.java(Compiled Code))
at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java(Compiled Code))
at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java(Compiled Code))
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java(Compiled Code))
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewInformation(HttpInboundLink.java(Compiled Code))
at com.ibm.ws.http.channel.inbound.impl.HttpICLReadCallback.complete(HttpICLReadCallback.java(Compiled Code))
at com.ibm.ws.tcp.channel.impl.WorkQueueManager.requestComplete(WorkQueueManager.java(Compiled Code))
at com.ibm.ws.tcp.channel.impl.WorkQueueManager.attemptIO(WorkQueueManager.java(Compiled Code))
at com.ibm.ws.tcp.channel.impl.WorkQueueManager.workerRun(WorkQueueManager.java(Compiled Code))
at com.ibm.ws.tcp.channel.impl.WorkQueueManager$Worker.run(WorkQueueManager.java(Compiled Code))
at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java(Compiled Code))
Caused by: com.ibm.db2.jcc.c.SqlException: DB2 SQL error: SQLCODE: -727, SQLSTATE: 56098, SQLERRMC: 2;-440;42884;SYSIBM.SQLCAMESSAGECCSID|PROCEDURE
at com.ibm.db2.jcc.c.SqlException.a(SqlException.java(Compiled Code))
at com.ibm.db2.jcc.c.p.a(p.java(Compiled Code))
at com.ibm.db2.jcc.c.li.a(li.java(Compiled Code))
at com.ibm.db2.jcc.c.SqlException.getMessage(SqlException.java(Compiled Code))
at java.lang.Throwable.getLocalizedMessage(Throwable.java(Compiled Code))
at java.lang.Throwable.toString(Throwable.java(Compiled Code))
at java.lang.String.valueOf(String.java(Inlined Compiled Code))
at java.lang.StringBuffer.append(StringBuffer.java(Inlined Compiled Code))
at java.lang.Throwable.printStackTraceAsCause(Throwable.java(Compiled Code))
at java.lang.Throwable.printStackTrace(Throwable.java(Compiled Code))
at org.hibernate.exception.NestableRuntimeException.printPartialStackTrace(NestableRuntimeException.java:199)
at org.hibernate.exception.NestableDelegate.printStackTrace(NestableDelegate.java:327)
at org.hibernate.exception.NestableRuntimeException.printStackTrace(NestableRuntimeException.java:195)
at org.apache.log4j.spi.ThrowableInformation.getThrowableStrRep(ThrowableInformation.java(Inlined Compiled Code))
at org.apache.log4j.spi.LoggingEvent.getThrowableStrRep(LoggingEvent.java(Inlined Compiled Code))
at org.apache.log4j.WriterAppender.subAppend(WriterAppender.java(Compiled Code))
at org.apache.log4j.RollingFileAppender.subAppend(RollingFileAppender.java(Compiled Code))
at org.apache.log4j.WriterAppender.append(WriterAppender.java(Compiled Code))
at org.apache.log4j.AppenderSkeleton.doAppend(AppenderSkeleton.java(Compiled Code))
at org.apache.log4j.helpers.AppenderAttachableImpl.appendLoopOnAppenders(AppenderAttachableImpl.java(Compiled Code))
at org.apache.log4j.Category.callAppenders(Category.java(Compiled Code))
at org.apache.log4j.Category.forcedLog(Category.java(Inlined Compiled Code))
at org.apache.log4j.Category.log(Category.java(Compiled Code))
at org.apache.commons.logging.impl.Log4JLogger.fatal(Log4JLogger.java:274)
at com.hsbc.esf.exceptionhandling.ErrorRecorderThrowableLogger.doLogging(ErrorRecorderThrowableLogger.java:26)
at com.hsbc.esf.exceptionhandling.ThrowableLogger.process(ThrowableLogger.java:32)
at com.hsbc.esf.exceptionhandling.ApplicationErrorHandler.executePreEventmappingsProcessors(ApplicationErrorHandler.java(Compiled Code))
at com.hsbc.esf.requestprocessing.portlet.exceptionhandling.PortletApplicationErrorHandler.executePreEventmappingsProcessors(PortletApplicationErrorHandler.java:45)
at com.hsbc.esf.exceptionhandling.ApplicationErrorHandler.process(ApplicationErrorHandler.java(Compiled Code))
... 58 more