Clarity

 View Only
Expand all | Collapse all

Services query

  • 1.  Services query

    Posted Sep 08, 2020 06:39 AM
    I have done a fresh install of 15-8-1 on a new Win Server 2016.
    The build was successful in so far as I can see.

    I can see the niku server and beacon services installed and running.
    This may be a very basic question but I cannot seem to deploy or add the APP and BG services however.

    I have my JAVA_HOME and NIKU_HOME variables set in environmental variables.

    But the service command is not being recognized as an internal command etc in command prompt.
    This is probably something very basic...

    JAVA_HOME = C:\Java\jdk-11.0.6
    NIKU_HOME = C:\niku\clarity

    Path: %NIKU_HOME%\bin;%JAVA_HOME%\bin;%SystemRoot%\system32;%SystemRoot%;%SystemRoot%\System32\Wbem;%SYSTEMROOT%\System32\WindowsPowerShell\v1.0\;C:\Program Files\Amazon\AWSCLI\bin\

    ------------------------------
    Team Lead, IT Infra
    Pramerica Systems Ireland
    ------------------------------


  • 2.  RE: Services query

    Broadcom Employee
    Posted Sep 08, 2020 06:59 AM
    App and BG will come up only if you have configured the CSA with database details as APP and BG will need database connectivity.

    ------------------------------
    Thanks & Regards
    Suman Pramanik
    Sr. Principal Support Engineer | Customer Success & Support, Enterprise Software Division
    Broadcom
    ------------------------------



  • 3.  RE: Services query

    Posted Sep 08, 2020 07:18 AM
    Thank you Suman.

    It has been quite a while since I installed and configured Clarity! I will populate the relevant DB info the CSA and then retry deploying services.

    ------------------------------
    Team Lead, IT Infra
    Pramerica Systems Ireland
    ------------------------------



  • 4.  RE: Services query

    Broadcom Employee
    Posted Sep 08, 2020 07:39 AM
    You are welcome

    ------------------------------
    Thanks & Regards
    Suman Pramanik
    Sr. Principal Support Engineer | Customer Success & Support, Enterprise Software Division
    Broadcom
    ------------------------------



  • 5.  RE: Services query

    Posted Sep 14, 2020 05:14 AM
    Hi Suman,

    so I have tried to configure the database via the CSA.

    But when I start services I see this in the logs:

    ERROR 2020-09-14 04:40:59,621 [localhost-startStop-1] niku.union (none:none:none:none) Clarity 15.7.0.212 failed to initialize.
    com.niku.union.config.ConfigurationException: The application failed to start because of a database configuration problem. Please review the application log for specific error information.

    in admin log:

    FATAL 2020-09-14 04:40:59,105 [main] union.persistence Failed to initialize Context properties
    9/14/20, 4:40 AM (admin) java.sql.SQLInvalidAuthorizationSpecException: [CA Clarity][SQLServer JDBC Driver][SQLServer]Login failed for user 'niku'.

    I don't know why the login for niku is failing. I just restored the base db image for sql server that comes with the Clarity installers.



    ------------------------------
    Team Lead, IT Infra
    Pramerica Systems Ireland
    ------------------------------



  • 6.  RE: Services query

    Posted Sep 14, 2020 05:35 AM
    Are there any permissions I need to grant to 'niku' after I restore the base image?

    I filled in the database info in the databases tab in CSA as below:

    Vendor: MSSQL

    Specify URL: jdbc:clarity:sqlserver://DBServerName:1433;DatabaseName=niku;InsensitiveResultSetBufferSize=0;ProgramName=Clarity;DateTimeInputParameterType=dateTime

    Also tried the DB Server's IP Address:1433

    Left niku details as they are? (Is there a default niku password I need to specify on fresh installs?)

    When I save, the status remains 'Unavailable' and when I try running the admin general upload-config on the NSA server that is when I get the login falied for niku error message.

    ------------------------------
    Team Lead, IT Infra
    Pramerica Systems Ireland
    ------------------------------



  • 7.  RE: Services query
    Best Answer

    Posted Sep 14, 2020 11:30 AM
    I ususally delete the old niku and

    use niku
    go

    sp_addlogin @loginame = 'niku'
    , @passwd = 'Clarity15'
    , @defdb = 'niku'




    USE niku

    ALTER USER niku WITH LOGIN=niku

    USE master
    GRANT VIEW SERVER STATE to niku

    ALTER DATABASE niku
    SET ARITHABORT ON
    ALTER DATABASE niku
    SET ANSI_NULLS ON
    ALTER DATABASE niku
    SET QUOTED_IDENTIFIER ON


    EXEC SP_DBCMPTLEVEL niku, 130

    ALTER DATABASE niku
    SET READ_COMMITTED_SNAPSHOT ON



    sp_configure 'remote query timeout',0


    reconfigure with override

    The same for the DWH user


  • 8.  RE: Services query

    Posted Sep 14, 2020 11:33 AM
    Sangeet gives another approach in his blog
    https://letstalkclarity.blogspot.com/2008/07/6-sql-server-2005-configuration-for.html


  • 9.  RE: Services query

    Posted Sep 15, 2020 03:36 AM
    Thank you Martti.

    I executed the commands as you recommended and the db configuration is now complete and showing as 'Available' in the CSA.

    ------------------------------
    Team Lead, IT Infra
    Pramerica Systems Ireland
    ------------------------------



  • 10.  RE: Services query

    Posted Sep 15, 2020 05:02 AM
    So that solved your problem and you saved it for the next time?