SAP Knowledge Base Article - Preview

2253037 - In certain instances Error 3703 is raised when trying to drop a table with multiple triggers - ASE 16.0

Symptom

  • Attempting to drop a table raises error 3703
  • The table had at least one trigger on it that was a composite trigger (created for more than one of the actions insert, update, or delete)
  • The composite trigger was dropped before the table was dropped

    Msg 3703, Level 11, State 6:
    Server 'server_name', Line 1:
    Cannot drop the trigger with object-id XXXXXXXXXX in database Y , because it doesn't exist in the system catalogs.

Read more...

Environment

SAP Adaptive Server Enterprise (ASE) 16.0 GA and above

Product

SAP Adaptive Server Enterprise 16.0

Keywords

CR793076, sybase , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , BC-SYB-ASE-CE , ASE Cluster Edition (Standalone) , Bug Filed

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.