SCSQL backup fails with Data too long for column nsm_StorageFootPrintAppFilePath
Applies to
SnapCenter Plugin for Microsoft SQL (SCSQL) up to version 4.4P1
Issue
Snapcenter backup of SQL server fails as seen in the
SnapManagerWeb_<JOB>.log
:2021-04-20T20:01:26.9730177+02:00 DEBUG SnapManagerWeb_16768 PID=[15008] TID=[22] Updating Size of Object. Id: 10
2021-04-20T20:01:26.9730177+02:00 DEBUG SnapManagerWeb_16768 PID=[15008] TID=[22] Enter SaveBackupComponentObject
2021-04-20T20:01:27.5040174+02:00 ERROR SnapManagerWeb_16768 PID=[15008] TID=[22] Error saving backup info details :
2021-04-20T20:01:27.5050211+02:00 DEBUG SnapManagerWeb_16768 PID=[15008] TID=[22] Exit SaveBackupComponentObject
2021-04-20T20:01:27.5110202+02:00 ERROR SnapManagerWeb_16768 PID=[15008] TID=[22] System.Data.Entity.Infrastructure.DbUpdateException: An error occurred while updating the entries. See the inner exception for details. ---> System.Data.Entity.Core.UpdateException: An error occurred while updating the entries. See the inner exception for details. ---> Devart.Data.MySql.MySqlException: Data too long for column 'nsm_StorageFootPrintAppFilePath' at row 1