*E* The internal buffer size limit has been exceeded
John Hunter
jthunter@nbnet.nb.ca
Wed, 28 Aug 2002 10:48:19 -0300
See Qdesign Statement Reference p 481 in your 7.10 manual
I see three options: 1) remove the cache from the primary file (don't think
you want to do this) or 2) change the occurs with primary-file to occurs 15
or 3) Get cognos to fix this 'feature'
-John
-----Original Message-----
From: powerh-l-admin@cube.swau.edu
[mailto:powerh-l-admin@cube.swau.edu]On Behalf Of Chris Sharman
Sent: August 28, 2002 8:49 AM
To: Deskin, Bob; powerh-l@lists.swau.edu
Subject: RE: *E* The internal buffer size limit has been exceeded
> -----Original Message-----
> From: Deskin, Bob [mailto:bob.deskin@cognos.com]
> Sent: 28 August 2002 12:37
> To: powerh-l@lists.swau.edu
> Subject: RE: *E* The internal buffer size limit has been exceeded
>
>
> Is there any reason for agentn to occur 255? Try with no occurs
> first, then
> possibly 15. Just to see if this is the problem.
Tried that - didn't fix the problem.
> As for temps and cache, temps that are related to a cached
> primary file are
> also cached.
Related how ? I can't put occurs with on the temp, because it comes first. I
could put it on the primary I suppose ?
Thanks, anyway.
I can live with 114 for the time being.
Now, haven't you got a beach to go to or something ?
Have a good holiday,
Chris
> Bob Deskin
> PowerHouse Web Product Manager, Application Development Tools
> Cognos Inc. 3755 Riverside Drive, Ottawa ON K1G 4K9 CANADA
> bob.deskin@cognos.com (613) 738-1338 ext 7268
>
> -----Original Message-----
> From: Chris Sharman [mailto:chris.sharman@ccagroup.co.uk]
> Sent: August 28, 2002 7:29 AM
> To: Deskin, Bob; powerh-l@lists.swau.edu
> Subject: RE: *E* The internal buffer size limit has been exceeded
>
>
>
>
> > Take a look at your temp agentn that occurs 255 versus the
> > primary file that
> > occurs 15. I'll bet things are getting confused internally. Once
> > you have a
> > repeating primary file, anything that repeats should repeat the
> > same number
> > of times. First try commenting out the temp agentn to see if
> that's it. If
> > so, try moving it to after the primary.
>
> That is a slightly eccentric construction, but agentn occurs before
> post-bucket because it's used in the access statement for the purpose of
> validating a check digit which isn't stored in the file (via lookup on
> agents), but is required for user entry.
> And temp doesn't support "cache", afaik.
>
> If there's a better way of doing that, without altering the file
> structure,
> I'd be interested.
>
> Chris
> >
> > -----Original Message-----
> > From: Chris Sharman [mailto:chris.sharman@ccagroup.co.uk]
> > Sent: August 28, 2002 6:49 AM
> > To: PowerH List
> > Subject: *E* The internal buffer size limit has been exceeded
> >
> >
> > Anyone seen this ?
> > Is there a work-around ?
> > I've seen similar messages from Quick, fixable with QKGO, but
> > this one comes
> > from QDesign ...
> > char*114 is OK.
> > post-bucket is 20 bytes, post-otherref is 12, agents is 667,
> > orders is 2565,
> > and agent-class is 12.
> >
> > VMS 7.3, Alpha, RMS, PH 7.10G3.
> >
> > Thanks,
> > Chris
> >
> > Q D E S I G N (7.10.G3)
> > Copyright 1998 COGNOS INC. (ALPHA)
> > Licensed PH-AXP-DEVELOPMENT for customer: 7053780001 CCA
> > STATIONERY LIMITED
> > 2/300
> >
> > QD> set verify error noverify delete
> > QD> screen post-bucket noaction nomode fieldmark actionbar
> > startup on line 2
> > QD> temp agentn char*6 occurs 255
> > QD> file post-bucket occurs 15 cache close
> > QD> access via agent-order-key request agentn, order-pad &
> > QD> using (order-pad*65536*65536+nconvert(agentn[1:5]))
> > QD> access via agent-key request agentn using nconvert(agentn[1:5])
> > QD> access sequential
> > QD> file post-otherref designer close
> > QD>
> > QD> def oneweek date = date(-7,sysdate)
> > QD> def pcls char*4 = "PG" if (ordcat="X") &
> > QD> else "WEDD" if (ordcat="W") &
> > QD> else "SIG" if (ordcat="S")
> > QD>
> > QD> file agents reference close
> > QD> ; access via agent-key using agent-key of post-bucket
> > QD> file orders reference close
> > QD> select if (status-flag<>104) and (oneweek<entry-time of orders)
> > QD> file agent-class reference close
> > QD> actionmenu label "Find" action find
> > QD> actionmenu label "Next" action next data
> > QD> actionmenu label "Change" action fieldmark
> > QD> actionmenu label "Commit" action update
> > QD> actionmenu label "New" action append
> > QD> actionmenu label "Delete" action delete mark
> > QD> actionmenu label "Quit" action return
> > QD>
> > QD> temp orefs char*119 occurs with post-bucket
> > *E* The internal buffer size limit has been exceeded.
> >
> >
> >
> > -----------------------------------------------------------------------
> >
> > Any views expressed in this message are those of the sender and not
> > necessarily those of CCA Group. The unauthorized use, disclosure,
> > copying or alteration of this message is forbidden. The contents of
> > this message may be confidential and/or privileged, copyright CCA Group
> > and are intended solely for the use of the individual or entity to whom
> > they are addressed. Whilst this message has been scanned, CCA Group
> > cannot guarantee that it is virus free or compatible with your systems
> > and accepts no responsibility for any loss or damage arising from its
> > use. The recipient is advised to run their own anti-virus software. If
> > you receive this message in error please contact
> > postmaster@ccagroup.co.uk immediately, destroy any copies and delete it
> > from your computer systems.
> >
> > = = = = = = = = = = = = = = = = = = = = = = = = = = = =
> > Mailing list: powerh-l@lists.swau.edu
> > Subscribe: "subscribe" in message body to
> powerh-l-request@lists.swau.edu
> > Unsubscribe: "unsubscribe" 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.
> >
> > This message may contain privileged and/or confidential
> > information. If you
> > have received this e-mail in error or are not the intended
> recipient, you
> > may not use, copy, disseminate or distribute it; do not open any
> > attachments, delete it immediately from your system and notify
> the sender
> > promptly by e-mail that you have done so. Thank you.
> >
> > = = = = = = = = = = = = = = = = = = = = = = = = = = = =
> > Mailing list: powerh-l@lists.swau.edu
> > Subscribe: "subscribe" in message body to
> powerh-l-request@lists.swau.edu
> > Unsubscribe: "unsubscribe" 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.
> > ------------------------------------------------------------------
> > --------------
> > Date: Wed, 28 Aug 2002 07:21:23 -0400
> >
>
>
>
> -----------------------------------------------------------------------
>
> Any views expressed in this message are those of the sender and not
> necessarily those of CCA Group. The unauthorized use, disclosure,
> copying or alteration of this message is forbidden. The contents of
> this message may be confidential and/or privileged, copyright CCA Group
> and are intended solely for the use of the individual or entity to whom
> they are addressed. Whilst this message has been scanned, CCA Group
> cannot guarantee that it is virus free or compatible with your systems
> and accepts no responsibility for any loss or damage arising from its
> use. The recipient is advised to run their own anti-virus software. If
> you receive this message in error please contact
> postmaster@ccagroup.co.uk immediately, destroy any copies and delete it
> from your computer systems.
>
> This message may contain privileged and/or confidential
> information. If you
> have received this e-mail in error or are not the intended recipient, you
> may not use, copy, disseminate or distribute it; do not open any
> attachments, delete it immediately from your system and notify the sender
> promptly by e-mail that you have done so. Thank you.
>
> = = = = = = = = = = = = = = = = = = = = = = = = = = = =
> Mailing list: powerh-l@lists.swau.edu
> Subscribe: "subscribe" in message body to powerh-l-request@lists.swau.edu
> Unsubscribe: "unsubscribe" 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.
> ------------------------------------------------------------------
> --------------
> Date: Wed, 28 Aug 2002 07:35:19 -0400
>
-----------------------------------------------------------------------
Any views expressed in this message are those of the sender and not
necessarily those of CCA Group. The unauthorized use, disclosure,
copying or alteration of this message is forbidden. The contents of
this message may be confidential and/or privileged, copyright CCA Group
and are intended solely for the use of the individual or entity to whom
they are addressed. Whilst this message has been scanned, CCA Group
cannot guarantee that it is virus free or compatible with your systems
and accepts no responsibility for any loss or damage arising from its
use. The recipient is advised to run their own anti-virus software. If
you receive this message in error please contact
postmaster@ccagroup.co.uk immediately, destroy any copies and delete it
from your computer systems.
= = = = = = = = = = = = = = = = = = = = = = = = = = = =
Mailing list: powerh-l@lists.swau.edu
Subscribe: "subscribe" in message body to powerh-l-request@lists.swau.edu
Unsubscribe: "unsubscribe" 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.