- Using Automatic Table Maintenance (ATM) window to start a scheduled job, and then stop SAP application and ASE database, ASE may fail to shutdown.
- Using isql to connect to ASE and run dbcc stacktrace on user spid running shutdown, it would show the stack trace as in the following example :
1> dbcc traceon(3604)
DBCC execution completed. If DBCC printed error messages, contact a user with System Administrator (SA) role.
1> dbcc stacktrace(95)
A SHUTDOWN command is already in progress. Please log off.
Start dbcc stacktrace...
pc: 0x000000000150247c upyield+0x10c()
pc: 0x000000000079c3db shutdownjobscheduler+0x55()
pc: 0x0000000001598c85 syb_polite_shutdown+0x85()
pc: 0x0000000001599662 syb_shutdown+0x152()
pc: 0x00000000010ff7b8 s_execute+0x9e38()
[Handler pc: 0x0x0000000001196560 hdl_stack installed by the following
[Handler pc: 0x0x0000000001133420 s_handle installed by the following
pc: 0x0000000001136fcb sequencer+0x17cb()
pc: 0x00000000007bae1c tdsrecv_language+0x1ec()
[Handler pc: 0x0x0000000001429220 ut_handle installed by the following
pc: 0x00000000007db028 conn_hdlr+0x1078()
dbcc stacktrace finished.
SAP Adaptive Server Enterprise (ASE) 15.7 SP42 for Business Suite
CR742249, 742249, "alter thread pool" , KBA , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , Bug Filed
About this pageThis 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.