SAP Knowledge Base Article - Preview

2824091 - A task running in saptools database is not finished for a long time.

Symptom

  • There's a ong running task and its status is sleeping.

    dbid reserved spid page xactid masterxactid starttime name xloid
    --------------------------------------------------------------------------
    5 0 307 2420564 [B@66a8c396 [B@51c0e181 2019-07-04 00:00:33.946 $chained_transaction 614

  • the call stacks of spid 307 from dbcc stacktrace()

    Start dbcc stacktrace...
    pc: 0x09c059d30b2fbd19 ()
    pc: 0x00000001001476fc kpsuspend.fdpr.chunk.1+0x8()
    pc: 0x00000001004dd31c upsleepgeneric+0x2ac()
    pc: 0x0000000100daa7ec des_do_get.fdpr.chunk.30+0x1f8()
    [Handler pc: 0x00000001000b0894 hdl_backout_msg installed by the following function:-]
    pc: 0x000000010058f018 open_get_cacheid+0xec()

  • stacktrace raised at the time

    pc: 0x0000000100795a3c ex_raise+0x13c()
    pc: 0x0000000100db783c des__clean.fdpr.chunk.2+0x8c()
    pc: 0x0000000100dbf208 des__scavenge+0x6d8()
    pc: 0x0000000100dbea64 des_scavenge_for+0x1c()
    pc: 0x0000000100da434c ind__ides_scavenge+0x90()
    pc: 0x0000000100d9c9f0 ind__ides_install.fdpr.chunk.5+0x4c()
    pc: 0x000000010055cc08 ind__ides_init_fromrow+0x54()
    ...


Read more...

Environment

SAP Adaptive Server Enterprise (ASE) 16.0 SP01 PL01 for Business Suite

Product

SAP ERP 6.0

Keywords

CR786588, CR 786588, 786588 , 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.