has anyone ever faced this issue?
I have just installed 14.1 on Win2k8, Tomcat with Oracle on a separate server.
In CSA I have entered the correct Home Directory and then all correct settings under Internal Connection Niku (hostname, port, service name, login name and password). However when I try to save my settings I keep getting Status = Unavailable...
Looking into nsa-ca.log I found the following:
WARN 2015-02-10 15:28:04,735 [Config Monitor] config.TenantConfigurationManager (none:none:none:none) Found invalid database connection for local tenant clarity
ERROR 2015-02-10 15:29:22,439 [http-bio-8090-exec-8] persistence.PersistenceController (clarity:sa:a4S17jjH6iGvnfKmJC8Mpn7Cyv9IcWOXgq7lW5uof+o0:nsa.properties.database.save) Exception due to DB Connection failure
WARN 2015-02-10 15:29:22,439 [http-bio-8090-exec-8] niku.nsa (clarity:sa:a4S17jjH6iGvnfKmJC8Mpn7Cyv9IcWOXgq7lW5uof+o0:nsa.properties.database.save) Unable to persist configuration properties to database. Likely cause is database properties are not yet set or misconfigured.
ERROR 2015-02-10 15:29:34,669 [http-bio-8090-exec-8] handlers.SaveDWHDatabaseLinkHandler (clarity:sa:a4S17jjH6iGvnfKmJC8Mpn7Cyv9IcWOXgq7lW5uof+o0:nsa.properties.database.save) Connection with Data Warehouse database is not established
java.sql.SQLNonTransientConnectionException: [CA Clarity][Oracle JDBC Driver]Error establishing socket to host and port: localhost:1521. Reason: Connection refused: connect
at com.ca.clarity.jdbc.oraclebase.ddcr.b(Unknown Source)
Looking in Properties.xml I found extra hidden parameters under <dwhDatabaseServer> tag... which are all defaults that do not apply to my setup at all...
Furthermore the hostname and port are NOT the ones I entered manually in CSA !!! how is it supposed to connect if its not using the correct settings I entered???
many thanks in advance,