Issue
When attempting to delete a Notes Migrator (CMTe) 'Migration Profile, "Yes" is chosen when asked if they are to be deleted from the CMT Migration server. The profile disappears from the Lotus Notes interface.
The admin performs an IISRESET to clear the IIS server on the Migration Control Center (MCC).
When "Refresh Profiles" is selected in the 'Migration Profiles" view within the CMT for Exchange database, the migration profile reappears.
When examining the dbo.settings table in the SQL database the profile is still there and was never deleted. When examining the Windows OS Application event logs, the following error message is observed.
CMT Migration Server : Error deleting row The DELETE statement conflicted with the REFERENCE constraint "Migration_Details_FK00". The conflict occurred in database "CMT_Exchange_382", table "dbo.Migration_Details", column 'Settings_Id'. The statement has been terminated.
Solution
A migration profile cannot be deleted if it is assigned to a user record in the SQL 'dbo.Migration_Details' table.
Any record assigned to the migration profile you wish to delete, must be deleted in the 'dbo.Migration_Details' and must be deleted first in order to delete the migration profile.
How to remove the 'Migration_Details' record assigned to the CMTe migration profile:
Open Microsoft SQL Server Management Studio
Open 'Databases' and expand the 'CMT_Exchange' database (or whichever name you selected during Notes Migrator installation).
Right click on the 'dbo.Settings' table, and select 'Edit top 200 rows'
Find the migration profile and make note of the settings id number in the settings_id column for the profile you want to delete
Right click on the 'Migration_Details' table, and select 'Edit top 200 rows'
Do a Cntl+3 to edit the SQL argument. The query should look like this
SELECT TOP (200) MigrationRecord, RecordID, Start, [End], Status, MB_Migrated, [Log], Migrated_by, Settings_Id, [Key], CountErrors, CountWarnings
FROM Migration_Details
Modify the query to look like the statement below, where 14 is the setting id number of the profile in this example
SELECT TOP (200) MigrationRecord, RecordID, Start, [End], Status, MB_Migrated, [Log], Migrated_by, 14 AS Settings_Id, [Key], CountErrors, CountWarnings
FROM Migration_Details
If you want to edit more rows you can change the 200 to a larger number if you want to see more or all the records
Click the first column "migrationrecord" and right click and choose execute SQL or you could do an cntl + R
The records matching this query will show up. Select the record(s), right click and Delete
Now the migration profile can be deleted permanently from CMTe, 'Migration Profiles' view.
This will be fixed in a future release
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Términos de uso Privacidad Cookie Preference Center