We are facing JBBC Exception--BW-JDBC-100014

Hi,

We are getting below exception while quering from DB.

Our BW process are working in Load Balance mode.

The request recevied to primary server are getting below exception while quering JDBC.

Request receving to secondary server are processing fine.

We are getting below error in Primary server.

2011 Jan 19 13:57:07:299 GMT +5 BW.Ns_ServiceManagement-Ns_Servicemanagement_WS_PA Error [BW-Plugin] BW-JDBC-100014 Job-85070 Error in [Error_Handiling/SharedProcess/Generating UniqueID.process/Group/KEYIDGENERATION]

"JDBC error reported: (SQLState = 99999) - java.sql.SQLException: Closed Connection"

at com.tibco.plugin.jdbc.JDBCActivity.eval(JDBCActivity.java:990)

at com.tibco.pe.plugin.Activity.eval(Activity.java:241)

at com.tibco.pe.core.TaskImpl.eval(TaskImpl.java:574)

at com.tibco.pe.core.Job.a(Job.java:712)

at com.tibco.pe.core.Job.k(Job.java:501)

at com.tibco.pe.core.JobDispatcher$JobCourier.a(JobDispatcher.java:249)

at com.tibco.pe.core.JobDispatcher$JobCourier.run(JobDispatcher.java:200)

caused by: java.sql.SQLException: Closed Connection

at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:119)

at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:134)

at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:247)

at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:327)

at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:352)

at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:642)

at oracle.jdbc.driver.T2CConnection.checkError(T2CConnection.java:1226)

at oracle.jdbc.driver.T2CConnection.logon(T2CConnection.java:459)

at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:511)

at oracle.jdbc.driver.T2CConnection.<init>(T2CConnection.java:129)

at oracle.jdbc.driver.T2CDriverExtension.getConnection(T2CDriverExtension.java:56)

at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:538)

at java.sql.DriverManager.getConnection(DriverManager.java:525)

at java.sql.DriverManager.getConnection(DriverManager.java:171)

at com.tibco.pe.core.JDBCPool.getConnectionEntry(JDBCPool.java:1277)

at com.tibco.pe.core.JDBCPool.getConnectionEntry(JDBCPool.java:1165)

at com.tibco.pe.core.JDBCPoolManager.getConnectionEntry(JDBCPoolManager.java:588)

at com.tibco.plugin.jdbc.JDBCActivity.eval(JDBCActivity.java:893)

at com.tibco.pe.plugin.Activity.eval(Activity.java:241)

at com.tibco.pe.core.TaskImpl.eval(TaskImpl.java:574)

at com.tibco.pe.core.Job.a(Job.java:712)

at com.tibco.pe.core.Job.k(Job.java:501)

at com.tibco.pe.core.JobDispatcher$JobCourier.a(JobDispatcher.java:249)

at com.tibco.pe.core.JobDispatcher$JobCourier.run(JobDispatcher.java:200)

called by: [BusinessProcess/Notification_Services/NS_Request_Receiver.process/LOGGING>Error_Handiling/SharedProcess/EAI_Logging_ErrorHandling.process/Initialization]

<?xml version="1.0" encoding="UTF-8"?>

<Data>

<ns0:JDBCSQLException xmlns:ns0="http://schemas.tibco.com/bw/plugins/jdbc/5.0/jdbcExceptions">

<msg>"JDBC error reported: (SQLState = 99999) - java.sql.SQLException: Closed Connection"</msg>

<msgCode>BW-JDBC-100014</msgCode>

<sqlState>99999</sqlState>

<detailStr>java.sql.SQLException: Closed Connection</detailStr>

</ns0:JDBCSQLException>

</Data>

(1) Answer

Login