Upgrade from SnapCenter 5.0 to 6.0.1 fails with error "SnapCenter Schema Creation failed"
Applies to
- SnapCenter Server 5.0
- Amazon FSx
Issue
Upgrade from SnapCenter 5.0 to 6.0.1 fails with following error and uninstalled the SMCore service.
SnapCenter Schema Creation failed. Check the DotMigrate logs in the Windows Temp folder for more details.
DotMigrate logs
show that no stored procedure exists:
2024-09-30 03:55:52.826 Executing SQL script C:\Users\user_name\AppData\Local\Temp\ck21uae0.zyz\6.0\6.0.0.0002_Alter_table_nsm_policy_add_storage_type.sql
2024-09-30 03:55:52.858 Error: executing SQL script C:\Users\user_name\AppData\Local\Temp\ck21uae0.zyz\6.0\6.0.0.0002_Alter_table_nsm_policy_add_storage_type.sql
2024-09-30 03:55:52.858 Error: PROCEDURE nsm.AddColumnUnlessExists does not exist