Bug #1615
CMS Application could not do Query User Profile properly
| Status: | Dropped-End of life cycle | Start date: | August 07, 2012 | |
|---|---|---|---|---|
| Priority: | High | Due date: | August 07, 2012 | |
| Assignee: | % Done: | 100% | ||
| Category: | - | Estimated time: | 2.00 hours | |
| Target version: | - | Spent time: | 2.00 hours |
Description
CMS calls UA_QueryUserProserfile, but cannot get the expected value for internalUserIndi
2012/08/06 12:28:10:103 ERROR com.upass.db.DBOperations: [getTokenFromStore] no record found! AIACOAIACO10U
2012/08/06 12:28:10:103 ERROR com.upass.db.DBOperations: [getTokenFromStore] no record found! AIACOAIACO10U
2012/08/06 12:28:10:104 INFO DEDICATED: [UA_QueryUserProfile] Response: <msg><msgHeader><responseCode>0</responseCode></msgHeader><msgBody><userID>AIACO10U</userID><userStatus>DORMANT</userStatus><companyID>AIACO</companyID><userName>Mohd Shahril Bin Mustapha-DISABLED</userName><icPassport>0</icPassport><email>mohdshahril.mustapha@aia-afg.com</email><mobileNo>0000000000</mobileNo><countryCode>MY</countryCode><internalUserIndi>N</internalUserIndi><authMode>S</authMode><autoSendIndi>N</autoSendIndi><application>103</application><tokenSerial/></msgBody></msg>
2012/08/06 12:28:12:257 INFO my.com.upass.UPassController: Constructor::UPassController()
2012/08/06 12:28:12:257 INFO my.com.upass.UPassController: Constructor::UPassController()
2012/08/06 14:34:44:954 INFO DEDICATED: [UA_QueryUserProfile] ADMIN:{UpassAdmin} LOGIN ID:{AIACO10U} COMPANY ID:{AIACO} APPLICATION ID:{103}
2012/08/06 14:34:45:034 ERROR com.upass.db.DBOperations: [getTokenFromStore] no record found! AIACOAIACO10U
2012/08/06 14:34:45:034 ERROR com.upass.db.DBOperations: [getTokenFromStore] no record found! AIACOAIACO10U
2012/08/06 14:34:45:035 INFO DEDICATED: [UA_QueryUserProfile] Response: <msg><msgHeader><responseCode>0</responseCode></msgHeader><msgBody><userID>AIACO10U</userID><userStatus>DORMANT</userStatus><companyID>AIACO</companyID><userName>Mohd Shahril Bin Mustapha-DISABLED</userName><icPassport>0</icPassport><email>mohdshahril.mustapha@aia-afg.com</email><mobileNo>0000000000</mobileNo><countryCode>MY</countryCode><internalUserIndi>N</internalUserIndi><authMode>S</authMode><autoSendIndi>N</autoSendIndi><application>103</application><tokenSerial/></msgBody></msg>
2012/08/06 14:34:48:228 INFO my.com.upass.UPassController: Constructor::UPassController()
2012/08/06 14:34:48:228 INFO my.com.upass.UPassController: Constructor::UPassController()
History
#1
Updated by Rayvandy Gabbytian about 12 years ago
- Status changed from Development / Work In Progress to Internal Testing
- % Done changed from 0 to 100
Reasons why the userInternalIndi (E_INTERNAL_INDI from TB_AM_EXT = 'N'), noted that Application access is also set to 999 (this will cause CAS System to crash when hit the user details, since there is no key for 999 to display which application it belongs to) :
Those that was tagged as 'N' are migrated over from SSO.
This category is there because there's no user role being defined in SSO.
So CAS assumed that this user is not a valid user.
But since Maybank wanted to migrate all users over from SSO,
we made this tagging so that they should not be reused anymore.
According to migration logs:
2011/09/16 01:54:11:287 DEBUG users: [IN] Processing UID aiaco10u at line 2165
2011/09/16 01:54:11:287 DEBUG users: [OUT] Processed UID AIACO10U
2011/09/16 01:54:11:287 DEBUG users: [IN] Processing ADMIN_ROLES at line 2165
2011/09/16 01:54:11:287 WARN users: ==== ENTRY WARNING START ====
2011/09/16 01:54:11:287 WARN users: [ROLE] Unknown mapped to 999(Unknown) and No User Type
2011/09/16 01:54:11:287 WARN users: ==== ENTRY WARNING END ====
2011/09/16 01:54:11:287 WARN users: ==== ENTRY WARNING START ====
2011/09/16 01:54:11:287 WARN users: [USER TYPE] Unknown set to No Autosend and System Generated Password
2011/09/16 01:54:11:287 WARN users: ==== ENTRY WARNING END ====
How to solve:
DELETE TB_AM_APPSERV WHERE A_USER_ID = 2376;
UPDATE TB_AM_USER_EXT SET E_INTERNAL_INDI = 'E' WHERE E_USER_ID = 2376;
As per 9th August 2012, we are still waiting feedback from users (cc: Maya).
#2
Updated by Rayvandy Gabbytian about 12 years ago
- Status changed from Internal Testing to Dropped-End of life cycle