This is related to max text repl size Server Configuration
Check: http://msdn.microsoft.com/en-us/library/ms179573.aspx
Ravi
> Date: Mon, 7 May 2012 15:11:18 -0400
> From: jdso...@shyle.net
> Subject: Re: Remedy 7.6.04 SQL Error Message
> To: arslist@ARSLIST.ORG
>
> Mike,
>
> At the risk of suggesting something you might have already tried, take an
> SQL log while reproducing the error so you get to see what is the offending
> form and field that is causing this error..
>
> If this doesn't yield anything, search for all fields in your database that
> has a max length of 65536.
>
> select schemaid, fieldid from field where fieldid in (select fieldid from
> field_char where maxlength = 65536);
> Or maybe
> select schemaid, fieldid from field where fieldid in (select fieldid from
> field_char where lengthunits = 65536);
>
> Joe
>
> -----Original Message-----
> From: Mike Hocks
> Sent: Monday, May 07, 2012 2:46 PM Newsgroups:
> public.remedy.arsystem.general
> To: arslist@ARSLIST.ORG
> Subject: Remedy 7.6.04 SQL Error Message
>
> After installing Analytics and we are now seeing the following error message
> when trying to attach a file larger than 65536...any idea in SQL where to
> adjust this size constraint?
>
> "The SQL database operation failed. : The statement has been
> terminated.Length of LOB data (549551) to be replicated exceeds configured
> maximum 65536. (SQL Server 7139) (ARERR 552) "
>
> Remedy 7.6.04
> SQL 2008 64 Bit
> Winodws 2008 Srv 64 Bit for App Server
>
> Thanks,
> -Mike
>
> _______________________________________________________________________________
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
> attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
