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
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?
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 tab2. In Report server - Jaspersoft - Web URL enter the value:http://localhost:8081/reportservice3. Save and restart all services4. 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 responds2. 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 hostname4. 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.
Nika HadzhikidiCA TechnologiesPrincipal Support Engineer
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
Somewhat similar problem in the thread
I am back to work.
I change in Report server - Jaspersoft - Web URL the value to:
I enter my parameters in the database, I have an error on Jaspersoft (it is normal)
But it works.
No worries, thanks for letting us know Jerome!