Wireportserver.exe is consuming 100% cpu

I would request you to confirm the below steps.

1) If you are using Load balance then please increase the Load Balancer idle session timeout .
2) Can you also do this test: Please do take backup of the file.
1- Open folder : <Your BO install Folder>\Tomcat55\webapps\AnalyticalReporting\WEB-INF\classes
2- Edit file : webi.properties
3- Change the lines :
#WID_FAILOVER_SIZE=10
#WID_STORAGE_TOKEN_STACK_SIZE=10
By:
WID_FAILOVER_SIZE=0
WID_STORAGE_TOKEN_STACK_SIZE=0
4- Save ans close the file
5- Restart tomcat
6- check if the issue is resolved

3) Purge the query and run the same one by one. Once it is done then refresh all the queries. With this we can get to know which query is causing the issue. If you find that few queries are taking long time then foloow the below steps for that specific queries:
a. . Edit the report and go to Edit Query.
b. At bottom you can see the name of the Query
c. Right click on Query and click Duplicate Query. It will create a copy of the original query.
d. And then delete the original query.
e. Do the same step for all queries
f. Run all queries and then test the issue again.
4) Run the report in Webi Rich Client. If it works then Save the report with different name and in different folder. And export same in Repository. From the Infoview try to refresh the report.
5) Please check if using Web mode is acceptable workaround.
6) In Universe Designer> parameter> Controls, uncheck the option 'Limit Execution Time To' and 'Limit Result Set To' parameters. By doing this it will allow users to create queries that have not been tuned, run for extended period of time .
7) It is always recommended to Schedule the report which are of large size instead of refreshing. I would suggest you to schedule the report to resolve the issue.

~Sujeet Sharma

Do you observe any ghost sessions running in webi processing server metrics.

How soon is the issue occurring. It seems as though the cache is not getting cleared.

Disable your existing server and create a new WIPS. It might help.

Hi,

Are you facing issue continuously or having issue when particular report run?

If it happens when the report runs, make sure that you don't have more no of Varbles/inputcantrols and format of the report.

if it happen continuously , try to clear the Data folder and restart the SIA.

Delete contents under the Data Folder in order to clear Web Intelligence Cache

<Install Directory>\SAP Business Objects\SAP BusinessObjects.XI 4.0 \Data Folder

stop SIA and rename Data folder and start the SIA

Sounds like Platform search is doing its job:

Ghosts in the Database | EV Technologies, Inc.