Below problems reported with start of UIM DB Merge Replication process :-
1) data_engine goes red (max restarting). UIM DB schema got messy state. Errors in probe log.
de: (1) ExecuteNoRecords [Microsoft OLE DB Provider for SQL Server] Cannot truncate table 'D_QOS_PROBES' because it is published for replication or enabled for Change Data Capture.
de: COM Error [0x80040e14] IDispatch error #3092 - [Microsoft OLE DB Provider for SQL Server] Cannot truncate table 'D_QOS_PROBES' because it is published for replication or enabled for Change Data Capture.
2) No metric found in USM for all devices
3) MPSE probe is not working and
ERROR IMPSCoordinator - Failed to execute sql script scripts/db/<database type>_mpse_create.sql: Column name or number of supplied values does not match table definition.
IMPSCoordinator - Will retry database connection (and possibly initialization) attempt # 2 in 15 seconds...
4) fragmentation level of UIM DB tables reached to 99%
UIM & UMP 8.47
An Additional column named “rowguid” got appended to UIM tables in UIM DB due to Merge Replication process that was running
This caused multiple problem.
Merge replication is a feature offered by Microsoft SQL Servers that allows changes to be sent from one primary server, called a publisher, to one or more secondary servers, called subscribers.
Data Replication in principle is not supported by UIM. Hence it is recommended to remove the replication and revert schema on the UIM tables.