SAP Knowledge Base Article - Preview

1938188 - ASE fails to shutdown after starting scheduled job from ATM - SAP ASE for Business Suite


  • 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)
2> go

DBCC execution completed. If DBCC printed error messages, contact a user with System Administrator (SA) role.

1> dbcc stacktrace(95)
2> go

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


SAP Adaptive Server Enterprise 15.7


CR742249, 742249, "alter thread pool" , KBA , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , Bug Filed

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.