SAP Knowledge Base Article - Preview

3097911 - Saptools long running unable to clear or kill

Symptom

Sometimes, below SELECT statement from dumphist file raised timeslice 5340.

SELECT 'S' AS COLLECT_MODE,
        'Aug 17 2021  8:15PM' AS SNAPSHOT_TIMESTAMP,
        TIMESTAMP_UTC AS TIMESTAMP_UTC,
        110 AS METRIC_ID,
        null AS INSTANCEID,
        null AS SITE,
        DB_Name AS ENTITY,
        'PATH=' || DB_Name AS RESOURCE,
        CAST((value) AS VARCHAR(35)) AS METRIC_VALUE_S,
        CAST((value) AS DECIMAL(34,9)) AS METRIC_VALUE,
        'Minutes' AS UNIT,
        (saptools.dbo.sap_realhostname(null)) AS SOURCE_HOSTNAME
 FROM   (select getutcdate() AS TIMESTAMP_UTC,
                name as DB_Name,
                min(datediff(mi,dump_date,'Aug 17 2021  8:15PM')) as 'value'
           from saptools..historyDumps
          WHERE status = 1 and (rec_type = 2 or rec_type = 5 ) group by name) corTab

00:0012:00000:00231:2021/08/17 19:09:22.62 kernel  timeslice -5340, current process infected at 0x7f1b3e89ee1d (read+0x2d)
...

00:0012:00000:00231:2021/08/17 19:09:22.64 kernel  pc: 0x00000000015848e0 kitermproc+0x1c8()
00:0012:00000:00231:2021/08/17 19:09:22.64 kernel  pc: 0x00007f1b3e89fc00 (null)+0x3e89fc00()
00:0012:00000:00231:2021/08/17 19:09:22.64 kernel  pc: 0x000000000155fcbb ufread+0x292()
00:0012:00000:00231:2021/08/17 19:09:22.64 kernel  pc: 0x00000000016f1229 FILERemoteAccess::getNext()+0xd9()
00:0012:00000:00231:2021/08/17 19:09:22.64 kernel  pc: 0x00000000018b8303 LeScanOp::_LeOpNext(ExeCtxt&)+0xbe3()


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 16.0 for Business Suite
  • SAP Solution Manager (SOLMAN) 7.2

Keywords

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.