[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: "Don Mellen" <donm@ontko.com>
Date: Thu, 1 Nov 2007 12:48:15 -0400
Delivery-date: Thu, 01 Nov 2007 12:50:38 -0400
In-reply-to: <011B450E3C26C043B444BC6D2FCC81B1C94D00@FFX-INF-EX-V1.cgifederal.com>
List-id: "This list is for discussion about the SQR database reportinglanguage from Hyperion Solutions." <sqr-users.sqrug.org>
References: <d0d6f760710311320g23fa727eg9bc5192a8246a1b9@mail.gmail.com><011B450E3C26C043B444BC6D2FCC81B1C94D00@FFX-INF-EX-V1.cgifederal.com>

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

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>

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