Support #5032: [SCP ID :##2495##] : Successful Rentas Trxn Having Pending Approval status - KFH Support - Penril Support System

Support #5032

[SCP ID :##2495##] : Successful Rentas Trxn Having Pending Approval status

Added by Ahmad Hazri almost 10 years ago. Updated over 9 years ago.

Status:

Work Completed-End life cycle

Start date:

December 08, 2014

Priority:

Normal

Due date:

January 08, 2015

Assignee:

Zahir Abd Latif

% Done:

100%

Category:

SI Engine

Spent time:

3.00 hours

Target version:

Description

Hi Hafiz

Kindly refer below reported case

There is one successful Rentas transaction performed via CMS on 5th December but the status is still pending approval. When checked in core banking, the account has been debited.

ibg_test_approve_12-1-2015.png (6.92 KB) Yap Kah Yan, January 12, 2015 15:20

History

#1 Updated by Zahir Abd Latif over 9 years ago

Dear Hafiz,

Kindly assist to update the current status in Redmine.
Please help to follow up to see whether we can closed this case or update the status.

Thanks.

#2 Updated by Zahir Abd Latif over 9 years ago

Dear Hafiz/ KFH Support,

Please respond and update the current status in Redmine.

Thanks.

#3 Updated by Norhaidah Md Dasuki over 9 years ago

Due date set to January 08, 2015

IT have transferred 05/12/2014 request logs to \\10.20.8.124\Shared\05122014_ib_logs

Hafiz, Kindly look into it and update the findings.

#4 Updated by Ngoh Chee Ping over 9 years ago

Status changed from New - Begin Life Cycle to Internal Testing
Assignee changed from Hafizudin MD to Yap Kah Yan
% Done changed from 0 to 100

Done the fixes, assign to kah yan to test in development.

#5 Updated by Ngoh Chee Ping over 9 years ago

After checked the log file i found error below also. Cannot insert null into receipt table, just like issue happened before. Need to provide same fix for this case.

ERROR 2014/12/05 10:50:25:480 broadvision.data.server.GenericDao.insertData: An SQL error returned from data source row 0 SQL: INSERT INTO IB_RECEIPT_DETAILS (TRNX_DATE, TRNX_ID, RECEIPT_DETAIL_NAME, RECEIPT_DETAIL_VALUE, SEQUENCE_ID, REFERENCE, OTHER1, OTHER2) VALUES (?, ?, ?, ?, ?, ?, ?, ?)
ERROR 2014/12/05 10:50:25:496 data.ejb.content.ContentDbSLBean.insertData: An SQL error returned from data source {0}. Exception: com.broadvision.data.exceptions.DataException: SQL ErrorCode=0, State=null, Message=SQL ErrorCode=1400, State=23000, Message=ORA-01400: cannot insert NULL into ("BVUSERPRD"."IB_RECEIPT_DETAILS"."RECEIPT_DETAIL_VALUE")

com.broadvision.data.exceptions.DataException: SQL ErrorCode=0, State=null, Message=SQL ErrorCode=1400, State=23000, Message=ORA-01400: cannot insert NULL into ("BVUSERPRD"."IB_RECEIPT_DETAILS"."RECEIPT_DETAIL_VALUE")

at com.broadvision.data.ejb.content.ContentDbSLBean.insertData(ContentDbSLBean.java:4612)
    at sun.reflect.GeneratedMethodAccessor846.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    at java.lang.reflect.Method.invoke(Method.java:585)
    at org.jboss.invocation.Invocation.performCall(Invocation.java:359)
    at org.jboss.ejb.StatelessSessionContainer$ContainerInterceptor.invoke(StatelessSessionContainer.java:237)
    at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invoke(CachedConnectionInterceptor.java:158)
    at org.jboss.ejb.plugins.StatelessSessionInstanceInterceptor.invoke(StatelessSessionInstanceInterceptor.java:169)
    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.invoke(SecurityInterceptor.java:168)
    at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:205)
    at org.jboss.ejb.plugins.CleanShutdownInterceptor.invoke(CleanShutdownInterceptor.java:278)
    at org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invoke(ProxyFactoryFinderInterceptor.java:136)
    at org.jboss.ejb.SessionContainer.internalInvoke(SessionContainer.java:648)
    at org.jboss.ejb.Container.invoke(Container.java:954)
    at sun.reflect.GeneratedMethodAccessor714.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    at java.lang.reflect.Method.invoke(Method.java:585)
    at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
    at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
    at org.jboss.mx.server.Invocation.invoke(Invocation.java:86)
    at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
    at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
    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:209)
    at org.jboss.invocation.InvokerInterceptor.invoke(InvokerInterceptor.java:195)
    at org.jboss.proxy.ejb.RetryInterceptor.invoke(RetryInterceptor.java:176)
    at org.jboss.proxy.TransactionInterceptor.invoke(TransactionInterceptor.java:61)
    at org.jboss.proxy.SecurityInterceptor.invoke(SecurityInterceptor.java:70)
    at org.jboss.proxy.ejb.StatelessSessionInterceptor.invoke(StatelessSessionInterceptor.java:112)
    at org.jboss.proxy.ClientContainer.invoke(ClientContainer.java:100)
    at $Proxy116.insertData(Unknown Source)
    at com.broadvision.data.ejb.content.ContentInfoSLBean.insertData(ContentInfoSLBean.java:4445)
    at sun.reflect.GeneratedMethodAccessor845.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    at java.lang.reflect.Method.invoke(Method.java:585)
    at org.jboss.invocation.Invocation.performCall(Invocation.java:359)
    at org.jboss.ejb.StatelessSessionContainer$ContainerInterceptor.invoke(StatelessSessionContainer.java:237)
    at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invoke(CachedConnectionInterceptor.java:158)
    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.AbstractTxInterceptorBMT.invokeNext(AbstractTxInterceptorBMT.java:173)
    at org.jboss.ejb.plugins.TxInterceptorBMT.invoke(TxInterceptorBMT.java:77)
    at org.jboss.ejb.plugins.StatelessSessionInstanceInterceptor.invoke(StatelessSessionInstanceInterceptor.java:169)
    at org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:168)
    at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:205)
    at org.jboss.ejb.plugins.CleanShutdownInterceptor.invoke(CleanShutdownInterceptor.java:278)
    at org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invoke(ProxyFactoryFinderInterceptor.java:136)
    at org.jboss.ejb.SessionContainer.internalInvoke(SessionContainer.java:648)
    at org.jboss.ejb.Container.invoke(Container.java:954)
    at sun.reflect.GeneratedMethodAccessor714.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    at java.lang.reflect.Method.invoke(Method.java:585)
    at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
    at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
    at org.jboss.mx.server.Invocation.invoke(Invocation.java:86)
    at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
    at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
    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:209)
    at org.jboss.invocation.InvokerInterceptor.invoke(InvokerInterceptor.java:195)
    at org.jboss.proxy.ejb.RetryInterceptor.invoke(RetryInterceptor.java:176)
    at org.jboss.proxy.TransactionInterceptor.invoke(TransactionInterceptor.java:61)
    at org.jboss.proxy.SecurityInterceptor.invoke(SecurityInterceptor.java:70)
    at org.jboss.proxy.ejb.StatelessSessionInterceptor.invoke(StatelessSessionInterceptor.java:112)
    at org.jboss.proxy.ClientContainer.invoke(ClientContainer.java:100)
    at $Proxy114.insertData(Unknown Source)
    at com.broadvision.data.client.DataManagerImpl.insertData(DataManagerImpl.java:2715)
    at com.broadvision.data.client.DataManager.insertData(DataManager.java:1859)
    at my.com.kfh.enterprise.services.GenericBVDataServicesImpl.insertDataSQL(GenericBVDataServicesImpl.java:498)
    at my.com.kfh.web.utils.IBLogger.logReceiptDetail(IBLogger.java:906)
    at my.com.kfh.web.utils.IBLogger.logReceiptDetail(IBLogger.java:844)
    at my.com.kfh.enterprise.services.IBUtils.loopIntoReceiptDetails(IBUtils.java:814)
    at my.com.kfh.enterprise.services.ib104_fundtransfer.interbank.IBInterbankSITransferResultsServices.executeTransaction(IBInterbankSITransferResultsServices.java:513)
    at net.penril.scheduler.job.SIJobConsumer.execute(SIJobConsumer.java:93)
    at org.quartz.core.JobRunShell.run(JobRunShell.java:199)
    at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:543)

