Registry loader error on SOI Manager "java.sql.SQLException : Length of LOB data <88301> to be replicated exceeds configured maximum 65536"

Document ID : KB000014193
Last Modified Date : 14/02/2018
Show Technical Document Details
Introduction:

When running "RegistryLoader.bat" command on SOI Manager, getting an error due to this the command fails

Question:

When running "RegistryLoader.bat" command on SOI Manager, getting below SQL error

"java.sql.SQLException : Length of LOB data <88301> to be replicated exceeds configured maximum 65536. Use the stored procedure sp_configure to increase the configured maximum value for max text replsize option, which defaults to 65536. A configured value of -1 indicated no limit, other the limit imposed by the data type."

 

Environment:
SOI 3.3 or 4.0SQL 2008 | 2012
Answer:

Please change below setting on SQL Server where SAMStore DB exists.. 

1) Right click on SQL Server name in the Object Explorer -> Click 'Properties' -> Click on 'Advanced' -> Max text replication Size is available under    

    “Miscellaneous” header. 

2) Change the value from 65536 to -1 or 2147483647 (depending on the version on SQL Server)

3) Press OK button

1.jpg

2.jpg