ISIM application trace logs display SQL exceptions on the member node of the virtual appliance

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 ISIM 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.

Parent topic: Troubleshooting virtual appliance problems