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 ( Exception due to DB Connection failure

WARN  2015-02-10 15:29:22,439 [http-bio-8090-exec-8] niku.nsa ( 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 ( 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 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,