Support #13608
[SCP ID :##6763##] : PROD/BBO/PH/PHSLCI/20230810 : BBO CHECKER UNABLE TO APPROVE UNBIND TOKEN TASK
Status: | Work Completed-End life cycle | Start date: | August 14, 2023 | ||
---|---|---|---|---|---|
Priority: | Normal | Due date: | |||
Assignee: | Zahir Abd Latif | % Done: | 90% | ||
Category: | - | Spent time: | - | ||
Target version: | - |
Description
Hi,
Kindly attend below request:-
2 different token tied to same userid, Please help to check.
History
#1 Updated by Ngoh Chee Onn about 1 year ago
- Status changed from New - Begin Life Cycle to Work Completed-End life cycle
- Assignee changed from Ngoh Chee Onn to Zahir Abd Latif
- % Done changed from 0 to 90
Hi Zahir,
The solution had been implemented in the production, you may proceed to close the case.
Root Cause:
- Only 1 record duplicate user id assigned to the same token serial number in 2014 and no other records found after that. I believe this was the junk data during the previous CR release and issue had been resolved. So, no other duplicated records after 2014 until today.
Resolution:
- Patch the junk data with below query to resolve the case cannot unbind token task.
update TB_AM_VASCO set V_USER_ID = null, V_DP_ASSIGNED = 0 where V_SERIAL_NO = '2688576839';