- 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.
SAP Adaptive Server Enterprise (ASE) 15.7 and 16.0 for Business Suite (BS)
CR771230, 771230 , KBA , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , Bug Filed
About this pageThis 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.