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.
SAP Knowledge Base Article - Preview