How to install and configure SpagoBI Server 3.3?

  1. Download “All-In-One-SpagoBI-3.3-12222011.zip” from http://forge.ow2.org/project/showfiles.php?group_id=204.
  2. Extract the zip file in your preferred location and Follow readme.txt.
  3. Install SpagoBI Metadata DB (MySQL)
    • Downloaded “mysql-dbscript-3.3.0_12202011.zip” from http://forge.ow2.org/project/showfiles.php?group_id=204.
    • Install MySQL 5.1 or, later.
    • Created a mysql database named “spagobi” and imported the schema from .sql file downloaded above with following command:
    • mysql –u<username> –p<password>  spagobi < MySQL_create.sql
    • mysql –u<username> –p<password>  spagobi < MySQL_create_quartz_schema.sql

4. Then configured it as per the instructions at http://wiki.spagobi.org/xwiki/bin/view/spagobi_server/Installation_v3
or, we can also take other configurations help from http://wiki.spagobi.org/xwiki/bin/view/spagobi_server/Configure_v3

5. Run the server with following steps:

    • Start the command shell, in case you are not aware of your access level, run command shell as an administrator account.
    • Locate the bin folder e.g. D:\SpagoBIServer3.3\SpagoBI-Server-3.3\bin>
    • Now execute the batch file named “SpagoBIStartup.bat”.
    • Login into the server at http://localhost:8080/SpagoBI/

Errors and Solutions

  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).
  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 ‘SPA
GOBI.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 ‘SPA
GOBI.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 http://www.spagoworld.org/jira/browse/SPAGOBI-712.

We downloaded the patch and extracted it into ……./webapps/SpagoBI/WEB-INF/classes, the server is working fine now.

13 thoughts on “How to install and configure SpagoBI Server 3.3?

  1. Hi, I’m beginning with my studies about SpagoBI and I’m happy to find your blog. I see you in SpagoBI’s group of LinkedIn too. I hope you can help me too.

  2. Thanks Márcia, yes I am there on linked-in too. Please let me know in case you find any problem with SpagoBI, I will try my best to help you.

    Regards,
    Rakesh

  3. Rakesh, I have a doubt: In the step 3, in the comand “mysql –u –p spagobi3 < MySQL_create.sql" what mean the "spagobi3"? If you can, send me an email: marcia.neoqav [at] gmail.com

    • Hello Sir,

      I am using SpagoBI open source.
      In this project i am using KPI model.Inside this model i have created KPI for company but after that when i am using Goal Definition i am not understanding how to crack this module.

      If any idea about this please reply immediate.

      Thanks in advance.

      Regards,
      Amit

  4. Sorry It was a typo mistake, it should be as below:

    mysql –u –p spagobi < MySQL_create.sql
    mysql –u –p spagobi < MySQL_create_quartz_schema.sql

    The db name should be spagobi. I have edited my blog accordingly.

    Anyway, now the new version, 3.4 is available and you should try that.

    • Hello Sir,

      I am using SpagoBI open source.
      In this project i am using KPI model.Inside this model i have created KPI for company but after that when i am using Goal Definition i am not understanding how to crack this module.

      If any idea about this please reply immediate.

      Thanks in advanced.

      Regards,
      Amit

  5. Hello Tony,

    Thanks for following my blog.

    I have checked, both the URL mentioned there are accessible. You would need to write the full URL.

    Please find below the same URL:
    1. http://wiki.spagobi.org/xwiki/bin/view/spagobi_server/Installation_v3
    2. http://wiki.spagobi.org/xwiki/bin/view/spagobi_server/Configure_v3#HDataSourceconfiguration

    Please let me know in case of any problem.

    PS: Anyway, I am going to re-write the installation/configuration blog keeping latest version, i.e. 3.5 in mind.

    Regards,
    Rakesh

  6. Rakesh, how are you?
    Well, I have a doubt about the installation:
    If I didnt’t follow the step 3: Install SpagoBI Metadata DB (MySQL). What the result of my installation? What the behavior that I will have?
    How I can see if I the step 3 was made with sucess?
    Thank’s!

  7. Hi rakesh,
    i want to know step by step how to build spagobi 3.6. i have already download the 3.6 src. please tell me step by step how to build the source.

    Thanks,
    Arun S

  8. Hi Rakesh,

    I am new to spagobi (and new to the world of BI and databases in general :-) )

    I created a report using spagoBI 4 and spagostudio.

    My questions are

    1.Is there any way we can create reports without exporting datamodel from spagostudio ie adding datasource and then importing dataset from spagobi server itself? If yes, how ? (i tried this but couldn’t succeed.

    2.Export from spagobi studio works fine for biadmin but when i try to export to biuser/bidemo, i get an error and there is no document under Document Root. Is this a usual behavior or an error ?

    At last, I would say this is really an incredible tool to generate reports (I created a PIE Chart using 1st step)

    Best Regards,
    Chinmay

Leave a Reply

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


1 + = eight

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>