System.Data.SqlClient.SqlException: Length of LOB data (1397200) to be replicated exceeds configured maximum 65536
---solution---
Using script to query the repl config as below:
SELECT * FROM sys.configurations WHERE NAME LIKE'%repl%'
Using script update the repl config as below:
sp_configure 'max text repl size', 483647
reconfigure with override