Focal Point Banner


As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only.

Join the TIBCO Community
TIBCO Community is a collaborative space for users to share knowledge and support one another in making the best use of TIBCO products and services. There are several TIBCO WebFOCUS resources in the community.

  • From the Home page, select Predict: WebFOCUS to view articles, questions, and trending articles.
  • Select Products from the top navigation bar, scroll, and then select the TIBCO WebFOCUS product page to view product overview, articles, and discussions.
  • Request access to the private WebFOCUS User Group (login required) to network with fellow members.

Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community.


Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     PDF Compound Report report getting broken after specific layouts.

Read-Only Read-Only Topic
Go
Search
Notify
Tools
PDF Compound Report report getting broken after specific layouts.
 Login/Join
 
Member
posted
Hi,
I have a pdf compound report layout in which i am looping the number of Page layouts and components respectively. Default there are 9 reports. When the loop runs for 1 or 2 times its working fine by showing 18 report in one pdf which are being called from 9 FEX files by passing different parameters 2 times.
Now the problem is when the loop runs for 3 times it is getting broken by throwing an error message ""exceed IBI error msgs..". If I run the third loop seperalty it working as expected. so the fex are working as expected.
My current PDF might run for 10-12 loops. Can you please help me on how to fix this issue. I tried surfing the forums but of no use. Awating response. Thanks.
Regards;
Prabhakar Rao


WebFOCUS 7.7.05 and 8.x
Windows, All Outputs
 
Posts: 27 | Registered: December 13, 2012Report This Post
Platinum Member
posted Hide Post
Hi,

By what you're explaining, it sounds like it may be related to the following:

IBIF_max_messages
Controls how many WebFOCUS Reporting Server messages will be accumulated before WFServlet stops processing the request and displays error message 32100: "Reporting Server messages exceeded IBIF_max_messages, report retrieval aborted." Messages include –TYPE commands, &ECHO=ALL variables, and errors or warnings from a data adapter. The setting protects against the situation where the Java VM executing WFServlet runs out of memory. 20000 is the default value. IBIF_max_messages can be passed with the request, in which case it overrides the value set in the console. When debug mode is enabled in Developer Studio, a value of 50000 is passed with each request. A value of 0 indicates that no limit exists.

See: http://www.csueastbay.edu/FOCU...EN/help/topic469.htm

IBIF_max_messages is a WF Client setting, which you can set to 0.

Or - if the above does sound like your error, then turn whatever is generating messages off e.g. SET MSG=OFF, and -SET &ECHO=OFF ;


WebFOCUS 8.2.06 mostly Windows Server
 
Posts: 195 | Location: Johannesburg, South Africa | Registered: September 13, 2008Report This Post
Platinum Member
posted Hide Post
Just BTW - I found the info by doing a Google search for "exceed ibi error messages".

Admittedly you need to at least have a fair knowledge of WebFOCUS to know whether the search results that are returned are in fact applicable or not - but it is always worth starting with Google.
 
Posts: 195 | Location: Johannesburg, South Africa | Registered: September 13, 2008Report This Post
Member
posted Hide Post
For better representation of my problem, let us consider the below sample code.
-*************************************************************
-DEFAULTH &CNT_VAL = 1;
-DEFAULT &CNT_VAL1 =10;

-SET &ECHO = ALL;

SET HTMLARCHIVE=ON
COMPOUND LAYOUT PCHOLD FORMAT PDF
UNITS=IN, $
OBJECT=bookmarks ,$
SECTION=section1, LAYOUT=ON, METADATA='.208^.208^.208^.208^4', MERGE=OFF, ORIENTATION=LANDSCAPE, PAGESIZE=LETTER, SHOW_GLOBALFILTER=OFF, $

