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

Document ID : KB000086264
Last Modified Date : 14/04/2018
Show Technical Document Details
Issue:
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.
Environment:
OS: All
Cause:
Cause type:
Defect
Root Cause: N/A
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