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

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

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