SAP Knowledge Base Article - Preview

2402937 - DBA Cockpit Statement Cache SP_DBH_STMTCACHE Error in job scheduling / execution: Statement has been rolled back. Transaction is unaffected

Symptom

  • Data Collection Framework Statement Cache shows error message in Object Log:
      

           **********************************************************

           Start of routine: saptools..SP_DBH_STMTCACHE (Log Level: 3)
           Statement has been rolled back. Transaction is unaffected.
           Error in job scheduling / execution (job exit code = 0; job user code = 1-)  

           ***********************************************************

  • No error/warning found in job scheduler history and log file(sybmgmtdb..js_history and sybmgmtdb..js_output);
  • No error messages found in ASE server/database log file;
  • The query involved in is as like following:

            *************************************************************************

INSERT INTO saptools..DBH_SNAP_STMTCACHE(....)
SELECT ....
FROM master..monCachedStatement AS SRC_MONCACHEDSTMT WHERE (...) /* DBH_STMTCACHE: SNAPSHOT */

**************************************************************************


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 16.0 SP02 PL04 for Business Suite
  • SAP Enterprise Resource Planning (ERP) 6.0
  • SAP NetWeaver (NW) 7.40 SP14

Product

SAP Adaptive Server Enterprise 16.0 ; SAP ERP 6.0 ; SAP NetWeaver 7.4

Keywords

SYB, ASE, dbacockpit, DBA cockpit, data collector, RETURN_CODE 3601, monCachedStatement, DBH_SNAP_STMTCACHE, Cached Statements , KBA , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , 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.