Upgrading SnapCenter to 4.6 fails during NSM SQL script with a collate mismatch
Applies to
- SnapCenter Server (SC) 4.6
- SnapCenter MYSQL NSM database repository
Issue
- When trying to install SC 4.6 as an upgrade from 4.5, the installation fails with the following error:
- Error in the
\temp\DotMigrate_MySQL_4.6.log:
2022-02-02 20:06:03.413 Error: executing SQL script C:\Temp\mwaqbl2g.3gh\4.6\4.6.7.0001_Update_DAG_ShortName_To_FQDN.sql
2022-02-02 20:06:03.413 Error: Illegal mix of collations (utf8_unicode_ci,IMPLICIT), (utf8_general_ci,COERCIBLE), (utf8_general_ci,IMPLICIT) for operation 'replace'
2022-02-02 20:06:03.413 at Devart.Data.MySql.bi.a()
at Devart.Data.MySql.bi.i()
at Devart.Data.MySql.af.a(Byte[] A_0, Boolean A_1)
at Devart.Data.MySql.af.b(Boolean A_0)
at Devart.Data.MySql.i.b(Boolean A_0)
at Devart.Data.MySql.MySqlDataReader.a(Boolean A_0)
at Devart.Data.MySql.MySqlDataReader.Close()
at Devart.Common.DbCommandBase.ExecuteNonQuery()
at PetaPoco.Database.Execute(String sql, Object[] args)
at NetApp.Migrate.DotMigrate.MigrateDatabaseSchema(SchemaVersionList scripts)