Home > SAP BI, WeBi > Webi Processing Server launches a lot of sql on database

Webi Processing Server launches a lot of sql on database

Hi,

I’ve encountered following behaviour: WebIntelligenceProcessingServer launches a lot of “SELECT DISTINCT <column> FROM “-statements on the database.

This is caused by the Infromation Engine Service of WEBI, which allows you to cache List of Values. This option is enabled by default and in case you accept the defaults during universe design,  this will cause a lot of LOV-cache generation.

You can disable this option by deactivating the checkbox “Enable List Of Values” in the properties screen of the WebIntelligenceProcessingServer:

ScreenHunter_39 Dec. 11 17.30

Afterwards, restart the WebiProcessingServer, and your database load will decrease significantly.

kr,

Hans

Advertisements
Categories: SAP BI, WeBi
  1. April 11, 2013 at 3:40 am

    We experience this problem with the platform search http://vynesolutions.wordpress.com/2013/04/03/watch-out-for-the-platform-search-in-the-central-management-console/
    by deactivating the checkbox “Enable List Of Values” and disabling the platform search this solved our problem.

  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: