SAP Knowledge Base Article - Preview

2202276 - ADONET: connection pool returns 30004, connection does not exist - SDK for SAP ASE

Symptom

  • Involves a multi-threaded application using C#/VB.NET, ASP.NET.
  • Under certain situations, when client timeout occurs and ASE (pre SP12X) is un-responsive to cancel requests due to command timeout ASE ADO.NET Provider will close connection to ASE after 2X command timeout duration
  • Connection should then be removed from pool.
  • Instead the connections are marked dead and remain in the pool.
  • As a result subsequent threads requesting connection via Open() call receive the bad connection.
  • Upon execution of command to ASE the AseException is thrown: Err# 30004, "Connection does not exist".
  • This eventually cascades to more thread requests and renders the web application useless.


Read more...

Environment

  • Adaptive Server Enterprise ADO.NET Data Provider pre 15.7 SP127
    • 2.0 Provider ( Sybase.AdoNet2.AseClient.dll )
    • 3.5 Provider ( Sybase.AdoNet35.AseClient.dll )
    • 4.0 Provider ( Sybase.AdoNet4.AseClient.dll )
    • 4.5 Provider ( Sybase.AdoNet45.AseClient.dll )
  • SAP Adaptive Server Enterprise (ASE) 15.7 and 16.015.7 ESD#3, #4
  • Solaris x64
  • Development platform: MSDEV 2005+ (using 2012 for repro)
  • C# or vb.net code with ASP.NET, Windows 2008 R2 x64
  • IIS 6.0+

Product

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

Keywords

Connection Dead, hang, FIN_WAIT, CLOSE_WAIT, Software Developers Kit, Adaptive Server Enterprise, SDK for SAP ASE, 764227, CR#764227, CR764227 , KBA , BC-SYB-SDK , SDK , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Problem

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.