Support #3529
SCP ID# 777 : eCustody Duplicate User
Status: | Closed - End of life cycle | Start date: | August 30, 2013 | |
---|---|---|---|---|
Priority: | Normal | Due date: | August 30, 2013 | |
Assignee: | Saputra Febhy Toomy | % Done: | 100% | |
Category: | - | Spent time: | 4.00 hours | |
Target version: | - |
Description
eCustody Duplicate User
History
#1 Updated by Ahmad Hazri about 11 years ago
Updated by vincent
Hi Toomy,
Untuk hapuskan dua record dari database produksi, rujuk kepada SQL query dia bawah.
// Query ini untuk check dua record yang sama
SELECT * FROM ADMIN_USER_PROFILE WHERE F_USER_ID IN ('17028', 'PUJI001');
SELECT * FROM IB_USER WHERE USER_ID IN ('17028', 'PUJI001');
// Query ini untuk hapuskan dua record tu.
DELETE FROM ADMIN_USER_PROFILE WHERE F_USER_ID IN ('17028', 'PUJI001');
DELETE FROM IB_USER WHERE USER_ID IN ('17028', 'PUJI001');
// Setelah hapuskan dua record tu, execute query ini untuk check sama ade dua record tu masih wujud atau tidak.
SELECT * FROM ADMIN_USER_PROFILE WHERE F_USER_ID IN ('17028', 'PUJI001');
SELECT * FROM IB_USER WHERE USER_ID IN ('17028', 'PUJI001');
Note: Ini untuk rujukan Toomy dan jangan buat. Hazri akan create case ID and email ke BII team. Kemudian toomy jumpe dengan IT (Lieby) untuk execute SQL Query ini.
Terima Kasih.
#2 Updated by Saputra Febhy Toomy about 11 years ago
- Status changed from New - Begin Life Cycle to Development / Work In Progress
- % Done changed from 0 to 90
- This issue happen because there is duplicate user id in database so we need to check that duplicate user id and to resolved it with delete the duplicate user id.
- Query already execute for check duplicate user id and already delete user id if any duplicate user id.
- After delete that duplicate user id, need to create the same user id again for retest the issue.
Thanks
#3 Updated by Saputra Febhy Toomy about 11 years ago
- Due date set to August 30, 2013
- Status changed from Development / Work In Progress to Finished Development
- % Done changed from 90 to 100
- User already retest for duplicate user in eCustody Admin and no found error.
- This issue already solved.
#4 Updated by Tan Lee Yong about 11 years ago
Has this migrated to production?
#5 Updated by Norhaidah Md Dasuki almost 11 years ago
- Subject changed from eCustody Duplicate User (SCP ID: 777) to SCP ID# 777 : eCustody Duplicate User
#6 Updated by Vincent Devethas almost 11 years ago
- Status changed from Finished Development to Closed - End of life cycle
No fixes for this issue. Provided some workaround to handle this case.
- Delete the duplicated users and re-create new users.