Support #10096: [SCP ID :##5066##] : FPX Transaction Unsuccessful - KFH Support - Penril Support System

Support #10096

[SCP ID :##5066##] : FPX Transaction Unsuccessful

Added by Zahir Abd Latif about 5 years ago. Updated about 5 years ago.

Status:

Closed - End of life cycle

Start date:

August 07, 2019

Priority:

High

Due date:

Assignee:

Zahir Abd Latif

% Done:

100%

Category:

MY RIB

Spent time:

Target version:

Description

Hi,
Kindly attend below request:

Customer performed FPX transaction amounting RM1,492.00 dated 07/08/2019 transaction status show as unsuccessful once approver approved the transaction.

Attached transaction details as per below screenshot.

Transaction date: 2019-08-07 10:17:07
Verified Date: 2019-08-07 10:17:07
Approved Date: 2019-08-07 10:40:53 (ANNIEON2018)
Approved Date: 2019-08-07 11:12:24 (KUHANESH2018)

Kindly assist

History

#1 Updated by Zahir Abd Latif about 5 years ago

Status changed from New - Begin Life Cycle to Pending Customer Feedback
Assignee changed from Hafizudin MD to Zahir Abd Latif
% Done changed from 0 to 100

Hafiz, Aug 16, 2019 04:42 PM:-

From our investigation, We find BIB system unable to get transaction limit from database. If this issue happen frequently, please restart BV service. Please refer log below for details

LOG

2019/08/07 11:12:25:748 ERROR kfhbib.hibernate.utils.HibernateGenericDBUtils: Error code : 0000
2019/08/07 11:12:25:749 ERROR kfhbib.hibernate.utils.HibernateGenericDBUtils: Error details : null
Exception class : oracle.jdbc.driver.OracleStatement, class method : getColumnIndex, line number : 3292oracle.jdbc.driver.OracleStatement.getColumnIndex(OracleStatement.java:3292)
oracle.jdbc.driver.OracleResultSetImpl.findColumn(OracleResultSetImpl.java:1914)
oracle.jdbc.driver.OracleResultSet.getBoolean(OracleResultSet.java:1527)
com.mchange.v2.c3p0.impl.NewProxyResultSet.getBoolean(NewProxyResultSet.java:2391)
org.hibernate.type.BooleanType.get(BooleanType.java:46)
org.hibernate.type.NullableType.nullSafeGet(NullableType.java:184)
org.hibernate.type.NullableType.nullSafeGet(NullableType.java:173)
org.hibernate.type.AbstractType.hydrate(AbstractType.java:105)
org.hibernate.persister.entity.AbstractEntityPersister.hydrate(AbstractEntityPersister.java:2124)
org.hibernate.loader.Loader.loadFromResultSet(Loader.java:1404)
org.hibernate.loader.Loader.instanceNotYetLoaded(Loader.java:1332)
org.hibernate.loader.Loader.getRow(Loader.java:1230)
org.hibernate.loader.Loader.getRowFromResultSet(Loader.java:603)
org.hibernate.loader.Loader.doQuery(Loader.java:724)
org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:259)
org.hibernate.loader.Loader.loadEntity(Loader.java:1881)
org.hibernate.loader.entity.AbstractEntityLoader.load(AbstractEntityLoader.java:71)
org.hibernate.loader.entity.AbstractEntityLoader.load(AbstractEntityLoader.java:65)
org.hibernate.persister.entity.AbstractEntityPersister.load(AbstractEntityPersister.java:3072)
org.hibernate.event.def.DefaultLoadEventListener.loadFromDatasource(DefaultLoadEventListener.java:434)
org.hibernate.event.def.DefaultLoadEventListener.doLoad(DefaultLoadEventListener.java:415)
org.hibernate.event.def.DefaultLoadEventListener.load(DefaultLoadEventListener.java:165)
org.hibernate.event.def.DefaultLoadEventListener.proxyOrLoad(DefaultLoadEventListener.java:223)
org.hibernate.event.def.DefaultLoadEventListener.onLoad(DefaultLoadEventListener.java:126)
org.hibernate.impl.SessionImpl.fireLoad(SessionImpl.java:905)
org.hibernate.impl.SessionImpl.get(SessionImpl.java:842)
org.hibernate.impl.SessionImpl.get(SessionImpl.java:835)
my.com.kfhbib.hibernate.utils.HibernateGenericDBUtils.findByIdentifier(HibernateGenericDBUtils.java:284)
my.com.kfhbib.hibernate.utils.HibernateFundTransferUtils.getTransLimitByAccountNo(HibernateFundTransferUtils.java:86)
my.com.kfhbib.enterprise.services.IBEnterpriseResultsServices.getTransactionLimit(IBEnterpriseResultsServices.java:203)
my.com.kfhbib.enterprise.services.bib115_fpx.IBFpxResultServices.executeFpx(IBFpxResultServices.java:335)
my.com.kfhbib.enterprise.services.bib108_checker_maker.IBCheckerResultsServices.executeTransaction(IBCheckerResultsServices.java:591)
my.com.kfhbib.enterprise.services.bib108_checker_maker.IBCheckerResultsServices.executeVerification(IBCheckerResultsServices.java:272)
my.com.kfhbib.controller.actions.bib108_checker_maker.IBCheckerResultsAction.execute(IBCheckerResultsAction.java:180)
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)

#2 Updated by Zahir Abd Latif about 5 years ago

Issue closed in SCP.

#3 Updated by Zahir Abd Latif about 5 years ago

Status changed from Pending Customer Feedback to Closed - End of life cycle

Also available in: Atom PDF

B - Production Support » KFH Support