We have some problems of performances on our server BO (Windows 2003).
The specifications of our machine are:
VM Eco Center x86
2 Go RAM
20 KTpmC
OS Windows .NET 5.2
1 Processor Pentium (II/Pro)
RAM (Mo) 2 047,383
Business Object Version : 12.1.0.882
The process WIReportServer.exe takes more than 80 % on average of the available CPU. News connections are not possible.
Could you help me to configure my Server .
Franck009 (BOB member since 2010-01-28)
Franck,
For a WebI report server to take 80% CPU is not unusual. It generally happens when you have a complex report(multiple data providers, multi-passes sql, syncronization across merged dimensions, large dataset etc). Since you have 1 processor machine you are limited by hardware. Can you isolate which report(s) is causing the spike?
BO_TN (BOB member since 2008-07-30)
What BO_TN said is true, you won’t get much more performance out of your current server.
You are running with a 1 Processor Pentium (II/Pro) CPU? This CPU is like 12 years old. It is a minimum system requirement to have a 2.0 GHz Pentium 4-class processor. I always recommend to have 2 of those CPU’s to provide even better performance. Also you should have 3+GB of RAM as well.
J0sh 
(BOB member since 2006-10-09)
My suggestion is to Upgrade your server (hardware) and Upgrade BO also (install FP 1.6 at least). This combination should help!
aneelf (BOB member since 2006-05-15)
1 CPU means no growth potential if you need to add additional webi proc servers. 
Jay Riddle 
(BOB member since 2008-12-03)
I just configured my Business Object XI 3.1 server and the very first report that we ran the WIReportServer.exe ate up over 50% of the CPU. My server configuation is:
Intel Core 2 Duo 2.0 Ghz
2 GB RAM
Windows 2003 SP2 32-bit
The strange thing is, the SQL should only take 5 minutes to run, but the report never returns back. The Infoview viewer looks like it’s crunching something forever. I click cancel and INforview hangs. The WIReportServer.exe continues to run at 50% of CPU until restart the hardware. Is there a configuration issue I missed? This server was just installed.
gjwl_8 (BOB member since 2010-02-17)
Is there anything regarding this in the Server event logs?
How many rows are you trying to display?
Have you changed the Java runtime settings, on the server, if you are using the interactive viewer?
To be frank, you should stick some more RAM in the machine, 2GB is just not enough.
Do you get this issue if you do this on the server, itself?
Also, it may help if you tell us what Service Pack you are running.
Mak 1 
(BOB member since 2005-01-06)
I don’t think this is a server issue. Looks like Infoview hangs after certain amount of time although it looks like it is running. I was able to run the SQL in SQLPLUS and the results returned in 5 minutes. I was also able to run the report in Web Intelligence Rich Client and the result returns in 7 minutes. But, when I tried to run the report in Infoview, it didn’t come back after 50 minutes.
There were some posts that about about Infoview timing out, but that’s for previous versions of BO. I’m using XI 3.1 and I couldn’t find those settings they’re talking about. Any advise?
gjwl_8 (BOB member since 2010-02-17)
Gary,
Please answer my other questions…
Cheers,
Mark.
Mak 1 (BOB member since 2005-01-06)
Hi Mark,
There’s nothing suspicious in the server event logs. This report returns about 1000 rows because I was able to run it using the Web Intelligence Rich Client. It took about 5 minutes to get the results using WebI Rich Client. I have not touched any of the Java settings because this server was freshly built and we ran this report a day later.
We will be procuring a faster server later so this is a temp server. The faster server will be more memory, but I don’t think this is a RAM issue? After it was hanging for a while, I checked Task Manager and notice the CPU and RAM usage stayed constant. I had to kill the process or shutdown the server after waiting too long. Sometimes I closed the Internet Explorer session and still noticed WIReportServer.exe eating 50% of the CPU.
I’m running:
Business Objects Enterprise Professional XI 3.1
Windows server 2003 service pack 2
gjwl_8 (BOB member since 2010-02-17)
This smells a little like something I saw recently. Does this happen on all user accounts? Certainly a long shot, but I had a single user that had his preferences set to open the document in a new browser window. He was working with a report, also not too large, that was having this same effect on the server. However, when I opened the document and refreshed, it did not spike the CPU or take long to run.
After debugging the individual preferences I backed up his account, deleted his profile, recreated, and retested and shockingly the problem stopped.
That was a new one on me. Tough to open a case at that point as well considering I had already blasted the bad user.
Worth a shot…
V
Eric Vallo (BOB member since 2002-08-15)
Before you go hell over high water troubleshooting this issue, I would at least wait for your new server or install the lastest SP2 and most recent fix packs. FP 2.5 for SP2 was released on 2/24.
A lot of folks have reported improved performance after FP2.1+
If you’re getting your new server relatively soon, you may want to repurpose your “temp” server purely as the Web Application server and scale only your Intelligence & Processing tiers onto the new server. Although your temp server meets the minimum platform requirements, you’re pushing it by hosting Tomcat on the same box.
Jay Riddle (BOB member since 2008-12-03)
I don’t disagree. However, in this case it almost sounds a little less like a performance tweak than it does something problematic with a report or user. Just seems to stand out a bit more than just “all my reports are running slow”.
While a patch may fix that, diagnosis of a distinct issue may be faster than planning/testing/implementing a significant patch version and an opportunity to avoid.
I personally like to know what a FP or SP is going to fix before I fix it.
My two cents (as usual) 
V
Eric Vallo (BOB member since 2002-08-15)
Good point as well. Maybe a little more info would be good. You mentioned SQL Plus so I assume you’re hitting Oracle, so have you tried a different query? Do you have a test database you can hit, say SQL server? Is the problem the same across all reports?
I was assuming from your post that you just implemented a test box and only ran one report.
The effort you want to put in is time dependant on when your new server is available. However, I would still jump to the latest release, if not for the chance it resolves the issue then for the latest WebI features like fold/unfold, query on query, and input controls.
I stick by getting on the latest release. With that said, Eric’s got 10 years on me in the BI space. 
Jay Riddle (BOB member since 2008-12-03)
Thanks guys for your reponses!
To answer Eric’s question/comments; any user running this report gets the same results.
To answer Jay’s questions/comments; I will look into SAP’s site to try the latest service pack and patches. I guess since it’s a test server, it’d be a good idea to get the latest and greatest of the software. Also, this was the first report we tested. I"ll have the tester run more similar reports. I ran smaller reports and they returned relatively fast.
Now, assuming we test more reports and they all run fast, is it possible that this ONE report is messed up somehow and in someway?
gjwl_8 (BOB member since 2010-02-17)
I think that’s what Eric is getting at when he suggested following through with further testing to narrow down the possible root cause. I agree with Eric that if in production you want to use upgrades as an option used only after exhausting other methods as I’m sure he’ll agree when I say as much as fix packs and service packs in any application may resolve one issue, they are just as good at breaking something else.
Perhaps while you begin staging your service pack software you can test some other queries/reports. A hybrid approach since if what you’re saying is true, that other reports work fine. It may in fact be related to a particular query or report formatting.
If you edit the WebI report, you can see the actual SQL it is sending back vs what you are using in SQL Plus. If nothing looks unusual, it could be some dimensions they are using in the report that are unique to the other reports. In that case it could also be an issue of some Universe design or Universe settings. Remember, with WebI, because it relies on a unvierse layer you’re dealing with several layers between the build of the report, the query, the sql it is creating, and the universe layer. That’s a lot of possible kinks vs. running the SQL directly against the database. If other reports are working on the same datasource, at least you know it isn’t the ODBC driver. I assume you already tested running the report through InfoView on your own machine as well, but at this point it sounds deeper than that.
However, you may be surprised, as we’ve seen through a number of clients the various fix packs resolve bizarre SQL/WebI issues with a number of different datasources.
I know, a lot to take in, but good practice for future troubelshooting down the road.
Jay Riddle (BOB member since 2008-12-03)
I’m with Eric, on this one, in that you should be able to get this, base installation to work.
Although Jays comments are perfectly valid, with regards to performance enhancements r.e. SP2 and his, distributed, architecture recommendations.
However, you do not have any users on the system yet, so your report should work :).
Have you checked the Business Objects Product Availability Report to check you are running all the correct drivers, supported DB, IE and Java.
Can you run anything else? Try running it on the server directly, if the problem persists then you haven’t got a fire wall issue.
Is this a migrated universe and or report?
Is it one particular universe / datasource?
Any tests run in SQL+ should use the BO user account and connection string, to enure a, proper, comparison.
Cheers,
Mark.
Mak 1 (BOB member since 2005-01-06)
Indeed. These are the supported datasources for WebI:
Oracle 11g R1 Oracle Net Client 11g R1 ()
Oracle JDBC 11g R1 (11.1.0.6) ()
Oracle 10g R1 (10.1) Oracle Net Client 10.1 ()
Oracle 10g R2 (10.2) Oracle Net Client 10.2 ()
Oracle JDBC 10g R2 (10.2.0.1) (*)
Oracle 9.2 Oracle Net Client 9.2
Oracle JDBC 9i (9.2.0.5)
Only the Asteriks (*) support Oracle RAC.
If you’re running the latest ODBC driver supported against one of these datasources and the problem persists a long shot could also be the way Oracle is caching the SQL from WebI/Universe vs. other methods which doesn’t necessarily make sense, but I’ve seen present itself before. If you have an Oracle DBA it may worth having them examine and trace should it get to that point.
Jay Riddle (BOB member since 2008-12-03)
Indeed, Jay :).
In fact, this may be more common than you may think…;).
The amount of people that say that the query is running really fast through an editor, when in reality, it is only returning the firs5t x rows, or the DB has cached it as a recnt result set.
Mak 1 (BOB member since 2005-01-06)
I’m getting this also on one of my BOXI servers.
Keep in mind, I have 2 other servers with the exact same configuration.
The issue is on a UAT box, the DEV and PROD boxes are fine.
Client is reporting slow performance.
ConnectionServer.exe is 99% and Wireportserver.exe is erroring out.
Just starting to look in to the issue now.
Let me know what was done to resolve.
pGwtech (BOB member since 2011-12-07)