Symptom
You are running SAP Applications on SAP Adaptive Server Enterprise. The following errors appear in the system log or are raised during user processing:
-
[ASE Error SQL4956]Cannot alter table if REORG command or level 0 scans are active.
The ALTER TABLE command is similar to: alter table "/BI0/F<cube>" add partition ("/BI0/F<cube>_<n>" values <= (<request id>)
-
[ASE Error SQL4720]Cannot truncate table '<n>' because there are one or more isolation level 0 scans, or REORG command, active on the table.
-
[ASE Error SQL7794]You cannot scan table '/BI0/F<cube>' at isolation level 0 because another process is running a utility command that is incompatible with level 0 scans. Please retry later.
Read more...
Environment
- SAP Adaptive Server Enterprise (ASE) 15.7 for Business Suite (BS) and Business Warehouse (BW)
- SAP Solution Manager (SOLMAN) 7.1
Product
SAP Adaptive Server Enterprise 15.7 ; SAP Solution Manager 7.1
Keywords
sybase; ASE Error SQL 4956 ; ASE Error SQL 4720 ; ASE Error SQL 7794 ; business warehouse ; business planning ; BPC ; Solution Manager ; E2E ; DBIF_RSQL_SQL_ERROR ; CX_SY_OPEN_SQL_DB , KBA , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , 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.