Support #13514

[SCP ID :##6679##] : BVMC portal issue

Added by Zahir Abd Latif over 1 year ago. Updated over 1 year ago.

Status:Closed - End of life cycleStart date:May 25, 2023
Priority:NormalDue date:
Assignee:Zahir Abd Latif% Done:

100%

Category:MY BVMCSpent 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.

Also available in: Atom PDF