[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index]
[Date Index]
[Thread Index]
[SQR-USERS Info]
[SQRUG Home Page]
RE: [sqr-users] SQRW not responding?????
Responding to the: Why do you press "Ctrl-Alt-Del?"
I have a Windows 98 desktop and when I do a"Ctrl-Alt-Del" , the task
manager window comes up. It tells which applications are running. And I do
this to check SQRW and it says SQRW is not responding. Before I do this the
prompt box comes up for me to put in my parameters? I put them in. Then
the SQRW prompt is on the task bar. I thought the SQR was taking too long.
So I did the "Ctrl-Alt-Del" to see if SQRW was responding.
Responding to the : When you say a different SQR works, do you mean
Ctrl-Alt-Del works or the SQR program performs its task
successfully?
The SQR I am trying to run is SRES2019.sqr. I am running it against
datasource (Database) FSCLN, Username dbaprd.
Then I decided to run another sqr SSS2034.sqr against the same
Database, Username and password: datasource (Database) FSCLN, Username
dbaprd. I did this to see if possibly it was a problem with the Database,
my username or password.
Also: Where is the best place to put some display statements in
the SQR?
Thanks Ken
From: "Alexander, Steve" <Steven.Alexander@sanjoseca.gov> on
10/29/2003 05:18 PM
Please respond to sqr-users@sqrug.org@SMTP@Exchange
To: sqr-users@sqrug.org@SMTP@Exchange
cc:
Subject: RE: [sqr-users] SQRW not responding?????
If the problem is in the compiler or the operating system, changing
from
desktop to server might help. If the problem is slow database
access, being
on the server will speed that up, but going from 1000 hours to 100
hours
won't help enough. I'd start by assuming that the problem is in my
SQR
program and use some display statements.
I just reread your original message, Ken, and it suddenly hit me how
little
information you gave us. Why do you press "Ctrl-Alt-Del?" We've
assumed
it's because you're not getting any signs of life from your program.
Is
that it or do you just want to interrupt your program? If you're
getting no
signs of life, do you mean you get something then nothing further,
or you
get nothing at all? When you say a different SQR works, do you mean
Ctrl-Alt-Del works or the SQR program performs its task
successfully?
-----Original Message-----
From: Katchur, Ken DCRE [mailto:KKatchur@dcre.gov.sk.ca]
Sent: Wednesday, October 29, 2003 2:08 PM
To: sqr-users@sqrug.org
Subject: RE: [sqr-users] SQRW not responding?????
I am running this from my workstation desktop (client).
Would it
make a difference if it was run through the server?
Thanks Ken
From: "Alexander, Steve" <Steven.Alexander@sanjoseca.gov>
on
10/29/2003 03:21 PM
Please respond to sqr-users@sqrug.org@SMTP@Exchange
To: sqr-users@sqrug.org@SMTP@Exchange
cc:
Subject: RE: [sqr-users] SQRW not responding?????
This could also be an infinite loop. In general, I'd insert
show or
display
statements throughout the program; "show 1", "show 2", etc.
See
which ones
appear in the SQRw window. That will tell you how far your
program
got, and
let you focus on the code that is hanging up.
-----Original Message-----
From: Larry Roux [mailto:LRoux@syr.edu]
Sent: Wednesday, October 29, 2003 12:46 PM
To: sqr-users@sqrug.org
Subject: RE: [sqr-users] SQRW not responding?????
This sounds like a runaway select still. If you do not have
a
display then
the spf would not get built.
Try having your DBA look to see what the process is doing
while the
job is
running. My guess is that it is sticking on one statement.
Your
machine
would lock up due to the large result set filling up memory.
******************************
Larry Roux
Syracuse University
lroux@syr.edu
*******************************
>>> KKatchur@dcre.gov.sk.ca 10/29/03 02:43PM >>>
Th .spf file never gets built. The one from
yesterday is
still
there from when I ran the same SQR against another database.
I have
to a
end task to end the SQRW. And sometimes that does not work
and my
workstation locks up and I have to do a hard re-boot.
Thanks Ken
From: "Sahani, Dev" <Dev.Sahani@FMR.COM> on
10/29/2003
11:46 AM
Please respond to sqr-users@sqrug.org@SMTP@Exchange
To: sqr-users@sqrug.org@SMTP@Exchange
cc:
Subject: RE: [sqr-users] SQRW not
responding?????
And if that's happening, you will notice this .spf
file (in
the
folder that
you are executing the job from) growing in size till
the
point that
you kill
the job
-Dev Rishi Sahani
__________________________
FESCo DB Systems -- Development
Fidelity Investments
-----Original Message-----
From: Larry Roux [mailto:LRoux@syr.edu]
Sent: Wednesday, October 29, 2003 12:36 PM
To: KKatchur@dcre.gov.sk.ca; sqr-users@sqrug.org
Subject: Re: [sqr-users] SQRW not responding?????
Could there be a run-away select statement? I would
think
that if
you have
a cartesian join somewhere you might see that
happen.
******************************
Larry Roux
Syracuse University
lroux@syr.edu
*******************************
>>> KKatchur@dcre.gov.sk.ca 10/29/03 12:17PM >>>
I am running a SQR through SQRW on my desktop and
when I do
a
Crtl+Alt+delete it says SQRW is not responding.
When I run a different SQR with the same database
and
username it
works! Any
help would be appreciated.
Thanks in
advance
Ken
_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users
_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users
_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users
_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users
_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users
_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users
_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users
_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users
_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users