webi report server becomes full and crashes

server administration XI Server Discussion
1

Hi

We have windows with 8 CPU and 8GB ram.

One CMS, 3 webi report servers and one jobserver.

recently we find at a specific time the webi report server accumulates memory and crashes after 1,5GB. The process is killed and service restarted.

From audit we find around that time 5million row report was running in 6 mins time

THis repeated 2 days in succession now.

So ideally it looks like memory accumulation and crash due to heavy reports.

But Recently we also deleted some users. Is it possible due to orphan reports. How to check using query builder orphan schedules or similar investigation?

cubic coma (BOB member since 2006-09-16)

2

[Moderator Note: Moved from XI Scheduler to XI Server Discussion]

Marek Chladny :slovakia: (BOB member since 2003-11-27)

3

Which version of BO are you using? In the earlier versions of 3.0 and 3.1 there was a memory leak in the WebI Processing Server that could cause this type of issue. I would recommend making sure that you have the at least the latest service pack and possibly the latest fix pack for your system to see if that will resolve the issue.

-Dell

hilfy :us: (BOB member since 2007-04-16)

4

Also, isn’t there a thread on the ncs.conf file, changing this param:

I think that was a big help in keeping memory consumption down…

Brent

bdouglas :switzerland: (BOB member since 2002-08-29)

5

Hello,

We are using BOXI R2 SP4.10.

Is there possibility of memory not released?

Do you know what are pros and cons of changing the parameter you mentioned?

cubic coma (BOB member since 2006-09-16)

6

I have not seen any issues arise (negatives) from changing this parameter… I believe it’s only used by another debugging application, would not affect normal BO operations.

If you get a memory full error, I would dig into the logs for that reportserver process and see if there is a specific report causing this…

B

bdouglas :switzerland: (BOB member since 2002-08-29)

7

Thanks!!..Here is what we found,

Our webi report server all 3 have settings:-

  1. Keep cache for 24 hours period
  2. Cache size=10GB
  3. Keep Cache till 70% when full i.e 7 GB when full
  4. Check cache every 2 hours

NOW…

When we check the SIZE of folder in cache directory:-\BusinessObjects Enterprise 11.5\Data<>\storage\docs\

WE see 18GB!!

Is it possible that cache folder is not getting cleaned? It should be in every 2 Hours whenever it reaches >7GB, and certainly every day as I have mentioned the parameters.

  • We are thinking of cleaning old cache and retain only till 7GB: Any impact, and how to do? backup and delete from old date stamps of files and keep cache till around 7GB…Restart all webi service?
  • Dont know why auto mechanism does not work??

Thanks!

cubic coma (BOB member since 2006-09-16)

8

We also faced the same Issue. here is the reference

Manikandan Elumalai :us: (BOB member since 2009-10-23)