SAP Knowledge Base Article - Preview

3429935 - (ssql__rmplans) SAP_ASE INFO: SSQL_DESC

Symptom

  • ASE errorlog reports messages including ssql__rmplans and VEH_stmtcache function names

    (ssql__rmplans) SAP_ASE INFO: SSQL_DESC at 0x0x22fb26c50 was added to freelink already. Freelink next is 0x0x220b15458, prev is 0x0x1feb0af18
    (VEH_stmtcache) SAP_ASE INFO: SIGSEGV happened in routine ssql_release

  • As a result many spids report timeslices:

    Warning: The internal timer is not progressing. If this message is generated multiple times, report to SAP Technical Support and restart the server (alarminterval=-1113).
    Spid 123 exhausted its 'time slice' of 100 milliseconds and additional 'cpu grace time' of 150000 milliseconds. Resetting 'time slice' for 1 (out of 3) time(s) as Adaptive Server has recorded excessive page fault. Page fault pattern: 0x1.
    Spid 456 exhausted its 'time slice' of 100 milliseconds and additional 'cpu grace time' of 150000 milliseconds. Resetting 'time slice' for 1 (out of 3) time(s) as Adaptive Server has recorded excessive page fault. Page fault pattern: 0x1.
    etc

  • Due to many timeslices, ASE engines cannot process other tasks and appears to be hung


Read more...

Environment

SAP Adaptive Server Enterprise 16.0 SP03 & SP04

Product

SAP Adaptive Server Enterprise 16.0

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

Search for additional results

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