Symptom
- You are running SAP applications on SAP ASE 160 SP02 PL04 HF1.
- dbcc checks on certain ASE tables fail with Errors 7794 and 678. The errors occur even if the database is in single-user mode.
The errors come up against dbcc checkstorage, dbcc checktable, dbcc tablealloc.
1> dbcc checktable(<tab1_GTT>)
2>
3> go
Checking table 'tab1_GTT' (object ID 1065219639): Logical page size is 16384 bytes.
Msg 7794, Level 16, State 6:
Server 'SID', Line 1:
You cannot scan table 'tab1_GTT' at isolation level 0 because another process is running a utility command that is incompatible with level 0 scans. Please retry later.
DBCC execution completed. If DBCC printed error messages, contact a user with System Administrator (SA) role.
※If the GTT have not been accessed in the session and not materialized, you will get 267 error.
1> dbcc checktable(<tab1_GTT>)
2> go
Msg 267, Level 16, State 5:
Server 'SID', Line 1:
Object '##tab1_GTT' cannot be found.
1> dbcc tablealloc ('tab1_GTT', full, fix)
2> go
Msg 7794, Level 16, State 6:
Server 'SID', Line 1:
You cannot scan table 'tab1_GTT' at isolation level 0 because another process is running a utility command that is incompatible with level 0 scans. Please retry later.
1> dbcc tablealloc ('tab1_GTT', full, nofix)
2> go
***************************************************************
TABLE: tab1_GTT OBJID = 1065219639
PARTITION ID=1730838248 FIRST=857 ROOT=857 SORT=0
Msg 678, Level 20, State 1:
Server 'SID', Line 1:
Invalid Buffer Cache Access: Could not open object '1730838248' in database '4'
- sp_help indicates these tables to be "Global Temporary Tables"
1> sp_help tab1_GTT
2> go
This table is a Global Temporary Table.
Read more...
Environment
- SAP Adaptive Server Enterprise (ASE) 16.0 SP02 PL04 HF1 for Business Suite
- SAP NetWeaver (NW) - All versions
- SAP Adaptive Server Enterprise (ASE)
Product
Keywords
dbcc, GTT, 7794, 267, CR#803302, CR803302, 803302 , KBA , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , 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.