Error when trying to register a duas node 6 that was previously removed from UVMS: "A similar object already exists in the database"
book
Article ID: 86264
calendar_today
Updated On:
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