DX Infrastructure Management

One of my users cannot log in in UMP:

Portal log: Nimsoft/probes/service/wasp/portal.log is showing the following exception:

22 May 2017 16:38:52,767 ERROR [NmsAuth:339] Unable to add user user : com.liferay.portal.GroupFriendlyURLException

Although the user is able to log in into IM and Admin Console it might still be unable to log into UMP if there is any issue in the underlying 'Liferay tables' (User_ / Group_ ). In this case, the exception "com.liferay.portal.GroupFriendlyURLException" indicates that UMP is unable to add the user (create the user in the User_table) because there is a mismatch between the User_ and Group_ tables. Specifically there is an entry for the same user in the Group_ table which doesn't allow the "creation" of the entry for the user in the User_ table. 

To resolve this:

1. Verify if you have an entry for the affected user in the Group_ table but not in the User_ table:

select * from Group_

select * from User_

If so procede:

2. stop the UMP wasp 

3. execute: 

delete from Group_ where userid = '<affected_user_id>' 

3. start wasp 

4. log in as admin > control panel > server administration > reindex all search indexes 

5. log out and log in as <user>. 

Related techdoc:

TEC000003832 UMP login error :com.liferay.portal.NoSuchGroupException: No Group exists with the key

https://www.ca.com/us/services-support/ca-support/ca-support-online/knowledge-base-articles.TEC000003832.html