SAP Knowledge Base Article - Preview

3730698 - SUM fails with SQL Exception code 3616: An error was raised during trigger execution

Symptom

You are performing an SAP NetWeaver (SAP ERP) system upgrade or update.
During the 'Delete Backup Tables' phase, SUM process fails and Trouble Ticket log report following message:

-----------------------------------------------------------------------------------------------
An error occurred during the execution of Delete Backup Tables of action configure.

Service com.sap.sdt.j2ee.services.servicesimpl.DMTService failed with the following message:

Could not complete DMT process. Check the DMT.DROP_TABLE.LOG log file.
-----------------------------------------------------------------------------------------------


The  DMT.DROP_TABLE.LOG log file indicates:


-----------------------------------------------------------------------------------------------
<!--LOGGINGVERSION[2.0.7.1006]/-->
<!--NAME[disk:\software\SUM\sdt\log\DMT.DROP_TABLE_0x.LOG]/-->
<!--PATTERN[DMT.DROP_TABLE_0x.LOG]/-->
                    .                  .                    .

mm/dd/yyyy hh/mm/ss [Info  ]: Executes statement:
mm/dd/yyyy hh/mm/ss  [Info  ]: DROP TABLE BC_SLM_SDT_SRV_GRP
mm/dd/yyyy hh/mm/ss  [Info  ]: Error while executing statement.
mm/dd/yyyy hh/mm/ss  [Info  ]: An error was raised during trigger execution. The batch has been aborted and the user transaction, if any, has been rolled back.

      OpenSQLExceptionCategories: []

mm/dd/yyyy hh/mm/ss [Error ]: Error while executing statement.
mm/dd/yyyy hh/mm/ss [Error ]: Error while executing statement list.
mm/dd/yyyy hh/mm/ss  [Info  ]: Connection has been closed.

mm/dd/yyyy hh/mm/ss [Error ]: SQL Exception code 3616: An error was raised during trigger execution. The batch has been aborted and the user transaction, if any, has been rolled back.

      OpenSQLExceptionCategories: []

mm/dd/yyyy hh/mm/ss [Error ]: Could not execute the list of statements.
mm/dd/yyyy hh/mm/ss [Error ]: Could not execute DMT command runhandler. See previous messages.
-----------------------------------------------------------------------------------------------

 



Read more...

Environment

  • SAP Systems based on SAP Netweaver;
  • Microsoft SQL Server 2012 and higher;

Keywords

SQL Exception code 3616: An error was raised during trigger execution, SUM, upgrade, update, SQL Server, Java, ABAP, triggers, DDL , KBA , BC-DB-MSS , SQL Server in SAP NetWeaver Products , BW-SYS-DB-MSS , BW on Microsoft SQL Server , 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.