USS_MDB database move to a new Unified Self Service installation box

Products

• CA Service Management - Asset Portfolio Management
• CA Service Management - Service Desk Manager

Issue/Introduction

Customer Used the procedure the move the USS_mdb database from a box to new USS installation box, and gets the error message in the login page:

an-unexpected-system-error-occurred 
com.liferay.portal.NoSuchGroupException: No Group exists with the key {companyId=10154, classNameId=10005, classPK=10723}

He used the following documentation to perform the database moving:
Moving the CA MDB Database on Microsoft SQL Server
Unimpacted CA Service Management Configuration Tables

Cause

After installing the new Unified Self Service box, and before backup the 4 original tables:

os_ExternalSource 
os_ExternalSourceProperties 
PortalPreferences 
User_ 

Customer created a test user to make some tests in environment.
It caused a modification in 2 original tables User_ and ProtalPreferences

Environment

CA Unified Self Service 17.1

Resolution

Manually removed the new user reference from tables: User_ and PortalPreferences
The problem has been solved.

Additional Information

Moving the CA MDB Database on Microsoft SQL Server
Unimpacted CA Service Management Configuration Tables