Re: [U2] Redback Limit
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: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] 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: 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]
Re: [U2] Redback Limit
Hi, Sorry, I meant within BEGIN TRANSACTION... END TRANSACTION, but if there was no writing, I wouldn't have thought this was the issue. Adam -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 13:53 To: 'U2 Users List' Subject: Re: [U2] Redback Limit I don't understand the within transaction boundaries? I was not updating (writing to disk) anything. I was just loading the RBO in my basic program, then on the web server I was pulling that data apart and building an Excel file with that data. The user was then shown a window (produced by the browser) asking if they wanted to open the file. If they say yes, it opens in Excel. Nothing was ever written to disk in the original design. 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 Adam Eccleshall Sent: Thursday, March 31, 2011 8:45 AM To: U2 Users List Subject: Re: [U2] Redback Limit Hi, Was the update within transaction boundaries at all? We had an issue where attempting to update all records in an import within the same transaction hit a limit and crashed the process. This was resolved by making each import line its own transaction (transaction processing had been wrapped around an existing process, rather than being designed in from the start). Adam -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 13:29 To: 'U2 Users List' Subject: Re: [U2] Redback Limit 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: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] 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: 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
Re: [U2] Trigger questions
Come on, Doug, you know documentation is usually treated as an afterthought - way behind the software and usually incomplete. I'm glad you got your trigger working. Now, since I have no interest in learning Java, am I 1 or 10 of those people? ;^) Charlie On 03-31-2011 10:55 AM, Doug Chanco wrote: Thank you very much this was extremely helpful info I have it working but does anyone besides me think the trigger info in the sysdesc manual is not very helpful? I did not see any reference to setdiagnostics and why is there no pick syntax for working with triggers? The SQL syntax works fine once you get used to it Anyway thanks to everyone for their help and yes outside my world there are those that do not like or want to Learn java Dougc email signature There are 10 kinds of people in the world, those that know binary and those that do not. Along the same lines there are those who know java and those who want to learn java .. On Mar 30, 2011, at 20:29, Boydell, Stuartstuart.boyd...@spotless.com.au wrote: If you want to force the trigger to issue a rollback I think you need to execute the SetDiagnostics function. Something like... subroutine TRIGGER.HANDLER(triggerName,schema,tableName, event,eventTime, newRecordID,newRecord,oldRecordID,oldRecord, association,associationEvent, triggerCount,chainCascade,cascade) if someCheckCondition then call updateThirdPartyApp(xxx, returnStatus) if returnStatus 0 then *// rollback and gracefully end processing. z = setDiagnostics('[999] Third Party App update failed with: ': returnStatus) end end return end -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Doug Chanco Sent: Thursday, 31 March 2011 03:05 To: U2 Users List Subject: [U2] Trigger questions I am sure I can do this but I am trying to figure out the best way I need to write a WRITE trigger that does the following Call a java web service to update an SQL table (no problem) But if the update fails do NOT update the pick record and if possible notify the user My question is what would be the best method/way to do this? Do triggers use transaction logging that I could roll back the record or should I do something more manual? Copy the record (for example) Any thoughts/suggestions/ideas welcomed and appreciated Dougc email signature There are 10 kinds of people in the world, those that know binary and those that do not. Along the same lines there are those who know java and those who want to learn java .. ___ 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
Re: [U2] Trigger questions
While it's working I am getting back: [error] SQL update failed good But I am also seeing Error performing trigger for customer but It works the record is not updated Write failure good Any idea on why I am getting the error performing trigger when it's obvious it's working? Thanks Dougc email signature There are 10 kinds of people in the world, those that know binary and those that do not. Along the same lines there are those who know java and those who want to learn java .. On Mar 31, 2011, at 11:55, Doug Chanco d...@chancofamily.com wrote: Thank you very much this was extremely helpful info I have it working but does anyone besides me think the trigger info in the sysdesc manual is not very helpful? I did not see any reference to setdiagnostics and why is there no pick syntax for working with triggers? The SQL syntax works fine once you get used to it Anyway thanks to everyone for their help and yes outside my world there are those that do not like or want to Learn java Dougc email signature There are 10 kinds of people in the world, those that know binary and those that do not. Along the same lines there are those who know java and those who want to learn java .. On Mar 30, 2011, at 20:29, Boydell, Stuart stuart.boyd...@spotless.com.au wrote: If you want to force the trigger to issue a rollback I think you need to execute the SetDiagnostics function. Something like... subroutine TRIGGER.HANDLER(triggerName,schema,tableName, event,eventTime, newRecordID,newRecord,oldRecordID,oldRecord, association,associationEvent, triggerCount,chainCascade,cascade) if someCheckCondition then call updateThirdPartyApp(xxx, returnStatus) if returnStatus 0 then *// rollback and gracefully end processing. z = setDiagnostics('[999] Third Party App update failed with: ': returnStatus) end end return end -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Doug Chanco Sent: Thursday, 31 March 2011 03:05 To: U2 Users List Subject: [U2] Trigger questions I am sure I can do this but I am trying to figure out the best way I need to write a WRITE trigger that does the following Call a java web service to update an SQL table (no problem) But if the update fails do NOT update the pick record and if possible notify the user My question is what would be the best method/way to do this? Do triggers use transaction logging that I could roll back the record or should I do something more manual? Copy the record (for example) Any thoughts/suggestions/ideas welcomed and appreciated Dougc email signature There are 10 kinds of people in the world, those that know binary and those that do not. Along the same lines there are those who know java and those who want to learn java .. ___ 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
Re: [U2] Redback Limit
Hi John, I hit a Redback size limit at a clients also. The app was fine, and then all of a sudden it stopped working. The RBO was very straight forward - it captured data from the web, and then transmitted it to the back end. IIRC, the limit was just over 15,000 characters. I didn't redesign the whole app, but instead looped on the submission - limiting the # of rows submitted each itteration. The client had a bunch of RBOs with a bunch of submissions, and we were suprised to find a limit. But it was absolutely reproduceable. I don't think that they ever encountered this problem since then, and it's real possible that an application upgrade (redback, unidata) also helped. Hope that helps! Or at least you have a sympathetic ear. -Laura -Original Message- From: Israel, John R. [johnisr...@daytonsuperior.com] Date: 03/30/2011 11: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
Re: [U2] Redback Limit
Thanks Laura, You are the first to confirm a size limit. Like you, I found a way around it. It just would have been nice to know about this up front. For all I know, it actually is documented somewhere and folks just do not hit that limit due to other limiting factors. Any idea if it was a 15k limit on a property, or a 15k limit on the overall RBO? 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 Laura Hirsh Sent: Thursday, March 31, 2011 12:58 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Redback Limit Hi John, I hit a Redback size limit at a clients also. The app was fine, and then all of a sudden it stopped working. The RBO was very straight forward - it captured data from the web, and then transmitted it to the back end. IIRC, the limit was just over 15,000 characters. I didn't redesign the whole app, but instead looped on the submission - limiting the # of rows submitted each itteration. The client had a bunch of RBOs with a bunch of submissions, and we were suprised to find a limit. But it was absolutely reproduceable. I don't think that they ever encountered this problem since then, and it's real possible that an application upgrade (redback, unidata) also helped. Hope that helps! Or at least you have a sympathetic ear. -Laura -Original Message- From: Israel, John R. [johnisr...@daytonsuperior.com] Date: 03/30/2011 11: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] A Customer Opinion
[ad] Normally we boast about our products. However here is an email from one of XLr8 Clients that is using our $49.00 XLr8Editor and our $99.00 XLr8Installer. Doug, You are a scholar and a gentlemen, but I take it you already know that. I have installed the current version of Eclipse Helios on the Laptop, then installed the U2 Logic tools. (Unpacked the Helios tar-ball into '/usr/local/eclipse', changed permissions to a local common group) Once that was done, the old license info magically appeared on reboot. (I assume it picked it up from the local user profile, from the previous version of Eclipse?) I then removed the legacy Fedora version of Eclipse, with no problems, then updated the new Helios version, still no problems. As far as I can see, all looks happy. I have tested the newly reinstalled Editor, it seems to work fine and dandy. I also noticed that I now have what appears to be a happier Installer. Now I also have a comprehensive help system, in addition to some other things that weren't always playing nice, like the Item List Filter. So, I'm impressed. If I have any problems, I let you know, but I think I need some sleep. Should you need anyone to sing the praise of U2 Logic, I'm also converted. :-) I thank you very much. :-) Regards, Christopher [/ad] ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Redback Limit
Hi John, I'm pretty sure that it was a per property limit. The application had a lot of people's names: salutation + first name + middle initial + last name, etc. It took a bunch of trial and error to figure out - RBO Scope helped a ton. The team I was working with at the time, couldn't believe that there was any limit, but after I demo-ed to them, they were believers! HTH, Laura -Original Message- From: Israel, John R. [johnisr...@daytonsuperior.com] Date: 03/31/2011 01:08 PM To: 'U2 Users List' Subject: Re: [U2] Redback Limit Thanks Laura, You are the first to confirm a size limit. Like you, I found a way around it. It just would have been nice to know about this up front. For all I know, it actually is documented somewhere and folks just do not hit that limit due to other limiting factors. Any idea if it was a 15k limit on a property, or a 15k limit on the overall RBO? 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 Laura Hirsh Sent: Thursday, March 31, 2011 12:58 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Redback Limit Hi John, I hit a Redback size limit at a clients also. The app was fine, and then all of a sudden it stopped working. The RBO was very straight forward - it captured data from the web, and then transmitted it to the back end. IIRC, the limit was just over 15,000 characters. I didn't redesign the whole app, but instead looped on the submission - limiting the # of rows submitted each iteration. The client had a bunch of RBOs with a bunch of submissions, and we were surprised to find a limit. But it was absolutely reproduce-able. I don't think that they ever encountered this problem since then, and it's real possible that an application upgrade (redback, unidata) also helped. Hope that helps! Or at least you have a sympathetic ear. -Laura -Original Message- From: Israel, John R. [johnisr...@daytonsuperior.com] Date: 03/30/2011 11: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
Re: [U2] Redback Limit
Laura, Yeah, your experience looks strikingly similar to what I experienced. It was a pain to zero in on, but reproducible over and over. Thanks again for confirmation. That looks like something we all need to keep in mind. 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 Laura Hirsh Sent: Thursday, March 31, 2011 1:40 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Redback Limit Hi John, I'm pretty sure that it was a per property limit. The application had a lot of people's names: salutation + first name + middle initial + last name, etc. It took a bunch of trial and error to figure out - RBO Scope helped a ton. The team I was working with at the time, couldn't believe that there was any limit, but after I demo-ed to them, they were believers! HTH, Laura -Original Message- From: Israel, John R. [johnisr...@daytonsuperior.com] Date: 03/31/2011 01:08 PM To: 'U2 Users List' Subject: Re: [U2] Redback Limit Thanks Laura, You are the first to confirm a size limit. Like you, I found a way around it. It just would have been nice to know about this up front. For all I know, it actually is documented somewhere and folks just do not hit that limit due to other limiting factors. Any idea if it was a 15k limit on a property, or a 15k limit on the overall RBO? 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 Laura Hirsh Sent: Thursday, March 31, 2011 12:58 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Redback Limit Hi John, I hit a Redback size limit at a clients also. The app was fine, and then all of a sudden it stopped working. The RBO was very straight forward - it captured data from the web, and then transmitted it to the back end. IIRC, the limit was just over 15,000 characters. I didn't redesign the whole app, but instead looped on the submission - limiting the # of rows submitted each iteration. The client had a bunch of RBOs with a bunch of submissions, and we were surprised to find a limit. But it was absolutely reproduce-able. I don't think that they ever encountered this problem since then, and it's real possible that an application upgrade (redback, unidata) also helped. Hope that helps! Or at least you have a sympathetic ear. -Laura -Original Message- From: Israel, John R. [johnisr...@daytonsuperior.com] Date: 03/30/2011 11: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
[U2] WebDE PE
Hi, Is anyone using WebDE PE on UV PE? I've installed the most recent versions available, and have not got it working. Or so I think. I've installed UV PE 11 on Linux, then deployed the rbo server and the example application war file to Glassfish 3.1. When launching the app and trying the first link: uObject1.jsp, I get the error message RedObject.jrgwOpen(): The UniVerse license has expired. Not sure what to do differently. Anyone have any ideas? Bob Little UniVerse Developer Market America, Inc. Greensboro NC. 336-478-1694 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] dynamically disassociate associated fields?
Two ways Dynamic Normalization SELECT colname1,colname2,colname3 FROM tablename_assocname; Using this method only the primary key (@ID) and columns named in the association can be selected. UNNEST Operator SELECT colname1,colname2,colname3 FROM UNNEST tablename ON assocname; Using this method (which is akin to BY.EXP in the other query language TCL) you can select any columns whether from the base table (in which case they'll be repeated) or from the assocation. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Trigger questions
When/if you upgrade to UV 11.1 - perhaps you should use Index-based triggers - now supported by Rocket. Simpler than SQL-style triggers... see the new features.pdf in UV 11.1. Excerpt: In some circumstances, an application may not require all of the capabilities available to conventional triggers. In these cases, index-based subroutines may serve the purpose better because they have reduced overhead, which may translate to better performance. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Doug Chanco Sent: Friday, 1 April 2011 3:19 AM To: U2 Users List Subject: Re: [U2] Trigger questions While it's working I am getting back: [error] SQL update failed good But I am also seeing Error performing trigger for customer but It works the record is not updated Write failure good Any idea on why I am getting the error performing trigger when it's obvious it's working? Thanks Dougc ** IMPORTANT MESSAGE * This e-mail message is intended only for the addressee(s) and contains information which may be confidential. If you are not the intended recipient please advise the sender by return email, do not use or disclose the contents, and delete the message and any attachments from your system. Unless specifically indicated, this email does not constitute formal advice or commitment by the sender or the Commonwealth Bank of Australia (ABN 48 123 123 124) or its subsidiaries. We can be contacted through our web site: commbank.com.au. If you no longer wish to receive commercial electronic messages from us, please reply to this e-mail by typing Unsubscribe in the subject line. ** ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] dynamically disassociate associated fields?
You can use an alternate dictionary in native or SQL queries... USING DICT MYALTDICT Or more practical suggest made by Kate is to have a different dictionary definition... -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Shane Ricciardi Sent: Thursday, 31 March 2011 4:22 AM To: u2-users@listserver.u2ug.org Subject: [U2] dynamically disassociate associated fields? Hello. I have a rather large MV association that contains around 40 or so I- type dicts that all call subroutines. Since this is essentially a subtable to uv/SQL, selecting any field from the subtable causes all the fields to be processed, although only the requested field is returned. As you can imagine this slows things down a ton. Is there a way to tell universe to *just* process the field(s) requested in the SELECT stmt without creating new dicts associations? Thanks. ** IMPORTANT MESSAGE * This e-mail message is intended only for the addressee(s) and contains information which may be confidential. If you are not the intended recipient please advise the sender by return email, do not use or disclose the contents, and delete the message and any attachments from your system. Unless specifically indicated, this email does not constitute formal advice or commitment by the sender or the Commonwealth Bank of Australia (ABN 48 123 123 124) or its subsidiaries. We can be contacted through our web site: commbank.com.au. If you no longer wish to receive commercial electronic messages from us, please reply to this e-mail by typing Unsubscribe in the subject line. ** ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users