Clarity

  • Private Community

  • 1.  Problem on CA PPM 15.2 Installation

    Posted Jun 13, 2017 07:00 PM

    Hello,

    I try to make a new installation of CA PPM 15.2 on Windows Server 2012r2

    I installed Oracle 11g database and created the database and the dwh database from the .db files.

    I installed java (8.101), tomcat (8.5.9) and the CA PPM application on the same server.

    Configured the different properties on the server (CSA, system, database, etc..)

    All the services are started, but when I check the database properties, it appears as unavailable.

     

    the nsa-ca.log show:

        WARN...    Found invalid database connection for local tenant clarity

        ERROR... [http-nio-8090-exec-2] feature.FeatureCache (clarity:admin:-1:none) Failed to build cache for features
                          com.niku.union.persistence.PersistenceException: Error getting a DB connection

     

    I check this thread Problem on CA Clarity 14.3 installation  , and follow the recommended steps of Nika Hadzhikidi, but dídn´t work

     

    Someone had an idea what i´m doing wrong or had a similar problem and solved it?

     

    I do not have install jaspersoft yet, do I must install jaspersoft?
    Thanks for your help
    Julian


  • 2.  Re: Problem on CA PPM 15.2 Installation

    Broadcom Employee
    Posted Jun 14, 2017 07:18 AM

    HI Julian,

     

    To just install PPM you don't need jaspersoft, if the database is showing unavailable then PPM CSA is unable to make a JDBC call to database. Are you able to connect to the database using any SQL client tools like SQL developer.

     

    Regards

    Suman Pramanik 



  • 3.  Re: Problem on CA PPM 15.2 Installation

    Posted Jun 14, 2017 05:23 PM 
    Hello Suman, Yes I have been able to connect to the database using SQL Developer and SQLPlus command line.
    I know that it is not mandatory to install Jaspersoft, although in the thread that I mentioned
    says that it is necessary to configure the URL, so i did it


  • 4.  Re: Problem on CA PPM 15.2 Installation

    Broadcom Employee
    Posted Jun 15, 2017 04:57 AM

    Hi Julian,

     

    I would request you to log a case, we need to see how your database is set up and look into it.

     

    Regards

    Suman Pramanik 



  • 5.  Re: Problem on CA PPM 15.2 Installation
    Best Answer

    Posted Jun 16, 2017 01:27 PM

    Hi Suman,

    I reinstalled everything again and the error was solved.

     

    Thanks



  • 6.  Re: Problem on CA PPM 15.2 Installation

    Broadcom Employee
    Posted Jun 17, 2017 06:10 AM

    Thanks for the update



  • 7.  Re: Problem on CA PPM 15.2 Installation

    Posted Jun 16, 2017 10:11 AM

    hello, try to check using SQL client

    SHOW PARAMETER SEC_CASE_SENSITIVE_LOGON

    I found few times as a problem when establishing connection to DB using JDBC connection strings from Clarity. It should be set on TRUE to make it properly working otherwise it didn't work in my case.



  • 8.  Re: Problem on CA PPM 15.2 Installation

    Posted Jun 16, 2017 01:34 PM

    Hi Lukas,

     

    Yes, I checked it and it's set on TRUE.

     

    Thanks for the advice.

     

    Finally i reinstalled everything again and the error was solved.