SnapCenter MySQL replication failure post SnapCenter upgrades to 5.0P2
Applies to
- SnapCenter Server [SC]
- F5 High Availability [HA]
- MySQL [NSM]
Issue
- SnapCenter MySQL replication failure post SnapCenter upgrades:
Error: SnapCenter repository database restore failed with error : MySQL query execution failed with error : ERROR 3734 (HY000) at line 1178: Failed to add the foreign key constraint. Missing column 'NetAppAccountId' for constraint 'FK_nsm_AzureNetAppFiles_StorageFootprint_nsm_AzureNetAppAccount' in the referenced table 'nsm_AzureNetAppAccount'