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

SAP Knowledge Base Article - Preview

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

Symptom

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

Environment

  • 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 

Product

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

Keywords

performance, slow execution, java.io.IOException:, JZ0T3:, Read operation timed out, optmizer, ATM, table maintenance , KBA , BC-DB-SYB , SAP Business Suite on Sybase ASE Database Platform , How To

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.