Support #4060
SCP ID# 1895 : Unable to approve bind token-QL Resources Bhd
Status: | Closed - End of life cycle | Start date: | January 03, 2014 | |
---|---|---|---|---|
Priority: | Normal | Due date: | ||
Assignee: | Ahmad Hazri | % Done: | 0% | |
Category: | - | Spent time: | - | |
Target version: | - |
Description
Hi Penril,
BBO cannot approve token.
We find out from RCAS DB both id MYQLRESO9D and MYQLRESO9U was duplicate.
Please check.
History
#1 Updated by Ting Wei Gan over 10 years ago
- File rcas_1_24.zip added
- File rcas_2_24.zip added
- File duplicate_user.gif added
- Status changed from New - Begin Life Cycle to Development / Work In Progress
Provided the queries below to update the duplicate entries to dummy.
update TB_AM_USER set U_USER_ALIAS = 'MYQLRESO9D-DUMMY1' where U_USER_ID = '1226054451'
update TB_AM_USER set U_USER_ALIAS = 'MYQLRESO9U-DUMMY1' where U_USER_ID = '1836604315'
update TB_AM_USER_EXT set E_USER_ALIAS = 'MYQLRESO9D-DUMMY1' where E_USER_ID = '1226054451'
update TB_AM_USER_EXT set E_USER_ALIAS = 'MYQLRESO9U-DUMMY1' where E_USER_ID = '1836604315'
Logs (rcas_1_24.zip, rcas_2_24.zip) provided for the investigation of duplicate user creation.
#2 Updated by Ahmad Hazri over 10 years ago
- Status changed from Development / Work In Progress to Pending Prod Deployment
- Assignee changed from Ting Wei Gan to Hartanto Boby
#3 Updated by Hartanto Boby over 10 years ago
- Status changed from Pending Prod Deployment to Closed - End of life cycle
- Assignee changed from Hartanto Boby to Ahmad Hazri
caused by duplicate id. fix still in UAT