Symptom
- You are running applications on the SAP ASE database.
- You run a REORG DEFRAG on a user table and kill it because it takes too long to complete.
- Following this, isolation level 0 scans (dirty reads/SELECTs) against this table continue to fail with error 7794:
Msg 7794, Level 16, State 1: Server '<SID>', Line 1: You cannot scan table 'XXXX' at isolation level 0 because another process is running a utility command that is incompatible with level 0 scans. Please retry later.
- Per sp_who and sysprocesses outputs, there is no "reorg" or similar utility running on the table.
Read more...
Environment
- SAP Adaptive Server Enterprise (ASE) 16.0 for Business Suite
- SAP Adaptive Server Enterprise (ASE) 15.7 for Business Suite
- SAP NetWeaver (NW) - All versions
Product
SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0 ; SAP ERP 6.0
Keywords
CR771230, CR#771230, 771230 , 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.