Hi Dwayne, Since it works for a small number of records but not large, this sounds like a data issue. Either it is corrupt or the field in the vendor form is larger than where you are adding the data. The latter may result in some failures, and the jumpy behavior. Mark ________________________________ From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Martin, Robert Sent: Monday, November 30, 2009 8:23 AM To: [email protected] Subject: Filter guide loops table several times
Dear List I have a filter that calls a guide that loops a table with 3000 records. For each row, it gets info from the entry, and depending on the value, adds the info to a list in a character field. The problem is, the guide seems to be looping the table 3+ times. The list field shows the same several entries three times, and begins the fourth time, then stops before getting to the end. If I run a filter log it begins in the middle of the looping process, apparently because the log has exceeded its maximum size and the beginning is getting dropped. The Max Log-File Size is set to 2,000,000 bytes. If I try to change it I get, "Value does not fall within the limits specified for the field : (0-100000) : Maximum Log-File Size (byte) :" So it is already over its limit. In the portion of the filter log that I can see, the system processes a record 9/10 of the way to the bottom of the table, then jumps up to the second table row, skipping the bottom and top rows. Towards the end of the guide I find this bit of code: 'Call Guide "GN:SysVar-Fill Inactive ESN list" (return).' This is after it has processed a row about a sixth of the way down the table. So it looks like the guide is looping the table three times, but never quite gets to the end, and on the fourth loop it arbitrarily quits in the middle. If the table were based on a regular form I could use an sql query to find the records, but it is based on a Vendor form, and they don't seem to have underlying tables or views. If I change the table qualification to only include a few entries, everything works fine and the guide only loops the table once. Maybe filter guides simply get lost when they try to loop tables with thousands of rows. Any suggestions? (ARS 7.1 p3, RH Linux server, Oracle 10.2 db) Dwayne Martin James Madison University _Platinum Sponsor: [email protected] ARSlist: "Where the Answers Are"_ ________________________________ This e-mail is the property of NaviSite, Inc. It is intended only for the person or entity to which it is addressed and may contain information that is privileged, confidential, or otherwise protected from disclosure. Distribution or copying of this e-mail, or the information contained herein, to anyone other than the intended recipient is prohibited. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are"
