SAP Knowledge Base Article - Preview

2050132 - EAServer 6.3 - Could not update session in database for sessionid error

Symptom

Using EAServer 6.3.1.07 (build 63107 - ebf 19113) and getting the following errors in the log file:

014-05-20 09:23:39.844 INFO  Thread-79 [SybaseStoredProcedure] Using JIT stored procedure 'jit_sp_22' for data source 'default'
2014-05-20 09:23:39.847 INFO  pool-2-thread-344 [SystemException] com.sybase.djc.DataStoreException was thrown by transaction com.sybase.djc.web.distributed.SessionDBUtil.update(com.sybase.djc.web.distributed.SessionState)
2014-05-20 09:23:39.847 INFO  pool-2-thread-344     com.sybase.djc.DataStoreExceptio2014-05-20 09:23:39.847 INFO  pool-2-thread-344         at com.sybase.djc.sql.PersistenceManager.update(PersistenceManager.java:5066
2014-05-20 09:23:39.847 INFO  pool-2-thread-344         at com.sybase.djc.sql.PersistenceManager.updateBlob(PersistenceManager.java:4905)
2014-05-20 09:23:39.847 INFO  pool-2-thread-344         at com.sybase.djc.web.distributed.SessionState$update.invoke(SessionState$update.java:201)
2014-05-20 09:23:39.847 INFO  pool-2-thread-344         at com.sybase.djc.DataStore.update(DataStore.java:248)
2014-05-20 09:23:39.847 INFO  pool-2-thread-344     Caused by: java.sql.SQLException: This driver does not support JDBC data type with id = 2004
2014-05-20 09:23:39.847 INFO  pool-2-thread-344         at ianywhere.ml.jdbcodbc.jdbc3.IIPreparedStatement.setNull(Native Method)
2014-05-20 09:23:39.847 INFO  pool-2-thread-344         at ianywhere.ml.jdbcodbc.jdbc3.IPreparedStatement.setNull(IPreparedStatement.java:302)
2014-05-20 09:23:39.847 INFO  pool-2-thread-344         at com.sybase.djc.sql.PersistenceManager.update(PersistenceManager.java:5030)
2014-05-20 09:23:39.847 INFO  pool-2-thread-344         ... 35 more
.
.
2014-05-20 09:23:39.849 INFO  pool-2-thread-344 [ConsoleOutput] 15795274 [pool-2-thread-344] ERROR / - Could not update session in database for sessionId =
.
.
2014-05-20 09:25:29.038 INFO  Thread-79     Caused by: java.sql.SQLException: [Sybase][ODBC Driver][SQL Anywhere]Resource governor for 'prepared statements' exceeded
2014-05-20 09:25:29.038 INFO  Thread-79         at ianywhere.ml.jdbcodbc.jdbc3.IIStatement.nativeExecuteUpdate(Native Method)
2014-05-20 09:25:29.038 INFO  Thread-79         at ianywhere.ml.jdbcodbc.jdbc3.IIStatement.executeUpdate(IStatement.java:502)
2014-05-20 09:25:29.038 INFO  Thread-79         at ianywhere.ml.jdbcodbc.jdbc3.IStatement.executeUpdate(IStatement.java:289)
2014-05-20 09:25:29.038 INFO  Thread-79         at com.sybase.djc.sql.jit.SybaseConnection.executeStatement(SybaseConnection.java:325)
2014-05-20 09:25:29.038 INFO  Thread-79         at com.sybase.djc.sql.jit.SybaseConnection.setAutoCommit(SybaseConnection.java:209)
2014-05-20 09:25:29.038 INFO  Thread-79         at com.sybase.djc.sql.jit.SybaseStoredProcedure.init(SybaseStoredProcedure.java:372)
2014-05-20 09:25:29.038 INFO  Thread-79         ... 6 more

 


Read more...

Environment

  • Sybase EAServer 6.3.1.07

Product

SAP PowerBuilder 12.5 ; Sybase EAServer 6.3

Keywords

EAServer, jdbc, jconnect,ianywhere.ml.jdbcodbc.jdbc3, ianywhere.ml.jdbcodbc.jdbc3,session,jconn3.jar,JDBC-ODBC , KBA , BC-SYB-EAS , EAServer , 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.