Jump to content

Errors uploading Documents with SQL Transactional Replication


Recommended Posts


If using the High Availability version of Passwordstate, with Transactional Replication in place it is possible to get the following error when uploading a document that exceeds 64kb:


Error Code = The statement has been terminated. Length of LOB data (1138720) 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., StackTrace = at System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior, String method) at System.Data.OleDb.OleDbCommand.ExecuteNonQuery() at Passwordstate.Document.UploadPasswordListDocument(Int32 PasswordListID, String PasswordList, String DocumentDescription, String DocumentName, Object DocumentContent, String FileSize, Boolean Folder)




In order to resolve this error, increase the ‘Max Text Replication Size’ of SQL Server:

  • Open SQL Server Management Studio
  • Right click on the server name à Properties
  • Advanced
  • Set Max Text Replication Size to a value higher than the document size limit specified in the Passwordstate System Settings
    • For example: 4194304 is about 4MB
    • Set -1 for unlimited
  • Make this change on both SQL database servers
  • Restart of SQL Server was not necessary


Click Studios would like to thanks our friend Hans for supplying this fix:)  We appreciate feedback from our customers that helps out all of our customers:)



Click Studios Support


Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Create New...