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.

Comments are closed.