The new SpagoBI (version 3.6.0) – Installation instructions and Troubleshooting

SpagoBI released their new version i.e. 3.6.0 with more enhancements and bug fixes on Oct 22 last month. This tool is becoming more popular worldwide now, and user will get the new version more attractive and stronger from the last version. You can get the release notes at , which will help you to know the changes and enhancements done in this version.

Easy way to install from windows installer

  1. Download “” from
  2. Extract the zip file in your preferred location and run the setup file i.e. SpagoBI.exe.
  3. Follow the setup instructions to complete the installations.
  4. Login into the server at http://localhost:8080/SpagoBI/ with biadmin / biadmin and play with the examples. This installation will work with HSQL and it has examples for different reporting engines.

Notes: After you install SpagoBI with sample data, you can configure it to work with external database. Please find mysql configuration steps in sections below.

Manual installation on Windows/Linux from All-In-One package:

  1. Download “” from
  2. Extract the zip file in your preferred location and run the startup fileWindows: run the batch file i.e. /bin/SpagoBIStartup.bat (You should have admin permission or, run the cmd through administrator)Linux: run ./ from inside /bin folder (Run it from sudo command or, root account)
  3. Login into the server at http://localhost:8080/SpagoBI/ with biadmin/biadmin and play with the examples.

Notes: After you install SpagoBI with sample data, you can configure it to work with external database. Please find mysql configuration steps in sections below.

Configure external database MySQL:

  1. Install SpagoBI Metadata DB (MySQL)
    1. Install MySQL 5.1 or, later.
    2. Download “mysql-dbscript-3.6.0” from
    3. Create a mysql database named “spagobi” and import the schema from .sql file downloaded above with following command:
      mysql –u<username> –p<password>  spagobi < MySQL_create.sql
      mysql –u<username> c –p<password>  spagobi < MySQL_create_quartz_schema.sql
  2. Configure data sources
    • Open /conf/server.xml and add a new Data Source, fragment of XML under <GlobalNamingResources> tags,

e.g. <Resource auth=”Container” driverClassName=”com.mysql.jdbc.Driver” maxActive=”20″        maxIdle=”10″ maxWait=”-1″ name=”jdbc/spagobi” password=”root” type=”javax.sql.DataSource” url=”jdbc:mysql://localhost/spagobi” username=”root”/>

This is the Connection poll for SpagoBI metadata.

    • We can add more data sources for each data warehouse we have.

e.g. <Resource auth=”Container” driverClassName=”com.mysql.jdbc.Driver” maxActive=”20″ maxIdle=”10″ maxWait=”-1″ name=”jdbc/foodmart” password=”root” type=”javax.sql.DataSource” url=”jdbc:mysql://localhost/foodmart” username=”root”/>

    • Comment all previous data sources which were present for HSQL.
    • Make sure the context information for data sources defined above are embedded in /webapps/SpagoBI\META-INF /context.xml. You can insert this xml in server.xml if you prefer.

<ResourceLink global=”jdbc/spagobi” name=”jdbc/spagobi” type=”javax.sql.DataSource”/>

<ResourceLink global=”jdbc/foodmart” name=”jdbc/foodmart” type=”javax.sql.DataSource”/>

  1. Configure DBMS Type
    • We must configure DBMS type used by SpagoBI under \webapps\SpagoBI\WEB-INF\classes\hibernate.cfg.xml

                          <property name=”hibernate.dialect”>org.hibernate.dialect.MySQLDialect</property>


                           <property name=”hibernate.dialect”>org.hibernate.dialect.SQLServerDialect</property>

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

                           <property name=”hibernate.dialect”>org.hibernate.dialect.Oracle9Dialect</property>

                           <property name=”hibernate.dialect”>org.hibernate.dialect.IngresDialect</property>

                           <property name=”hibernate.dialect”>org.hibernate.dialect.HSQLDialect</property>

                           <property name=”hibernate.dialect”>org.hibernate.dialect.DB2400Dialect</property>       


    • Then we would need to configure hibernate dialect for JBPM workflow engine: look at file /webapps/SpagoBI/WEB-INF/classes/jbpm.cfg.xml, there is a reference to JBPM hibernate file:

