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     [CLOSED] IBIF_max_messages and EDASERVE errors
Go
New
Search
Notify
Tools
Reply
  
[CLOSED] IBIF_max_messages and EDASERVE errors
 Login/Join
 
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, 2009Reply With QuoteReport This Post
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, 2008Reply With QuoteReport This Post
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, 2006Reply With QuoteReport This Post
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, 2005Reply With QuoteReport This Post
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, 2009Reply With QuoteReport This Post
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, 2006Reply With QuoteReport This Post
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, 2009Reply With QuoteReport This Post
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, 2003Reply With QuoteReport This Post
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, 2009Reply With QuoteReport This Post
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, 2008Reply With QuoteReport This Post
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, 2006Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] IBIF_max_messages and EDASERVE errors

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