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

book

Article ID: 4120

calendar_today

Updated On:

Products

DX Infrastructure Management NIMSOFT PROBES

Issue/Introduction

One of my users cannot log in in UMP:

<Please see attached file for image>

login1.JPG 

 

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

 

an-unexpected-system-error-occurred

com.liferay.portal.NoSuchGroupException: No Group exists with the key {companyId=10131, classNameId=10046, classPK=15491}

 

 

Cause

Although a 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.NoSuchGroupException" indicates that UMP is unable to add the liferay user (properly create the user and assign the roles in the User_table) because there is a mismatch between the User_ and Group_ tables. Specifically there is an entry for the user in the  User_  table but not in the Group_ table.

Environment

UIM/UMP 8.x

Resolution

Check if the user is present in the following database tables

select * from user_
select * from group_

In this particular case

User was in the user_ table but not in the group_ table.
Removing the row from the user_ table and recreating the account contact resolved the issue

 

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

 

select * from Group_

select * from User_

 

If the user is only in the User_ table then:

 

2. stop the UMP wasp 

3. execute: 

delete from User_ 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 the affected <user>. 

 

After successful log-in User_ and Group_ for the affected user will be populated correctly.

Additional Information

Related techdoc:

UMP log in error: com.liferay.portal.GroupFriendlyURLException

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

Attachments

1558708390192000004120_sktwi1f5rjvs16r2c.jpeg get_app