SAP Knowledge Base Article - Preview

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

Symptom

  • 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
function:-]
[Handler pc: 0x0x0000000001133420 s_handle installed by the following
function:-]
pc: 0x0000000001136fcb sequencer+0x17cb()
pc: 0x00000000007bae1c tdsrecv_language+0x1ec()
[Handler pc: 0x0x0000000001429220 ut_handle installed by the following
function:-]
pc: 0x00000000007db028 conn_hdlr+0x1078()
dbcc stacktrace finished.


Read more...

Environment

SAP Adaptive Server Enterprise (ASE) 15.7 SP42 for Business Suite

Product

SAP Adaptive Server Enterprise 15.7

Keywords

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 for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.