SAP Knowledge Base Article - Preview

2537375 - SQL701 error reported during DTP load or BW reporting - SAP BW on ASE


  •  On SAP BW and Solution Manager systems running on SAP ASE, datloads, DTPs, BW reports fail with ASE Error 701:

    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.
  • A DTP job fails due to this error reported on SM37 log just after an alter table... add partition:

xx.xx.xxxx xx:xx:xx  alter table "/BI0/FXXXX" add partition ( DBMAN 099 I
xx.xx.xxxx xx:xx:xx  "/BI0/FXXXX_000000XXX" values <= (nnnn) ) DBMAN 099 I
xx.xx.xxxx xx:xx:xx  SQL-END: xx.xx.xxxx xx:xx:xx  00:00:42 DBMAN 099 I
xx.xx.xxxx xx:xx:xx SQL Error: [ASE Error SQL701][SAP][ASE ODBC Driver][Adaptive Server Enterprise]Ther
xx.xx.xxxx xx:xx:xx System error: RSDU_PART_GENERIC_ADD_SYB SYBASE 701 [ASE Error SQL701][SAP][ASE ODBC Driver][Adaptive

  • ST22 short dump and the corresponding developer / work process trace file may report: 

C Xxx Xxx xx xx:xx:xx xxxx
C ERROR: -1 in function ExecuteAndFlush (SQLExecDirect) [line 12552]
C (701) [ZZZZZ] [SAP][ASE ODBC Driver][Adaptive Server Enterprise]There is not enough procedure
C cache to run this procedure, trigger, or SQL batch. Retry later, or ask your SA
C to reconfigure ASE with more procedure cache.

  • SAP BW Correction Collection note (latest version for the corresponding SAP Basis release) is implemented

  • t-code SE38 -> ABAP report RSSYBDBVERSION reports all GREEN lights

  • Increasing the value of ASE configuration parameter "procedure cache size" (per SAP KBA 1933464 and ASE Sizing Chart in the Best Practices Guide SAP Note 1680803) does not help resolve the Error 701 - these errors persist



  • SAP Adaptive Server Enterprise (ASE) 16.0 for Business Suite
  • SAP Business Warehouse - All versions 
  • SAP Solution Manager 7.2


SAP NetWeaver 7.4


701, Msg 701, "procedure cache", compression, infocube, partitions, SQL701

, KBA , BW-SYS-DB-SYB , BW 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.