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!

Architect Forums - SalesLogix .NET Extensions
Forum to discuss the use of .NET Extensions in SalesLogix version 7 and higher. View the code of conduct for posting guidelines.

Forums RSS Feed

Back to Forum List | Back to SalesLogix .NET Extensions | New Thread

View: Search:

Author

Thread: .Net Extensions Manager Issue

Neil
Posts: 1

.Net Extensions Manager Issue Your last visit to this thread was on 1/1/1970 12:00:00 AM

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

[Reply][Quote]

Doug Miller
Posts: 20

Re: .Net Extensions Manager Issue Your last visit to this thread was on 1/1/1970 12:00:00 AM

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'

[Reply][Quote]

Page 1 of 1

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!

slxdeveloper.com is brought to you courtesy of Ryan Farley & Customer FX Corporation. This site, and all contents herein, are Copyright © 2025 Customer FX Corporation. The information and opinions expressed here are not endorsed by Sage Software.	code of conduct \|

page cache (param): 2/21/2025 7:06:47 AM