Re: Unable to retrieve data from a form

[Ankur Gulati]

Fred,
 
There are three tables on the form(Email handler Form) 
 
First table is attachment table, this brings the attachment to this form
from another form. 
Second table is the attachment pool.
Third table fetches the data from AR System Email Attachment Join.
 
I have also turned down the table refreshes on display. No Improvement. 
 
I'd be glad if you can fwd me the script to check indexes on tables.
 
Regards
Ankur


________________________________

        From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Grooms, Frederick W
        Sent: 18 June 2008 07:31 PM
        To: arslist@ARSLIST.ORG
        Subject: Re: Unable to retrieve data from a form
        
        
        ** 
        What table do you have on the form?  It still sounds like an
index problem (Either you are missing an index on the B table or your
selection query for your table on the form is not using an index).
         
        Since you are on Oracle I have a script you can use to verify if
all tables have their primary (Remedy defined), and User defined
indexes.
         
        Fred

________________________________

        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

        __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the
Answers Are" html___ 


_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"