When attempting to view CA Business Intelligence (CABI) Infoview WEBI Reports, the following error is received: ERRORCODE="30280" ERRORTYPE="USER" MESSAGE="The Web Intelligence server memory is full"

Document ID : KB000056545
Last Modified Date : 14/02/2018
Show Technical Document Details

Description:

When attempting to view CA Business Intelligence (CABI) Infoview WEBI Reports, the following error is received: ERRORCODE="30280" ERRORTYPE="USER" MESSAGE="The Web Intelligence server memory is full"

Solution:

There are a few CABI performance configurations changes that can be made to improve WEBI memory performance.

Clear the CABI Data directory:

1. Stop the Server Intelligent Agent (SAI) via Central Configuration Manager (CCM).
2. Navigate to <'CABI Install directory>/BusinessObject Enterprise 12.0' directory
3. Rename the DATA directory.
4. Create a new empty DATA directory.
5. Restart the SIA via CCM.

Change CABI Apache Tomcat heap size settings:

1. On the CABI server, navigate to Start menu --> Programs --> Tomcat--> Configuration --> Java tab.
2. Set the Initial and Maximum size to 512 and 1024 respectively.
3. Restart Apache Tomcat via CCM.

Change Web Intelligence Server properties settings:

1. Login to the Central Management Console (CMC) with a CABI Administrator account.
2. Click on Servers.
3. Right-click on the Web Intelligence Processing server and select Properties
4. Change the Document Cache Cleanup interval to 600 seconds (default 120 seconds).
5. Change the Cache Timeout to 20 minutes (default 4370 minutes).
6. Reduce the Maximum Document cache Size to 10240 KB (default 1000000 KB).
7. Restart the Web Intelligence Processing server.
8. Go to the '<CABI Install directory>\Tomcat55\webapps\AnalyticalReporting\WEB-INF\classes' directory and take a backup of the 'webi.properties' file.
9. Uncomment the below lines:

i.WID_FAILOVER_SIZE=60
ii.WID_STORAGE_TOKEN_STACK_SIZE=60
iii.#MAX_HEAP_SIZE=1073741824 (Added line)

 

NOTE: An additional WEBI Processing Server can also be added to distribute the load between the two. Here's how its normally done:

1) Add a new WEBI Processing server via: Central Management Console -> New Server -> WEBI Service -> type an appropriate name (do not select the "single sign-on" option).  

2) Repeat the step further above to change WEBI Server properties settings update the WEBI settings again on the newly created WEBI Processing Server.

 

 

10. Reboot the CABI server.