2/21/2025 5:00:56 AM
|
| |
| slxdeveloper.com Community Forums |
|
| |
|
|
The Forums on slxdeveloper.com are now retired. The forum archive will remain available for the time being. Thank you for your participation on slxdeveloper.com!
Forum to discuss the use of .NET Extensions in SalesLogix version 7 and higher. View the code of conduct for posting guidelines.
|
|
|
|
.Net Extensions Manager Issue
Posted: 08 May 09 3:13 PM
|
When trying to add a new binary using the .Net Extensions manager, I continually get an Unhandled Exception: "Length of text, ntext or image data (208896) to be replicated exceeds configured maximum 65536. Is there a way to increase this maximum? I am perplexed, as I've updated this same binary with same dependencies a few times before without a problem, and the codebase has not grown.
Thanks,
Neil |
|
|
|
Re: .Net Extensions Manager Issue
Posted: 14 May 09 7:38 AM
|
Neil,
I found this after a quick google. May help..
http://www.novicksoftware.com/TipsAndTricks/tip-sql-server-image-replication-maximum-size-configured.htm
--------------------------------------------------
This message occurs when you attempt to insert into a text, ntext, or image column that is published in a replication article.
Solution: Use sp_configure to increase 'max text repl size'
The default value for the maximum configuration size is only 65536. Once it's increased, the insert can proceed. To increate the size execue sp_configure on 'max text repl size'. This stored procedure does the job:
CREATE PROC usp_CONFIGURE_ReplicationSizeForBlobs
@NewSize int = 100000000
/*
* Sets the 'max text repl size' instance wide configuration setting
* that governs the maximum size of an image, text, or ntext column
* in a replicated table.
*
* Example:
exec usp_CONFIGURE_ReplicationSizeForBlobs default
**********************************************************************/
AS
print 'Old size'
exec sp_configure 'max text repl size'
print ' Setting new size'
exec sp_configure 'max text repl size', @NewSize
print 'Reconfiguring'
RECONFIGURE WITH OVERRIDE
print 'New size'
exec sp_configure 'max text repl size'
|
|
|
|
You can
subscribe to receive a daily forum digest in your
user profile. View the site code
of conduct for posting guidelines.
 Forum RSS Feed - Subscribe to the forum RSS feed to keep on top of the latest forum activity!
|
|
|
|
|
|
|
|