Thursday, May 5, 2011

Error: 7139, Severity: 16, State: 1, Failed to upload large sized File to Database

One of out client was facing some error while uploading documents to the table. They had a database in which they were uploading all the documents related to the Suppliers and Customers, when the user tries to upload the document they gets the error message as shown below
Server: Msg 7139, Level 16, State 1, Line 1 
Length of text, ntext, or image data (200) to be replicated exceeds configured maximum 10. 
The statement has been terminated.
When the document size is less than 50 KB it works fine, so I come to a conclusion that some SQL server setting is missing. Another thing is that this works fine in our development environment which again confused us. Only difference between our development and production server is that production is set to transactional replication. Finally we squared replication configuration and found that one of the server level replication setting is set to small value. "max text repl size" is the server level setting set to a small value of 64 KB, we then increased this value to “2147483647” (2 GB) and it started working fine. 
If you are facing similar problem just connect to the server and execute the query below to rectify the issue.
EXEC SP_CONFIGURE 'max text repl size', 2147483647

No comments:

Post a Comment