Upgrade of SnapCenter to version 4.6P1 fails when updating the MYSQL NSM database

Applies to

• SnapCenter Server (SC) 4.5
• SnapCenter MYSQL NSM database
• Upgrade to 4.6P1

Issue

• Upgrade of SC from 4.5 to 4.6P1 fails with the following error during the upgrade:

Error: SnapCenter Schema Creation failed. Check the DotMigrate logs in the Windows Temp folder for more details

• DotMigrate log shows the error:

Executing 11 SQL scripts to update database schema to 4.6.7.2
SchemaVersion = { Id = [338], Version = [4.6.1.1], ScriptName = [4.6.1.0001_Update_SCV_ObjectTypeID.sql], SHA1 = [70ddf027c6180b7b204d91422b5b84158cf57793], User = [domain\username], StartTimeUtc = [date_time], ElapsedTime = [], IsSuccess = [False], Error = [] }
Executing SQL script user_folder\AppData\Local\Temp\0rdr3zpr.tur\4.6\4.6.1.0001_Update_SCV_ObjectTypeID.sql
Error: executing SQL script user_folder\AppData\Local\Temp\0rdr3zpr.tur\4.6\4.6.1.0001_Update_SCV_ObjectTypeID.sql
Error: Duplicate entry '16' for key 'PRIMARY'