Bulls Eye.......! Thank you Carey. Yep there was a table field with blank qualification retrieving "Assigned To" from the same form. I disabled this table and it worked perfect.
Thank you Axton, Brian, Frank and Fred. Regards Ankur > -----Original Message----- > From: Action Request System discussion list(ARSList) > [mailto:[EMAIL PROTECTED] On Behalf Of Carey Matthew Black > Sent: 19 June 2008 04:29 PM > To: arslist@ARSLIST.ORG > Subject: Re: Unable to retrieve data from a form > > 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" > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"