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.