SAP Knowledge Base Article - Preview

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

Symptom

  • 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. "

  • Similar messages in the ASE errorlog such as:

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.

  • Error 701 can also be reported on Java stack systems, with some similar stack:

#2.0#YYYY MM DD hh:mm:ss:xxx#+0530#Error#com.sap.sql.jdbc.direct.DirectPreparedStatement#
com.sap.sql_0003#BC-JAS-PER-SQL#opensqlkernel#C0000AC7034E069E00000007000025A4#3788950000000004#sap.com/com.sap.aii.adapter.rest.app#com.sap.sql.jdbc.direct.DirectPreparedStatement#Guest#0#JTA Transaction : 14946#12E8B97094D411E99BBF00000039D096#12e8b97094d411e99bbf00000039d0960#Thread[HTTP Worker [@150246888],5,Dedicated_Application_Thread]#Plain##
SQL error occurred on connection <SID>:<SID>:SAPSR3DB: code=701, state="ZZZZZ", message="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.
";

  • When a job/transaction failing with this is rerun, it may succeed since the procedure cache is not fully used all the time.


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 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.