SAP Knowledge Base Article - Preview

2402944 - Data Collectors and Admin Procedure occur an error in job scheduling - SAP ASE

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

Product

SAP Adaptive Server Enterprise 16.0 ; SAP NetWeaver 7.5

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 ONE Support launchpad (Login required).

Search for additional results

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