SAP Knowledge Base Article - Preview

2387290 - dbcc checks on Global Temporary Tables (GTT) fail with Error 7794 / 678 - SAP ASE

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

SAP Access Control 10.1

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.