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