SAP Knowledge Base Article - Preview

2239536 - concurrent SELECTs and 'update statistics" on large tables fail with Error 7794: SAP ASE


You find that sometimes, while the "update statistics" runs on certain large tables, concurrent SELECTs (isolation level 0 scans) on the same table fail with the errors: SQL error: "SQL code: 7794" occurred while accessing table "ABCD".

Database error text: "SQL message: [ASE Error SQL7794] [SAP] [ASE ODBC Driver]
You cannot scan table 'ABCD' at isolation level 0 because another process is runing a utility command
that is incompatible with level 0 scans. Please retry later.#"

On SAP systems, above errors will appear in ST22 short dumps or in SM21 system log. Per ASE documentation, 'update statistics' is compatible with level 0 scans.  We see isolation level 0 scans on large tables to fail with Error 7794, despite this allowance.



  • SAP Adaptive Server Enterprise (ASE) 15.7
  • SAP Adaptive Server Enterprise (ASE) 16.0
  • 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 Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0 ; SAP ERP 6.0


update statistics, ATM, isolation level 0 scans, SELECT , KBA , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , Bug Filed

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.