Is there any consistent element among the three table fields? Perhaps in any workflow object referencing or updating them? How about some recursive workflow? Are client/server resources taxed while waiting for the refresh of the display?
Rick -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Dwayne Martin Sent: Tuesday, April 25, 2006 12:00 PM To: [email protected] Subject: Re: Form freezes on display Thanks for your suggestions, Sylvia and Rick. There is no diary field on the form. The problem carries over into the "DeleteMe" copies, which don't have any workflow. Rick suggested SQL. I believe tables use SQL to select their records. There are three table fields on the form. If I delete any one table field the form still hangs. But if I delete all three table fields it stops hanging. The only consistant pattern seems to be that if I delete enough fields the form stops hanging. Thanks again for your suggestions. Dwayne ---- Original message ---- >Date: Tue, 25 Apr 2006 11:42:01 -0700 >From: Rick Cook <[EMAIL PROTECTED]> >Subject: Re: Form freezes on display >To: [email protected] > > ** > No, that old limitation was a Windows one, back in > ARS v3 or 4. You had 32 MB for Windows and 64 MB > for UNIX. It would save the record with more than > that, but would not re-open. Now that we have about > a 2 GB limitation, that's not a problem any more. > > My guess here is that there's a problem with some > piece of workflow referencing an orphaned field or a > bad SQL command or something. > > Rick > > ------------------------------------------------ > > From: Action Request System discussion list(ARSList) > [mailto:[EMAIL PROTECTED] On Behalf Of Sylvia > Holy > Sent: Tuesday, April 25, 2006 11:34 AM > To: [email protected] > Subject: Re: Form freezes on display > ** > Hi Dwayne, > > I had a similiar problem several years ago with a > record where someone had pasted a huge file into the > work log field. The system saved the entry but > whenever you tried to open it would freeze up. > Could something like have happened to your single > record form? > > HTH, > > Sylvia Holy > > Dwayne Martin To [email protected] > <[EMAIL PROTECTED]> cc > Sent by: "Action Subject Form freezes on > Request System display > discussion > list(ARSList)" > <[email protected]> > > 04/25/2006 01:26 PM > > +---------------------+ > | Please respond to | > | [email protected] | > +---------------------+ > > Greetings everyone, > > I was working with a form which normally has a > single record. > Suddenly it started freezing when I tried to display > that > record. The "Processing Search Results" window pops > up, then > disappears and a white rectangle stays in its place, > but the > record never appears. I have to kill the User tool. > The > workflow.log shows no errors or loops. I can still > display the > form in Query or Submit mode. > > I copied the form to another form called "DeleteMe", > and > created a single record in the new "DeleteMe" form. > It too > hung when I tried to display the record. There is > no workflow > in "DeleteMe" so the problem must be in the form > itself. > > I deleted all the newly-created fields and it still > hung. > Then I started deleting the old fields, and it > stopped hanging. > > I went back to my original form and made a > "DeleteMe2" form. > This time I first deleted the old fields that I had > deleted > from "DeleteMe", but it still hung. Then I deleted > the > newly-created fields and it stopped hanging. > > I am totally puzzled. Any suggestions on what to > look for? > > (ARS 6.3, HPUX-11 server, Oracle 9.2 db) > > Dwayne Martin > Computing Support > James Madison University > > ________________________________________________________________________ _______ > UNSUBSCRIBE or access ARSlist Archives at > http://www.wwrug.org > __20060125_______________________This posting was > submitted with HTML in it___ > __20060125_______________________This posting was > submitted with HTML in it___ Dwayne Martin Computing Support James Madison University ________________________________________________________________________ _______ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
