[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: Sun, 10 Sep 2006 09:45:36 -0700 (PDT)
- Delivery-date: Sun, 10 Sep 2006 12:48:17 -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=CEFn7TeZw/mf/ZLR6bdxf9lhCjAbyCfcSMtrucFLPBd42mS2ufAoFNXJYuSWpArH4tmk9FjlAfhLEkCEvVozjfL5w6p8KGEGAMBCIquDRMyjspb+e0DcmMasJ2XgvJr/gWiQ978SuEQMNgV0CWacI0Gp3VFiDrW7B6/40kwreWk=;
- 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>
...not sure how to do this..
it's an outside vendor application..
what troubles me is that it works in winnt server not in win2003 which has more
memory, space, speed etc...
I was getting an error message at first because of the sqlcon.ini. After I
copied the sqlcon.ini from the old server to the new server, I didn't get any
error messages.
I was wondering if there is a "timeout" setting in the configuration files.
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