SAP Knowledge Base Article - Preview

3126084 - Corruption after drop trigger - SAP ASE

Symptom

After drop trigger. The dbcc checkcatalog reported the following corruption. 

dbcc checkcatalog (mydb)
go
Checking mydb: Logical pagesize is 8192 bytes
Msg 15009, Level 16, State 1:
Server 'myserver', Line 1:
Table Corrupt: Trigger (id 71965714) for table 'ticket_rules' was not found in sysobjects.
Msg 2513, Level 16, State 12:
Server 'myserver', Line 1:
Table Corrupt: Object id 71965714 (object name = 71965714) does not match between sysobjects and sysconstraints


Read more...

Environment

SAP ASE 16.0

Keywords

CR825879, CR#825879, Msg 15009, Msg 2513, Table Corrupt: Trigger, does not match between sysobjects and sysconstraints , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Known Error

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.