Re: FRM-99999 error when running web-enabled forms

Don't you just LOVE NT. We were having a similar problem. Finally after months, it seemed to relate to users abnormally ending their Netscape/Oracle session....as in Control/Alt/Delete. The NT machine would have these runaway 'ZOMBIE' sessions that caused memory problems. At first we would reboot the server and everything was fine. Finally we killed the processes one by one. When we killed the offending process that caused the constipation, the other processes would finish up(sometimes sitting there for many hour). I am not sure that it is the same problem, but after working for months with Oracle on this we no longer have the problem.

We changed the FORMS50_TIMEOUT key from a string to a DWORD with a value of 3. Oracle did not state that it definitely make a difference but according to their documentation, it should be a DWORD and the value should not be less than 3 (minutes). Don't know if that fixed it. The only other thing is that I finally won on having the NT machines reboot every Sunday. (I tried for every day because NT is such junk when it comes to memory issues.) All I know is we have been fine for months now instead of having a problem every couple of weeks. Oracle said they had this particular problem but that it had been fixed in the version we were running, NOT!

rq

Ric Sullivan wrote:

> We are encountering the FRM-99999 error when running web-enabled
> forms. We have 4 NT boxes behind a load balancer that serve up our
> web-enabled Forms to client machines running Netscape 4.5 or IE 5.0.
> The servers will run without error for 2-3 weeks and then suddenly we
> are unable to run the web-forms from one of them. Each server
> encounters the same problem after running without reboot for extended
> period of time.
>
> After we identify the problem machine, we look in Task Manager from NT
> and notice nothing unusual in terms of memory resources being
> consumed. What we do find unusual is that while in Task Manager, if
> we look at the Processes that are running, there will be many
> F50WEB32.EXE processes that cannot be killed using the “End Process”
> button. The only way we’ve found they can be killed is by rebooting
> the machine.
>
> Another unusual thing about these “errant” processes is that they are
> very small in size (about 200K) in comparison to a normal process
> running the web-enabled forms (approx. 15,000-35,000K). This symptom
> is found consistently on a box that is producing the FRM-99999 error.
> Typical of NT, rebooting the machine consistently corrects the
> problem.
>
> We are running the following configuration and have tested on other
> machines as well, always with the same result over time:
>
> Oracle Forms 5.0
> Jinitiator 1.1.5.21
> Windows NT 4.0
> Service Pack (tried 3.0 through 5.0 with no success)
> Oracle Database Enterprise Server 8.0.5.1
> Netscape Enterprise Server 3.6
> Netscape Administration Server 3.5
>
> Any advice will be greatly appreciated.
>
> Ric
>
> Ric_Sullivan_at_Harvard.edu
>
>
> Ric Sullivan, Practice Manager, Grants Management
> Harvard University, Financial Administration
> Office of Administrative Systems
>
> 619 Holyoke Center Email:
> Ric_Sullivan_at_Harvard.edu
> 1350 Massachusetts Avenue Voice: 617.496.8721
> Cambridge, MA 02138 Fax: 617.496.8883
Received on Mon Dec 06 1999 - 20:19:11 CET