The bwagent throws an "IO Error: Connection reset"error and fails to startup.
Article ID: KB0084681
Updated On:
| Products | Versions |
|---|---|
| TIBCO ActiveMatrix BusinessWorks | - |
| Not Applicable | - |
Description
The bwagent throws an "IO Error: Connection reset" error and fails to startup.
Symptoms:
"connection reset" error both in bwagent and bwadmin logs, shown below.
~ bwagent.log
+++
...
2016-02-24 14:19:25.840 DEBUG [main] com.microsoft.sqlserver.jdbc.Driver - RETURN null
2016-02-24 14:24:20.270 WARN [main] bw - TIBCO-BW-AGENT-500009: Failed to start agent due to an error in initializing data store, <CausedBy> TIBCO-BW-ADMIN-PRSTNC-500010: Failed to execute query on database with given parameters. [IO Error: Connection reset]
com.tibco.neo.exception.BaseException: TIBCO-BW-ADMIN-PRSTNC-500010: Failed to execute query on database with given parameters. [IO Error: Connection reset] at com.tibco.bw.thor.management.persistence.rdbms.dao.BWDataSource.getInstance(BWDataSource.java:137) ~[com.tibco.bw.thor.management.persistence_1.3.203.004.jar:na]
...
+++
~ bwadmin.log
+++
...
2016-02-24 14:12:44.927 INFO [main] c.t.b.t.m.p.rdbms.BWRDBMSDataManager - initializing DB connection
2016-02-24 14:19:21.266 ERROR [main] c.t.b.t.m.d.u.AppNodeLifecycleCommand - TIBCO-BW-ADMIN-500001: Failed to perform operation [startappnode] on [RetailJServices.application-mceplm008] in the Domain [MCE_PROD] due to an error in initializing data manager, <CausedBy> TIBCO-BW-ADMIN-PRSTNC-500010: Failed to execute query on database with given parameters. [IO Error: Connection reset]
com.tibco.neo.exception.BaseException: TIBCO-BW-ADMIN-PRSTNC-500010: Failed to execute query on database with given parameters. [IO Error: Connection reset] at com.tibco.bw.thor.management.persistence.rdbms.dao.BWDataSource.getInstance(BWDataSource.java:137) ~[com.tibco.bw.thor.management.persistence_1.3.203.004.jar:na]
...
+++
Cause:
This could be a network outage issue but if that is already ruled out, then this is a result of a known issue with Linux 64-bit Oracle environments. Oracle JDBC drivers use "java.security.SecureRandom" standard API to generate random number during login. The method void nextBytes(byte[]) uses /dev/random on Linux. On some machines which lack random number generating hardware, the operation slows down to the extent of bringing the whole login process to a halt. Ultimately the the user encounters SQLException ("IO exception:Connection reset").
Issue/Introduction
Resolution
The resolution is to add the following property in the bwagent.tra file and restart the bwagent.
java.extended.properties=-Djava.security.egd=file:///dev/urandom
Additional Information
https://community.oracle.com/message/3795101
http://stackoverflow.com/questions/2327220/oracle-jdbc-intermittent-connection-issue
https://en.wikipedia.org/wiki//dev/random
Feedback
