Unrelated to 'use statements' I hit some type of MAX or something

[Darren Reely]

Nancy,

Six footings should work. I have reports with 4, 5, 6 and even 7 
footings. This is under PH 8.23.D7 on Solaris and Oracle.

Break down the problem. First limit the number of records you fetch to 
say 1000 or less. Comment out all but one footing to see if a particular 
footing is causing the problem. Repeat 6 times.

Powerhouse can give misleading errors. Stop panicing every time you have 
a problem. More often than not, it is programmer error or lack of 
knowledge that must be learned.

Darren.


Nancy Tietz wrote:

>Dear ListServer,
>Below is a further problem this programmer is having with the same Quiz on
>which Robert Mills assisted.
>
>(By the way, the USE STD1.use file was approx. 200 lines long to get a 14
>line footer, and it was needed in 6 footing at's.)
>
>Now, some sort of MAX has been reached.  The old program that worked had 4
>sort items and only 1 footer line.  The new program needs to have 6 sort
>items and 6 footing at statements.  Each of those footing at stmt's has this
>200 line temp 'use' file in it.  There is only 1 file being accessed at the
>top.
>
>Result:  It stops printing in the middle of a footer and gives this message:
> *Fatal Error* *45* Notify Cognos Customer Support
>
>Also, if 1 footing line is removed, it does work.  However all 6 footing at
>stmt's are necessary.  See below for what all else we tried.
>
>Thank you for your kind help.  
>Nancy 
>
>-----Original Message-----
>From: Derrick Tietz [mailto:DTietz@msxi.com]
>Sent: Monday, May 19, 2003 10:33 AM
>To: ntietz@MCARE.MED.UMICH.EDU
>Subject: RE: Unrelated to 'use statements' I hit some type of MAX or
>something
>
>
>Do you have time to pose this question to the list server? The quizscr=
>and quizsort = has not helped.
> *Fatal Error* *45* Notify Cognos Customer Support
>
>I have 6 sorts 6 footings. Each footing has 10 lines and 13 columns.
>It runs without error with any variation of 3 footings but not 4
>footings. It stops in the middle of one of the footings (not a
>particular one).
>
>
>
>
>
>  
>
>>>>Nancy Tietz <ntietz@MCARE.MED.UMICH.EDU> 05/16/03 01:43PM >>>
>>>>        
>>>>
>also try
>file quizscr;disc=90000   or some number
>
>this is the file equate for the quiz scratch file... I hope I have the
>right
>name there.
>nt
>
>-----Original Message-----
>From: Nancy Tietz 
>Sent: Friday, May 16, 2003 1:37 PM
>To: 'Derrick Tietz'
>Subject: RE: Unrelated to 'use statements' I hit some type of MAX or
>something
>
>
>no I don't know what to do.  It must be a very big quiz program.  Lots
>of
>linkages and define statements etc. ?  Are you sure it isn't a Sort
>issue? 
>try this before quiz runs:
>file quizsort;disc=90000
>or adjust the size
>nt
>
>
>-----Original Message-----
>From: Derrick Tietz [mailto:DTietz@msxi.com] 
>Sent: Friday, May 16, 2003 1:30 PM
>To: ntietz@MCARE.MED.UMICH.EDU 
>Subject: Unrelated to 'use statements' I hit some type of MAX or
>something
>
>
>Unrelated to 'use statements' I hit some type of MAX or something
> *Fatal Error* *45* Notify Cognos Customer Support
>
>I kept adding footings at different sorts. I have 6 sorts 6 footings.
>I
>took out the use and got the same error. Have you ever got this? It
>stops in the middle of one of the footings.
>
>Derrick Tietz
>Oracle Developer (OCP)
>= = = = = = = = = = = = = = = = = = = = = = = = = = = =
>Mailing list: powerh-l@lists.swau.edu
>Subscribe: "subscribe" in message body to powerh-l-request@lists.swau.edu
>Unsubscribe: "unsubscribe <password>" in message body to powerh-l-request@lists.swau.edu
>http://lists.swau.edu/mailman/listinfo/powerh-l
>This list is closed, thus to post to the list you must be a subscriber.
>  
>