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 , SAP Business Suite on Sybase ASE Database Platform , 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.