<string name=’resource.hibernate.cfg.xml’ value=’jbpm.hibernate.cfg.xml’ />

May be you read jbpm.hibernate.cfg.hsql.xml instead of jbpm.hibernate.cfg.xml,           jbpm.hibernate.cfg.hsql.xml is the hibernate file suitable for HSQLDB; if you are not using HSQLDB change resource.hibernate.cfg.xml property to jbpm.hibernate.cfg.xml.

    • Then, edit /webapps/SpagoBI/WEB-INF/classes/jbpm.hibernate.cfg.xml and change the following as according to your database server.

<property name=”hibernate.dialect”>org.hibernate.dialect.MySQLDialect</property>

    • At last you have to configure Quartz scheduler engine: edit /webapps/SpagoBI/WEB-INF/classes/ you will read something like:

# job store delegate class –

# Hsqldb delegate class


# Mysql/Ingres delegate class


# Postgres delegate class


# Oracle delegate class


Uncomment the job store delegate class suitable to your database server and comment all others.

  1. Database schema configuration

When creating SpagoBI metadata tables, they should be put into the default schema of the JDBC connection’s user.  In case this is not possible, you should edit hibernate.cfg.xml adding the following line:

<property name=”hibernate.default_schema”><name of the schema></property>

– modify SpagoBI/WEB-INF/classes/jbpm.hibernate.cfg.xml adding the following line:

<property name=”hibernate.default_schema”><name of the schema></property>

                Notes: you can skip this step.

  1. Restart the SpagoBI server, login into the server at http://localhost:8080/SpagoBI/ with biadmin / biadmin. This installation will work with MySQL , meta data.

Upgrade from older version to new version (Simple Upgrade):

  1. Stop the SpagoBI Server.
  2. Remove or, move (for backup purpose) your current SpagoBI installation folder.
  3. Install the latest version you want to install, through steps in section “Easy way to install from windows installer” or, “Manual installation on Windows/Linux from All-In-One package”.
  4. Download the upgrade script for MySQL from .
    Notes: Make sure you have downloaded the required version of script.
  5. Run the db script downloaded above and the upgrade is done.
  6. Start the SpagoBI server, login into the server at http://localhost:8080/SpagoBI/ with biadmin / biadmin. This installation will work with MySQL  upgrade version meta data.

Notes: This upgrade works well in case you have not done any personalization changes in installation files of older version.

Troubleshoot/Help for the issue I came across during installation: 

  1. Very first error we got was “Address already in use” as the shutdown port 8005 was already being used on the system. Changed the port to 7005 in server.xml (located under conf folder) and it worked.
  2. We came across another issue where everything were perfect but we were not able to see the login screen and it was showing an error as follows:

[main] 28 Dec 2011 09:13:46,072 ERROR it.eng.spagobi.commons.SingletonConfigCache.<init>:36 – The table sbi_config is EMPTY

[main] 28 Dec 2011 09:13:46,074 ERROR it.eng.spagobi.commons.SingletonConfigCache.get:53 – The property ‘SPAGOBI.DATE-FORMAT-SERVER.format’ doens’t have any value assigned, check SBI_CONFIG table

[main] 28 Dec 2011 09:13:46,074 ERROR it.eng.spagobi.commons.SingletonConfigCache.get:53 – The property ‘SPAGOBI.TIMESTAMP-FORMAT.format’ doens’t have any value assigned, check SBI_CONFIG table

[main] 28 Dec 2011 09:13:48,272 ERROR it.eng.spagobi.commons.initializers.metadata.MetadataInitializer.init:

163 – Error while initializing metadata

We explored the forums and different channels and came to know that this is a bug logged into Jira and they have uploaded a patch to be downloaded at
We downloaded the patch and extracted it into ……./webapps/SpagoBI/WEB-INF/classes, the server is working fine now.

3. While working with linux, once unzipped the “All-in-one….”  Package and tried to start spagoBI server with the command, sudo sh, I got a access denied error. I used chmod command and gave all permission to the folder as follows:

          chmod 777 –R SpagoBI-DEMO-3.5 and it worked.

