SAP Knowledge Base Article - Preview

3136979 - Issue with stored procedure after upgrading from 15.7 to 16.0 - SAP ASE

Symptom

ASE seemed to hang and was unresponsive, some observations were:

  • Observed device time out error and 16K Pool error for tempdb_cache 
  • Device timeout errors (there are more in the log than posted here)
    kernel  Spid 2713 has exceeded its timeout value while issuing a write for virtual device 234 ('/path/dev_006'). A system call has not responded for 150 seconds, and Adaptive Server will be impacted until it returns. Contact your operating system vendor for assistance.
    ernel  Spid 244 has exceeded its timeout value while issuing a write for virtual device 234 ('/path/dev_006'). A system call has not responded for 150 seconds, and Adaptive Server will be impacted until it returns. Contact your operating system vendor for assistance.
  • 16K info
    The 16K memory pool of named cache tempdb_cache (cache id 16, cachelet id 12) is configured too small for current demands (state 4). Transaction progress may cease or response time may increase.


Read more...

Environment

SAP Adaptive Server Enterprise 16.0

Product

SAP Adaptive Server Enterprise 15.7

Keywords

KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Problem

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.