[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index] [Date Index] [Thread Index]
[SQR-USERS Info] [SQRUG Home Page]

RE: [sqr-users] Problem with Version 613 running/compiling report

Subject: RE: [sqr-users] Problem with Version 613 running/compiling report
From: "RITTER, Philippe" <philippe.ritter@caisse-des-medecins.ch>
Date: Thu, 1 Nov 2007 19:02:21 +0100
Delivery-date: Thu, 01 Nov 2007 14:05:34 -0400
List-id: "This list is for discussion about the SQR database reportinglanguage from Hyperion Solutions." <sqr-users.sqrug.org>
References: <d0d6f760711010948i174d9b7avcd8f214befe1377d@mail.gmail.com><011B450E3C26C043B444BC6D2FCC81B1C94E34@FFX-INF-EX-V1.cgifederal.com><d0d6f760711011047v53ba9ee9n4dd801045f9be9b0@mail.gmail.com>
Thread-index: Acgcr3tMHNSD+r73Q/2jBy8GV50dBQAAa6bA
Thread-topic: [sqr-users] Problem with Version 613 running/compiling report

Hello,

We got the same problem. We are running SQR on Unix, but we edit the program 
from Windows. What we did to correct this program was to :

Run an unix2dos utilies and then back with dos2unix. After that, the program 
run correctly

Regards
Philippe RITTER

-----Message d'origine-----
De : sqr-users-bounces+philippe.ritter=caisse-des-medecins.ch@sqrug.org 
[mailto:sqr-users-bounces+philippe.ritter=caisse-des-medecins.ch@sqrug.org] De 
la part de Don Mellen
Envoyé : jeudi 1 novembre 2007 18:48
À : This list is for discussion about the SQR database reporting languagefrom 
Hyperion Solutions.
Objet : Re: [sqr-users] Problem with Version 613 running/compiling report

Are you running from the DOS prompt or through an app?  (I was originally
thinking from the DOS prompt)

If from DOS prompt, are you fully pathing the sqrw exe?

Can you run a simple program from 613, i.e.

Begin-Program
  show 'Hello'
End-Program


