SAP Knowledge Base Article - Preview

2916704 - Error 8601 when running sp_showplan - SAP ASE

Symptom

The following stack traces can occur occasionally when monitoring system by running sp_showplan, dbcc sqltext:

  • Error: 8601, Severity: 20, State: 1
    Process XX tried to keep the PSS for process 1 when it already had the PSS for process YY kept.
    ...
    pcstkwalk
    ucstkgentrace
    ucbacktrace
    terminate_process
    hdl_default
    s_handle
    exc_raise
    pss_get_active_or_sick
    ins_sysproc
    make_fake
    s__setup_tabsdes
    s_setuptables
    curs_open
    s_execute
    sequencer
    execproc
    s_execute
  • Current process (0x830042) infected with signal 11 (SIGSEGV)
    Address 0x0x0000000000f31149 (query_text+0x466), siginfo (code, address) = (1, 0x0x0000000000000020)
    ...
       SQL causing error : sp_showplan 23, null, null, null, 'short'
    ...
    pcstkwalk
    ucstkgentrace
    ucbacktrace
    terminate_process
    kisignal
    query_text
    LeRun
    LeEvals::LeEvRun
    LeExecEvals::exec
    s_exec_evals
    s_execute
    sequencer
    execproc
    s_execute


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 16.0 SP02 PL07

Product

SAP Adaptive Server Enterprise 16.0

Keywords

Error 8601 query_text LeRun LeEvals::LeEvRun LeExecEvals::exec pss_get_active_or_sick ins_sysproc make_fake PSS for process when it already had the PSS for process kept CR 812522 CR812522 sp_showplan dbcc sqltext , 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.