Symptom
On the Netweaver 7.50 System error occurs at DBA Cockpit Framework -> Data Collectors and Admin Procedures --> "resource limit" and "statement cache".
*******************************************************************************************************
Resource Limit: Error in job scheduling / execution (job exit code = 0; job user code=1-)
Start of routine: saptools..SP_DBH_THRESHOLDEVENT (log Level: 3)
Statement has been rolled back. Transaction is unaffected.
*******************************************************************************************************
SQL: INSERT INTO saptools..DBH_THRESHOLDEVENT (...)
SELECT ...
FROM master..monThresholdEvent AS EVENT LEFT OUTER JOIN master..monCachedStatement AS SQL_STMT
ON EVENT.ProcedureID = SQL_STMT.SSQLID
WHERE ( EVENT.ReportDatetime > @last_snap_time OR @last_snap_time IS NULL )
*******************************************************************************************************
Statement Cache: Error in job scheduling / execution (job exit code = 0; job user code=1-)
Start of routine: saptools..SP_DBH_STMTCACHE (log Level: 3)
Statement has been rolled back. Transaction is unaffected.
*******************************************************************************************************
SQL: INSERT INTO saptools..DBH_SNAP_STMTCACHE (...)
SELECT 'S' , ...
FROM master..monCachedStatement AS SRC_MONCACHEDSTMT
WHERE ( CAST ( SRC_MONCACHEDSTMT.UseCount AS BIGINT ) *SRC_MONCACHEDSTMT.AvgElapsedTime ) > @min_elapsedtime /*DBH_STMTCACHE: SNAPSHOT */
Read more...
Environment
- SAP Adaptive Server Enterprise 16.0 SP02 PL04
- SAP NetWeaver (NW) - All versions
Product
Keywords
Statement has been rolled back, Transaction is unaffected, Error in job scheduling, Start of routine, JS Agent error , 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.