On 11/1/07, Eric Miller <Eric.Miller@cgifederal.com> wrote:
>
> Still no luck.
>
> I dropped a sqr.ini file in the sqrw.exe directory and made sure the max
> value were set.
>
> I then used the -ZIF flag to point specifically to that file in that
> directory.
>
> Any other ideas?
>
>
> Thanks,
> Eric
>
>
> -----Original Message-----
> From: sqr-users-bounces+eric.miller=cgifederal.com@sqrug.org
> [mailto:sqr-users-bounces+eric.miller=cgifederal.com@sqrug.org] On
> Behalf Of Don Mellen
> Sent: Thursday, November 01, 2007 12:48 PM
> To: This list is for discussion about the SQR database reporting
> languagefrom Hyperion Solutions.
> Subject: Re: [sqr-users] Problem with Version 613 running/compiling
> report
>
> I'd try making a copy of the .ini and put it in the same directory as
> the
> 613 SQRW.exe, then edit it to point to 613 directories.
>
> On 11/1/07, Eric Miller <Eric.Miller@cgifederal.com> wrote:
> >
> > Thanks for the reply Don.
> >
> > I tried an "allmax" file and it still throws the same error.
> >
> > I just checked, and there aren't any SQR related environment variables
> > set.
> >
> > Should I try creating a SQR.INI in the same directory as the 613
> > SQRW.exe ? Or modify the one in my windows directory?
> >
> > Thanks.
> >
> > -----Original Message-----
> > From: sqr-users-bounces+eric.miller=cgifederal.com@sqrug.org
> > [mailto:sqr-users-bounces+eric.miller=cgifederal.com@sqrug.org] On
> > Behalf Of Don Mellen
> > Sent: Wednesday, October 31, 2007 4:21 PM
> > To: This list is for discussion about the SQR database reporting
> > languagefrom Hyperion Solutions.
> > Subject: Re: [sqr-users] Problem with Version 613 running/compiling
> > report
> >
> > Hmmmm.
> >
> > I'm assuming this is a large program (counting included files) and
> that
> > it
> > not only runs in ver 8+ but returns appropriate results.
> >
> > Next I'd try an "allmax" -M file (max out everything).  If that works
> > with
> > 6.1.3, then remove items one at a time till you find the culprit.
> >
> > If it doesn't, make sure you do have an sqr.ini that points to 6.1.3
> > stuff,
> > especially for the value of SQRDIR (make one if needed) and that it's
> in
> > the
> > right place, or use the -ZIF flag.  And double check environment
> > variables
> > for any SQR type stuff (also look at "path").
> >
> > That's pretty much all I got off the top of my head.
> >
> >
> > On 10/31/07, Eric Miller <Eric.Miller@cgifederal.com> wrote:
> > >
> > > I set PROGLINES=32767 and it still gives me:
> > >
> > > (SQR 4401) Out of param storage; use -Mfile to increase
> PROGLINEPARS.
> > > SQR: Program Aborting.
> > >
> > >
> > >
> > >
> > > -----Original Message-----
> > > From: sqr-users-bounces+eric.miller=cgifederal.com@sqrug.org
> > > [mailto: sqr-users-bounces+eric.miller=cgifederal.com@sqrug.org] On
> > > Behalf Of Don Mellen
> > > Sent: Wednesday, October 31, 2007 2:55 PM
> > > To: This list is for discussion about the SQR database reporting
> > > languagefrom Hyperion Solutions.
> > > Subject: Re: [sqr-users] Problem with Version 613 running/compiling
> > > report
> > >
> > > Well, I would have expected the error message to switch to PROGLINES
> > > instead
> > > of PROGLINEPARS, but for S.A.G. try upping the PROGLINES next.
> > >
> > > On 10/31/07, Eric Miller <Eric.Miller@cgifederal.com> wrote:
> > > >
> > > > Thanks for the info Don.
> > > >
> > > > We are using the -M(filename) and I have put the max
> > > > value(PROGLINEPARS=65535) in there and it still throws the same
> > error.
> > > > If I increase it to PROGLINEPARS=65536 it will complain about the
> > max
> > > > being 65535 so it seems like it is at least using the -M(file)
> > > >
> > > > I can run the -M flag using 832 with PROGLINEPARS=18000(default)
> and
> > > it
> > > > will process successfully. That is what has me so confused with
> > this.
> > > >
> > > > Any other ideas?
> > > >
> > > >
> > > > Thanks again.
> > > >
> > > >
> > > > -----Original Message-----
> > > > From: sqr-users-bounces+eric.miller=cgifederal.com@sqrug.org
> > > > [mailto: sqr-users-bounces+eric.miller=cgifederal.com@sqrug.org]
> On
> > > > Behalf Of Don Mellen
> > > > Sent: Wednesday, October 31, 2007 1:33 PM
> > > > To: This list is for discussion about the SQR database reporting
> > > > languagefrom Hyperion Solutions.
> > > > Subject: Re: [sqr-users] Problem with Version 613
> running/compiling
> > > > report
> > > >
> > > > The way these versions handle processing limits
> ("Processing-Limits"
> > > in
> > > > the
> > > > ini) is that prior to 8.0, SQR would "cap" things at wherever
> limits
> > > > were
> > > > set.  In 8.0 and above, they start at those limits, but will
> > increase
> > > > themselves "on-the-fly" up to the architectural limit.
> > > >
> > > > Did you try to use an -M{filename} flag on the command line, or
> did
> > > you
> > > > just
> > > > try to change the .ini file?
> > > >
> > > > If you haven't, try making a processing limits override file that
> > sets
> > > > PROGLINEPARS=65535 and use the -M{filename} flag on the command
> line
> > > for
> > > > the
> > > > 613 version.  If that works, then you know that it was not finding
> > > > whatever
> > > > file you changed (plus you know that your code works in that
> version
> > > and
> > > > the
> > > > error was accurate).
> > > >
> > > > The order of where SQR looks for the SQR.INI file is...
> > > > 1. The file name specified by the -ZIF{file} command-line flag.
> > > > 2. The directory where the executable image resides.
> > > > 3. The Windows system directory.
> > > >
> > > > HTH,
> > > > Don
> > > >
> > > >
> > > > On 10/31/07, Eric Miller <Eric.Miller@cgifederal.com> wrote:
> > > > >
> > > > > I am not sure. There is a SQR.INI file in the C:\Windows\
> > directory
> > > > > (which points to the 832 install), then there are sqr_en.ini
> files
> > > in
> > > > > the individual directories for 832 and 820 but NOT 613.
> > > > >
> > > > > Will 613 just be trying to see what's in C:\Windows\SQR.INI and
> > > since
> > > > > that has data inside it pointing to the 832 install, it doesn't
> > know
> > > > > what to do?
> > > > >
> > > > > Thanks for the Reply.
> > > > >
> > > > >
> > > > >
> > > > > -----Original Message-----
> > > > > From: sqr-users-bounces+eric.miller=cgifederal.com@sqrug.org
> > > > > [mailto: sqr-users-bounces+eric.miller=cgifederal.com@sqrug.org]
> > On
> > > > > Behalf Of Knapp, Richard
> > > > > Sent: Wednesday, October 31, 2007 12:32 PM
> > > > > To: This list is for discussion about the SQR database
> > > > reportinglanguage
> > > > > fromHyperion Solutions.
> > > > > Subject: RE: [sqr-users] Problem with Version 613
> > running/compiling
> > > > > report
> > > > >
> > > > >
> > > > > Are you sure it is finding the init file with the new value?
> > > > >
> > > > > Richard Knapp
> > > > > EAS - Data Warehouse Group
> > > > > University of Missouri
> > > > > 615 Locust Street  #200
> > > > > Columbia, MO 65201
> > > > > 573-882-8856
> > > > > knappr@umsystem.edu
> > > > >
> > > > >
> > > > > -----Original Message-----
> > > > > From: sqr-users-bounces+knappr= umsystem.edu@sqrug.org
> > > > > [mailto:sqr-users-bounces+knappr=umsystem.edu@sqrug.org] On
> Behalf
> > > Of
> > > > > Eric Miller
> > > > > Sent: Wednesday, October 31, 2007 11:24 AM
> > > > > To: sqr-users@sqrug.org
> > > > > Subject: [sqr-users] Problem with Version 613 running/compiling
> > > report
> > > > >
> > > > > Hello All,
> > > > > We are encountering a problem when running one of our SQR files
> > with
> > > > > version 6.1.3. It is throwing an error saying the following:
> > > > >
> > > > > (SQR 4401) Out of param storage; use -Mfile to increase
> > > PROGLINEPARS.
> > > > > SQR: Program Aborting.
> > > > >
> > > > > I have searched the archive and read the articles related to
> this,
> > > but
> > > > > none seem to solve my problem.
> > > > >
> > > > > I have increased this variable to its max value and the error is
> > > still
> > > > > thrown.
> > > > >
> > > > > If I run it with the original value using versions 820 or 832 it
> > > will
> > > > > run fine.
> > > > >
> > > > > Is there any difference in configuration or anything for 613?
> Our
> > > > > problem seems to be specific to that version for some reason.
> > > > >
> > > > > Thanks in advance for the help,
> > > > > Eric
> > > > >
> > > > >
> > > > > _______________________________________________
> > > > > 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
> > > > >
> > > >
> > > >
> > > >
> > > > --
> > > >
> > >
> >
> -----------------------------------------------------------------------
> > > > Donald Mellen  | Ray Ontko & Co. - Richmond, IN -
> > > http://www.ontko.com/
> > > > donm@ontko.com  |  "In the beginning, there was nothing, which
> > > exploded"
> > > > (Terry Pratchett)
> > > >
> > > > _______________________________________________
> > > > 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
> > > >
> > >
> > >
> > >
> > > --
> > >
> >
> -----------------------------------------------------------------------
> > > Donald Mellen  | Ray Ontko & Co. - Richmond, IN -
> > http://www.ontko.com/
> > > donm@ontko.com  |  "In the beginning, there was nothing, which
> > exploded"
> > > (Terry Pratchett)
> > >
> > > _______________________________________________
> > > 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
> > >
> >
> >
> >
> > --
> >
> -----------------------------------------------------------------------
> > Donald Mellen  | Ray Ontko & Co. - Richmond, IN -
> http://www.ontko.com/
> > donm@ontko.com  |  "In the beginning, there was nothing, which
> exploded"
> > (Terry Pratchett)
> >
> > _______________________________________________
> > 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
> >
>
>
>
> --
> -----------------------------------------------------------------------
> Donald Mellen  | Ray Ontko & Co. - Richmond, IN - http://www.ontko.com/
> donm@ontko.com  |  "In the beginning, there was nothing, which exploded"
> (Terry Pratchett)
>
> _______________________________________________
> 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
>



-- 
-----------------------------------------------------------------------
Donald Mellen  | Ray Ontko & Co. - Richmond, IN - http://www.ontko.com/
donm@ontko.com  |  "In the beginning, there was nothing, which exploded"
(Terry Pratchett)

_______________________________________________
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

Follow-Ups:
- RE: [sqr-users] Problem with Version 613 running/compiling report
  - From: "Eric Miller" <Eric.Miller@cgifederal.com>

References:
- Re: [sqr-users] Problem with Version 613 running/compiling report
  - From: "Don Mellen" <donm@ontko.com>
- RE: [sqr-users] Problem with Version 613 running/compiling report
  - From: "Eric Miller" <Eric.Miller@cgifederal.com>
- Re: [sqr-users] Problem with Version 613 running/compiling report
  - From: "Don Mellen" <donm@ontko.com>

Prev by Date: RE: [sqr-users] Problem with Version 613 running/compiling report
Next by Date: RE: [sqr-users] Problem with Version 613 running/compiling report
Previous by thread: RE: [sqr-users] Problem with Version 613 running/compiling report
Next by thread: RE: [sqr-users] Problem with Version 613 running/compiling report
Indexes: [ Thread] [ Author] [ Date]
SQR-USERS List and Archive Info
SQRUG Home Page