What is the largest amount of data in that field?
From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Kemes, Lisa Sent: Wednesday, April 04, 2012 1:02 PM To: arslist@ARSLIST.ORG Subject: Re: Large Character Fields even Larger? ** Nevermind, when I increased it to 400,000 it now works. Why would it work in 7.1 p7 with 90000, but I have to increase it to 400,000 in 7.6.04 SP2? The data is basically the same. Thanks! Lisa ________________________________ From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG]<mailto:[mailto:arslist@ARSLIST.ORG]> On Behalf Of Kemes, Lisa Sent: Wednesday, April 04, 2012 1:57 PM To: arslist@ARSLIST.ORG<mailto:arslist@ARSLIST.ORG> Subject: Re: Large Character Fields even Larger? ** Sorry, I meant to say that I increased it to 200,000.... I just increased it again to 450,000 still same error message. Thanks! Lisa ________________________________ From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG]<mailto:[mailto:arslist@ARSLIST.ORG]> On Behalf Of Kemes, Lisa Sent: Wednesday, April 04, 2012 1:27 PM To: arslist@ARSLIST.ORG<mailto:arslist@ARSLIST.ORG> Subject: Large Character Fields even Larger? ** We upgraded from ARS 7.1 p7 to 7.6.04 SP2 and I'm found that one of my large character fields that I've set to 90000 (for example) is getting errors that the "Character String exceed maximum size allowed: 536870919" when I try to set it. It only happens to those records that do have quite a large amount of characters, but this never happened in 7.1 p7. I pushed it up to 20000 characters and I'm still getting the error. Looks like this is more on the DB side? Should I talk to my DBA? Lisa Kemes AR System Developer TEIS - USA +1 717 810 2408 tel +1 717 602 9460 mobile lisa.ke...@te.com<mailto:lisa.ke...@te.com> 100 Amp Drive Harrisburg, PA 17112 [http://www.te.com/images/socialmedia/smallTElogo.gif]<http://www.te.com/> www.te.com<http://www.te.com/> [http://www.te.com/images/socialmedia/twitter.png]<http://twitter.com/teconnectivity>[http://www.te.com/images/socialmedia/facebook.png]<http://www.facebook.com/teconnectivity>[http://www.te.com/images/socialmedia/flickr.png]<http://www.flickr.com/photos/teconnectivity/>[http://www.te.com/images/socialmedia/linkedin.png]<http://www.linkedin.com/groups?gid=1591657>[http://www.te.com/images/socialmedia/youtube.png]<http://www.youtube.com/teconnectivity> _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"