#6 Updated by Yap Kah Yan over 9 years ago

File ibg_test_approve_12-1-2015.png added
Status changed from Internal Testing to Development / Work In Progress
Assignee changed from Yap Kah Yan to Ngoh Chee Ping

Attached is the screenshot.

Please correct me if I'm wrong,
if the transaction needs 2 approver, and 1 approver approved, the status should be Pending Approval not Accepted
(IBG/Rentas transactions) ?

if 2 approver already approved, then the status will change to Accepted (IBG/Rentas transactions).

#7 Updated by Ngoh Chee Ping over 9 years ago

Status changed from Development / Work In Progress to Pending Customer Feedback

Actually the status still pending approval because not able to log into receipt table cause this problem. This transaction cannot update the status because the exception throw before update the transaction history table. Therefore, the status still pending approval. Already send a email to KFH to migrate logger enhancement to prevent this kind of issue to happen again.

#8 Updated by Ngoh Chee Ping over 9 years ago

Status changed from Pending Customer Feedback to Work Completed-End life cycle
Assignee changed from Ngoh Chee Ping to Zahir Abd Latif

While waiting the logger enhancement to migrate, KFH decide to update database first. Kah yan already provide the DB script for them to update the database.

#9 Updated by Yap Kah Yan over 9 years ago

Script given:

alter table ib_receipt_details modify receipt_detail_value VARCHAR2 (200 BYTE) null;
alter table bib_receipt_details modify receipt_detail_value VARCHAR2 (200 BYTE) null;

Also available in: Atom PDF

B - Production Support » KFH Support

Issues