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: [email protected] [mailto:[email protected]] 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: [email protected] [mailto:[email protected]] 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: [email protected] [mailto:[email protected]] 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: [email protected] Web: http://www.all-spec.com Blog: http://blog.all-spec.com ---------------------------------------- > -----Original Message----- > From: [email protected] [mailto:u2-users- > [email protected]] 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: [email protected] [mailto:u2-users- > [email protected]] 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 > [email protected] > http://listserver.u2ug.org/mailman/listinfo/u2-users > > _______________________________________________ > U2-Users mailing list > [email protected] > http://listserver.u2ug.org/mailman/listinfo/u2-users _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users
