SAP Knowledge Base Article - Preview

1996428 - The getData function does not work anymore after a timeout of the connection

Symptom

A Sybase Aleri Streaming Platform (ASP) or SAP Event Stream Processor (ESP) application uses the getData function to select data from a database.

After a period in which no calls were made, the next call of getData does not succeed due to a dead connection and gives an exception like the following example:

 

Exception in thread "Thread-0" java.sql.SQLException: JZ006: Caught IOException: com.sybase.jdbc3.jdbc.SybConnectionDeadException: JZ0C0: Connection is already closed.

at com.sybase.jdbc3.jdbc.ErrorMessage.createIOEKilledConnEx (Unknown Source)

at com.sybase.jdbc3.jdbc.ErrorMessage.raiseErrorCheckDead (Unknown Source)

at com.sybase.jdbc3.tds.Tds.a(Unknown Source)

at com.sybase.jdbc3.tds.Tds.a(Unknown Source)

at com.sybase.jdbc3.tds.Tds.nextResult(Unknown Source)

at com.sybase.jdbc3.jdbc.ResultGetter.nextResult(Unknown Source)

at com.sybase.jdbc3.jdbc.SybStatement.nextResult(Unknown Source)

at com.sybase.jdbc3.jdbc.SybStatement.nextResult(Unknown Source)

at com.sybase.jdbc3.jdbc.SybStatement.queryLoop(Unknown Source)

at com.sybase.jdbc3.jdbc.SybStatement.executeQuery(Unknown Source)

at com.sybase.jdbc3.jdbc.SybStatement.executeQuery(Unknown Source)

[SP-03-104003] (12168.691) sp(11329) Error in function 'getData': could not execute query exec GetMarketstoredprocedure @Keyargument = 'CM_Value

 


Read more...

Environment

  • Sybase Aleri Streaming Platform (ASP) all versions
  • SAP Event Stream Processor (ESP) 5.1 SP 08 and earlier

Product

SAP Event Stream Processor 5.1 ; Sybase Aleri Streaming Platform 3.1

Keywords

ESP Aleri ASP GetData SybConnectionDeadException timeout , KBA , BC-SYB-CEP , Sybase Aleri Streaming Platform (CEP) , BC-SYB-ESP , Sybase ESP (Event Stream Processor) , Bug Filed

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.