SAP Knowledge Base Article - Preview

3024682 - Error 701 resulted in orphan temp table and signal 11 at s_handle() - SAP ASE

Symptom

  •  Concurrent execution of a query that create #temp table hit error 701. ASE report orphan temporary tables.

Error: 701, Severity: 17, State: 2
There is not enough procedure cache to run this procedure, trigger, or SQL batch. Retry later, or ask your SA to reconfigure ASE with more procedure cache.

  • ASE may also report an infected with signal 11 error at s_handle:

Current process (0x6e50373) infected with signal 11 (SIGSEGV) at s_handle
kisignal
s_handle
exc__raise
exc_raise
memcreate
tmp_create
s_normalize
sequencer
tdsrecv_language


Read more...

Environment

SAP Adaptive Server Enterprise (ASE) 16.0

Product

SAP Adaptive Server Enterprise 16.0

Keywords

tmp_create, memcreate, 701 , 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.