Support #12784
[SCP ID :##6135##] : unable to activate rib customer account
| Status: | Internal Testing | Start date: | February 07, 2022 | ||
|---|---|---|---|---|---|
| Priority: | Normal | Due date: | |||
| Assignee: |  Siti Balqis Othman | % Done: | 50% | ||
| Category: | RIB | Spent time: | - | ||
| Target version: | - |
Description
Hi,
Kindly attend below request:-
Kindly assist to check as agent unable to activate customer account.
There is no error appear while the process but system like hang after agent click "confirm".
Customer detail as below:
Name: RAHIMAH BINTI HAMZAH
Ic: 760711035798
User name: Rahimah76
Contact number: 601119779838
based on log:
[1/31/22 10:52:06:368 SGT] 00001733 SystemOut O [31/01/2022] [10:52:06:368] [ERROR] [IBSSBusinessException]:141 - [98] System is not ready.
[1/31/22 10:52:06:368 SGT] 00001733 SystemOut O [31/01/2022] [10:52:06:368] [ERROR] [IBSSLoggerBase]:242 -
com.ib.ibss.error.exception.IBSSBusinessException:
at com.ib.ibss.error.handler.IBSSErrorHandler.createBusinessException(IBSSErrorHandler.java:59)at com.ib.ibss.enterprise.services.ss112_user.RetailUserSharedServices.activateUser(RetailUserSharedServices.java:133)at com.ib.ibss.enterprise.services.ss112_user.RetailUserSharedServices.activateUser(RetailUserSharedServices.java:113)at com.ib.ibss.enterprise.services.ss112_user.IBSSRetailUserActivateResultServices.execute(IBSSRetailUserActivateResultServices.java:136)at com.ib.ibss.controller.actions.ss112_user.IBSSRetailUserActivateResultAction.execute(IBSSRetailUserActivateResultAction.java:94)at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484)
History
#1
Updated by Siti Balqis Othman over 2 years ago
- Status changed from New - Begin Life Cycle to Investigation
#2
Updated by Siti Balqis Othman over 2 years ago
- File not case sensitive rahimah.png added
- File ib_user.png added
- File rename_rahimah76.jpeg added
- Status changed from Investigation to Development / Work In Progress
- % Done changed from 0 to 50
Reported Issue:
IBAM user unable to perform activation on the user with username Rahimah76
Root Cause:
Duplication user id with different case with group id 0 which is unknown in the system. This has caused IBAM users unable to activate the user.
Solution:
1) We suggest deleting user id rahimah76 from table TB_AM_USER which causes duplication. We already do confirmation, this user is not valid. We can prove this user is not valid
because based on the IB_USER table, this user does not exist in the IB_USER table as per attach screen shot (ib_user). (Fast fixes)
SQL query
delete TB_AM_USER where U_USER_ID='13814'
delete TB_AM_PASSWORD where P_USER_ID='13814'
2) We suggest cleaning up in the TB_AM_USER. We notice there are 85 user pairs with Group ID 0. All this data is not valid, and it might cause duplication id issues in the future.
I attach an excel file that contains a list of users with group id 0 and have highlighted 3 user id that we suggest not to include in this action.
Prevention:
Update upass create user services with new check user id ignore case method.
Update info on 17/02/2022:
The solution 1 already executed today at 2.55.PM
As per conversation with IT team, they decided to rename the user alias instead of delete the data because of sensitive reason to delete the data.
IT team (kak Ilah) already execute below query at 2.55.PM;
UPDATE TB_AM_USER SET U_USER_ALIAS='rahimah76_del' WHERE U_USER_ID='13814'
#3
Updated by Siti Balqis Othman over 2 years ago
- Status changed from Development / Work In Progress to Internal Testing
Implementation:
- Passing group id value when retrieve data from TB_AM_USER