Support #12658
[SCP ID :##6055##] : User Status failed Update in DB
Status: | Work Completed-End life cycle | Start date: | December 06, 2021 | |
---|---|---|---|---|
Priority: | Normal | Due date: | ||
Assignee: | Zahir Abd Latif | % Done: | 100% | |
Category: | Bug | Spent 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