Support #10735
[SCP ID :##5305##] : User ID LM18912 not able to login and get response code 99 from RCAS
| Status: | Closed - End of life cycle | Start date: | April 17, 2020 | |
|---|---|---|---|---|
| Priority: | Normal | Due date: | ||
| Assignee: |  Zahir Abd Latif | % Done: | 100% | |
| Category: | - | Spent time: | - | |
| Target version: | - |
Description
Hi,
Kindly attend below request:
Please help for issue user id LM18912 not being able to login and get a response code 99 and when checking in RCAS for user LM18912 RCAS application error.
History
#1
Updated by Ngoh Chee Onn over 4 years ago
- Status changed from New - Begin Life Cycle to Pending Customer Feedback
- % Done changed from 0 to 70
Hi All,
please refer below for the root cause and temporary solution.
Root Cause:++
- Found duplicated user id LM18912 in table tb_am_user table in database. The duplicated user id is able to be created in rcas system, due to existing user id LM18912 created in 2013 not found in table tb_am_usermas, which this table used to validate the existing user.
Temporary solution:++
- As confirmation from business user, user wanna to reuse the user id LM18912 created in 2013. Please refer below for the query to rename the user id created in 2020 to LM18912_BAK.
update TB_AM_USER set U_USER_ALIAS = 'LM18912_BAK' where U_USER_ID = 382;
#2
Updated by Zahir Abd Latif over 4 years ago
- Assignee changed from Ngoh Chee Onn to Zahir Abd Latif
- % Done changed from 70 to 100
Chee Onn, Apr 22, 2020 04:56 PM:-
Root Cause:
- There was duplicate USER_ALIAS 'LM18912' in table ADMIN_USER_PROFILE, due to the same root cause in the last email i sent out.
Resolution:
- Please refer below for the query to update the duplicate USER_ALIAS resolve this issue.
update ADMIN_USER_PROFILE set USER_ALIAS = 'LM18912_BAK' where USER_ID = 1211;
#3
Updated by Zahir Abd Latif over 4 years ago
- Status changed from Pending Customer Feedback to Closed - End of life cycle
Issue closed in SCP.