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
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.