SAP Knowledge Base Article - Preview

2284019 - Error 12034 & 8601 when executing query on hot MDA tables in parallel from multiple sessions - SAP ASE

Symptom

  • Executing a query on hot MDA tables in parallel from multiple sessions.
       
  • A client session received the following error:

Msg 12034, Level 17, State 3:
Line 10:
Collection of monitoring data for table 'monProcessProcedures' failed due to insufficient memory. Retry when there is less load, or fewer users, on the server. 26 rows were not returned because 3744 bytes of memory could not be allocated.
Msg 8601, Level 20, State 1:
Line 10:
Process 21 tried to keep the PSS for process 23 when it already had the PSS for process 22 kept.
ASE is terminating this process.   

  • The ASE errorlog reported Error 8601 with a stack traces:

Error: 8601, Severity: 20, State: 1
Process 21 tried to keep the PSS for process 23 when it already had the PSS for process 22 kept

  • The stack trace may include modules such as:

pss_get_active_or_sick
mda_keep_pss
mda_fill_and_send_monProcessProcedures
mda_std_populate_pid
mda_exec
VTABRemoteAccess::getNext
VTABRemoteAccess::startScan(short, short, bool)
LeScanOp::_LeOpNext(ExeCtxt&)
LeEmitSndOp::_LeOpNext(ExeCtxt&)
LePlanNext


Read more...

Environment

SAP Adaptive Server Enterprise (ASE) 15.7 and 16.0

Product

SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0

Keywords

monitoring, diagnostic, CR793902, CR#793902, 793902 , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , 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.