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

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 , SAP Business Suite on Sybase ASE Database Platform , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.