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

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

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

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