SAP Knowledge Base Article - Preview

1933464 - Error SQL701 "There is not enough procedure cache..." - SAP ASE for Business Suite

Symptom

  • You see this ABAP dump error reported frequently from ST22:

Category Installation Errors
Runtime Errors DBIF_RSQL_SQL_ERROR
Except. CX_SY_OPEN_SQL_DB
Date and Time <timestamp>


Short text
SQL error 701 when accessing table "<tablename>".

What happened?
Error Text of the Database: "[ASE Error SQL701]There is not enough procedure
cache to run this procedure, trigger, or SQL batch. Retry later, or ask your
SA to reconfigure ASE with more procedure cache. "

  • You should see similar messages like this in the ASE errorlog:

Error: 701, Severity: 17, State: 12
There is not enough procedure cache to run this procedure, trigger, or SQL batch. Retry later, or ask your SA to reconfigure ASE with more procedure cache.


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 15.7 and 16.0 for Business Suite
  • SAP NetWeaver (NW) - All versions 

Product

SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0 ; SAP NetWeaver all versions

Keywords

"procedure cache", SQL701, 701, ASE sizing , KBA , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , 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.