2143791 - "Connection was terminated" error with SQL Anywhere after 4 hours of idle time - SAP ESP

• In an SAP Event Stream Processor (ESP) 5.1 project, data is updated into an SAP SQL Anywhere database server using the Database Output Adapter (db_out).
• After a long 4 hour idle time, for example after the end of the working day, the connection is lost and all subsequent insert or update statements fail with the error "-308 [SQL Anywhere]Connection was terminated":

[SP-3-148012] (69959.763) sp(7436) ConnectionWriter(Stream_MonitoringValues) connection conversion error: 2015-03-13 05:13:01 DBOutput_Adapter::rollbackTransaction() failed with reason code
[SP-3-100005] (69959.763) sp(7436) Error creating SQL statement insert into MonitoringValues values( null, ? , ? , ? , ? ). ODBC state: 08S01
ODBC error: -308
ODBC message: [Sybase][ODBC Driver][SQL Anywhere]Connection was terminated
[SP-3-150004] (69959.763) sp(7436) Connection(OutputDBAdapter_MonitoringValues/Stream_MonitoringValues):: DBOutput_Adapter::executeUpdateSQL() executeUpdate not successful for [insert into MonitoringValues values( null, ? , ? , ? , ? )] update count of: 0
[SP-3-100005] (69959.763) sp(7436) Error rolling back transaction from database. ODBC state: 08S01
ODBC error: -308
ODBC message: [Sybase][ODBC Driver][SQL Anywhere]Connection was terminated
[SP-3-150004] (69959.763) sp(7436) Connection(OutputDBAdapter_MonitoringValues/Stream_MonitoringValues):: DBOutput_Adapter::rollbackTransaction() failed with reason code
[SP-3-150004] (69959.763) sp(7436) Connection(OutputDBAdapter_MonitoringValues/Stream_MonitoringValues):: DBOutput_Adapter::putNext() executeUpdateSQL Failed - see previous messages

• When new data enters the project it appears that the ESP project stopped working as no updates are taking place on the database server.

• SAP Event Stream Processor (ESP) 5.1
• SAP SQL Anywhere

idle timeout streaming processing , KBA , BC-SYB-ESP , Sybase ESP (Event Stream Processor) , BC-SYB-SQA , SQL Anywhere (on premise, on demand) , Problem