2050132 - EAServer 6.3 - Could not update session in database for sessionid error | SAP Knowledge Base Article

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 ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.