Release : 6.10
Component : DOLLAR UNIVERSE
Subcomponent: UVMS
Some records in tables UNI_UV_PERMISSIONS and UNI_UV_ROLES2 kept automatic creation of Node View / Roles from being created for a specific Company name.
In order to fix the issue, some records needs to be purged from the UVMS Master tables.
Please contact Technical Support to help you diagnose exactly what records need to be deleted.
Example for this case:
uniderby -q "delete from UNI_UV_PERMISSIONS where ROLE_ID in (select ID from UNI_UV_ROLES2 where COMPANY = 'CNA050' and IS_DELETED=0)"
uniderby -q "delete from UNI_UV_ROLES2 where COMPANY = 'CNA050' AND IS_DELETED=0"
Additionally, you will need to upgrade the UVMS Master to version 6.10.21 or superior as some improvements on Roles / Groups queries has been performed in case a Master / Subordinate Architecture is being used.
The synchronization request from the master to the subordinate may take a lot of time caused by multiple requests to the database, which also may result to a high CPU consumption.
The synchronization request has been reduced on the master side.