For 4.x and newer versionsChange to the Advanced Migration view in Notes Migrator.nsf
Select the users and clear their back-end SQL user records
Click 'Clear or Reset user(s) - Remove backend user record" view action
For 3.8.x:
Open SQL Management Studio
Open the CMTe database
Open the 'CMT_User' table
Delete all the user entries that had the issue.
Close SQL management studio
For 3.7.x and older versions of CMTe
Open the CMT_Universal.MDB, file (located: C:\Program Files\BinaryTree\CMT Universal\CMT_XMLServer\App_Data ). MS Access must be installed to view file.
Open the 'CMT_User' table,
Delete all the user entries that had the issue.
Run Compact & Repair
Save and Close the mdb
---------------------------------------------------
Restart IIS on the Migration Control Center (MCC), via iisreset command prompt
Select the user(s) and place them into the migration queue
The migrations should start.
If this does not resolve the issue, check the Lotus Notes Status bar for the following errors:
No Errors
Remove all back-end records related to the user(s), delete the Notes Migrator front-end documents, and import the user(s) again, match, set the migration profile and run migration process.
Failed to validate
This means there was an issue with the selected user's Short Name and/or Internet Address field.
Confirm there are no trailing or leading spaces.
Confirm there is a single value in the Internet Address field
If there are multiple values in the ShortName field, confirm the field is a Text List data type, and not Text type. This can be confirmed from the Document Properties window, second tab.
SetCMTUserRecordStatus Error: 6: Overflow
For the migration status going back to "Ready for Migration" and you receive this error, this is usually caused by a user with too many records in the 'Migration_Details' table in SQL.
Open SQL and remove the details records for these users
Run an iisreset on the MCC, and try the migration again.
If there are many records in this table, and you are unable to easily find them all, you may use the following table query to find and remove the records.
Open the table, and edit top 200 rows
Rick click on a row, hover cursor over 'Pane', and select "SQL"
The SQL query for this table will display.
SELECT TOP (200) MigrationRecord, RecordID, Start, [End], Status, MB_Migrated, [Log], Migrated_by, Settings_Id, [Key], CountErrors, CountWarnings
FROM Migration_Details
Append the following to the query
WHERE ([Key] = '')
Your new query will look like this, add the short name between the single quotes, this can be found in the user's key value column.
SELECT TOP (200) MigrationRecord, RecordID, Start, [End], Status, MB_Migrated, [Log], Migrated_by, Settings_Id, [Key], CountErrors, CountWarnings
FROM Migration_Details
WHERE ([Key] = '')
Click the 'Execute', red exclamation point icon.
A list of just this user's migration details records will be displayed.
Highlight all records for this user, except for the most recent
Right click, select 'Delete'
All records for this user should have been deleted, except for the one you retained.
When closing the table, do not save the new query
Reminder: Run iisreset from cmd prompt, after removing the records from this table.