Analytics Error after moving the server to a new VLAN

Document ID : KB000100747
Last Modified Date : 12/06/2018
Show Technical Document Details
Issue:
We recently moved our Analytics Server to a different VLAN. This server houses the postgresql and analytics backend. I was able to restart the PostgreSQL database and access the database. However, when I start the analytics backend(as root) with the below command, I get the errror:

 nohup java -jar analytics-backend.jar &

Caused by: org.postgresql.util.PSQLException: The connection attempt failed.
 at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:275)
 at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:55) at org.postgresql.jdbc.PgConnection.(PgConnection.java:219)
 at org.postgresql.Driver.makeConnection(Driver.java:407) at org.postgresql.Driver.connect(Driver.java:275)
 at com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:95)
 at com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:101)
 at com.zaxxer.hikari.pool.BaseHikariPool.addConnection(BaseHikariPool.java:444)
 at com.zaxxer.hikari.pool.BaseHikariPool.initializeConnections(BaseHikariPool.java:548)
 ... 40 common frames omitted
Caused by: java.net.NoRouteToHostException: No route to host (Host unreachable)
 at java.net.PlainSocketImpl.socketConnect(Native Method)
 at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:350)
 at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:206)
 at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:188)
 at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
 at java.net.Socket.connect(Socket.java:589) at org.postgresql.core.PGStream.(PGStream.java:64)
 at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:147)
 ... 48 common frames omitted
Resolution:
Please kindly try to change domain name in these connection string to IP address:
  •  In plugin.properties:
backend.endpoint=http://cmhlqatmwpan01.expdev.local:8090
  •  In application.properties:
datasource.analytics.url=jdbc:postgresql://cmhlqatmwpan01.expdev.local:5432/awadatastore datasource.ae.url=jdbc:oracle:thin:@//cmhdhofcodb.expdev.local:1521/automic.qa.expdev.local
  • 3. Update your etc/hosts file in your server