3230693 - Database Dump/Backup fail 7712 Stored procedure 'saptools.dbo.SP_ADM_DUMPDB' may be run only in chained transaction mode.- SAP ASE for BS / BW

• Database dump/backup in DBA Cockpit failed with error:
  
  Msg 7712, Level 16, State 2:
  Stored procedure 'saptools.dbo.SP_ADM_DUMPDB' may be run only in chained transaction mode. The 'SET CHAINED ON' command will cause the current session to use chained transaction mode.
  
  
• The execution mode associated with 'SP_ADM_DUMPDB' is 'Chained' on the system.
  
  isql -Usapsa -S<SID> -X
  1> exec sp_procxmode 'SP_ADM_DUMPDB'
  2> go
   procedure name         user name                   transaction   mode 
  ------------------          ---------                      ------------------
   SP_ADM_DUMPDB          dbo                         Chained

• SAP Adaptive Server Enterprise (ASE) for Business Suite
• SAP Adaptive Server Enterprise (ASE) for Business Warehouse
• SAP Netweaver (NW) All versions

7712, SP_ADM_DUMPDB, chained transaction mode, SET CHAINED ON , database dump, backup , KBA , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , BW-SYS-DB-SYB , BW on Adaptive Server Enterprise , Problem