UVMS Node list not updated with synchronisation

Products

• CA Automic Dollar Universe

Issue/Introduction

Error Message :
N/A

Patch level detected:Univiewer Console 6.1.00
Product Version: Dollar.Universe 6.1.0

Description :UVMS Node list is not updated with synchronisation but full synchronisation is working.
When adding a new node, the field operation_version is not correctly set.
As a result new Dollar universe nodes are not synched to existing nodes.

Cause

Cause type:
Configuration
Root Cause: The issue is that the node operation sequence is desynchronized with the actual max operation version in the node table.

Environment

OS: All

Resolution

To fix this issue you need to do some manual operations.
But first, make sure to backup your UVMS before doing this
(the following steps will modify directly the content of the database).

1 - Shutdown your UVMS

2 - Modify the file uniderby. Change the line:
echo READONLY ON; >> %SQLFILE%
to:
echo READONLY OFF; >> %SQLFILE%

4 - Check the max version using the following command
unienv.bat
uniderby.bat -q "select max(operation_version) from uni_uv_nodes"

5 - Verify that the version is lower than 10000 (if it's not you will have to adapt the following values).

6 - Run the following commands:

uniderby.bat -q "DROP SEQUENCE SEQ_UNI_UV_NODES RESTRICT;"
uniderby.bat -q "CREATE SEQUENCE SEQ_UNI_UV_NODES AS BIGINT START WITH 10000;"
uniderby.bat -q "UPDATE UNI_UV_NODES SET OPERATION_VERSION = 9999 WHERE PRODUCT_TYPE = 'DU' or PRODUCT_TYPE = 'DU_OWLS'"

7 - Modify back the file uniderby. Change the line:
echo READONLY OFF; >> %SQLFILE%
to:
echo READONLY ON; >> %SQLFILE%

8 - Start your UVMS

From now on the DUAS 6 should sync correctly

Fix Status: No Fix

Additional Information

Workaround :
N/A