SAP Knowledge Base Article - Preview

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


  •  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

  • From dev trace file: 

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.
C DbSlExecute - Error 99 (dbcode 701) on DDLExecute
C DbSlExecute - <alter table "/BI0/FXXXX" add partition ( "/BI0/FXXXX_000000XXX" values <= (nnnn) ) >
C dbdssyb: DBSL99 SQL701

  • SAP Note BW Correction Collection related to the BW version is implemented



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


SAP NetWeaver 7.4


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 ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.