Support #8834
SCP ID :##4767##] : FTT Error Exception - 25102018
Status: | Closed - End of life cycle | Start date: | October 25, 2018 | |
---|---|---|---|---|
Priority: | High | Due date: | ||
Assignee: | Zahir Abd Latif | % Done: | 100% | |
Category: | MY BIB | Spent time: | - | |
Target version: | - |
Description
Hi,
Kindly attend below request:-
Please help to check on Labuan transaction as we received below alert. Kindly advise.
Transaction Id: 201810250000295554 Amount: 2500 my.com.kfhbib.error.exception.IBServiceException: at my.com.kfhbib.error.handler.IBErrorHandler.createServiceException(IBErrorHandler.java:172) at my.com.kfhbib.hibernate.utils.HibernateDBUtils.getCollectionAccNo(HibernateDBUtils.java:349) at my.com.kfhbib.enterprise.services.BIBUtils.getCollectionAccountNoWithoutBV(BIBUtils.java:2013) at my.com.kfhbib.enterprise.services.BIBUtils.getCollectionAccountNo(BIBUtils.java:2018) at my.com.kfhbib.web.utils.IBLogger.logFttTransfer(IBLogger.java:1264) at my.com.kfhbib.enterprise.services.bib104_fundtransfer.ftt.IBFttResultsServices.logTransaction(IBFttResultsServices.java:1533) at my.com.kfhbib.enterprise.services.bib104_fundtransfer.ftt.IBFttResultsServices.getFttResults(IBFttResultsServices.java:224) at my.com.kfhbib.controller.actions.bib104_fundtransfer.ftt.IBFttResultsAction.execute(IBFttResultsAction.java:108) at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484) at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274) at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482) at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:525) at my.com.kfhbib.web.utils.IBActionServlet.doPost(IBActionServlet.java:81) at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at javax.servlet.http.HttpServlet.service(HttpServlet.java:810) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at my.com.kfhbib.web.utils.SetSessionTimeout.doFilter(SetSessionTimeout.java:95) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178) at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:175) at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:74) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105) at org.jboss.web.tomcat.tc5.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:156) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148) at org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:199) at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:282) at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:767) at org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:697) at org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:889) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684) at java.lang.Thread.run(Thread.java:595)
History
#1 Updated by Zahir Abd Latif almost 6 years ago
- Status changed from New - Begin Life Cycle to Closed - End of life cycle
- Assignee changed from Hafizudin MD to Zahir Abd Latif
- % Done changed from 0 to 100
Hafiz,Oct 29, 2018 12:33 PM:-
Hi Alen, From our investigation, FTT transaction failed due unable to execute query to get GL account from database. Please refer log below for details:- Log 2018/10/25 10:09:08:686 ERROR kfhbib.hibernate.utils.HibernateDBUtils: Error code : 0000 2018/10/25 10:09:08:686 ERROR kfhbib.hibernate.utils.HibernateDBUtils: Error details : could not execute query Exception class : org.hibernate.exception.SQLStateConverter, class method : handledNonSpecificException, line number : 126org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:126) org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:114) org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66) org.hibernate.loader.Loader.doList(Loader.java:2231) org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2125) org.hibernate.loader.Loader.list(Loader.java:2120) org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:401) org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:361) org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:196) org.hibernate.impl.SessionImpl.list(SessionImpl.java:1148) org.hibernate.impl.QueryImpl.list(QueryImpl.java:102) org.hibernate.impl.AbstractQueryImpl.uniqueResult(AbstractQueryImpl.java:835) my.com.kfhbib.hibernate.utils.HibernateDBUtils.getCollectionAccNo(HibernateDBUtils.java:338) my.com.kfhbib.enterprise.services.BIBUtils.getCollectionAccountNoWithoutBV(BIBUtils.java:2013) my.com.kfhbib.enterprise.services.BIBUtils.getCollectionAccountNo(BIBUtils.java:2018) my.com.kfhbib.web.utils.IBLogger.logFttTransfer(IBLogger.java:1264) my.com.kfhbib.enterprise.services.bib104_fundtransfer.ftt.IBFttResultsServices.logTransaction(IBFttResultsServices.java:1533) my.com.kfhbib.enterprise.services.bib104_fundtransfer.ftt.IBFttResultsServices.getFttResults(IBFttResultsServices.java:224) my.com.kfhbib.controller.actions.bib104_fundtransfer.ftt.IBFttResultsAction.execute(IBFttResultsAction.java:108) org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484) org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274) org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482) org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:525) my.com.kfhbib.web.utils.IBActionServlet.doPost(IBActionServlet.java:81) javax.servlet.http.HttpServlet.service(HttpServlet.java:717) javax.servlet.http.HttpServlet.service(HttpServlet.java:810) org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252) org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) my.com.kfhbib.web.utils.SetSessionTimeout.doFilter(SetSessionTimeout.java:95) org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96) org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213) org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178) org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:175) org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:74) org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126) org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105) org.jboss.web.tomcat.tc5.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:156) org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107) org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148) org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:199) org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:282) org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:767) org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:697) org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:889) org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684) java.lang.Thread.run(Thread.java:595)
Issue closed in SCP.