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
