SAP Knowledge Base Article - Preview

2886789 - jConnect: Connection timed out issue from application - SDK for ASE

Symptom

  • ASE log:
    Cannot read, host process disconnected: spid: 134
    kernel nrpacket: recv, Connection timed out, spid: 256, suid: 110
    kernel extended error information: hostname:
     
  • Application log:
    A connection error occurred.
    To help determine the problem, enable the Diagnose Connection Usage option on the Connection Factory or Data Source.
    This is the multithreaded access detection option. Alternatively check that the Database or MessageProvider is available.
    The Connection Manager received a fatal connection error from the Resource Adapter for resource jdbc.
    The exception is: java.sql.SQLException: JZ006: Caught IOException: com.sybase.jdbc4.jdbc.SybConnectionDeadException: JZ0C0: Connection is already closed.:com.sybase.jdbc4.jdbc.SybConnectionDeadException: JZ0C0: Connection is already closed.:java.io.IOException: JZ0C0: Connection is already
     
  • TDS5 query [Malformed Packet]
    [TCP Retransmission] [PSH, ACK] Seq= Ack= Win= Len=
    [ACK] Seq= Ack= win= Len= SLE= SRE=
    [TCP Keep-Alive] {ACK} Seq= Ack= Win= Len=
    [TCP Keep-Alive] {ACK} Seq= Ack= Win= Len=
    [TCP Keep-Alive] {ACK} Seq= Ack= Win= Len=
    [TCP Keep-Alive] {ACK} Seq= Ack= Win= Len=
    [TCP Keep-Alive] {ACK} Seq= Ack= Win= Len=
    [RST, ACK] Seq= Ack= Win= Len=

  • Query eventually times out but it's still on the line causing backups of the application, until the application comes to a standstill and no one can use it without timing out


Read more...

Environment

  • SAP Sybase Software Developer Kit (SDK) 15.7
  • SAP Adaptive Server Enterprise (ASE) Software Developer Kit (SDK) 16.0
  • jConnect
    • JDBC 7.07
    • JDBC 16 (is version JDBC 7.07)
  • SAP Adaptive Server Enterprise (ASE) 16.0

Product

SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0 ; SAP Adaptive Server Enterprise SDK 16.0 ; Sybase Software Developer Kit 15.7

Keywords

KBA , BC-SYB-SDK , SDK , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , How To

About this page

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

Search for additional results

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