Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] Infinite loop?
Go
New
Search
Notify
Tools
Reply
  
[SOLVED] Infinite loop?
 Login/Join
 
Gold member
posted
I have the following two graphs in the same procedure. If I comment one of them out, the other one runs fine. However, if I run both of them at the same time, I get IBIF_max_messages error. Can someone tell me what I am doing wrong here. Thanks.


SET HOLDLIST=PRINTONLY
SET ASNAMES=ON
-SET &RANDOM=EDIT(&TOD,'99$99$99');
-SET &CURRENTMN=EDIT(&YYMD,'$$$$99');
-SET &CURENTYR = EDIT(&YYMD, '9999$$');
-SET &STARTYR12 = &SYEAR -1;
-SET &STARTYRMN12 = &STARTYR12 || &SMONTH;


TABLE FILE CACHE_REGION_SALES_BY_COSTCENTER_MONTH_TEST_3
SUM MAX.ACC_PER2
BY ACC_PER1 NOPRINT
WHERE ACC_PER1 GE '&STARTYRMN12' AND IDCSTS EQ '&COSTCENTERDRILL'
ON TABLE SAVE
END
-RUN

-SET &CNTR=0;
-RUN

-SET &MAXVALUES=&LINES;

-MRNOEDIT BEGIN

GRAPH FILE CACHE_REGION_SALES_BY_COSTCENTER_MONTH_TEST_3
SUM CC_CURRENTYTD_SALES AS 'Sales $'
WHERE ACC_PER1 GE '&STARTYRMN12'
ACROSS ACC_PER2 AS 'Accounting Period'
COLUMNS
-READMORE
-READ SAVE &ACC_PER2.A12. NOCLOSE
-IF &IORETURN NE 0 GOTO DONE;
-SET &CNTR=&CNTR +1;
-SET &ANDCOLUMN.&CNTR= IF &CNTR EQ &MAXVALUES THEN '''&ACC_PER2.EVAL'''
-ELSE '''&ACC_PER2.EVAL''' || (' AND') ;
&ANDCOLUMN.&CNTR
-GOTO READMORE
-DONE


ON GRAPH HOLD AS GRAPHE FORMAT HTMTABLE
......
..........



SET HOLDLIST=PRINTONLY
SET ASNAMES=ON
-SET &RANDOM=EDIT(&TOD,'99$99$99');
-SET &CURRENTMN=EDIT(&YYMD,'$$$$99');
-SET &CURENTYR = EDIT(&YYMD, '9999$$');
-SET &STARTYR12 = &SYEAR -1;
-SET &STARTYRMN12 = &STARTYR12 || &SMONTH;


TABLE FILE CACHE_REGION_SALES_BY_COSTCENTER_MONTH_TEST_3
SUM MAX.ACC_PER2
BY ACC_PER1 NOPRINT
WHERE ACC_PER1 GE '&STARTYRMN12' AND IDCSTS EQ '&COSTCENTERDRILL'
ON TABLE SAVE
END
-RUN

-SET &CNTRA=0;
-RUN

-SET &MAXVALUESA=&LINES;

-MRNOEDIT BEGIN

GRAPH FILE CACHE_REGION_SALES_BY_COSTCENTER_MONTH_TEST_3
SUM CC_GROSS_MARGIN_YTD AS 'GP MTD'
WHERE ACC_PER1 GE '&STARTYRMN12'
ACROSS ACC_PER2 AS 'Accounting Period'
COLUMNS
-READMOREA
-READ SAVE &ACC_PER2.A12. NOCLOSE
-IF &IORETURN NE 0 GOTO DONE;
-SET &CNTRA=&CNTRA +1;
-SET &ANDCOLUMN.&CNTRA= IF &CNTRA EQ &MAXVALUESA THEN '''&ACC_PER2.EVAL'''
-ELSE '''&ACC_PER2.EVAL''' || (' AND') ;
&ANDCOLUMN.&CNTRA
-GOTO READMOREA
-DONE



ON GRAPH HOLD AS GRAPHF FORMAT HTMTABLE
.....
.......

This message has been edited. Last edited by: Kerry,


WebFOCUS 7.6.10
Windows
all output (Excel, HTML, PDF)
 
Posts: 69 | Registered: March 11, 2010Reply With QuoteReport This Post
Expert
posted Hide Post
For starters, you have multiple target labels: -DONE. Which ONE do you want to -GOTO? Keep target labels unique.

IMHO: I wouldn't even use such things as READMORE and READMOREA. Just for uniqueness. READMORE is the shortest unique truncation of READMOREA.

I only took a glance at this, so, I hope this helps.


   In FOCUS Since 1983 ~ from FOCUS to WebFOCUS.
   Most recent: 8204 Gen 48 in Test and Production.
   Currently Available. Please contact me.
 
Posts: 2976 | Location: Middle Tennessee [8204M Gen48 in Test&Prod] | Registered: February 23, 2005Reply With QuoteReport This Post
Gold member
posted Hide Post
It did. Thanks.


WebFOCUS 7.6.10
Windows
all output (Excel, HTML, PDF)
 
Posts: 69 | Registered: March 11, 2010Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] Infinite loop?

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.