[SOLVED] 'Exceeded IBIF_max

May 10, 2010, 05:38 PM

texgator

[SOLVED] 'Exceeded IBIF_max_messages' error

I am trying to create two graph in a single fex. Both involve looping through the same table. If I comment out any one of these graphs, the other one run fine. However, when I run the entire fex at the same time, I get the error 'Reporting Server messages exceeded IBIF_max_messages'. Seems like it runs into an infinite loop. Not sure if this is the correct forum to ask this but would appreciate if someone could have a look. Thanks!

-*****First graph code below*****-
TABLE FILE FINHLDAR30
PRINT MNTH
ON TABLE SAVE
END
-RUN

-SET &CNTR=0;
-RUN

-SET &MAXVALUES=&LINES;

-MRNOEDIT BEGIN
GRAPH FILE FINHLDAR30
SUM
	VALPRE30  AS '>30D &YEAR24'
	VALPRE60  AS '>60D &YEAR24'
	VALCUR30  AS '>30D &YEAR12'
	VALCUR60  AS '>60D &YEAR12'
    PERPRE NOPRINT
	PERCUR NOPRINT
ACROSS MNTH AS ' '
COLUMNS
-READMORE
-READ SAVE &MNTH.A5. NOCLOSE
-IF &IORETURN NE 0 GOTO DONE;
-SET &CNTR=&CNTR +1;
-SET &ANDCOLUMN.&CNTR= IF &CNTR EQ &MAXVALUES THEN  '''&MNTH.EVAL'''
-ELSE '''&MNTH.EVAL''' || (' AND') ;
&ANDCOLUMN.&CNTR
-GOTO READMORE
-DONE
HEADING
"AR Aging $ > 30-60 Days for Cost Center &CCENTER  "
ON GRAPH HOLD AS GRAPH1 FORMAT HTMTABLE
END
-RUN
-MRNOEDIT END

-*****Second graph code below*****-
TABLE FILE FINHLDAR30
PRINT MNTH
ON TABLE SAVE
END
-RUN

-SET &CNTR=0;
-RUN

-SET &MAXVALUES=&LINES;

-MRNOEDIT BEGIN
GRAPH FILE FINHLDAR30
SUM
	VALPRE30P  AS '>30D &YEAR24'
	VALPRE60P  AS '>60D &YEAR24'
	VALCUR30P  AS '>30D &YEAR12'
	VALCUR60P  AS '>60D &YEAR12'
    PERPRE NOPRINT
	PERCUR NOPRINT
ACROSS MNTH AS ' '
COLUMNS
-READMORE
-READ SAVE &MNTH.A5. NOCLOSE
-IF &IORETURN NE 0 GOTO DONE;
-SET &CNTR=&CNTR +1;
-SET &ANDCOLUMN.&CNTR= IF &CNTR EQ &MAXVALUES THEN  '''&MNTH.EVAL'''
-ELSE '''&MNTH.EVAL''' || (' AND') ;
&ANDCOLUMN.&CNTR
-GOTO READMORE
-DONE
HEADING
"AR Aging $ > 30-60 Days for Cost Center &CCENTER  "
ON GRAPH HOLD AS GRAPH2 FORMAT HTMTABLE

END
-RUN
-MRNOEDIT END


-HTMLFORM BEGIN
<html>
<head>
</head>
<body>
<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" width="100%">
  <tr>
    <td width="25%">!IBI.FIL.GRAPH1;</td>
    <td width="25%">!IBI.FIL.GRAPH2;</td>
  </tr>
</table>
</body>
</html>
-HTMLFORM END

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

May 10, 2010, 05:56 PM

Dan Satchell

You have two -DONE and two -READMORE labels. This will cause infinite looping.

May 10, 2010, 06:32 PM

texgator

I see. Thanks. Is there a workaround to make this work? I need to pass parameters to each of these graphs and produce them at run time. Wish there was a way to have these graphs in different frames of an html document (created in composer) that could open when a user clicks on a value in parent report. I already have these graphs working in different frames of an HTML doc but couldn't find a way to open it automactially and receive parameters when user clicks on the parent report. Need to have them both open in the same page.

May 10, 2010, 06:43 PM

Darin Lee

change the names of the second labels - maybe DONE2 and READMORE2. You can have as many labels as you want but they have to have unique names within the same fex.

May 11, 2010, 11:11 AM

texgator

Thanks!