Support #6739

[SCP ID :##3446##] : KFH online login failure.

Added by Zahir Abd Latif almost 8 years ago. Updated almost 8 years ago.

Status:Closed - End of life cycleStart date:October 31, 2016
Priority:HighDue date:
Assignee:Zahir Abd Latif% Done:

100%

Category:Information SiteSpent 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.

Also available in: Atom PDF