在 NSM SQL 脚本中升级 SnapCenter 到 4.6 失败,并且检查分页不匹配
适用场景
- SnapCenter 服务器(SC) 4.6
- SnapCenter MySQL NSM数据库存储库
问题描述
- 尝试将SC 4.6作为 4.5的升级版本安装时、安装将失败、并显示以下错误:
- 中的错误
\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)