Issue
We receive the following error in the Lotus Notes status bar, at the bottom of the screen for a few users, not all. SetCMTUserRecordStatus Error: 6: Overflow MigrateCMTUser Error: Failed to update CMT user status. <CMTkey> Migration Status is set to Pending for user: <CMTkey>
I noticed Status returns to Ready for Migration
Solution
This is usually caused by a user with too many records in the 'Migration_Details' table. Open SQL and remove the details records for this user 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] = '<CMTkey>') Your new query will look like this, just replace, <CMTkey> with the user's key value. SELECT TOP (200) MigrationRecord, RecordID, Start, [End], Status, MB_Migrated, [Log], Migrated_by, Settings_Id, [Key], CountErrors, CountWarnings FROM Migration_Details WHERE ([Key] = '<CMTkey>') 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'
or run the following queue
Delete FROM [NotesMigrator_CMT].[dbo].[Migration_Details] Where [Key]='<CMTKEY>'
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.
|