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.
SAP Knowledge Base Article - Preview