-
Title
Duplicate objects (servers or databases) are shown in MMEX Management Tree. EMWMIgration.log file shows Error: [Microsoft][ODBC SQL Server Driver][SQL Server]Subquery returned more than 1 value. -
Description
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:
Info aeEMWGUIShared.SQLStoreStruct.AddMailboxDBCopy|Adding mailbox database copy: CN=[DB_Name],CN=[DB_Name],CN=Databases,CN=Exchange Administrative Group (FYDIBOHF23SPDLT),CN=Administrative Groups,CN=[Exchange_org],CN=Microsoft Exchange,CN=Services,CN=Configuration,DC=[domain_name],DC=comError aeEMWGUIShared.SQLStoreStruct.AddMailboxDBCopy|-2147217900-[Microsoft][ODBC SQL Server Driver][SQL Server]Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression., (CN=[DB_Name],CN=[DB_Name],CN=Databases,CN=Exchange Administrative Group (FYDIBOHF23SPDLT),CN=Administrative Groups,CN=[Exchange_org],CN=Microsoft Exchange,CN=Services,CN=Configuration,DC=[domain_name],DC=com) -
Cause
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.
-
Resolution
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.