Hi All,
BOXI 3.1 SP3 sitting on windows server 2003 SP2 reporting Oracle 10G:
We have two BO servers (=2 SIAs) clustered and two tomcat servers taking care of WAS part. I could see on my event viewer the following error messages often:
Also the performance is very low on reports part! users are complaining that sometime the reports runs for 3 mins some time it is 10 mins and other time it is timing out(20 Mins). so Not sure where we need to tune / correct.
I’ve seen these also for our Web Intelligence Processing Server. I think it actually isn’t an unexpected error, it is just recorded that way for some reason.
For the Web Intelligence Processing Server there are two settings that I believe come into play here:
Maximum Documents Before Recycling
Timeout Before Recycling (seconds)
These two settings will cause the Web Intelligence Processing Server to restart when their conditions have been met. That is, after the number of documents specified have processed and the service has been idle for the time specified, the Web Intelligence Processing Server will restart.
I think this restart is what is being recorded in the Event Viewer log as an unexpected event, even though it really is by design.
I don’t know how this would impact the performance of your reports unless there isn’t enough idle time for your service to restart and it gets bogged down for some reason.
As far as the inconsistency of the time that your reports run, there are lots of places where you may be able to adjust settings.
I would check the log files and see if you are getting any entries that may be related. One thing to look for could be the size of the document cache.
I would also make sure that the reports that are running differently are returning a comparable amount of data. If one time it is pulling 100 records and the other time it is pulling 1,000,000 records, then yes, the second report will run longer.
Without actually seeing your system, how it is set up, and how it is used, it is hard to give any suggestions to look into.
Hi John,
Thanks for your points!
As you said, I have increased the values for
Maximum Documents Before Recycling
Timeout Before Recycling (seconds)
to a higher one. The same have been recommanded by SAP KB Note.
Today morning only I have increased these values and I will monitor it and post here the results!
Also I was analysing in such a wasy that when this restart happens, whot would happen actually to the reports - will it be there and reconnected and continues once the webI processing server available again? I think it is. your thoughts on this?
Regarding report running slowly, we have some DB performance issue because of which I suppose our report is running in diferent time.
Will try to give you the info as much as I can here. we use only webI reports & users reporting globally, BO server & DB is in US. Adhoc reporting and other users will use these reports once a user created.
By the explanation given for the settings, there shouldn’t be any reports that are running at the time of the service restart. The Timeout Before Recycling (seconds) is supposed to be idle time.
I would suspect that you would need to monitor this to verify though. We haven’t noticed this being a problem yet.
(BOB member since 2006-11-01)