SAP Knowledge Base Article - Preview

2867616 - Changing a config parameter by sp_configure may not respond - SAP ASE

Symptom

  • When you try to change a configuration parameter by sp_configure, ASE does not respond; the connection hangs while executing sp_configure
    If dbcc stacktrace is run on the hung spid, a typical stack trace is :

upyield
uppushaffinity
cfg_create_file
cfg__setconfig
cfg_main
LeRun

  • There is a similar issue when you try to select from monLicense table.
    A typical stack trace from dbcc stacktrace is :

upyield
uppushaffinity
klicense_report
mda_exec
VTABRemoteAccess::startScan
LeScanOp::_LeOpNext


Read more...

Environment

  • SAP Adaptive Server Enterprise 15.7
  • SAP Adaptive Server Enterprise 16.0

Keywords

CR811271, CR#811271, sysconfigures, 11205, hang , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , 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.