Support #12658

[SCP ID :##6055##] : User Status failed Update in DB

Added by Nurul Akmal almost 3 years ago. Updated over 2 years ago.

Status:Work Completed-End life cycleStart date:December 06, 2021
Priority:NormalDue date:
Assignee:Zahir Abd Latif% Done:

100%

Category:BugSpent time:-
Target version:-

Description

Hi Athira,
Kindly attend below request.

Issue: Error 'Your BSN Online account has been locked' once insert Mobile Token

Flow:
1. Once user locked > admin Unlocked user > Temporary password sent to Customer > Customer insert Mobile Token > Prompt same error (1 time insert token)

Checking:
1. Status in IBAM User Maintenance still display Locked even after Admin unlocked
2. Status in BIB_USER still 1 (which is locked)

Action:
1. Unlocked user in IBAM
2. Ensure status 'UNLOCKED' in User Maintenance
3. Ensure db updated with status 2
4. Ask user to relogin
5. User success to login

History

#1 Updated by Nurul Athira Abdul Rahim almost 3 years ago

  • Assignee changed from Nurul Athira Abdul Rahim to Nurul Hasnieza Bt Mohd Zamri

#2 Updated by Nurul Hasnieza Bt Mohd Zamri almost 3 years ago

  • Status changed from New - Begin Life Cycle to Development / Work In Progress

#3 Updated by Nurul Hasnieza Bt Mohd Zamri almost 3 years ago

Need to do DB maintenance - Reorganize DB
Second try unlock user status in db is updated.

#4 Updated by Nurul Hasnieza Bt Mohd Zamri almost 3 years ago

  • Status changed from Development / Work In Progress to Internal Testing
  • Assignee changed from Nurul Hasnieza Bt Mohd Zamri to Nurul Athira Abdul Rahim
  • % Done changed from 0 to 80

DB maintenance has been done on Friday(10/12/2021)

Finding: Issue is intermittent because weaken of db performance.
Solution: Run script DB2 REORG to re-organize the table data to optimize performance.

#5 Updated by Nurul Athira Abdul Rahim over 2 years ago

  • Status changed from Internal Testing to System Integration Test
  • % Done changed from 80 to 90

There is no issue on the flow. Only DB issue.

#6 Updated by Nurul Athira Abdul Rahim over 2 years ago

  • Status changed from System Integration Test to Work Completed-End life cycle
  • Assignee changed from Nurul Athira Abdul Rahim to Zahir Abd Latif
  • % Done changed from 90 to 100

Script run DB in prod on 10/12/21

Also available in: Atom PDF