Possibly. I was able to move the data from our current production (7.6.04 SP2) to our old production 7.1p7 and run my workflow and I didn't get any errors.
It looks like when a field was updated with a filter the character limit didn't matter (if it were manually updated through user tool or midtier it would have popped up an error). That was in 7.1 p7. Now it looks like it matters whether it's populated with a filter or manual in 7.6.04 SP2..... Thanks! Lisa ________________________________ From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Joe Martin D'Souza Sent: Wednesday, April 04, 2012 4:55 PM To: arslist@ARSLIST.ORG Subject: Re: Large Character Fields even Larger? ** Have the DBA's converted the data to unicode? That would explain the additional space requirement.. Joe From: Kemes, Lisa<mailto:lisa.ke...@te.com> Sent: Wednesday, April 04, 2012 2:50 PM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG<mailto:arslist@ARSLIST.ORG> Subject: Re: Large Character Fields even Larger? ** 287,351 characters.... Thanks! Lisa ________________________________ From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Grooms, Frederick W Sent: Wednesday, April 04, 2012 2:44 PM To: arslist@ARSLIST.ORG Subject: Re: Large Character Fields even Larger? ** 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> _attend WWRUG12 www.wwrug.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"
