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

["Peter Burton" <peter.burton@oracle.com>]

Eric,

SQR versions 8.3 and above really ignore the -Mfile and/or the SQR.INI 
[Processing-Limit] values.  They are used as the basis for the initial memory 
allocations only.  As the SQR program is compiled more memory is consumed.  
When the current structure allocations are exhausted then are then expanded 
until the architectual limit is hit or memory is exhausted.

Versions of SQR prioer to 8.3 had changes made to how much memory was allocated 
in different areans and how it is ued so it is possible that a report works in 
8.2 but not in 6.1.3.

Peter

-----Original Message-----
From: sqr-users-bounces+peter.burton=oracle.com@sqrug.org 
[mailto:sqr-users-bounces+peter.burton=oracle.com@sqrug.org] On Behalf Of Eric 
Miller
Sent: Wednesday, October 31, 2007 2:29 PM
To: This list is for discussion about the SQR database reportinglanguage from 
Hyperion Solutions.
Subject: RE: [sqr-users] Problem with Version 613 running/compiling report

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


_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users