SAP Knowledge Base Article - Preview

2044209 - How to solve SQL4956, SQL4720, SQL7794 errors in SAP BW or BPC on SAP ASE

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.