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 ONE Support launchpad (Login required).

Search for additional results

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