Thanks, Bill, I tried SQL logging, but my form has so many fields that the log won't print them all. It goes:
*/SELECT C1,C2,C3,C4,C5,C6,C7,C8,0,C536870916,C536870927 [etc]C563000061,C5 63000062... I don't see the entire selection statement, or the results. I did look at all of my field names and none look like any Oracle reserved words, but I try checking on this further. It looks like my form is getting so big it is unworkable. I'll try breaking its functions into to smaller forms. Thanks again, Dwayne Date: Tue, 25 Apr 2006 19:02:29 -0000 From: "Baxter, Bill" <[EMAIL PROTECTED]> Add To Address Book | This is Not Spam Subject: Re: Form freezes on display To: [email protected] ** Let me restate my last suggestion. It was not a special character in the field name, the field was named something that was an Oracle reserved word. ---- Original message ---- >Date: Tue, 25 Apr 2006 18:59:54 -0000 >From: "Baxter, Bill" <[EMAIL PROTECTED]> >Subject: Re: Form freezes on display >To: [email protected] > >Another thing to look for is a special character in a field name. I had >a similar issue once where when the query was submitted the character >caused the SQL statement to error. Have you done SQL logging? > > >Bill Baxter >Senior Consultant, Service Management >Business and Systems Aligned. Business Empowered. >BearingPoint || 115 Perimeter Center Place, NE Suite 380, South Terraces >Atlanta, GA 30346 || >Office: 678.731.2750 || Mobile: 678.910.5325 >[EMAIL PROTECTED] || www.bearingpoint.com > > > > > > >________________________________ > >From: Action Request System discussion list(ARSList) >[mailto:[EMAIL PROTECTED] On Behalf Of Rick Cook >Sent: Tuesday, April 25, 2006 2:42 PM >To: [email protected] >Subject: Re: Form freezes on display > > >** >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 <[EMAIL PROTECTED]> >Sent by: "Action Request System discussion list(ARSList)" ><[email protected]> > >04/25/2006 01:26 PM >Please respond to >[email protected] > > > >To > [email protected] >cc > >Subject > Form freezes on display > > > > > > >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___ > >*************************************************************************************************** >The information in this email is confidential and may be legally privileged. Access to this email by anyone other than the intended addressee is unauthorized. If you are not the intended recipient of this message, any review, disclosure, copying, distribution, retention, or any action taken or omitted to be taken in reliance on it is prohibited and may be unlawful. If you are not the intended recipient, please reply to or forward a copy of this message to the sender and delete the message, any attachments, and any copies thereof from your system. >*************************************************************************************************** > >_______________________________________________________________________________ >UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org Dwayne Martin Computing Support James Madison University _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
