3663051 - SQL error "SQL code: 523" occurred while accessing table "table name".

The SAP NetWeaver (SAP ERP) system raises following ABAP dump during a SM13 process for updating a table. SM13 update is not completing its process,

-------------------------------------------------------------------------------------
Category                                            Installation error
Runtime Errors                                    DBSQL_SQL_ERROR
Exception                                            CX_SY_OPEN_SQL_DB
 
   Short Text
            SQL error "SQL code: 523" occurred while accessing table "KNC1".

   What happened?
           Database error text:
           "SQL message: A trigger returned a resultset and/or was running with SET NOCOUNT OFF while another outstanding result set was active."

     Error analysis

            During COMMIT WORK processing, an exception has occurred that could not be intercepted during processing.  
            To avoid inconsistencies, this  situation causes the session to abort, regardless of whether or not  there is an exception handler outside the COMMIT WORK statement.

            The reason for the exception is:

            Database error text: SQL message: A trigger returned a resultset and/or was  running with SET NOCOUNT OFF while another outstanding result set was active.
            Return value of the database layer: "SQL dbsl rc: 99"

    System environment
            SAP Release..... 7xx
            SAP Basis level  xxxx

            Operating system... Windows NT
            Database type..... MSSQL

                                          .          .          .

Database Interface Information

    C    1    ERROR: -1 in function ExeNormalModify (execute) [line xxxxx] [D:/depot/bas/7xx_/src/dbs/mss
    C    1    (523) [42000] [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]
                A trigger returned a resultset and/or was running with SET NOCOUNT OFF while another outstanding result set was  active."
    B    E    ***LOG BY4=> sql error 523    performing UPD on table <table name> [dbdbslst#xxxx]
    B    E    ***LOG BY0=> A trigger returned a resultset and/or was running with SET NOCOUNT OFF while another outstanding result set was  active."
-------------------------------------------------------------------------------------

• SAP NetWeaver based systems with ABAP stack
• Microsoft SQL Server 2012 and higher version

SAP NetWeaver, Microsoft SQL Server, triggers, update, database, SAP, tables , KBA , BC-DB-MSS , SQL Server in SAP NetWeaver Products , BW-SYS-DB-MSS , BW on Microsoft SQL Server , Problem