Length of LOB data (190999) to be replicated exceeds configured maximum 65536. 错误修改
在上传附件时,本地是可以的但服务器上就有了文件大小的限制,不能上传。经过打断点找到这样一个错误:
Length of LOB data (190999) to be replicated exceeds configured maximum 65536. Use the stored procedure sp_configure to increase the configured maximum value for max text repl size option, which defaults to 65536. A configured value of -1 indicates no limit, other that the limit imposed by the data type.
The statement has been terminated.
原来SQL server有一个存储过程,max text repl size的value值做了限制,无法上传。
随后用
sp_configure 'max text repl size', 2147483647
Go
RECONFIGURE
GO
就可以更新了所有的value值为2147483647.
不用担心需要重新启动数据库,它可以直接更新有效。
文件再次上传就没有问题了。