Issue
We have two users that have gone through all processes of pre prep migrations. The migration is failing, and when checked the back-end of CMTe (via CMT.exe) they showed as unresolved. No matter what we have tried they still showed as unresolved.
Solution
For 3.8 and newer versions:
Open SQL Management Studio
Open the CMTe database
Open the 'MigrationQueuetable' table
Delete all the user entries that had the issue.
Close SQL management studio
For CMTe 3.7 and older versions:
1. Delete the user's back-end record from CMT.exe
2. Open the cmt_universal.mdb database in Access and go to the 'MigrationQueuetable' table. Clear out all the users in this table.
3. Open the 'CMT-User' table, and remove this user record.
4. Run Compact & Repair
5. Save and Close the mdb
-----------------------------------------------------------
Restart the IIS server. from the command prompt ( iisreset )
In Notes, Edit the Notes Migrator person document, and change the ShortName value by appending an X ( this may resolve the issue because a few customers have notice that some fields in the Notes Person document have carriage returns or new lines feeds in some field values. By forcing a change and re-saving the document, the fields in the person document should strip out the carriage returns and new line values upon the new save)
Save & Close the document
Try migrating the user(s) again.
----------------------------------------------------------
If the above fails it could be because of a bad entry in the backend sql database. When Notes Migrator adds a user to the sql backend we add them via a field on the Notes Migrator person document called CMTKEY. When a user is imported for the first time, that field is not on document. When theuser is submitted to be migrated, Notes Migrator takes the value in the shortname field and write that to the CMTKEY field and that field is what is used to the send the user to SQL and add entry to the CMT_Users table.
What can be done is to go to the advanced migration view, highlight the user and choose “clear or reset user” and choose the choice “remove backend record” this will remove the sql record and should also clear the value of the CMTKEY field. Check that by open up the Note Migrator person document and check the cmt key field value.
Then the document can be edited and change the value of the shortname field to be something different than what it wasand save the document. When the user is resubmited, this will write the new value in the shortname field into the cmtkey field and add the user to SQL using this new and different value and they user migration should start.
