Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Length of LOB data exceeds maximum 65536 Expand / Collapse
Author
Message
Posted Tuesday, March 13, 2007 8:14 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 11:52 AM
Points: 2,832, Visits: 8,513

I'm replicating from a SQL 2005 DB to another server running SQL 2000. We were replicating from 2000 to 2000 without problem. Now, when the users enter data, sometimes they get this error.

Length of LOB data (78862) to be replicated exceeds configured maximum 65536

I found reference to the configuration setting max text repl size (B) and it is set to 65536, but that's the same value in 2000 and I never had a problem. Should I just increase the value ??  I'm hesitant to do it without a better understanding.

TIA




Post #351138
Posted Tuesday, March 13, 2007 10:58 AM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Thursday, October 16, 2014 6:06 AM
Points: 6,259, Visits: 2,030
yes. you can simply use:

sp_configure 'max text repl size', 2147483647



* Noel
Post #351202
Posted Tuesday, March 13, 2007 11:16 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 11:52 AM
Points: 2,832, Visits: 8,513

Clarification: We WERE getting the errors in SQL2000 as well, I just hadn't heard about them because of all the other problems we were having with other things.

Are there any implications to choosing a high number ?




Post #351213
Posted Tuesday, March 13, 2007 11:37 AM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Thursday, October 16, 2014 6:06 AM
Points: 6,259, Visits: 2,030
the implication is that more buffer space is needed to cover for the large values. If you are not short in memory this should not be an issue.

I have this setting on one of my servers and although the activity is not as high as on my big machines I have had no problems with this setting. Most of the time I have been worried about some other "user" failures

Cheers,



* Noel
Post #351224
Posted Tuesday, March 13, 2007 1:13 PM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 11:52 AM
Points: 2,832, Visits: 8,513
Thanks for the help !  


Post #351262
Posted Tuesday, May 20, 2008 9:59 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, May 20, 2008 9:54 PM
Points: 1, Visits: 0
I am getting the same error while trying to insert data into the varbinary(max) column in my production environment. But I am getting any error in our dev and test machines, though it is not configured for the maximum 2gb value. The thing is this is happening during insert query, not in transactional replication (msdn says the setting is applicable only for transactional replication). Any ideas will be appreciated.

Many thanks,
Syed
Post #504190
Posted Tuesday, May 20, 2008 10:02 PM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Wednesday, June 18, 2008 5:48 AM
Points: 581, Visits: 36
hi
Post #504192
Posted Monday, March 2, 2009 9:47 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, April 24, 2009 6:26 AM
Points: 1, Visits: 3
Hi,

Length of LOB data (72174) to be replicated exceeds configured maximum 65536.
This error when it will replicate I am unable to replicate. Client getting this error. On what case this error will through

Plz can you reply as early as possible
Post #667028
Posted Wednesday, July 21, 2010 7:16 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, September 10, 2014 9:43 PM
Points: 13, Visits: 145
I get the following message:
Ad hoc update to system catalogs is not supported.
Post #956333
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse