Skip to Content

The SAP BusinessObjects BI 4 platform uses Tomcat as the default web application server. However there are a couple of configuration changes that can be made to Tomcat that will help Analysis edition for OLAP to perform even better.

Based on a default installation, the first change will increase the maximum memory pool for Java and the second change will increase the maximum number of processing threads. These changes will allow for a larger number of users and larger query size.

This blog explains the simple steps to make these changes, for both Windows (including video) and Linux.

NOTE: The values shown in the video and mentioned in this blog are example values. It is important that you make use of the various sizing tools available at http://service.sap.com/sizing for actual values.

Windows

1. From the machine that is running Tomcat we want to change the properties of the Tomcat service. Click on the “Start” button and open the “Tomcat” program folder. Click on “Tomcat Configuration”.

2. In the “Apache Tomcat for BI 4 Properties” dialog, click on the “Java” tab.

3. Change the “Maximum memory pool” setting from 2048 MB to the suggested size from the sizing tools. In the video it is changed to 4096 MB. Click on “Apply”. *Do not close the dialog*

4. Use Windows Explorer to navigate to the folder:-

    <SystemDrive:>\Program Files (x86)\SAP BusinessObjects\tomcat\conf\.

5. Open the file “server.xml” in a text editor.

6. Assuming that the default port 8080 is being used by your SAP BusinessObjects BI installation, look for the line that starts:-

    “<Connector port=”8080″ protocol=”HTTP/1.1″ …”

7. Add the maxThreads parameter to this line with the suggested value from the sizing tools. In our example we increase the number of threads from the default value of 200 to 400 threads. The line now starts:-

    “<Connector maxThreads=”400″ port=”8080″ protocol=”HTTP/1.1″ …”

[Aside: The number of threads is loosely related to the number of concurrent users and the number of Analysis OLAP workspaces that each user will open simultaneously.]

8. Save and close the “server.xml” file.

9. Return back to the “Apache Tomcat for BI 4 Properties” dialog and click on the “General” tab.

10. Click on “Stop” to stop the Apache Tomcat service. Once stopped, click on “Start” to start it again and use the settings you have just made.

[For easier viewing, we recommend you toggle on “Full screen” mode and switch to 720p HD]

Linux

1. From the machine that is running Tomcat we want to change the properties of the Tomcat daemon. Go to the directory $BOBJEDIR (the directory where SAP BusinessObjects Enterprise is installed) and stop Tomcat by executing the command “tomcatshutdown.sh”.

2. Go to the directory $BOBJEDIR/tomcat/bin.

3. Open the file “setenv.sh” with a text editor.

4. Locate the line with the JAVA_OPTS environment variable. Change the -Xmx parameter to the suggested size from the sizing tools. In our example we will change it to 8GB (ie 8g). The edited entry will be similar to:-
    JAVA_OPTS=”… -Xmx8g …”

5. Go to the directory $BOBJEDIR/tomcat/conf.

6. Open the file “server.xml” with a text editor.

7. Assuming that the default port 17078 is being used by your SAP BusinessObjects BI installation, look for the line that starts:-

    “<Connector port=”17078″ protocol=”HTTP/1.1″ …”

8. Add the maxThreads parameter to this line with the suggested value from the sizing tools. In our example we increase the number of threads from the default value of 200 to 400 threads. The line now starts:-

    “<Connector maxThreads=”400″ port=”17078″ protocol=”HTTP/1.1″ …”

[Aside: The number of threads is loosely related to the number of concurrent users and the number of Analysis OLAP workspaces that each user will open simultaneously.]

9. Save and close the “server.xml” file.

10. Go to the $BOBJEDIR directory.

11. Start Tomcat by executing the command “tomcatstartup.sh”. It will now use the changes you have just made.

To report this post you need to login first.

8 Comments

You must be Logged on to comment or reply to a post.

  1. Ladislav Varga

    Hello, Ian,

    where are the Apache Tomcat for BI 4 properties stored? I mean some configuration file, not the Apache Tomcat for BI 4 properties window.

    Thank you.

    (0) 
    1. Ian McAlpine Post author

      Hi Ladislav

      I’m not entirely clear what you mean. Do you mean where are the values stored that are set using the “Apache Tomcat for BI 4 Properties” dialog?

      Regards

      (0) 
            1. Ladislav Varga

              You are right. They are stored here: [HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Apache Software Foundation\Procrun 2.0\BOEXI40Tomcat\Parameters\Java]

              But, their are stored as binary data, therefore I could not find them.

              Thank you very much. 🙂

              (0) 

Leave a Reply