You said you were making XML .... no stray ">" or "<" in the data you are generating that could throw things off?
Ross Ferris Stamina Software Visage > Better by Design! >-----Original Message----- >From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- >boun...@listserver.u2ug.org] On Behalf Of Israel, John R. >Sent: 31 March 2011 6:33 AM >To: 'U2 Users List' >Subject: Re: [U2] Redback Limit > >There were 13 columns with 970 rows (including a header). These columns >included: >E-mail address >User Name >Domain >User Type >Last Login Date >Last Login Time >AR Inq (1/0) >Sales Inq (1/0) >RMA Inq (1/0) >Products Inq (1/0) >Storefront (1/0) >USA Companies (svm) >Canadian Companies (svm) > >The last 2 columns contain the company # and name. > >Everything worked find for a while. At some point, we noticed that it was no >longer working. I suspect this was when we reached a certain number of >users thus hitting a limit. Using a "SAMPLE XXX" on my SELECT, I was able to >determine the last record that would work. I looked at it and the following >record for bad info, but there was none. I skipped over the offending record, >but it simply blew up on the next record (thus hitting the suspected size >limit). >Taking the names out of the last 2 columns (thus only returning just the >customer numbers) worked, but was not meaningful. > >I have since redesigned this whole process to created an XML file on the UNIX >box then E-mailed it to the user as an attachment. Thus, the exact same info >is received by the user, but no data is actually passed back to the web page. > >Just one of life's little mysteries. > > >Thanks for all the input. > > > >John Israel >Senior Programmer/Analyst >Dayton Superior Corporation >1125 Byers Road >Miamisburg, OH 45342 > > >-----Original Message----- >From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- >boun...@listserver.u2ug.org] On Behalf Of Holt, Jake >Sent: Wednesday, March 30, 2011 2:16 PM >To: U2 Users List >Subject: Re: [U2] Redback Limit > >How many fields do you have? From what I remember reading, there was a >field limit on RBOs, it was like a thousand fields though. > >-----Original Message----- >From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- >boun...@listserver.u2ug.org] On Behalf Of Israel, John R. >Sent: Wednesday, March 30, 2011 10:33 AM >To: 'U2 Users List' >Subject: Re: [U2] Redback Limit > >It was not timing out. I have other pages that take longer. It really seemed >to >be a size limit. I develop with FF with a Web Developer plug-in that helps a >lot. >I validate with IE, Chrome, Opera and Safari, but FF is my preferred browser. > > >John Israel >Senior Programmer/Analyst >Dayton Superior Corporation >1125 Byers Road >Miamisburg, OH 45342 > > >-----Original Message----- >From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- >boun...@listserver.u2ug.org] On Behalf Of Glen Batchelor >Sent: Wednesday, March 30, 2011 11:03 AM >To: 'U2 Users List' >Subject: Re: [U2] Redback Limit > > > Try using cURL or wget, with an unlimited timeout, and get the real headers >from the server. Assuming you're using IE, it rarely tells a true story when it >comes to server connection issues or HTTP errors. > >---------------------------------------- >Glen Batchelor >IT Director/CIO/CTO >All-Spec Industries > phone: (910) 332-0424 > fax: (910) 763-5664 >E-mail: webmas...@all-spec.com > Web: http://www.all-spec.com > Blog: http://blog.all-spec.com >---------------------------------------- > >> -----Original Message----- >> From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- >> boun...@listserver.u2ug.org] On Behalf Of Israel, John R. >> Sent: Wednesday, March 30, 2011 8:33 AM >> To: 'U2 Users List' >> Subject: Re: [U2] Redback Limit >> >> I was exporting all the user info we track with Avanté's ePortal from >> ePortal back to a web page which rips the data apart and automatically >> opens it in Excel. Over 900 records with all kinds of info (name, >> company, access, etc.) I was never able to find any corruption in the >> data. I did find that by capping the number of records OR not loading >> the company names of the users the problem went away. If I wrote the >> data to a temp file prior to loading up the RBO to pass back to the >> web page, there was nothing wrong. I think there is simply a limit >> somewhere. I am not sure if the limit is on a specific property (mv >> list of company/name the user has access to see) or the RBO in general. >> >> Either way, I could not wait on this and I have had to re-engineer >> this export. What used to automatically build an Excel file for the >> user via an ASP web page will now create an XML file of the same info >> in ePortal (on the UNIX box), then E-mail it to the user. >> >> Granted, this was a lot of data, but with today's technology, I did >> not think it was THAT bad. >> >> >> John Israel >> Senior Programmer/Analyst >> Dayton Superior Corporation >> 1125 Byers Road >> Miamisburg, OH 45342 >> >> >> -----Original Message----- >> From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- >> boun...@listserver.u2ug.org] On Behalf Of Kevin King >> Sent: Tuesday, March 29, 2011 9:16 PM >> To: U2 Users List >> Subject: Re: [U2] Redback Limit >> >> About how much data is being passed back? Could the server be timing >> out while receiving it all? >> >> -Kevin >> http://www.PrecisOnline.com >> _______________________________________________ >> U2-Users mailing list >> U2-Users@listserver.u2ug.org >> http://listserver.u2ug.org/mailman/listinfo/u2-users >> >> _______________________________________________ >> U2-Users mailing list >> U2-Users@listserver.u2ug.org >> http://listserver.u2ug.org/mailman/listinfo/u2-users > >_______________________________________________ >U2-Users mailing list >U2-Users@listserver.u2ug.org >http://listserver.u2ug.org/mailman/listinfo/u2-users > >_______________________________________________ >U2-Users mailing list >U2-Users@listserver.u2ug.org >http://listserver.u2ug.org/mailman/listinfo/u2-users >_______________________________________________ >U2-Users mailing list >U2-Users@listserver.u2ug.org >http://listserver.u2ug.org/mailman/listinfo/u2-users > >_______________________________________________ >U2-Users mailing list >U2-Users@listserver.u2ug.org >http://listserver.u2ug.org/mailman/listinfo/u2-users _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users