Support #5285
[SCP ID :##2647##] : IBG OFI Error Page & SI IBG Failed due to ID Invalid Format
Status: | Closed - End of life cycle | Start date: | April 27, 2015 | |
---|---|---|---|---|
Priority: | Normal | Due date: | ||
Assignee: | Zahir Abd Latif | % Done: | 100% | |
Category: | MY IBG | Spent time: | - | |
Target version: | - |
Description
Hi,
Kindly attend below request:
1) Corus OFI Enquiry - We encountered error page while trying to retrieve IBG Trx No. 101406 & 101407 and from account = 003103001403 2) Noticed there were 2 SI IBG trx dated 26/04/2015 were failed with reason Invalid Beneficiary ID Format Suspect these 2 issues are inter-related. Please assist to look into this matter immediately.
History
#1 Updated by Yap Kah Yan over 9 years ago
- File scheduler.log.2015-04-26 added
- File scheduler_consumer3.log.2015-04-26 added
- File 2647.txt added
- Status changed from New - Begin Life Cycle to Development / Work In Progress
Root Cause:
INVALID ID FORMAT : NEW IC
Logs:
2015-04-26 11:06:03,552 INFO [net.penril.ws.IBGWS] (http-0.0.0.0-4242-1) IBG Entry
2015-04-26 11:06:03,552 INFO [net.penril.ws.IBGWS] (http-0.0.0.0-4242-1) assignToIBGEntry
2015-04-26 11:06:03,560 INFO [net.penril.ws.IBGWS] (http-0.0.0.0-4242-1) Method : verifyInputValues
2015-04-26 11:06:03,561 INFO [net.penril.util.IBGGenericUtils] (http-0.0.0.0-4242-1) Transfer Limit : 500000.0 | Amount : 550.0
2015-04-26 11:06:03,562 INFO [net.penril.util.IBGGenericUtils] (http-0.0.0.0-4242-1) Bank Account No Length validation : 12074022287256(14)
2015-04-26 11:06:03,562 INFO [net.penril.ws.IBGWS] (http-0.0.0.0-4242-1) Beneficiary ID Validation
2015-04-26 11:06:03,562 INFO [net.penril.ws.IBGWS] (http-0.0.0.0-4242-1) INVALID ID FORMAT : NEW IC
2015-04-26 11:06:14,455 INFO [net.penril.ws.IBGWS] (http-0.0.0.0-4242-1) IBG Entry
2015-04-26 11:06:14,455 INFO [net.penril.ws.IBGWS] (http-0.0.0.0-4242-1) assignToIBGEntry
2015-04-26 11:06:14,461 INFO [net.penril.ws.IBGWS] (http-0.0.0.0-4242-1) Method : verifyInputValues
2015-04-26 11:06:14,462 INFO [net.penril.util.IBGGenericUtils] (http-0.0.0.0-4242-1) Transfer Limit : 500000.0 | Amount : 310.0
2015-04-26 11:06:14,462 INFO [net.penril.util.IBGGenericUtils] (http-0.0.0.0-4242-1) Bank Account No Length validation : 127007061288286(15)
2015-04-26 11:06:14,462 INFO [net.penril.ws.IBGWS] (http-0.0.0.0-4242-1) Beneficiary ID Validation
2015-04-26 11:06:14,462 INFO [net.penril.ws.IBGWS] (http-0.0.0.0-4242-1) INVALID ID FORMAT : NEW IC
#2 Updated by Yap Kah Yan over 9 years ago
- Status changed from Development / Work In Progress to Pending Customer Feedback
Provided query and patch to cater for -
Query:
bvuserprod:
select * from IB_INTER_TRANSFER where BENEFICIARY_ID = '-' or NEW_IC_NO = '-' or OLD_IC_NO = '-' or BUSINESS_REG_NO = '-' or OTHER_ID_NO = '-';
update IB_INTER_TRANSFER set BENEFICIARY_ID = '' where BENEFICIARY_ID = '-';
update IB_INTER_TRANSFER set NEW_IC_NO = '' where NEW_IC_NO = '-';
update IB_INTER_TRANSFER set OLD_IC_NO = '' where OLD_IC_NO = '-' ;
update IB_INTER_TRANSFER set BUSINESS_REG_NO = '' where BUSINESS_REG_NO = '-';
update IB_INTER_TRANSFER set OTHER_ID_NO = '' where OTHER_ID_NO = '-';
bib
select * from BIB_INTER_TRANSFER where BENEFICIARY_ID = '-' or NEW_IC_NO = '-' or OLD_IC_NO = '-' or BUSINESS_REG_NO = '-' or OTHER_ID_NO = '-';
update BIB_INTER_TRANSFER set BENEFICIARY_ID = '' where BENEFICIARY_ID = '-';
update BIB_INTER_TRANSFER set NEW_IC_NO = '' where NEW_IC_NO = '-';
update BIB_INTER_TRANSFER set OLD_IC_NO = '' where OLD_IC_NO = '-' ;
update BIB_INTER_TRANSFER set BUSINESS_REG_NO = '' where BUSINESS_REG_NO = '-';
update BIB_INTER_TRANSFER set OTHER_ID_NO = '' where OTHER_ID_NO = '-';
Patch:
\10.20.8.35\InternetBanking\Production\20150428_SCP_2647_IBG_OFI_Error_due_to_ID_invalid_Format
#3 Updated by Yap Kah Yan over 9 years ago
- Assignee changed from Yap Kah Yan to Zahir Abd Latif
#4 Updated by Zahir Abd Latif over 9 years ago
- Status changed from Pending Customer Feedback to Closed - End of life cycle
- % Done changed from 0 to 100
Issue closed in SCP.
Refer email:- Re: [Request ID :##2647##] : IBG OFI Error Page & SI IBG Failed due to ID Invalid Format