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) 160 SP02 PL04 HF1

Product

SAP Access Control 10.1

Keywords

dbcc, GTT, 7794, 267 , KBA , BC-DB-SYB , SAP Business Suite on Sybase ASE Database Platform , 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 ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.