Clarity

Expand all | Collapse all

Jaspersoft Installation Query

  • 1.  Jaspersoft Installation Query

    Posted Mar 24, 2015 10:11 AM

    Hi all,

     

    just reviewing the prerequisites for this.

    I have installed Java and Tomcat, set java_home and PATH variable.

     

    "Create a database and a user for Jaspersoft"

     

    Where do I create this database user? On my DB server?  We use SQL 2008R2. When I look there I can see a new ReportServer db, do I create my Jaspersoft user here?



  • 2.  Re: Jaspersoft Installation Query

    Broadcom Employee
    Posted Mar 24, 2015 10:19 AM

    Hi CMCN1982,

     

    You can use SQL server or Oracle to hold the metadata of jasper soft, in-case you use SQL 2008R2. you have to upgrade to Microsoft SQL Server 2012 as Jasper soft supported with only that. You have to create a database for jasper soft and grant few privileges to that schema.

     

    SQL Server

    Follow these steps:

    1. Create a database user. For example, PPM_JASPERSOFT.

    2. Alter database ppm_jaspersoft set arithabort On.

    3. Alter database ppm_jaspersoftsoft set ansi_nulls On.

    4. Alter database ppm_jaspersoft set quoted_identifier On.

    IF (SELECT (CAST(LEFT(CAST(SERVERPROPERTY('ProductVersion') AS VARCHAR(20)), CHARINDEX('.', CAST(SERVERPROPERTY('ProductVersion') AS VARCHAR(20)), 1) - 1) AS INTEGER))) = 10

    BEGIN

    exec sp_dbcmptlevel 'PPM_JASPERSOFT', @new_cmptlevel=100

    END

    IF (SELECT (CAST(LEFT(CAST(SERVERPROPERTY('ProductVersion') AS VARCHAR(20)), CHARINDEX('.', CAST(SERVERPROPERTY('ProductVersion') AS VARCHAR(20)), 1) - 1) AS INTEGER))) = 11

    BEGIN

    exec sp_dbcmptlevel 'PPM_JASPERSOFT', @new_cmptlevel=110

    END

    IF NOT EXISTS (SELECT 'yes' FROM syslogins WHERE LOWER(name) = LOWER('PPM_JASPERSOFT') )

    BEGIN

    exec sp_addlogin 'PPM_JASPERSOFT','password1234','PPM_JASPERSOFT','us_english'

    END

    Set the isolation level to read committed snapshot for SQL Server 2005.

    Note: Make sure that the user can access the system views. For example, syslockinfo, sysindexes.

    begin

    exec ('alter database PPM_JASPERSOFT set read_committed_snapshot on')

    exec ('grant VIEW SERVER STATE to PPM_JASPERSOFT')

    exec ('ALTER LOGIN PPM_JASPERSOFT WITH CHECK_POLICY=OFF')

    end

    USE PPM_JASPERSOFT.

    The schema owner is referenced when executing functions in SQL Server and is hard-coded to PPM_JASPERSOFT. However, the login name can differ.

    exec sp_grantdbaccess 'PPM_JASPERSOFT','PPM_JASPERSOFT'

     

    Installation Guide

    exec sp_defaultdb 'PPM_JASPERSOFT', 'PPM_JASPERSOFT'

    exec sp_addrolemember 'db_owner', 'PPM_JASPERSOFT'

     

    And you are all good to go ahead.

     

    Regards

    Suman Pramanik



  • 3.  Re: Jaspersoft Installation Query

    Posted Mar 24, 2015 01:26 PM

    Thanks, that kind of in depth info is more than welcome.

    Just wodnering....

    When you say

    in-case you use SQL 2008R2. you have to upgrade to Microsoft SQL Server 2012

    Can you run both CA PPM and Jaspersoft for single user testing purposes on SQL2012R2 Express?



  • 4.  Re: Jaspersoft Installation Query

    Broadcom Employee
    Posted Mar 25, 2015 03:17 AM

    Hi Urmas,

     

    Yes, I am actually testing Jasper, data ware house as well as Clarity on a single Box (however that is just a lab for me)

     

    Regards

    Suman Pramanik



  • 5.  Re: Jaspersoft Installation Query

    Posted Apr 09, 2015 07:33 AM

    Hi Suman,

     

    one of the pre-requisites for installing Jaspersoft also says that I must ensure that I have set the organisation name in the NSA.

    I am in my NSA, and I have been looking for the location where I would set this but cannot find it.

     

    Can you please help? Thanks



  • 6.  Re: Jaspersoft Installation Query
    Best Answer

    Posted Apr 09, 2015 07:36 AM

    Organization can be set using CSA -from Properties -> Reporting -> Report Server : Jaspersoft section.

     

    Thanks,

    Namita



  • 7.  Re: Jaspersoft Installation Query

    Posted Apr 09, 2015 07:37 AM

    Thanks Namita! It was staring right at me!



  • 8.  Re: Jaspersoft Installation Query

    Posted Apr 09, 2015 07:39 AM

    Great :-)

     

    Thanks,

    Namita Mishra



  • 9.  Re: Jaspersoft Installation Query

    Posted Apr 09, 2015 07:38 AM

    Hi CMCN,

     

    Its under the tab Reporting -> section Report Server: Jaspersoft, field Organization Name.

     

    Regards

    Georg



  • 10.  Re: Jaspersoft Installation Query

    Posted Apr 09, 2015 07:45 AM

    Thanks Georg!



  • 11.  Re: Jaspersoft Installation Query

    Posted Apr 09, 2015 08:37 AM

    Some more assistance required!

     

    I have set up my database and user -> PPM_JASPERSOFT, granted access, set login name and password etc

     

    then run install.bat

     

    Standalone

    MSSQL

     

    SQL Server DB Hostname: (I assume this is the name of the server on which I have SQL Server 2012 installed?)

     

    Port: 1433

     

    DB Name: PPM_JASPERSOFT

     

    DB Username: PPM_JASPERSOFT

     

    DB Username Password: xxxxxxxx

     

    I keep getting a connection refused and I'm unsure why?



  • 12.  Re: Jaspersoft Installation Query

    Posted Apr 09, 2015 08:42 AM

    dbconnection.png



  • 13.  Re: Jaspersoft Installation Query

    Posted Apr 09, 2015 08:47 AM

    Hi,

     

    please check whether you can connect with some other tool, e.g. the MSSQL Management Studio.

    The installation does not use any specific connetion tool, so if it works with the MSSQL Management Studio, it works for the installation as well.



  • 14.  Re: Jaspersoft Installation Query

    Posted Apr 09, 2015 09:02 AM

    I'm not sure I follow. In SQL Management Studio I can see this and PPM_JASPERSOFT user is dbowner.

     

    pic1.PNG

    pic2.PNG



  • 15.  Re: Jaspersoft Installation Query

    Posted Apr 09, 2015 09:44 AM

    D'oh!

     

    Got to the bottom of it. Because it was a fresh SQL Server 2012 installation I needed to assign the port number 1433 to the SQL Server Database Engine in the SQL Server Configuration Manager. Once I did this I restarted SQL services and then tried my install again. This time the Jaspersoft Database connected successfully.



  • 16.  Re: Jaspersoft Installation Query

    Posted Apr 09, 2015 09:43 AM

    Just checking, Did you create the ODBC Connection on the Target APP Server and test it prior?