SAP Knowledge Base Article - Preview

2252633 - Error 941 when a trigger is executed from a different database from where the trigger was created. - SAP ASE 16.0

Symptom

  • If a table has more than one trigger of the same type (insert, update or delete) on the same table
  • Error 941 is raised when trying to update that table from within a different database than where the two triggers were created:

Msg 941, Level 20, State 1:
Server 'server_name', Line 1:
Illegal database context operation.
ASE is terminating this process.

  • Then the isql session terminates.
  • ASE log shows a stacktrace including functions :

closedb
exectrig


Read more...

Environment

SAP Adaptive Server Enterprise (ASE) 16.0 GA and higher

Product

SAP Adaptive Server Enterprise 16.0

Keywords

CR793016, 793016, cross-database, DML , closedb , exectrig , message, CR#793016 , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Bug Filed

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.