Errors uploading Documents with SQL Transactional Replication

[support]

Issue:

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)

 

 

Fix:

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:)

 

Regards,

Click Studios Support