Support #9125
SCP ID :##4828##] : Insufficient Permision to Login KFHOnline (HD00020382)
| Status: | Closed - End of life cycle | Start date: | December 24, 2018 | |
|---|---|---|---|---|
| Priority: | Normal | Due date: | ||
| Assignee: |  Zahir Abd Latif | % Done: | 100% | |
| Category: | MY RIB | Spent time: | - | |
| Target version: | - |
Description
Hi,
Kindly attend below request:
We received one complaint on our new registered customer where she encountered error message of Insufficient Permission whn she login to KFHOnline.
Upon checking:
- Record in IB_REGISTRATION exist but the was unsuccessful
- Record in BV_USER_PROFILE exist
- Record in BV_USER exist
I have asked contact center to inform user to re-register, however the second attempt was unsuccessful as well. All db records as per mentioned above.
Please help to check why the issue persist. Will provide the logs once available.
History
#1
Updated by Zahir Abd Latif over 5 years ago
- Status changed from New - Begin Life Cycle to Closed - End of life cycle
- Assignee changed from Hafizudin MD to Zahir Abd Latif
- % Done changed from 0 to 100
Kah Yan, Dec 27, 2018 03:16 AM:-
Dear Shikin,
Script to check and update as below:
check in TB_AM_USER table
select * in TB_AM_USER where u_user_alias in (select user_alias from BV_USER where user_id in ('59169', '59250', '59248', '59246'));
IB_REGISTRATION table
update IB_REGISTRATION set STATUS = 'Successful' user_id = '-59169';
update IB_REGISTRATION set STATUS = 'Successful' user_id = '-59250';
update IB_REGISTRATION set STATUS = 'Successful' user_id = '-59248';
update IB_REGISTRATION set STATUS = 'Successful' user_id = '-59246';
commit;
update IB_REGISTRATION set user_id = '59169' user_id = '-59169';
update IB_REGISTRATION set user_id = '59250' user_id = '-59250';
update IB_REGISTRATION set user_id = '59248' user_id = '-59248';
update IB_REGISTRATION set user_id = '59246' user_id = '-59246';
commit;
IB_UACCESS_CREDENTIAL table
insert into ib_uaccess_credential set(user_id,mobile_no,cust_ref_no) values ('59169','60143955649','user_rim_no');
insert into ib_uaccess_credential set(user_id,mobile_no,cust_ref_no) values ('59250','60172358266','114666');
insert into ib_uaccess_credential set(user_id,mobile_no,cust_ref_no) values ('59248','60163329625','114711');
insert into ib_uaccess_credential set(user_id,mobile_no,cust_ref_no) values ('59246','60196288693','114680');
commit;
For user id 59169, pending RIM number to replace the value.
Issue closed in SCP.