SAP Knowledge Base Article - Preview

2605145 - Error 3703 on drop table with multiple triggers - SAP ASE

Symptom

  • You are receiving an Error 3703 when you are dropping a table with created triggers on it.
    Msg 3703, Level 11, State 6: Server 'ASE16', Line 1: Cannot drop the trigger with object-id 123456789 in database 1, because it doesn't exist in the system catalogs.
  • In other cases, you may receive an Error 15009 stating:
    Msg 15009, Level 16, State 1: Server 'ASE16X' , Line 1: Table Corrupt: Trigger (id 12345678) for table 'table1' was not found in sysobjects.


Read more...

Environment

Adaptive Server Enterprise (ASE) 16.0 SP03 PL02 and below.

Product

SAP Adaptive Server Enterprise 16.0

Keywords

3703, dbcc, checkcatalog, signal, 11, trigger, objects, utility , KBA , 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.