Exception: Length of LOB data (96550) to be replicated exceeds configured maximum 65536.

We got below exception recently as Lengh of LOB data to be replicated increased the configured limit 65536

Exception Thrown In InboundMessageProcessor ProcessExternalXML Method with [Error]: Internal Xml Parser Failed. Aborting Database Transaction. Current XML Node <FIInvocationSynchronousEvent>, Depth 1.

[InternalXMLParser Error]: Failed to execute business component method. Assembly: FlexNet.SVL.BusinessFacade.Utility, Version=1.0.0.0, Culture=neutral, PublicKeyToken=33f692327842122b, Class: FlexNet.SVL.BusinessFacade.Utility.TableAction, MethodName: TableUpdate, Exception: Length of LOB data (96550) 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.

Run below command to find the falue

select * from sys.configurations

where name like 'max text repl size%';

GO

You can configure the ‘max text repl size’ to unlimited by using below command

EXEC sp_configure 'max text repl size', -1 ;

RECONFIGURE;

GO

You should be able to see updated value now.

select * from sys.configurations

where name like 'max text repl size%';

GO

I see few users complained that’s this setting lost, you can use ‘OVERRIDE’ option.

EXEC sys.sp_configure N'max text repl size (B)', N'-1'

GO

RECONFIGURE WITH OVERRIDE

GO

Regards
Satishbabu Gunukula
http://sqlserver-expert.com