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     [CLOSED] IBIF_max_messages and EDASERVE errors

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[CLOSED] IBIF_max_messages and EDASERVE errors
 Login/Join
 
lalita
Member
posted
Hi,

There are two reports that I am having issues with.

1) The first report works well in PROD but fails in SIT and UAT giving the below error ---

Reporting Server messages exceeded IBIF_max_messages, report retrieval aborted.

Please, contact your WebFOCUS administrator.

2) The second report works well in PROD and SIT but fails in UAT giving the below error --

Unknown error occurred. Agent on reporting server EDASERVE may have crashed. Please investigate reporting server log.

Points to be noted ---

a) All the three versions (SIT, UAT, PROD) of fexes and metadata are same.

b)Rest of the reports in SIT and UAT are working.

Please let me know if you have any solution.

Thanks.

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


764
Windows
PDF,EXL2K,HTML
 
Posts: 27 | Registered: July 28, 2009Report This Post
fatboyjim
Platinum Member
posted Hide Post
Hi,

The first issue you may have debug (ie. -SET &ECHO=ALL or tracing can be on...etc) on so you may hit the limit in your test box. It may be that the limit is set lower compared to your PROD box. The default is set to 20000 lines for IBIF_max_messages. If you want it to be unlimited, set it to zero.

The second issue is more vague, it could be something like missing double quotes in code, join statements not cleared, ...etc (at least those were the ones that I've encountered, of course there are definitely more).

Hope this helps.

Best Regards,

Jimmy Pang


DEV: WF 7.6.10
TEST: WF 7.6.10
PROD: WF 7.6.10
MRE: WF 7.6.4
OS/Platform: Windows
Dev Studio: WF 7.7
Output: HTML, EXCEL, PDF, GRAPH, LOTUS, CSV
 
Posts: 117 | Location: Toronto, Ontario, Canada | Registered: February 29, 2008Report This Post
GinnyJakes
Expert
posted Hide Post
Lalita, even though the programs and masters are the same, it doesn't mean that the data is. You may be pointing to dev, trial, and prod versions of data. IBIF_max_messages oftentimes means that the focexec is having trouble handling the data that comes in and throws an error for each record that fails until it reaches the threshold and fails. The easiest way to diagnose this problem is to put a recordlimit in the program, very small, so that you don't crash and can see the error. Once you know what the error is, you can attempt to fix it.

That is how I would start to diagnose the problem. Please post your results of this exercise.


Ginny
---------------------------------
Prod: WF 7.7.01 Dev: WF 7.6.9-11
Admin, MRE,self-service; adapters: Teradata, DB2, Oracle, SQL Server, Essbase, ESRI, FlexEnable, Google
 
Posts: 2723 | Location: Ann Arbor, MI | Registered: April 05, 2006Report This Post
jbanas6
Gold member
posted Hide Post
Check your dialogue manager statements. My guess is you could have put it in an infinite loop.


WF 7.6.10 /IIS 6/ JBoss Enterprise 4.3
Windows XP SP 2/Windows 2003 Server
MVS 7.3.3
 
Posts: 76 | Location: Hartford, CT | Registered: August 30, 2005Report This Post
lalita
Member
posted Hide Post
Hi,

I tried printing just one record but it is still giving the Max messages error.

And reg the infinite loop data is coming till the last hold file, it is just that the report is not coming up.

Thanks.


764
Windows
PDF,EXL2K,HTML
 
Posts: 27 | Registered: July 28, 2009Report This Post
GinnyJakes
Expert
posted Hide Post
You can't fix the problem until you know what it is. Have you tried running a trace, server-side? You might have to go through a lot of text before you find the error message but once you find it, you'll know what you have to fix. Give it a shot.


Ginny
---------------------------------
Prod: WF 7.7.01 Dev: WF 7.6.9-11
Admin, MRE,self-service; adapters: Teradata, DB2, Oracle, SQL Server, Essbase, ESRI, FlexEnable, Google
 
Posts: 2723 | Location: Ann Arbor, MI | Registered: April 05, 2006Report This Post
Severus.snape
Platinum Member
posted Hide Post
Hi Lalita,

Not sure if this might be the issue with your case, but quite a few times I had encountered Max messages error because of having multilple Label names for a GOTO stmt.
WF parser would look for a single Label for a GOTO but if you have multiple Labels then this error would pop up.
Just check on it.

thanks
Sashanka


WF 7.7.03/Windows/HTML,PDF,EXL
POC/local Dev Studio 7.7.03 & 7.6.11
 
Posts: 103 | Registered: June 12, 2009Report This Post
Carol Dobson
Guru
posted Hide Post
Another thought is - if you have -TYPE statements in the code, you may need to remove them.



WebFOCUS 7.6.6/TomCat/Win2k3
 
Posts: 428 | Location: Springfield, MA | Registered: May 07, 2003Report This Post
lalita
Member
posted Hide Post
Hi,

@fatboyjim -- Could you please let me know where the IBIF_max_messages limit is set to a default value either 20000 or 0 ? Thanks.


764
Windows
PDF,EXL2K,HTML
 
Posts: 27 | Registered: July 28, 2009Report This Post
fatboyjim
Platinum Member
posted Hide Post
Hi Lalita,

I'm not a webFOCUS administrator at my company so unfortunately I can not tell you exactly where the problem is.

But here are a couple of links that may point you in the right direction.

1) Possible causes of the error:
http://documentation.informati.../source/topic101.htm

2) Possible solution:
http://techsupport.information...om/sps/52732528.html

NOTE: Not sure if it's always a good idea to set to unlimited as that may cause very large log file. So you should find out the limit that is best.

Best Regards,

Jimmy Pang


DEV: WF 7.6.10
TEST: WF 7.6.10
PROD: WF 7.6.10
MRE: WF 7.6.4
OS/Platform: Windows
Dev Studio: WF 7.7
Output: HTML, EXCEL, PDF, GRAPH, LOTUS, CSV
 
Posts: 117 | Location: Toronto, Ontario, Canada | Registered: February 29, 2008Report This Post
GinnyJakes
Expert
posted Hide Post
IBIF_max_messages is defined in the WebFOCUS Client Console under Configuration/Client Settings/General, near the bottom. You must be an admin to change this.

For this particular issue, I wouldn't raise it. I'd lower it so that the termination happened much more quickly and turn on client and server traces. You cannot solve this problem until you know what the error is, especially if you've ruled out the other suggested causes in this thread. My experience is that these are often data problems.


Ginny
---------------------------------
Prod: WF 7.7.01 Dev: WF 7.6.9-11
Admin, MRE,self-service; adapters: Teradata, DB2, Oracle, SQL Server, Essbase, ESRI, FlexEnable, Google
 
Posts: 2723 | Location: Ann Arbor, MI | Registered: April 05, 2006Report 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     [CLOSED] IBIF_max_messages and EDASERVE errors

Copyright © 1996-2020 Information Builders