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
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
Re: [U2] Trigger questions
Unidata or Universe? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Trigger questions
This is what EDA is for isnt it? On Wed, Mar 30, 2011 at 12:10 PM, Kevin King precisonl...@gmail.com wrote: Unidata or Universe? ___ 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
Eating Disorders Anonymous??? ;-) Sorry, couldn't resist. Charlie Noah On 03-30-2011 11:20 AM, Steve Romanow wrote: This is what EDA is for isnt it? On Wed, Mar 30, 2011 at 12:10 PM, Kevin Kingprecisonl...@gmail.com wrote: Unidata or Universe? ___ 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
By definition - if you're creating a write trigger the first parameter is the status. From Developing UniBasic Applications SUBROUTINE trigname(execstat, dictflag, filename, record.ID.expr, recordval) execstat The execution status returned by the trigger subroutine: 0 - No updates are allowed. 1 - Updates are allowed. 2 - Updates are allowed, using the return recordval. So if your before update trigger passes back a 0 as the execstat the write won't be performed. You'll just need to make sure the process calling the write can then deal with it. Hth Colin Alfke Calgary, Canada -Original Message- From: Doug Chanco 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 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Trigger questions
deal with it means ON ERROR clause -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Colin Alfke Sent: Wednesday, March 30, 2011 12:42 PM To: 'U2 Users List' Subject: Re: [U2] Trigger questions By definition - if you're creating a write trigger the first parameter is the status. From Developing UniBasic Applications SUBROUTINE trigname(execstat, dictflag, filename, record.ID.expr, recordval) execstat The execution status returned by the trigger subroutine: 0 - No updates are allowed. 1 - Updates are allowed. 2 - Updates are allowed, using the return recordval. So if your before update trigger passes back a 0 as the execstat the write won't be performed. You'll just need to make sure the process calling the write can then deal with it. Hth Colin Alfke Calgary, Canada -Original Message- From: Doug Chanco 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 ___ 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
Does anyone have EDA working to SQL yet? Jeffrey Lettau ERP Systems Manager polkaudio -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Steve Romanow Sent: Wednesday, March 30, 2011 12:21 PM To: U2 Users List Subject: Re: [U2] Trigger questions This is what EDA is for isnt it? On Wed, Mar 30, 2011 at 12:10 PM, Kevin King precisonl...@gmail.com wrote: Unidata or Universe? ___ 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 Disclaimer: This email may contain confidential and/or privileged information. It is intended only for the person or persons to whom it is addressed. Any unauthorized review, use, or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply email or telephone and destroy all copies of the original message. Please consider the environment before printing this email. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[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. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Trigger questions
Sorry it's universe on aix but can also be tested/run on windows and Linux 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 12:10, Kevin King precisonl...@gmail.com wrote: Unidata or Universe? ___ 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
Doug, In UniData you can test for STATUS() after the ON ERROR of a WRITE command. If the STATUS() is 2 then the WRITE failed in the Trigger. You can also set @USER.RETURN.CODE or use a COMMON variable to pass the error code/message. David A. Green (480) 813-1725 DAG Consulting -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Doug Chanco Sent: Wednesday, March 30, 2011 11:03 AM To: U2 Users List Cc: U2 Users List Subject: Re: [U2] Trigger questions Sorry it's universe on aix but can also be tested/run on windows and Linux 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 12:10, Kevin King precisonl...@gmail.com wrote: Unidata or Universe? ___ 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
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
Re: [U2] Trigger questions
In a message dated 3/30/2011 11:03:07 AM Pacific Daylight Time, d...@chancofamily.com writes: 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 .. You mean there are no people who don't want to learn java? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Trigger questions
me, me, there is at least one! :) On Wed, Mar 30, 2011 at 2:32 PM, fft2...@aol.com wrote: In a message dated 3/30/2011 11:03:07 AM Pacific Daylight Time, d...@chancofamily.com writes: 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 .. You mean there are no people who don't 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
Re: [U2] Trigger questions
Make that 2!!! Charlie Noah On 03-30-2011 1:59 PM, Steve Romanow wrote: me, me, there is at least one! :) On Wed, Mar 30, 2011 at 2:32 PM,fft2...@aol.com wrote: In a message dated 3/30/2011 11:03:07 AM Pacific Daylight Time, d...@chancofamily.com writes: 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 .. You mean there are no people who don't 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
Re: [U2] Trigger questions
Yeah, 10 Bruce M Neylon Health Care Management Group From: Charlie Noah cwn...@comcast.net To: U2 Users List u2-users@listserver.u2ug.org Date: 03/30/2011 03:13 PM Subject:Re: [U2] Trigger questions Sent by:u2-users-boun...@listserver.u2ug.org Make that 2!!! Charlie Noah On 03-30-2011 1:59 PM, Steve Romanow wrote: me, me, there is at least one! :) On Wed, Mar 30, 2011 at 2:32 PM,fft2...@aol.com wrote: In a message dated 3/30/2011 11:03:07 AM Pacific Daylight Time, d...@chancofamily.com writes: 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 .. You mean there are no people who don't 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
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
Re: [U2] Trigger questions
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
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] 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: