IBM Verify Identity Governance application trace logs display SQL exceptions on the member node of the virtual appliance

Edit online

When you reconnect a removed member node on the virtual appliance, SQL exceptions are displayed in the application trace log.

Problem

A typical SQL exception in the application trace log is as follows:
Caused by: java.sql.SQLException: [jcc][t4][2043][11550][3.64.82] 
Exception java.net.NoRouteToHostException: 
Error opening socket to server /9.113.51.83 on port 50,002 with message: 
No route to host. ERRORCODE=-4499, SQLSTATE=08001

Solution

When such a problem occurs, restart the Verify Identity Governance Server on member node to clear the exception in the application trace logs. Do these steps:
  1. On the Appliance Dashboard, locate the Server Control widget.
  2. Select Security Identity Manager server.
  3. Click Restart to restart the selected server.