-
Title
NM: Migration Failed Stuck in Progress, migration log error: "Marking migration as failed for automatic requeueing" -
Description
We have a migration for one user, the migration completes but the status is "Stuck in Progress" and I must reset the status in SQL, and perform an IIS reset, what is causing this?
From the migration log
Warning: RFC822 Body MIMEStreamOpen error 222 Note item not found
Error: Post MimeToMapi Set Props --MAPI reconnected 80040125 Retry Attempts Exceeded Folder:
Error: Set Properties - Folder: --MAPI reconnected 80040125 Retry Attempts Exceeded Folder:
Warning: BTMapiMessage Save Changes --MAPI reconnected 80040125 Attempting Retry Folder:
Error: BTMapiMessage Save Changes --MAPI reconnected 80040125 Retry Attempts Exceeded Folder:
Error: Insert Mail Failure, retry attempts exceeded. Folder:
Warning: Setting Migration status code to '#004 - MAPI write failed for 1 items'
MAPI retries have been exceeded for 1 documents
Warning: BTMapiMessage Save Changes --Network Error 80040115 Attempting Retry
Success: BTMapiMessage Save Changes --Recovered after 5 retries
Marking migration as failed for automatic requeueing. 2 documents had MAPI retry errors.
Done migrating "User Name"
Migration Failed : #004 - MAPI write failed for 2 items -
Cause
From this KB article: https://support.quest.com/kb/b301831/nm-explanation-of-automatic-migration-restart
We have seen a few cases where there was no crash on the worker. The workers were never receiving the migration job. It was acting just like a stuck in pending, but returned a status of "Requeued: Retry 1", but it would remain in this status and never retry even though recovery was enabled.
This is caused by corruption in the SQL table for these users reporting this status: "Requeued: Retry 1"
-
Resolution
Perform the following steps to get the migrations running again
Open SQL to the Notes Migrator database.
Edit these 3 tables; 'CMT_User', 'MigrationQueueTable'; 'Migration_Details'
Edit and delete any and all records related to these affected users
Close the SQL query windows
From the MCC, open a command prompt CMD, and run iisreset
Start migrations for these users