Support #5109
[SCP ID :##2530##] : iPay - 5/1/2015.
| Status: | Closed - End of life cycle | Start date: | January 06, 2015 | |
|---|---|---|---|---|
| Priority: | Normal | Due date: | January 08, 2015 | |
| Assignee: |  Zahir Abd Latif | % Done: | 100% | |
| Category: | MY RIB | Spent time: | - | |
| Target version: | - |
Description
Hi,
Kindly attend below request:
THERE'S 1 IPAY TRX PERFORMED ON 5.1.14 WAS REFLECTED AS SUCCESSFUL IN PHOENIX, POWERCARD AND MEPS REPORTS. HOWEVER, IN BVMC REPORT THIS TRX WAS UNSUCCESSFUL DUE TO EXCEEDED THE DAILY LIMIT OF RM10K. PLEASE ASSIST TO RECTIFY THIS ISSUE.
History
#1
Updated by Yap Kah Yan over 9 years ago
- Assignee changed from Yap Kah Yan to Hafizudin MD
Hi Hafiz,
Please check on the transfer limit
#2
Updated by Norhaidah Md Dasuki over 9 years ago
- Due date set to January 08, 2015
PAY transfer limit checking and the informations we need from production.
Steps:
###########################################################################
1. Get Max Limit (maxLimit) from IBFTOPEN / IBFTFAV (0 if empty)
2. Get Max Limit (maxLimit) from IBFTLIM (0 if empty)
3. Get Total ibft transfered amount from IBFTOPEN & IBFTFAV + current amount
4. Get user transfer limit from DB
5. if user transfer limit is null,
compare user standard limit (5000) with max limit from IBFTOPEN / IBFTFAV.
if user limit > max limit,
user transfer limit = max limit,
else user transfer limit = user limit
6. Get Total ibft transfered amount from IBFTOPEN / IBFTFAV + current amount
7. if Total ibft transfered amount (IBFTOPEN & IBFTFAV) > max limit from IBFTLIM = fail
8. if Total ibft transfered amount (IBFTOPEN / IBFTFAV) > user transfer limit = fail
###########################################################################
Information we need for further investigate is:
1. Transaction information like, transfer amount, transaction type (new or fav).
2. maxLimit data in IBFTOPEN, IBFTFAV, and IBFTLIM
3. user transfer limit for IBFTOPEN & IBFTFAV
4. Total transaction amount of IBFTOPEN & IBFTFAV done on that day.
#3
Updated by Norhaidah Md Dasuki over 9 years ago
- Status changed from New - Begin Life Cycle to Development / Work In Progress
- % Done changed from 0 to 20
Updated by Chee Ping (14/1/2015):-
refer to below findings. Please focus on the time in red and blue colour. That 2 transaction show in phoenix report is 10:00:42 and 10:01:42, but let look at the transaction in IB_IBFT_TRANSFER table, the second transaction the transaction time is 10:43:54 that is make after that 2 transaction show in phoenix report. Which mean that 2 transaction is not belong to second transaction that exceeded bank maximum daily transfer limit, it belong to the first successful transaction. But why phoenix report will show 2 transaction, on IB side only send 1 transaction?
Table: IB_IBFT_TRANSFER
TRNX_ID TRNX_DATE USER_ID FROM_ACCOUNT_NO AMOUNT STATUS REASON
201501050001724803 05-JAN-15 10:01:41 5493 002105001625 10000 Successful Successful
201501050001724973 05-JAN-15 10:43:54 5493 002105001625 10000 Unsuccessful You have exceeded the bank maximum daily transfer limit of RM10,000.00.
Phoenix Report
Phoenix Ref No Card Number Account Number Date / Time Original Trx Amt Orig. CCY Local Equiv Amt (MYR) Charge
(MYR) FI Code Terminal Number
SW239118150105100041 4678039900024085 002105001625 1/5/2015 10:00:42 AM 10,000.00 MYR 10,000.00 0.00 000001 KFH ONLINE .
SW239121150105100142 4678039900024085 002105001625 1/5/2015 10:01:42 AM 10,000.00 MYR 10,000.00 0.00 000001 KFH ONLINE .
#4
Updated by Norhaidah Md Dasuki over 9 years ago
- File ib_txn_hist.rar added
- Assignee changed from Hafizudin MD to Ngoh Chee Ping
14/1/15 - Updated by Chee Ping
checked the esb log, i found there is 2 same transaction logged in the esb log file. One transaction successfully store in IB_IBFT_TRANSFER table, whereas the other transaction does not. Therefore we need to check there is any duplicate submit of transaction or not. IT help to execute sql query below and send us the result:
SELECT TRNX_ID, TRNX_TYPE FROM IB_TRANSACTION_HISTORY WHERE TRNX_ID>201501050001724780 OR TRNX_ID<201501050001724804
Attached file from IT
#5
Updated by Ngoh Chee Ping over 9 years ago
Still cannot confirm the first transaction is lost, because the transaction ID not only log into transaction history, it also log into SMS and user activity table. Therefore the transaction ID will be jumping inside transaction history table. Now still need to figure out is there any possibility will cause duplicate request sent to esb.
#6
Updated by Ngoh Chee Ping over 9 years ago
- Status changed from Development / Work In Progress to Pending Customer Feedback
- Assignee changed from Ngoh Chee Ping to Zahir Abd Latif
- % Done changed from 20 to 100
Found the exception below in nohup.out. That user should receive session expired in this case. To prevent this to happen again, KFH need to implement logger enhancement.
10:00:12,512 ERROR localhost Exception Processing ErrorPage[exceptionType=java.lang.Throwable, location=/ep/common/catch-all-errors.jsp]
java.lang.IllegalStateException
at org.apache.coyote.Response.reset(Response.java:296)
at org.apache.catalina.connector.Response.reset(Response.java:645)
at org.apache.catalina.connector.Response.reset(Response.java:909)
#7
Updated by Zahir Abd Latif over 9 years ago
- Status changed from Pending Customer Feedback to Closed - End of life cycle