Support #13514
[SCP ID :##6679##] : BVMC portal issue
Status: | Closed - End of life cycle | Start date: | May 25, 2023 | |
---|---|---|---|---|
Priority: | Normal | Due date: | ||
Assignee: | Zahir Abd Latif | % Done: | 100% | |
Category: | MY BVMC | Spent time: | - | |
Target version: | - |
Description
Hi,
Kindly attend below request:-
As you all aware, currently our kfhib03 and kfhib04 having issue. this has affected bvmc portal, 2 instance down, another 2 having issue to login (http -500).
Is there any workaround to perform activate/unlock customer's KFHOnline?
History
#1 Updated by Zahir Abd Latif over 1 year 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
Hafiz, May 25, 2023:-
We provide you with sql to unlock user. Please wait 1 hour for the customer to forget the password after updating the database. workaround to unlock user Schema bvuserprd select a.user_alias , a.user_id , b.lock_access from bv_user a , bv_user_profile b where a.user_alias='user_alias' and a.user_id = b.user_id; --update bv_user_profile. set lock_access = 2 update bv_user_profile set lock_access='2' where user_id='' commit; note :- lock_access 0 = normal 1 = lock 2 = unlock 3 = TAC lock 4 = TAC unlock 5 = unactivate
Shahrulnizam,Jun 6, 2023:-
issue can be close since portal is now accessible and the servers is stable.
Issue closed in SCP.