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
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.
SAP Knowledge Base Article - Preview