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

1. From SQL Management Studio, right-click on the server at the top of the left-hand tree and choose Properties
2. Select Advanced > Max Text Replication Size > change the default value to 2000000 > OK