Symptom
- 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
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
Read more...
Environment
- 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
Product
Keywords
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.