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
Satishbabu Gunukula
http://sqlserver-expert.com
Posts
