ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.
USS_MDB database move to a new Unified Self Service installation box
Article ID: 108130
Updated On:
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
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
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.
The problem has been solved.
Additional Information
Feedback
Yes
No
Powered by
