-
Title
After installing Migration Manager for Exchange update 20170630EX MMEX Project Manager fails on the first start with SQL-related errors -
Description
After installing Migration Manager for Exchange update 20170630EX MMEX Project Manager fails on the first start with SQL-related errors. When running the UpdateDB.SQL query manually over MMEX SQL database it shows the following error:
Msg 547, Level 16, State 0, Line 29 The ALTER TABLE statement conflicted with the FOREIGN KEY constraint "FK_EXCH_SERVER_PROPERTY". The conflict occurred in database "[Database_Name]", table "dbo.EXCH_SERVER", column 'ID'.
-
Cause
MMEX SQL database has been updated incorrectly. -
Resolution
To resolve the issue, please:
1) Connect to MMEX SQL database
2) Run the following query:
Delete from EXCH_SERVER_PROPERTY
where EXCH_SERVER_ID not in (SELECT ID FROM EXCH_Server)
3) Locate the "UPDATEDB.SQL" file, which can be found on MMEX Project Manager (console) machine in its default path "<drive>:\Program Files (x86)\Quest Software\Migration Manager\Exchange Data\DB"
4) Open the UPDATEDB.SQL file with Notepad or other text editor
5) Copy its contents and run it against MMEX SQL database as a query to complete MMEX update.