[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index]
[Date Index]
[Thread Index]
[SQR-USERS Info]
[SQRUG Home Page]
Re: [sqr-users] sqr not responding
- Subject: Re: [sqr-users] sqr not responding
- From: curiosity5 <curiosity5@yahoo.com>
- Date: Mon, 11 Sep 2006 11:12:36 -0700 (PDT)
- Delivery-date: Mon, 11 Sep 2006 14:15:29 -0400
- Domainkey-signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com;h=Message-ID:Received:Date:From:Subject:To:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding;b=kBAP3Qggdb2rT1VBM6QIebfgMID0+fI/bVyxaM0SdkpUUf2gh6XeWPqWmm58imgWBijIvlysE7DVQR/+l5RnEXIwqryOn9oWJjTQ/h12voGz84aUdFhx54SMmwLKCHhDnXL7JVAj59vMaSB71/ewfCR+bWoeJAWKCSxtBjGgNoc=;
- In-reply-to: <s5040503.030@gwia203.syr.edu>
- List-id: "This list is for discussion about the SQR database reportinglanguage from Hyperion Solutions." <sqr-users.sqrug.org>
I tried to run the same sqr report using another database and it stopped
responding after creating 10 log files. I also tried to run the same report
knowing that there are no records in the database with the same criterias
selected except for one and it also stopped responding and no log files have
created. How do I view the .sqt, run it and debug it?
Larry Roux <lroux@syr.edu> wrote:
Try adding some display statements to see where it is hanging. I
suspect it is hitting some SQL that is taking too long to respond and
there is a timeout occurring.
Larry Roux
Information Systems
Syracuse University
lroux@syr.edu
>>> curiosity5@yahoo.com 09/10/06 11:21 AM >>>
My db is sqlbase 6.1. I moved my databases from winnt server to win2003
server. I was able to log into the application and run small
sqr/crystal reports in both servers. Client is winxp. The application
allows user to select certain criterias to run an sqr report. It works
when one of the criteria is selected or left blank in winnt. When all
fields or criterias are left blank, it creates a huge report and takes
more than 10 minutes. The sqr creates ~100 log files in the same
location as the database. When I tried to run it in win2003 server with
the criterias left blank, it created ~50 log files and the sqr stop
responding..no error messages...waited for 2 hours. First time I ran it
in win2003,it has "bad return fetching row" and I couldn't connect to
the database. I tested it again by copying the database and log files
from the old server to the new server. This time it didn't give me any
error message, sqr stopped responding, ~50 log files created (should be
about 100).
HELP!
_______________________________________________
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