Problem on CA Clarity 14.3 installation

[Anon Anon]

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

[Nika Hadzhikidi]

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

[Anon Anon]

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)

properties.xml.zip   2 KB 1 version

nsa-ca.log.zip   21 KB 1 version

[Deactivated User]

Somewhat similar problem in the thread

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

[Anon Anon]

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

[Nika Hadzhikidi]

No worries, thanks for letting us know Jerome!