Re: GPF

[Sam Spritzer <SSpritzer@GW.CTG.COM>]

Wayne...
That is exactly what we are doing here.  I am going to throw in some DEBUG statements and see if that gives me a clue.  I just wished Gates and Co. did a better job on identifying GPFs.  Thanks for your help!
Sam

<<< "Ivory, Wayne" <Wayne.Ivory@ILUKA.COM> 10/31  7:32p >>>
When I suggested running the SQR on the server, I still meant through
Citrix.  Just that you would invoke it through Citrix but the processing
would be happening on your Unix server.  If nothing else it might help you
decide if you do have a local memory problem.

Wayne Ivory
Information Services
Iluka Resources Limited


-----Original Message-----
From: Sam Spritzer [mailto:SSpritzer@GW.CTG.COM]
Sent: Friday, 29 October 1999 20:07
To: Multiple recipients of list SQR-USERS
Subject: Re: GPF


Yea, I could test off the backend but even if it works there, unfortunately,
I have to use Citrix.
I am suspecting a memory leak somewhere.
Sam

<<< "Ivory, Wayne" <Wayne.Ivory@ILUKA.COM> 10/28  4:45a >>>
Sam,

We just started using Winframe 1.7 and I think you're on the right track
about memory, but I don't think commits are necessarily going to help.  For
an experiment try getting all other (Citrix) users out and close any other
processes running on the Citrix server (eg Windows Explorer etc) and see if
it gets any further.

Also perhaps if you have a Unix back end you could try running the SQR on
the server.

HTH

Wayne Ivory
Information Services
Iluka Resources Limited


-----Original Message-----
From: Sam Spritzer [mailto:SSpritzer@GW.CTG.COM]
Sent: Wednesday, 27 October 1999 19:42
To: Multiple recipients of list SQR-USERS
Subject: GPF


Hi folks..
I have an SQR that does various selects and then an insert.  At around the
700th record (it is never the same one), I get a GPF on SQRW.EXE at address
0018:02E8 .  I am running SQR v.3.0.13.2 on an Oracle box (7.3.4) connecting
via Citrix WinFrame (v 1.7).  The WinFrame client is NT.
I suspected that it could be a memory problem so I modified the SQR to do a
commit after every 100th record.  That didn't work....same problem.  Is
there any way of telling what the GPF really means and how to go about
diagnosing it?  The select statements work fine in SQL*Plus.
Sam