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