In MMEX Management Tree one can see duplicate objects, like servers or mailbox databases and the following is logged in the EMWMigration.log file when doing a refresh:
For some reason Exchnage servers and / or Exchange mailbox databases are duplicated in MMEX SQL database. In most cases this is caused by temporary connection issues with either Exchange server or SQL server homing MMEX SQL database.
To fix the issue, the following query was run over the QMM SQL database:
SELECT COUNT([ID]), [NAME]
FROM [SERVER]
WHERE TYPEID=8 or TYPEIS=21
GROUP BY [NAME]
As a result one may get duplicated server names or mailbox database names:
2 Database1
5 Database2
14 Database3
4 Database4
The issue can be resolved by setting the DELETED field for the duplicated records to 1 in SERVER table. This can be done by running:
Update SERVER set DELETED=1 where ID=[ID of the duplicated database or server record]
Backing up MMEX SQL database prior to running an update query is a must.
Upon setting the deleted field to1 in SQL database, restart MMEX Project Manager and refresh the server MMEX Management Tree if required.
