Clarity PPM1

Expand all | Collapse all

Problem on CA Clarity 14.3 installation

Jump to Best Answer
  • 1.  Problem on CA Clarity 14.3 installation

    Posted 11-03-2015 04:56 PM

    Hi,

     

    I try to make a new installation of CA Clarity 14.3.

    I created the database and the dwh database from the .db files.

    I installed java, tomcat and the CA PPM application on an other server.

    Next step is to configure the different properties on the serveur (CSA, system, database, etc..)

    My problem is that when I enter the databse properties, the database appears always as unavailable.

    If I look at the nsa-ca.log I can see:

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

    And

    ERROR ....sendRequest Error: Illegal character in authority at index 7: http://<my_reportserver>/reportservice/rest_v2/serverInfo

    Error is because I do not have install jaspersoft because we do not want to use it. we need just CA portlet.

    So my questions are:

    Do I made something wrong on the install?

    Do I must install jaspersoft?

    Someone had an idea why my DB stay unavailable?

    Someone have the different step of the installation of the CA PPM 14.3?

     

    Really thanks,

     

    Jerome



  • 2.  Re: Problem on CA Clarity 14.3 installation
    Best Answer

    Posted 11-03-2015 05:29 PM

    Hi Jerome,

     


    From your error it looks like there is an issue with invalid character in CSA. And it seems like the issue is with the Jaspersoft URL.
    You should not have Illegal character error if your Jaspersoft is not configured, there will be a completely different error thrown.


    Please do the following:

    1. Go to CSA - Reporting tab
    2. In Report server - Jaspersoft - Web URL enter the value:
    http://localhost:8081/reportservice
    3. Save and restart all services
    4. Now connect to CSA and retry entering your Database connection details.

     

    If your error message is resolved and you still have an issue to make your Database available, it will be due to your database connection. You could try :

     

     

    1. Ping the database server from the Clarity server to ensure it responds
    2. Ensure the appropriate db ports are open (for example 1521 for Oracle)
    3. Try connecting with an IP instead of hostname to exclude an issue to resolve the hostname
    4. Ensure the connection details you use are correct

     

    Please try the above and let me know how it goes. Typically when the database is Unavailable this does not indicate an issue with the install itself. You are also not obliged to mandatorily install Jaspersoft for your Clarity to work.

     

    If you still have an issue, please provide your nsa-ca.log and your properties.xml  (you can upload them here, to a Support case or send them to me in a message/email). Properties.xml contains private information so do not upload it to this discussion unless you had all server names and passwords removed.


    Hope this helps. Looking forward to hearing from you.

     

    Kind Regards

     

    Nika Hadzhikidi
    CA Technologies
    Principal Support Engineer



  • 3.  Re: Problem on CA Clarity 14.3 installation

    Posted 11-03-2015 06:09 PM

    Hello,

     

    Thank you for your answer on community.

     

    I am not at work now. I will be back to work tomorrow. But I have the same problem on my test installation at home.

    I changed the parameters for jaspersoft to http://localhost:8081/reportservice

    The error is now:

    ERROR 2015-11-03 23:39:00,086  restAdapter.JasperRestAdapter (clarity:sa:diHraGc3DoUbHUPchmlgKaHFiZRWqI0FG/X1m5Y0U980:nsa.properties.database.save) sendRequest Error: Connection refused: connect

    ERROR 2015-11-03 23:39:00,087  util.JasperUtils (clarity:sa:diHraGc3DoUbHUPchmlgKaHFiZRWqI0FG/X1m5Y0U980:nsa.properties.database.save) Error occurred while checking Jaspersoft Server Status

     

    And the database seems always disconnect.

    You will find attached to this email my log and properties.xml

     

    Regards

     

    Jerome

    Attachment(s)

    zip
    properties.xml.zip   2K 1 version
    zip
    nsa-ca.log.zip   21K 1 version


  • 4.  Re: Problem on CA Clarity 14.3 installation

    Posted 11-04-2015 01:22 AM

    Somewhat similar problem in the thread

    https://communities.ca.com/message/101115561#101115561



  • 5.  Re: Problem on CA Clarity 14.3 installation

    Posted 11-04-2015 03:14 AM

    Hello,

     

    I am back to work.

    I change in  Report server - Jaspersoft - Web URL the value to:

    http://localhost:8081/reportservice

    I enter my parameters in the database, I have an error on Jaspersoft (it is normal)

    But it works.

     

    Thank you,

     

    Regards

     

    Jerome



  • 6.  Re: Problem on CA Clarity 14.3 installation

    Posted 11-04-2015 11:31 AM

    No worries, thanks for letting us know Jerome!