SAP Knowledge Base Article - Preview

2196494 - ASE returns error: com.sybase.jdbc4.jdbc.SybSQLException, the dynamic statement sh1731692265_0874276115ss* could not be found.

Symptom

  • The Weblogic application throws the error after upgrading the ASE Server from ASE 15.7 SP122 to 15.7 SP134.

  • The program executes an update statement and gives the following error :


Exception in thread "main" com.sybase.jdbc4.jdbc.SybSQLException: The dynamic statement '*sh1731692265_0874276115ss*' could not be found. This may be due to insufficient metadata descriptors. Increase the serverwide 'number of open objects' parameter or the 'procedure cache size' parameter.
at com.sybase.jdbc4.tds.Tds.processEed(Tds.java:4117)
at com.sybase.jdbc4.tds.Tds.nextResult(Tds.java:3207)
at com.sybase.jdbc4.jdbc.ResultGetter.nextResult(ResultGetter.java:78)
at com.sybase.jdbc4.jdbc.SybStatement.nextResult(SybStatement.java:291)
at com.sybase.jdbc4.jdbc.SybStatement.nextResult(SybStatement.java:273)
at com.sybase.jdbc4.jdbc.SybStatement.executeLoop(SybStatement.java:2595)
at com.sybase.jdbc4.jdbc.SybStatement.execute(SybStatement.java:2582)
at com.sybase.jdbc4.jdbc.SybPreparedStatement.execute(SybPreparedStatement.java:1398)


Read more...

Environment

  • Sybase Adatpive Server Enterprise (ASE) 12.5.4
  • SAP Adaptive Server Enterprise (ASE) 15.7 SP134
  • SAP Adaptive Server Enterprise (ASE) 16.0
  • JConnect version 15.7 SP133

Product

SAP Adaptive Server Enterprise 12.5 ; SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0

Keywords

dynamic statement, Exception , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , 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.