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%