AnsweredAssumed Answered

Connection settings ignored by CSA... always localhost:1521... (14.1 on Oracle)

Question asked by olivier.carrier on Feb 10, 2015
Latest reply on Feb 11, 2015 by olivier.carrier

Hi everyone,

 

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,

 

Olivier

Outcomes