Error when trying to register a duas node 6 that was previously removed from UVMS: "A similar object already exists in the database"

Products

• CA Automic Dollar Universe

Issue/Introduction

Error Message :
 When trying to upgrade to v6 a v5 node, we get this error:
#############################################################
"C:\ORSYP\DUAS\TESTUPEXP\TSTUPXexec\bin\unims" -update5 
Error updating information.
Error -2 returned by UVMS: org.springframework.dao.DataIntegrityViolationException: A similar object already exists in the database.; nested exception is org.hibernate.exception.ConstraintViolationException: could not execute update query
#############################################################  

Patch level detected:Univiewer Management Server 6.2.00

Product Version: Dollar.Universe 6.2.0

Description :When trying to upgrade to v6 a v5 node, we get this error:
#############################################################
Error -2 returned by UVMS: org.springframework.dao.DataIntegrityViolationException: A similar object already exists in the database.; nested exception is org.hibernate.exception.ConstraintViolationException: could not execute update query
#############################################################

As a result, upgrade can't continue.

Cause

Cause type:
Defect
Root Cause: N/A

Environment

OS: All

Resolution

In order to clean any record of a give nodename, a new parameter has been included to the UVMS unidlt NODE command: -purge.
It deletes all entries of the node $U5 and $U6.

In order to use it, UVMS must be upgraded to 6.2.21 or superior.

Example of the command:
unidlt node -company -node -purge -type DU

Fix Status: Released

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

Additional Information

Workaround :
N/A