Skip to main content
NetApp Knowledge Base

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

Views:
33
Visibility:
Public
Votes:
0
Category:
snapcenter
Specialty:
snapx
Last Updated:

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'

 

Sign in to view the entire content of this KB article.

New to NetApp?

Learn more about our award-winning Support

Scan to view the article on your device