51 thoughts on “The new SpagoBI (version 3.6.0) – Installation instructions and Troubleshooting

  1. By default, SpagoBI comes with HSQL database configuration, where all our meta data (data about documents created in SpagoBI, etc.) is stored in HSQL.

    Step above describes the process to configure MySQL so that all the meta data can be stored in MySQL database.

    There is no harm in not using MySQL configuration, you can still use the default HSQL configuration.

    • hi rakesh can you help me to show how to add schema to spagobi? i already make my schema using schema workbench
      thank you for your help

  2. Hi Rakesh,

    First of all thamks for the article

    I am trying to download SapgoBI from ow2forge (http://forge.ow2.og/projerct/showfiles.php?group_id=204) but it gives me an error as,


    You don’t have permission to access /spagobi/ on this server.
    Apache/2.2.9 (Debian) mod_ssl/2.2.9 OpenSSL/0.9.8g Server at Port 80

    Can you please helpme…

  3. Hi Rakesh,

    Such a coincidence, i posted in your site and it started working…i am able to download now…will come back to u for any issues further…hope u will help me in getting this done…Thank you

  4. Hi Rakesh,

    thanks for putting this walkthrough together. I’m trying to set up SpagoBI 3.6.0 using Mysql 5.5 and Java 1.6.

    I configured all files just like your guide and I can’t start it up at all. I’ve upgraded the mysql-connector driver to the one that came with my MySQL installation to avail. I wonder if you know what else I could do?

    I’ve also downloaded the .zip file from the SpagoBI JIRA and still had no luck.

    Do you reckon I should be using an older version of MySQL?

    Any help will be much appreciated.

    • Got it. The problem had nothing to do with Spago itself – it was a bad configuration on the MySQL side :)

  5. Hi Rakesh i have installed SpagoBI 3.6 in my Ubuntu and when i give the URL as http://localhost:8080/SpagoBI/ it gives an error as,

    HTTP Status 404 – /SpagoBI

    type Status report

    message /SpagoBI

    description The requested resource (/SpagoBI) is not available.

    Apache Tomcat/6.0.35

    Any resolution is highly appreciated.
    Thank u

    • Hi Rakesh,

      I need to develop dashboard and charts using SpagoBI. I am completely new to this tool and just got stuck in very begining itself.
      I downloaded SpagoBIDemo and SpagoBIStudio.I have MySQL installed in my system.

      Please tell me what else I need to download and install and please guide me for the initial set up and configuration.


      • Hello Mahesh,

        That is sufficient to develop dashboard and charts. I would request you to configure the latest SpagoBI with the help of this blog. Please let me know in case you face any issue.


  6. I worked with Goutham to help him to setup SpagoBI. Sharing the summary so that you could troubleshoot your problem youself.

    1. His first problem was from tomcat, where there were two other tomcat running on the system and that is why he was getting address already in use. We killed other tomcat, and ran it through SpagoBI, it worked.

    2. Then he faced problem, when configuring external data source i.e. MySQL. We replaced the jdbc driver for MySQL with the latest connector J, and it worked.


  7. Hi,

    I want to use Postgres 9.2.x, please comment the following setup steps:

    1. edit server.xml,

    // is the value of type correct?
    // is the value of class name correct?
    // is the name correct?
    // the postgres is installed in the same machine, port=5432, dbname=spagobi owned by user spagobi (ubuntu 12.04, postgresql 9.2)


  8. Hi I am getting an error like
    Could not open the editor: Impossible to initialize editor [it.eng.spagobi.meta.querybuilder.ui.editor.SpagoBIDataSetEditor]: An error occur while generating JPA jar
    when I supposed to write a query in SpagoMeta. pls can u give the solution for this.

  9. I have follows all the instructions as described, but Still I got an error.

    My Environment are:
    OS : Windows 7
    jdk : 1.6.0_24
    mysql: 5.6
    spagobi 3.6

    I successfully install spagobi 3.6 with hsql and its running fine.
    Now I want to use mysql as the spagobi repository. I’ve follows all the steps above but in the end i got the error as describe in the troubleshoot.

    I’ve download the patch as suggested, and extract it (domains.xml) in …/webapps/spagobi/WEB-INF/classes
    but still i am unlucky…

    Could you please advice me more.

  10. Sabri,

    The troubleshoot information is from earlier version, you should not get this error with 3.3.6 in case you changed the configuration as according to 1st, 2nd and 3rd point of section “Configure external database MySQL”.

    Please see if you have changed according to those steps in blog.

    If you still found that you are in trouble, send me your catlina.out at, I will try to help you install it.


  11. Hello Sravan,

    I would request you to describe your issue bit further. I need basic information such as which version of SpagoBI you are using, whether you are running SpagoBI with HSQL or, you are running it with MySQL meta data, what are you trying to do when you get this error, etc.


  12. Hi Rakesh:
    I want to do everything in MySQL – BAM, Foodmart, MetaData and main SpagoBI. Do you have everything in one neat zip file that we all can use? This flipping between HSQL and MySQL is confusing. It took me forever to figure out that the Metadata and other goodies were in HSQL and just the main SpagoBI stuff was in MySQL. I kept getting blank screens etc. until I realized I had no metadata. The install process is a bit fragmented.

    • Sorry Dave, I just seen your message as I went through a surgery recently.

      Yes, you can disable HSQL and use MySQL for everything. As you have the .sql files, I hope you already have installed everything with MySQL.


    • Hi, Dave,

      Quick question for you, as I’m just getting started in SpagoBI. I’ve been trying to figure out what the purpose of the bam database is (looking through forums) and trying to find the script to create it, but have yet to find anything. I have one hypothesis (related to eBAM) but have a feeling that is incorrect. Could you (or someone else) shed some light on that?

      Thanks in advance,


      • Hello Matt,

        I don’t have much knowledge about BAM, but let me try to guide you.

        BAM is Business Activity Monitoring, where you can monitor your day to day business activities. You can get all the information regarding BAM (eBAM from eclipse) at You will also get documentation on this link.

        I would request you to share your views about BAM, once you study it in bit detail.


        • Hi, Rakesh,

          Thanks for the clarification. When I get a chance to look into the BAM (eBAM) part of the system, I’ll definitely post my thoughts. Just one more thing – am I correct in understanding that, technically, the BAM portion is not necessary to run the rest of the suite? (Essentially, it is an add-on, right?)

          Thanks in advance,


  13. Hallo Rakesh,

    Today i was intalled SpagoBI 3.6 on my PC. But it return some error when run the SpagoBI server. The error is :

    [main] 08 Apr 2013 14:35:18,625 ERROR it.eng.spagobi.commons.initializers.metadata.MetadataInitializer.init:96 – An unexpected error occured while initializing metadata
    it.eng.spagobi.utilities.exceptions.SpagoBIRuntimeException: Ab unexpected error occured while initializeng Engines

    can you give some advice.



  14. Hello Rakesh,

    java.lang.NumberFormatException: For input string: “” at java.lang.NumberFormatException.forInputString( at java.lang.Integer.parseInt( at java.lang.Integer.( at at at it.eng.spago.dispatching.module.DefaultPage.invokeServiceBusiness( at it.eng.spago.dispatching.module.DefaultPage.nextStep( at it.eng.spago.dispatching.module.DefaultPage.service( at it.eng.spago.dispatching.module.ModuleCoordinator.service( at it.eng.spago.dispatching.httpchannel.AdapterHTTP.service( at javax.servlet.http.HttpServlet.service( at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter( at org.apache.catalina.core.ApplicationFilterChain.doFilter( at it.eng.spagobi.commons.filters.ProfileFilter.doFilter( at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter( at org.apache.catalina.core.ApplicationFilterChain.doFilter( at it.eng.spagobi.commons.filters.SpagoBICoreCheckSessionFilter.doFilter( at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter( at org.apache.catalina.core.ApplicationFilterChain.doFilter( at org.apache.catalina.core.StandardWrapperValve.invoke( at org.apache.catalina.core.StandardContextValve.invoke( at org.apache.catalina.core.StandardHostValve.invoke( at org.apache.catalina.valves.ErrorReportValve.invoke( at org.apache.catalina.core.StandardEngineValve.invoke( at org.apache.catalina.connector.CoyoteAdapter.service( at org.apache.coyote.http11.Http11Processor.process( at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process( at$ at

    This is the error msg i see when I click on already added datasource.
    I am not able to fix it. Posted on JIRA community too but no response. Could you please help me.?
    I am using:
    OS: Ubunutu 12.04 (64bit)
    WS: Apache 6.0.18
    DB: MySql
    Java: open-jdk-7 (installed from apt-get).
    I guess there is some issue with Data Source to load, as I am able to create JDBC connectivity from eclipse. I can fire a query from data set and get desired results too.
    Also it worked fine before I tried to add mysql datasource, using the configuration you have shared on this page.
    I also think some scripts are not loading up as I log into bidemo nothing appears.
    Thank you again.

    • Sorry Ameya, but I couldn’t get you properly. Do you have issue while configuring SpagoBI with MySQL meta data? If yes, please send me your server.xml and SpagoBI.log files.


  15. Rakesh,

    Sorry to bother you – I wanted to see if I could clarify a point that Dave may have made above with respect to the meta database after switching to MySQL. Like Dave, I noticed that a number of things weren’t present in the transferred database – specifically, in this case, the Engines. Granted, some of them are connected to Data Sources, so I wouldn’t necessarily have expected all of them. However, is it normal to need to essentially “rebuild” all of the Engines in the new Meta database?



    • Hello Matt,

      Before you shift your metadata to MySQL, all your data is stored in HSQL. And hence you will not see any sample reports which comes with demo application.

      But, I don’t think, you will loose any data regarding engine configuration as it is part of the sql script you download from SpagoBI for your version of software.

      For old data sources, you would need to create again through interface e.g., Resources->Data Sources.

      I hope, I have answered your query.


      • Even I’m facing the same issue. I can’t see the engines after moving the metadata to MySQL. How do we rebuild the engines ?

      • Again, thanks, Rakesh.

        Interesting…looking at my MySQL environment I don’t actually have any of them. Just documented all of them from the HSQL side so that I could rebuild any of them that I need on the MySQL side.

        I also looked through the MySQL_create.sql file from the MySQL version of the DB (v3.6), and don’t see any INSERT statements that would seem to match any of the fields that would be present on an Engine definition (i.e., something like the Description or Label fields). In fact, there didn’t appear to be any INSERT statements at all (essentially all just DDL) in the MySQL_create.sql.

        So this leads me to two points:
        a) Am I missing a .sql file somewhere? (I’ve only seen reference to one.)
        b) Could this perhaps be related to the problems initializing MetaData (the Error 163 you mention above)?

        I apologize for all of the questions, and again, thanks very much for your time and thoughts!!!


  16. Hi Rakesh,

    I followed the instructions here to change the metadata to MySQL and it worked fine and I could open SpagoBI and work. But the HomePage has disappeared from the UI. Is that a bug or is there a way to bring it back ? Please help.

  17. Hi Rakesh,

    please could you assist me with an error that I get when running bin/ on SpagoBI version 3.5 and 3.6.

    [root@xxx bin]# ./
    Using CATALINA_BASE: /opt/spago
    Using CATALINA_HOME: /opt/spago
    Using CATALINA_TMPDIR: /opt/spago/temp
    Using JRE_HOME: /usr/lib/jvm/java-1.6.0-openjdk.x86_64
    ERROR: transport error 202: bind failed: Address already in use
    ERROR: JDWP Transport dt_socket failed to initialize, TRANSPORT_INIT(510)
    JDWP exit error AGENT_ERROR_TRANSPORT_INIT(197): No transports initialized [../../../src/share/back/debugInit.c:708]
    FATAL ERROR in native method: JDWP No transports initialized, jvmtiError=AGENT_ERROR_TRANSPORT_INIT(197)
    /opt/spago/bin/ line 359: 7085 Aborted (core dumped) “$_RUNJAVA” $JAVA_OPTS -Djava.endorsed.dirs=”$JAVA_ENDORSED_DIRS” -classpath “$CLASSPATH” -Dcatalina.base=”$CATALINA_BASE” -Dcatalina.home=”$CATALINA_HOME””$CATALINA_TMPDIR” org.apache.catalina.startup.Bootstrap “$@” stop
    Killing: 6903



  18. Hi Rakesh,

    I having problem installing spagobi 3.6 on windows server 2003.
    I have install spagobi using windows installer .exe file.
    However it show error

    HTTP Status 404 – /SpagoBI

    type Status report

    message /SpagoBI

    description The requested resource is not available.
    Apache Tomcat/6.0.37

    Could you help me out, what i am doing wrong here.

  19. Hi Rakesh,

    I couldn’t access the “http://localhost:8080/SpagoBI” after installing the SpagoBI 3.6. It keeps on loading but nothing comes up on the browser.

    OS : Windows 7
    jdk : 1.7.0_21
    mysql: 5.0
    spagobi 3.6


  20. We are facing issues in getting our Cube to show while creating Analytical document usig JPalo. Questions :-
    (a) Is it necessary to use Schema Workbench to create the Cube.xml or can we hand-code using the Foodmart.xml template ?
    (b) When I click on Template Build, it shows Foodmart Cube as well as Dimensions, Measure. But it does not show my Cube Dimensions / Measure

  21. Hello,

    I just installed SpagoBI 3.6.0 and I can not seem to execute the SpagoBIStartup.bat under Windows. Could you please help me.

  22. Hi Rakesh,

    Your article on installation and troubleshooting was a wonderful and helpful compilation.

    I’m trying to install SpagoBI 3.6. First i tried with all default options (demo db and HSQL). It worked. Now i’m trying to make it work with MySql db. I followed the instructions for changing the configs. Still i’m not able to make it work.

    It would be of great help if you can share your expertise in troubleshooting my issue. Let me know your email. I will send the log files.

    My Environment are:
    OS : Windows 7 64.bit
    jdk : 1.7
    mysql: 5.6
    spagobi 3.6


  23. Hi,

    I have downloaded spagoBI and need help to start using it. I tried to run it thru start up as instruced but when I click on Start Spago a cmd prompts and goes….
    Pls help me use it, i am not a technical user. I am using it as a business user

    Thanks in advance


    • Hi Rakesh,
      I am trying to deploy datamart from SpagoBIStudio 4.0 to SpagoBI-Server for QBE.How to deploy datamart exactly?
      Steps I have taken:
      Created a general project in SpagoStudio 4.0,
      Added a SpagoBI Model to it.
      Made Bussiness Model.
      On right clicking it, there is a option create -> datamart.
      When I click on it, it asks place to export JPA mappings.
      I manually transferred files from that place to SpagoBIServer ->resources ->qbe -> datamarts ->(create manually a folder there )and copy datamart.jar and cfields_meta.xml manually , but this approach does not work? PLEASE HELP…

  24. Hello, please can you help me with setting up Spagobi for creating graphical BI reports with my data in both mysql and postgres. Is there any documentation for Spagobi version 4? Can you help me with setting up an adhoc reports too?


  25. Hello,

    Could anyone help me with transferring the entire spagobi system to oracle DB rather than uing HSQLDB. Please.

    Also, can someone help me with creating metadata in spagobi fr reports and charts too please.

  26. Hi,
    I am installed all in one spagobi i can run mobile engine it will display the menus but when i am click the button like charts, olap ,qbe,or any other menu it will display the empty page can any one help me how to solve the problem

  27. Hi Frnds,
    I had installed spagobi studio , spagobi meta ,Spagobi Server when i had create the template in studio and execute in server it will not dispaly the dataset When i click the models inside of mydata it will not allow to create the quries and charts, And one more doubt when i can goto spagobimobileengine it will dispaly the empty screen only logout button will be display how can i solve this problem

  28. hi frnds i am using mysql db in spagobi. i can download the file and run it will run properly but when i am going to change HSQL into MySql it willnot display the menus in mobileengine and also i cannot create chart report etc.. in spagobi server
    what is the problem can any one help me………………

Leave a Reply

Your email address will not be published. Required fields are marked *

one + 7 =

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>