-REPEAT ENDREPEAT1 &CNT_VAL1 TIMES
PAGELAYOUT=&CNT_VAL.EVAL, NAME='Page layout 1', text='Page layout 1', TOC-LEVEL=0, BOTTOMMARGIN=0.208, TOPMARGIN=0.208, LEFTMARGIN=0.208, RIGHTMARGIN=0.208, METADATA='BOTTOMMARGIN=0.208,TOPMARGIN=0.208,LEFTMARGIN=0.208,RIGHTMARGIN=0.208,', $
COMPONENT='&CNT_VAL.EVAL', TEXT='&CNT_VAL.EVAL', TOC-LEVEL=1, POSITION=(0.208 0.208), DIMENSION=(11.290 7.772), METADATA='Z-INDEX: 100; POSITION: absolute; WIDTH: 11.29in; HEIGHT: 7.772in; TOP: 0.208in; LEFT: 0.208in', $
-SET &CNT_VAL = &CNT_VAL + 1;
-ENDREPEAT1

-SET &CNT_VAL = 1;
END

-REPEAT ENDREPEAT10 &CNT_VAL1 TIMES
SET COMPONENT='&CNT_VAL.EVAL'

-*DUMMY LINES FOR TESTING
-*DUMMY LINES FOR TESTING
-*DUMMY LINES FOR TESTING
-*DUMMY LINES FOR TESTING
-*DUMMY LINES FOR TESTING
-*DUMMY LINES FOR TESTING
-*DUMMY LINES FOR TESTING
-*DUMMY LINES FOR TESTING
-*DUMMY LINES FOR TESTING
-*DUMMY LINES FOR TESTING
-*DUMMY LINES FOR TESTING
-*DUMMY LINES FOR TESTING
-*DUMMY LINES FOR TESTING
-*DUMMY LINES FOR TESTING
-*DUMMY LINES FOR TESTING
-*DUMMY LINES FOR TESTING
-*DUMMY LINES FOR TESTING

TABLE FILE CAR
PRINT
*
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT PDF
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
INCLUDE = endeflt,
$
ENDSTYLE
END

-SET &CNT_VAL = &CNT_VAL + 1;
-ENDREPEAT10
COMPOUND END
-EXIT
-*************************************************************

We observe that PDF compound layout is considering the commented lines as well. Not sure how and why.
Justification: If we execute the below code with &CNT_VAL1 =157 then the report works fine. But at &CNT_VAL1 =158 the report breaks with the error message “Reporting Server messages exceeded IBIF_max_messages, report retrieval aborted”.
By removing the commented lines the Break point goes from 157 to 182.
Break point is &CNT_VAL1 = 182

Do we have any limit for components in PDF compound layout painter?
If yes how many components can we fit in?
Is there a way to free the cache memory for every loop at the time of execution or rum time?
Do we have a storage limit for compound layout painter on execution time?


WebFOCUS 7.7.05 and 8.x
Windows, All Outputs
 
Posts: 27 | Registered: December 13, 2012Report This Post
Platinum Member
posted Hide Post
From the help information on IBIF_max_messages:
"Messages include –TYPE commands, &ECHO=ALL variables, and errors or warnings from a data adapter. The setting protects against the situation where the Java VM executing WFServlet runs out of memory. The default value is 20000. IBIF_max_messages can be passed with the request, in which case it overrides the value set in the console. When debug mode is enabled in Developer Studio, a value of 50000 is passed with each request. A value of 0 indicates that no limit exists."

Try commenting out or eliminating the -SET &ECHO = 'ALL'; statement.


WF 7.7.04, WF 8.0.7, Win7, Win8, Linux, UNIX, Excel, PDF
 
Posts: 175 | Location: Pomona, NY | Registered: August 06, 2003Report This Post
Member
posted Hide Post
Thanks a lot.It was helpful.


WebFOCUS 7.7.05 and 8.x
Windows, All Outputs
 
Posts: 27 | Registered: December 13, 2012Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     PDF Compound Report report getting broken after specific layouts.

Copyright © 1996-2020 Information Builders