An error appears when upgrading the second member of an UVMS Cluster - "ORA-00001: unique constraint"

Products

• CA Automic Dollar Universe

Issue/Introduction

Error Message :
These kind of error messages appear when upgrading the second member:

####################################################
INSERT INTO UNI_UV_PERMISSIONS (ID, ROLE_ID, PERMISSION_CLASS, PROTECTED_RESOURCE, ACTION_NAME, IS_POSITIVE) 
VALUES (8, 1, 'MANAGEMENT_SERVER_DUX_ADMINISTRATION', '*', '*', 1) 

Fatal Error due to JDBC error 1: ORA-00001: unique constraint (EUPRDUVMS.PK_UNI_UV_PERMISSIONS) violated 

java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (EUPRDUVMS.PK_UNI_UV_PERMISSIONS) violated
####################################################

Patch level detected:Univiewer Management Server 6.2.00
Product Version: Dollar.Universe 6.2.0

Description :An error occurs when upgrading the second member of an UVMS Cluster

Environment

OS: All
Related configuration item(s): UVMS in Cluster Mode

Cause

Cause type:
Defect
Root Cause: The script that upgraded the database was launched twice.

Resolution

The issue has been fixed via the new architecture introduced on UVMS 6.3.01
As a result, the UVMS in mode Cluster is deprecated and it is replaced by a Master / Failover UVMS that are never started at the same time.

Fix Status: Released

Fix Version(s):
Component: Univiewer.Management.Server
Version: Dollar.Universe 6.3.01

Additional Information

Workaround :
N/A