2497641 - SQL Error with Java stack and Read operation time out errors for SAP ASE for BS

• Following java stack is reported in the application trace file (defaultTrace_##.#.trc):

#2.0##2017 06 28 14:58:03:485#+00#Error#com.sap.sql.jdbc.direct.DirectPreparedStatement#
#BC-JAS-PER-SQL#opensqlkernel#C000647C1137032E0000000100000F51##sap.com/tc~monitoring~webservice~app#com.sap.sql.jdbc.direct.DirectPreparedStatement#a_dimmigs#2857##2F8A35F15C1211E7BD150000002E4139#2f8a35f15c1211e7bd150000002e4139##0#Thread[Socket Listener,5,]#Plain##
SQL error occurred on connection SID:SID:SAPSR3DB: code=0, state="JZ006", message="JZ006: Caught IOException: java.io.IOException: JZ0T3: Read operation timed out. use getCause() to see the error chain
=> (0,JZ0T3,JZ0T3: Read operation timed out.)
=> (0,JZ0TO,JZ0TO: Read operation timed out.)";
SQL statement is "UPDATE "T_CHUNK" SET "CHUNK_DATA" = ? WHERE "DOMAIN_HASH" = ? AND "DOMAIN_COUNTER" = ? AND "SESSION_HASH" = ? AND "SESSION_COUNTER" = ? AND "CHUNK_NAME" = ?".
[EXCEPTION]
java.sql.SQLException: JZ006: Caught IOException: java.io.IOException: JZ0T3: Read operation timed out. use getCause() to see the error chain
 at com.sybase.jdbc4.jdbc.ErrorMessage.raiseErrorCheckDead(ErrorMessage.java:1162)
 at com.sybase.jdbc4.tds.Tds.handleIOE(Tds.java:5219)
 at com.sybase.jdbc4.tds.Tds.handleIOE(Tds.java:5164)
 at com.sybase.jdbc4.tds.Tds.nextResult(Tds.java:2954)
 at com.sybase.jdbc4.jdbc.ResultGetter.nextResult(ResultGetter.java:78)
 at com.sybase.jdbc4.jdbc.SybStatement.nextResult(SybStatement.java:294)
 at com.sybase.jdbc4.jdbc.SybStatement.nextResult(SybStatement.java:276)
 at com.sybase.jdbc4.jdbc.SybStatement.updateLoop(SybStatement.java:2749)
 at com.sybase.jdbc4.jdbc.SybStatement.executeUpdate(SybStatement.java:2733)
 at com.sybase.jdbc4.jdbc.SybPreparedStatement.executeUpdate(SybPreparedStatement.java:335)
 at com.sap.sql.jdbc.basic.BasicPreparedStatement.executeUpdate(BasicPreparedStatement.java:108)
 at com.sap.sql.jdbc.syb.SybPreparedStatement.executeUpdate(SybPreparedStatement.java:54)
 at com.sap.sql.jdbc.direct.DirectPreparedStatement.executeUpdate(DirectPreparedStatement.java:373)
 at com.sap.sql.jdbc.common.CommonPreparedStatement.executeUpdate(CommonPreparedStatement.java:354)
 at com.sap.engine.core.session.persistent.db.DBStorage.updateSessionChunk(DBStorage.java:1346)
 at com.sap.engine.core.session.persistent.db.DBStorage.setChunk(DBStorage.java:1257)
 at com.sap.engine.core.session.persistent.db.DBPersistentSessionModel.setChunk(DBPersistentSessionModel.java:145)
 at com.sap.engine.session.exec.ClientContextImpl.storeObserver(ClientContextImpl.java:1438)
 at com.sap.engine.session.exec.ClientContextImpl.persistScopeObserver(ClientContextImpl.java:2362)
 at com.sap.engine.session.exec.SessionExecContext.clear(SessionExecContext.java:423)
 at com.sap.engine.session.exec.SessionExecContext.empty(SessionExecContext.java:998)
 at com.sap.engine.core.thread.ThreadContextImpl.empty(ThreadContextImpl.java:663)
 at com.sap.engine.core.thread.ThreadContextImpl.empty(ThreadContextImpl.java:649)
 at com.sap.engine.core.thread.MonitoredThreadImpl.clearThreadRelatedData(MonitoredThreadImpl.java:558)
 at com.sap.engine.core.thread.MonitoringInfo.cleanMonitoring(MonitoringInfo.java:68)
 at com.sap.engine.core.thread.JavaThreadsCallback.ended(JavaThreadsCallback.java:82)
 at com.sap.jvm.impl.monitor.thread.ThreadWatcherImpl$CallbackAdapter.ended(ThreadWatcherImpl.java:115)
Caused by: java.io.IOException: JZ0T3: Read operation timed out.
 at com.sybase.jdbc4.jdbc.ErrorMessage.raiseIOException(ErrorMessage.java:1006)
 at com.sybase.jdbc4.timedio.InStreamMgr.readIfOwner(InStreamMgr.java:627)
 at com.sybase.jdbc4.timedio.InStreamMgr.doRead(InStreamMgr.java:319)
 at com.sybase.jdbc4.tds.TdsProtocolContext.getChunk(TdsProtocolContext.java:622)
 at com.sybase.jdbc4.tds.PduInputFormatter.readPacket(PduInputFormatter.java:239)
 at com.sybase.jdbc4.tds.PduInputFormatter.read(PduInputFormatter.java:72)
 at com.sybase.jdbc4.tds.TdsInputStream.read(TdsInputStream.java:91)
 at com.sybase.jdbc4.tds.TdsInputStream.readUnsignedByte(TdsInputStream.java:124)
 at com.sybase.jdbc4.tds.Tds.nextResult(Tds.java:2912)
 ... 23 more

Read more...

• SAP Adaptive Server Enterprise (ASE) 15.7 for Business Suite
• SAP Adaptive Server Enterprise (ASE) 16.0 for Business Suite
• SAP Enterprise Resource Planning (ERP) 6.0
• SAP Customer Relationship Management (CRM) 7.0
• SAP Supplier Relationship Management (SRM) 7.0
• SAP Supply Chain Management (SCM) 7.0
• SAP Solution Manager (SOLMAN) 7.1
• SAP NetWeaver (NW) - All versions 

SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0 ; SAP Customer Relationship Management 7.0 ; SAP ERP 6.0 ; SAP NetWeaver 7.4 ; SAP NetWeaver all versions ; SAP Solution Manager 7.1 ; SAP Supplier Relationship Management 7.0 ; SAP Supply Chain Management 7.0

performance, slow execution, java.io.IOException:, JZ0T3:, Read operation timed out, optmizer, ATM, table maintenance , KBA , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , How To