"flexnet loaddb" command fails with "java.sql.SQLException: Io exception: Connection reset"
"flexnet loaddb" command fails with "java.sql.SQLException: Io exception: Connection reset"
Summary
"flexnet loaddb" command fails with "java.sql.SQLException: I/O exception: Connection reset".
Symptoms
Environment:
Application: FlexNet Manager for Engineering Applications
Operating System: Linux
Database: Oracle (Remote)
"flexnet loaddb" command fails with "java.sql.SQLException: Io exception: Connection reset" like the following.
ERROR: Could not connect to database:
Io exception: Connection reset
Attempting to connect to config service database 14:47:57,319 DEBUG Could not access config service data: java.sql.SQLException: Io exception: Connection reset
Cause
The net.ipv4.tcp_keepalive_time OS level KeepAlive parameter is configured in /etc/sysctl.conf but ACK response for KeepAlive from the Oracle database server was not received, therefore OS closed the connection.
Resolution
Please work with your network administrator to resolve to receive the KeepAlive packets.
Workaround
Please remove net.ipv4.tcp_keepalive_time = xxx in /etc/sysctl.conf.
