Symptom
- DB Backup is taking long time
- dbcc stacktrace of the spid of "dump databse"
Start dbcc stacktrace...
pc: 0x0000000002254f1b upsleepgeneric+0x5cb()
pc: 0x0000000000c9bed7 dfl_dmp_sleep+0x3d()
[Handler pc: 0x0x0000000000beabd8 dpdb_handle installed by the following function:-]
pc: 0x0000000000be7594 dpdb_main+0x10e4()
pc: 0x000000000206c990 s_execute+0xdcb0()
[Handler pc: 0x0x00000000020c7590 hdl_stack installed by the followingfunction:-]
[Handler pc: 0x0x000000000208b480 s_handle installed by the following function:-]
pc: 0x000000000208fc93 sequencer+0xd13()
pc: 0x000000000184252a tdsrecv_language+0x1ea()
[Handler pc: 0x0x00000000021e6020 ut_handle installed by the followingfunction:-]
pc: 0x0000000001859119 conn_hdlr+0xf19()
dbcc stacktrace finished.
DBCC execution completed. If DBCC printed error messages, contact a user with System Administrator (SA) role.
- "update index statistics on table ** " maintained by ATM is running for a long time.
- The following error in ASE errorlog
Can't allocate space for object 'temp worktable' in database 'tempdb' because 'system' segment is full/has no free extents. If you ran out of space in syslogs, dump the transaction log. Otherwise, use ALTER DATABASE to increase the size of the segment.
Read more...
Environment
- SAP Adaptive Server Enterprise (ASE) 15.7 for Business Suite (BS) and Business Warehouse (BW)
- SAP Adaptive Server Enterprise (ASE) 16.0 for Business Suite (BS) and Business Warehouse (BW)
- SAP NetWeaver (NW) - All versions
Product
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.