Support #6739
[SCP ID :##3446##] : KFH online login failure.
Status: | Closed - End of life cycle | Start date: | October 31, 2016 | |
---|---|---|---|---|
Priority: | High | Due date: | ||
Assignee: | Zahir Abd Latif | % Done: | 100% | |
Category: | Information Site | Spent time: | - | |
Target version: | - |
Description
Hi,
Kindly attend below request.
We have 3 customers reported they could not login to KFH Online after their KFH Online been activated.
Upon checking BVMC report for IB registration, all customer registration as IB User was unsuccessful
The BVMC viewing page for the below customer is not as per normal activation page where activation field is not available.
Kindly assist
Details :
Customer 1
Account No. : 007106002295
RIM : 95182
Contact No : 0198278472
Date : 28/10/2016
Customer 2
Account No.: 005106004979
RIM : 95228
Contact No : 0105218637
Error Message : Insufficient Permission.
Date : 28/10/2016
Customer 3
Account No.: 016103005887
RIM : 87883
Contact No : 0132967544
Error Message : Insufficient Permission.
Date : 27/10/2016
History
#1 Updated by Zahir Abd Latif almost 8 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
Update by Chee Ping, Nov 3, 2016 12:09 PM:_
Dear Shikin Below are the query for you to remove the failed registration users. Please take note to change the user name "K0175872" to the affected user name. delete from TB_AM_TAC where t_user_id = (select u_user_id from TB_AM_USER where u_user_alias='K0175872'); delete from TB_AM_USER where u_user_alias='K0175872'; delete from TB_AM_USERMAS where m_user_alias='K0175872'; delete from BV_USER where user_alias='K0175872'; delete from bv_user_profile where user_id=(select user_id from BV_USER where user_alias='K0175872'); delete from BV_ACCOUNT where acctholder_id=(select user_id from BV_USER where user_alias='K0175872'); delete from BV_EP_UPROF where user_id=(select user_id from BV_USER where user_alias='K0175872'); delete from BV_KM_UPROF where user_id=(select user_id from BV_USER where user_alias='K0175872'); delete from BV_MR_USER_PROFILE where user_id=(select user_id from BV_USER where user_alias='K0175872'); delete from BV_PM_USER_PROFILE where user_id=(select user_id from BV_USER where user_alias='K0175872'); delete from BV_SAMP_PR_UPROF where user_id=(select user_id from BV_USER where user_alias='K0175872'); delete from IB_UACCESS_CREDENTIAL where user_id=(select user_id from BV_USER where user_alias='K0175872'); delete from IB_USER_EXT_AUTH where user_id=(select user_id from BV_USER where user_alias='K0175872');
#2 Updated by Zahir Abd Latif almost 8 years ago
- Status changed from Pending Customer Feedback to Closed - End of life cycle
Issue closed in SCP.