I have a table on the form that displays entries from GN:CallEntry, our main call-tracking form. The selection criteria is "EXTERNAL( $Find Entries Entry list$)", which means, Go to "Find Entries Entry list" and get the selection criteria.
I had an active link that was supposed to set "Find Entries Entry list" to "Entry ID = $NULL$" on display of a record. Since no Entry ID can be null the table will be empty on display. Something happened to that active link, and since I am the only Remedy developer around here it had to have been my mistake. Anyway, without that active link, the table was trying to load all 50,000 GN:CallEntries. Thanks to all who replied, Dwayne ---- Original message ---- >Date: Fri, 19 Jan 2007 14:48:41 -0600 >From: "Opela, Gary L Contr OC-ALC/ITMA" <[EMAIL PROTECTED]> >Subject: Re: Form hangs on display >To: [email protected] > >Dwayne, you are not doing any remote database calls to your test server on >window display/open/loaded are you? > >Just a thought, if your test box was trusted with the database and your >production box was not, and you tried to pull data, I would expect you to >get an error, but it sounds like something with a database connection >somewhere has you all horked up. > >-----Original Message----- >From: Action Request System discussion list(ARSList) >[mailto:[EMAIL PROTECTED] On Behalf Of Dwayne Martin >Sent: Friday, January 19, 2007 12:10 PM >To: [email protected] >Subject: Re: Form hangs on display > >Thanks, Mike. I did try that, but it didn't help. > >Since sending my email I found that the problem affects all >users, not just me. > >Also I copied the form to a new form called "GN:DeleteMe", and >that form does the same thing. You can display it in search >mode, and submit a new entry, but as soon as you try to >display an existing entry it hangs. > >If you try to access the record from the web (Mid-Tier), the >pages on the page field are all overlapped, and the only >fields that display are those common to all pages. A message >says, "Error while parsing the qualifier (Error Code 5): Error >position: 13 (Arerror 10000)." The browser hangs and you have >to use the task manager to kill it. This happens with both >Mozilla and IE. > >Another wierd thing. I exported the form definition and >imported it into our test environment and it displays OK. So >I deleted the form from our live system and reimported it, but >it still doesn't display in our live system. I don't know of >any difference between the two systems, but there must be one >somewhere. > >Thanks again, >Dwayne > > > >---- Original message ---- >>Date: Fri, 19 Jan 2007 08:58:30 -0500 >>From: Mike White <[EMAIL PROTECTED]> >>Subject: Re: Form hangs on display >>To: [email protected] >> >> >>You could clear your pc cache to see if it helps. The >symptom doesn't >>exactly fit, but it's quick and easy enought to try. >> >>Mike White >>Office: 813-978-2192 >>E-mail: [EMAIL PROTECTED] >> >> >> > >> "Dwayne Martin" > >> <[EMAIL PROTECTED] To: >[email protected] > >> > cc: > >> Sent by: "Action Subject: Form >hangs on display >> Request System > >> discussion > >> list(ARSList)" > >> <[EMAIL PROTECTED] > >> ORG> > >> > >> > >> 01/18/2007 15:39 > >> Please respond to > >> arslist > >> > >> > >> >> >> >> >>Hi everyone, >> >>I have a form with a single entry. I added a field to the >>form, and changed a little bit of workflow. Suddenly the form >>started hanging whenever I tried to display that single entry. >> It displays fine in Search mode, but as soon as I try to do >>the search it hangs. It also hangs if I try to open the entry >>via workflow. >> >>I removed the field and put the workflow back the way it was >>but it doesn't help. I disabled all filters and active links >>that fire on display, so now the logs show nothing, but it >>still hangs. The api log shows the call to open the form, and >>so does the sql log, but neither show anything wrong. >> >>Any idea of what to look for? (I'll appreciate anyone's help. >> I need to write a report based on info that the form gathers.) >> >>(ARS 6.3, HPUX-11 server, Oracle 9.2 db) >> >>Dwayne Martin >>Computing Support >>James Madison University >> > >Dwayne Martin >Computing Support >James Madison University > >_______________________________________________________________________________ >UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are" Dwayne Martin Computing Support James Madison University _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
