How to Tune SpagoBI + Tomcat

In the previous section, I showed how to install and config the Oracle data source connection in SpagoBI 2.5 step-by-step. This time, I will show the steps of tuning the SpagoBI 2.5 environment.

Environment
============
SpagoBI: version 2.5
OS Server: Windows server 2008 R2 (x64)
App Server: Tomcat 6.0.18 (in the SpagoBI demo package)
Java: JDK 1.6.0_20

Problems
============
Here is the screenshot of Tomcat console:


We can find three issues:
1) APR (Apache Portable Runtime) is not installed by default. APR is to provide superior scalability, performance, and better integration with native server technologies;
2) No persistent store is configured for session management;
3) There is log4j warning of log4j system not being initialized properly;

Fixes
=============
1) First, download APR from here, and save to folder like Tomcat_home\APR;


Then, open and edit file "Tomcat_home\bin\catalina.bat", and add one line after ":okHome", just like below:



2) Edit the file "context.xml" at "tomcat_home\webapps\SpagoBI\META-INF":


The same change can apply to other context file;

3) Edit the file "log4j.properties" at "tomcat_home\webapps\SpagoBIJPXMLAEngine\WEB-INF\classes":

Add the following 2 lines:


Save and restart Tomcat server.