'Up To The Minute Retention' task of SCSQL backup job fails
Applies to
- SnapCenter Server
- SnapCenter Plug-in for Microsoft SQL Server (SCSQL)
- Running multiple SCSQL Backup job at the same time
Issue
- 'Up To The Minute Retention' task of SCSQL backup job fails due to "
The underlying connection was closed: An unexpected error occurred on a receive" - Excessive memory consumption is observed on SnapCenter Server host
- SMCore job log shows error:
INFO SMCore_XXXX PID=[XX] TID=[XX] Activity - Up To The Minute Retention, Starting
DEBUG SMCore_XXXX PID=[XX] TID=[XX] SqlUtmRetention Begin
...
DEBUG SMCore_XXXX PID=[XX] TID=[XX] RemoteUrl: https://XXXXXX:8146/BackupService.svc/GetBackups
...
ERROR SMCore_XXXX PID=[XX] TID=[XX] WebException Encountered, Response null
ERROR SMCore_XXXX PID=[XX] TID=[XX] Exception in method: Invoke.
System.Net.WebException: The underlying connection was closed: An unexpected error occurred on a receive. ---> System.IO.IOException: Unable to read data from the transport connection: An existing connection was forcibly closed by the remote host.00000000