Support #12720
[SCP ID :##6090##] : KfhOnline Login Issue | Unknown Error
Status: | Closed - End of life cycle | Start date: | December 30, 2021 | |
---|---|---|---|---|
Priority: | Normal | Due date: | ||
Assignee: | Zahir Abd Latif | % Done: | 100% | |
Category: | MY RIB | Spent time: | - | |
Target version: | - |
Description
Hi Kah Yan,
Kindly assist to check below request.
Customer unable to access KFH Online, message prompted “Unknown Error”.
Kindly assist. Details appended below: Name : AZZIATI BINTI MAMAT User Name : azyatimh729 Date Attempt : 29/12/2021 Time Attempt : 11:10am Name : MUHAMMAD AMINUDIN BIN SHAMSUDIN User Name : amnudn Date Attempt : 29/12/2021 Time Attempt : 11:20am All the related logs can be found from dir below: \\10.20.8.50\Insert Here\IB Logs\29122021
Thank you.
History
#1 Updated by Yap Kah Yan over 2 years ago
- Status changed from New - Begin Life Cycle to Pending Customer Feedback
Root Cause:
User's password was null in TB_AM_USER, was not able to replicate the issue in STG environment
Mitigation:
Suggest updating the column (password cipher) to not allow null value.
Below script was executed at 6-Jan-22.
1. Set null value to dummy
update tb_am_user set P_PASSWD_CIPHERTEXT = 'NULL' where P_PASSWD_CIPHERTEXT is null;
2. Update null constraint
alter table tb_am_user modify P_PASSWD_CIPHERTEXT VARCHAR2 NOT NULL;
#2 Updated by Zahir Abd Latif over 2 years ago
- Status changed from Pending Customer Feedback to Closed - End of life cycle
- Assignee changed from Yap Kah Yan to Zahir Abd Latif
- % Done changed from 0 to 100
Issue closed in SCP.