Overview
This article describes the resolution of the following error which is logged into the Windows Event Logs:
ERROR.DAL.UploadMessageSourceFailed.
Additional info: Length of LOB data to be replicated exceeds configured maximum 65536. The statement has been terminated.
Environment
- GFI Archiver
- Microsoft SQL server
Root Cause
Microsoft SQL server's default maximum text replication size is 65536. For more information, please see max text repl size Option.
Resolution
- From SQL Management Studio, right-click on the server at the top of the left-hand tree and choose Properties
- Select Advanced > Max Text Replication Size > change the default value to 2000000 > OK