Bug #940
C11-023 - iPAY failuer (EON BANK)
Status: | Work Completed-End life cycle | Start date: | May 26, 2011 | |
---|---|---|---|---|
Priority: | Normal | Due date: | ||
Assignee: | Sarinah Darsy | % Done: | 100% | |
Category: | - | Spent time: | - | |
Target version: | - |
Description
Prompt "Error while performing your request" after click confirm button at step 2/3 of Bene iPAY Account maintenance. Details as per below:
Bene Bank: EON Bank
Account #: 0018200222076
However, customer managed to add Bene iPAY for Maybank.
Tested okay when add other EON Bank Account.
History
#1 Updated by Sarinah Darsy over 13 years ago
- Status changed from New - Begin Life Cycle to Development / Work In Progress
- % Done changed from 0 to 80
Checked from the log files, the root caused is the apostrophe (') symbol at the beneficiary name return by EON Bank, which in our system data field cannot include this all characters [\"<>'%;&+] due to scripting pevention.
At the log file given there is SQL error stated:
011/05/26 16:19:21:432 ERROR kfh.enterprise.services.GenericBVDataServicesImpl: Error code : 0000
2011/05/26 16:19:21:450 ERROR kfh.enterprise.services.GenericBVDataServicesImpl: Error details : SQL ErrorCode=0, State=null, Message=SQL ErrorCode=1756, State=42000, Message=ORA-01756: quoted string not properly terminated
:INSERT INTO IB_IBFT_ACCOUNTS (USER_ID, BENE_ACCT_NUMBER, BANK_CODE, BANK_NAME, IBFT_BANK_MEMBER_ID, BENEFICIARY_NICK_NAME, BENEFICIARY_NAME, BENEFICIARY_EMAIL, LAST_MOD_TIME, MOBILE_NUMBER, REFERENCE, OTHER1, OTHER2) VALUES (1196, '0018200222076', 'EOBBMYKL', 'EON BANK', '589861', 'Noor', 'NOOR SA'AMAH BINTI MD ISA', '', SYSDATE, '', '', '', '')
Exception class : com.broadvision.data.ejb.content.ContentDbSLBean, class method : executeSql, line number : 819com.broadvision.data.ejb.content.ContentDbSLBean.executeSql(ContentDbSLBean.java:819)
sun.reflect.GeneratedMethodAccessor915.invoke(Unknown Source)
#2 Updated by Sarinah Darsy over 13 years ago
- Status changed from Development / Work In Progress to Internal Testing
- % Done changed from 80 to 100
I fixed this bug, by putting the filtering before pass the beneficiary account holder name to Database.
Fixed, and branch created at mercurial at directory: https://hub.penril.net/hg/kfh/branch/iPay_special_character/
#3 Updated by Sarinah Darsy about 13 years ago
- Status changed from Internal Testing to Work Completed-End life cycle
Vincent and Siti Norahayu fixed it and prepared to the UAT.
Migrated Successfully to Production on 05/07/2011.