This issue has been resolved by a complete re-write.
However, to answer your question: the original code was written several years
ago and was working for a long time before it broke. Exactly WHEN it broke, I
do not know - this process is not run on a regular basis. My basic program was
collecting the data and loading it into various properties of the RBO object.
It was NOT in XML originally. It was simply multi-valued (and some sub-valued)
data that was passed back to Redback who passed it back to the web page
(server). The web page then converted the data into arrays and built the data
as an Excel file using:
Response.Buffer = TRUE
Response.ContentType = "application/vnd.ms-excel"
Response.AddHeader "content-disposition", "attachment;
filename=All_Users.xls"
and building the data as an HTML table. This was pretty cool while it lasted.
XML was not involved with this original process.
Unfortunately, this stopped working at some point, and all my testing points to
a size limit hitting me somewhere. The failure was happening somewhere between
the basic program returning and the web page/server taking control. As far as
I can tell, the only things between these 2 points is Redback.
Since everything worked cleanly on the Avanté (UNIX) box and the failure
occurred AFTER returning control, I decided to completely redesign this overall
process to do all the work in the basic program. I am now building the data as
an XML file, sending the user an E-mail with the XML file as an attachment,
then returning control back to Redback (but w/o any data to handle), who in
turn returns control back to the web server. Upon regaining control, the web
servers simply redisplays the web page.
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 Ross Ferris
Sent: Wednesday, March 30, 2011 9:01 PM
To: U2 Users List
Subject: Re: [U2] Redback Limit
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: [email protected] [mailto:u2-users-
>[email protected]] 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: [email protected] [mailto:u2-users-
>[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:u2-users-
>[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:u2-users-
>[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
_______________________________________________
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
