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
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.