Platform
Learn
Community
Support
Partner Center
Sign up
or
Log in
logout
Account Settings
Profile
messages
Messages
logout
Logout
Platform
Home
Downloads
IPP
Licensing
Project Sizing
Learn
Training
Documentation
Evaluation Guide
What's New
Community
Home
Forums
Forge
Ideas
Members
Support
Partner Guide
Resources Library
Opportunities
Account Management
Sign up
or
Log in
Home
Forums
Forge
Ideas
Members
Dear ,
What would improve your OutSystems Community experience? Let us know by taking this 2-minute survey.
Pick up the survey
Community
›
Forums
›
Technology & Integration
SQL Server 2008 -> Replication Related Error
Community
›
Forums
›
Technology & Integration
SQL Server 2008 -> Replication Related Error
New Post
New Post
Cristóvão Honorato
Posted on 2009-06-18
Cristóvão Honorato
Rank: #0
Posted on 2009-06-18
Symptoms:
When inserting a record into a replicated table, the following SQLServer error message can appear:
"Length of text, ntext, or image data (x) to be replicated exceeds configured maximum 65536"
Example error stack:
Message :Length of text, ntext, or image data (96491) to be replicated exceeds configured maximum 65536.
The statement has been terminated.
Stack: at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
(...)
The insert is unsucessfull.
Cause:
Replicating large amounts of data will introduce latency. To prevent this, SQL server caps how much data can be replicated in a single column using the Max Text Replication Size setting. This setting has default value of 65536. If you try to replicate text data which exceeds this length, you will get the error message stated above.
Resolution:
You can work around this situation by changing the setting 'max text repl size'. You can do it, using a SQLServer stored procedure called 'sp_configure'.
Example Fix:
EXEC sp_configure 'max text repl size', @NewSize
RECONFIGURE WITH OVERRIDE
Links:
http://www.novicksoftware.com/TipsAndTricks/tip-sql-server-image-replication-maximum-size-configured.htm
http://msdn.microsoft.com/en-us/library/aa259616.aspx
Quick Reply
attachment
Choose File
No file chosen
Submit
Login to reply
New Post
Available Forums
Technology & Integration
News and Announcements
Forge Discussions
Meta
Community Quick Guides
Usability
Installation Troubleshooting
Personal Environment Troubleshooting
Forum Notifications
Email Digest Settings
Loading...