Friday, May 1, 2015

SP2 Configure spagoBI server - stand alone apache tomcat

1. postgres
2. All-In-One-SpagoBI-5.0-01102014
3. SpagoBIStudio_5.0.0_win32_23102014
4. postgres-dbscript-5.0.0_15092014
5. database any one oracle/sqlserver/mysql (i am using sqlserver)
6. apache tomcat 7
7. java jdk

go step by step
1. extract apache tomcat to some folder
2. extract to folder and move to folder
    e:\SpagoBI-Server-5.0-16092014\webapps\* cut or copy all spago engines to E:\apache-tomcat-7.0.61\webapps\*

3. move all library jar file from spago lib folder to apache tomcat
    SpagoBI-Server-5.0-16092014\lib\* to apache-tomcat-7.0.61\lib\*
4. Move postgres and sqljdbc driver to "apache-tomcat-7.0.61\webapps\SpagoBI\WEB-INF\lib\"    as well as at "apache-tomcat-7.0.61\lib\*"

5. we will going to create the spago repository on POSTGRES db, (i am not prefer sqlserver for spago repository.. for my case it throws lot of unresolved errors)
    so for this we need to execute script from zip file "postgres-dbscript-5.0.0_15092014"
    -create database "spagobi"
    - execute script:
        "PG_Create", "pg_create_quartz_schema"

6. modify server.xml file:
    add below text under "GlobalNamingResources" tag.
 <Environment name="spagobi_resource_path" type="java.lang.String" value="${catalina.base}/resources"/>  
 <Environment name="spagobi_sso_class" type="java.lang.String" value=""/>  
 <Environment name="spagobi_service_url" type="java.lang.String" value="http://localhost:8080/SpagoBI"/>  
 <Environment name="spagobi_host_url" type="java.lang.String" value="http://localhost:8080"/>  
 <Resource name="jdbc/spagobi"  

7. Remove code from server.xml file

 <Resource name="UserDatabase" auth="Container"  
 description="User database that can be updated and saved"  
 pathname="conf/tomcat-users.xml" />       

8. Modify context.xml
remove context tag and replace with below code

 <Context docBase="SpagoBIProject" path="/SpagoBI" privileged="true" reloadable="true" source="org.eclipse.jst.j2ee.server:SpagoBIProject">  
    <ResourceLink global="jdbc/spagobi" name="jdbc/spagobi" type="javax.sql.DataSource"/>   
    <ResourceLink global="spagobi_resource_path" name="spagobi_resource_path" type="java.lang.String"/>   
    <ResourceLink global="spagobi_sso_class" name="spagobi_sso_class" type="java.lang.String"/>   
    <ResourceLink global="spagobi_host_url" name="spagobi_host_url" type="java.lang.String"/>   

9. Now need to modify files at path: "apache-tomcat-7.0.61\webapps\SpagoBI\WEB-INF\classes\"

10. modify file "apache-tomcat-7.0.61\webapps\SpagoBI\WEB-INF\classes\hibernate.cfg.xml"

 remove HSQLdialect from file <property name="hibernate.dialect">org.hibernate.dialect.HSQLDialect</property>  
 and add postgres dialect <property name="hibernate.dialect">org.hibernate.dialect.PostgreSQLDialect</property> (at line number 17)  

11. modify file "apache-tomcat-7.0.61\webapps\SpagoBI\WEB-INF\classes\jbpm.hibernate.cfg"
Add postgres dialect at line number 19

 <property name="hibernate.dialect">org.hibernate.dialect.PostgreSQLDialect</property>  

12. modify "apache-tomcat-7.0.61\webapps\SpagoBI\WEB-INF\classes\" file
Comment line number 31 (using #) for HSQL delegate
uncomment line number 37 for POSTGRESDelegate

13. Dont forget to create enviornment variable of JAVA_HOME [upto path java-jdk] and path entry upto "bin" folder.

14. Set variable "JAVA_OPTS" in "catalina.bat" file
open file and add below line just above the line "rem Execute Java with the applicable properties"
set "JAVA_OPTS=%JAVA_OPTS% -Xms2048m -Xmx2048m -XX:PermSize=512m -XX:MaxPermSize=512m"


  1. Please could you help? I have tomcat 8.0.27 and it keeps pulling in tomcat 7.0? my localhost:8080/spagobi -displays a blank page? I have searched everywhere and your documentation is the best. please help.

    1. please use tomcat 7 , cause spagobi have some compatibility issue with tomcat server... you need to change server.xml and update your IP as per your machine

  2. Please, do I need to install boncode_tomcat connector?

  3. In my knowledge we don;t have to use boncode_tomcat connector!!

  4. Thank you so much for responding.
    Please, are you saying to use tomcat 7 standalone server with spagobi 5.1? or use the tomcat 7 version which comes with spagobi 5.1 all-in-one? thank you again. you are extremely knowledgeable. -this install is for windows server

  5. Please, are you saying to use tomcat 7 standalone server with spagobi 5.1? or use the tomcat 7 version which comes with spagobi 5.1 all-in-one? thank you again. you are extremely knowledgeable. -this install is for windows server

  6. Yes Standalone server
    - Download apache tomcat 6/7
    - download All-In-One spagobi 5.0/5/1
    - Extract webapps folder from spagobi and move it to apache tomcat

    i configured same on windows7

  7. wow. thank you. please, did you have problems starting up local service for apache tomcat?

  8. I got it. I have to click tomcat8w, click> java (tab) and adjust the memory size. Thank you so much for your guidance and support.

  9. any time!!!!!!! ...
    ur error seems to be related to memory allocation .. i have mentioned in point 14, for this you can also achieve the same by updating your catalina.bat file

  10. Hi, I tried your configuration for SpagoBI 5.0. but when I tried to open localhost:8080/SpagoBI after restart, it leads me to white blank page instead. fyi, I don't have apache tomcat in my PC so it relies on tomcat SpagoBI provided. please help..

    1. Check the logs of tomcat, what error it is giving? Thanks,Gurjeet


web stats