SAP Knowledge Base Article - Preview

2916704 - Error 8601 when monitoring environment by running sp_showplan - SAP ASE

Symptom

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

1)

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


2)

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 ONE Support launchpad (Login required).

Search for additional results

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