Ankur, Actually the API call structure in the log shows that the select that you are speaking of is from a GLEWF ARGetListEntryWithFields API call. That most likely means that a table field is being refreshed and the qualification on the table field is unqualified. I would look for any Table field with no qualification, or any table field that is totally dependent on one or more EXTERNAL() operators that may be referencing a field that is still NULL at the time the table field is being refreshed.
HTH -- Carey Matthew Black Remedy Skilled Professional (RSP) ARS = Action Request System(Remedy) Love, then teach Solution = People + Process + Tools Fast, Accurate, Cheap.... Pick two. On Thu, Jun 19, 2008 at 6:44 AM, Ankur Gulati <[EMAIL PROTECTED]> wrote: > ** > I took the db and API log for the search action on the form. > > I opened the form in the search mode, put in the request id =000000000000001 > to search for. > > In the logs, It starts with ARGetEntry and fetches this record but the last > SQL that runs is bit intruding...It selects all request_ID and assigned to > > SELECT T102.C1,C4 FROM T102 ORDER BY 1 ASC > > Now this query took 30 mins. there are just 69000 records in this form. > > Why is this SQL running? or is this normal ? Attached is the excerpt from > the log. > > This Darn issue has extended my stay in Sweden...its funny > sometimes when the travel plan gets affected with some technical issues.... > > Regards > Ankur > > ________________________________ > From: Action Request System discussion list(ARSList) > [mailto:[EMAIL PROTECTED] On Behalf Of Grooms, Frederick W > Sent: 18 June 2008 10:59 PM > To: arslist@ARSLIST.ORG > Subject: Re: Unable to retrieve data from a form > > ** > From the User tool turn on logging (at least API and Database) and see what > SQL statement is the one taking so long > ________________________________ > From: Action Request System discussion list(ARSList) > [mailto:[EMAIL PROTECTED] On Behalf Of Ankur Gulati > Sent: Wednesday, June 18, 2008 5:15 AM > To: arslist@ARSLIST.ORG > Subject: Re: Unable to retrieve data from a form > > Hi Guys, > > Another thing which I forgot to mention, the status bar at the bottom does > show that it found the record and it gets stuck saying "Refreshing table up > to Administrator`s limit" > > > Ankur > > ________________________________ > From: Ankur Gulati > Sent: 18 June 2008 03:30 PM > To: 'arslist@ARSLIST.ORG' > Subject: Unable to retrieve data from a form > > Hi Listers, > > We have a form which has 5 BLOB fields. There are around 67000 records and > it takes around 3-4 hrs to search for a single record. I search on the > request_id. We do have couple of other indexes in place apart on Request ID > field. > > The actual workflow is that an AL does a push field and creates a new record > in a form and then second Set field is fired in same AL which opens this new > record in modify window. So this is where it fails to open this new record > and even if I open the form and search for any record it takes forever to > show up and usually it freezes. > > I have rebuild the indexes but no improvement. On another form without no > BLOB data and 100+ fields, it takes less than a sec to search a record. > > Logs doesn't show anything. AL, SQL and filter log just shows the perfect > creation of new record and then on Display it does show the opening of the > form in SET Operation. > > What all should I check? > > ARS. 7.0 Patch 5 > Database Oracle 9i > > Regards > Ankur _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"