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

["Eric Miller" <Eric.Miller@cgifederal.com>]

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