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 for Me (Login required).

Search for additional results

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