SAP Knowledge Base Article - Preview

2886254 - A stack overflow reported when executing a batch with large number of inserts/updates - SAP ASE

Symptom

  • Trace flag 11013 must be enabled to encounter this issue.
  • ASE is configured for "Statement Cache".
  • A large batch with large number of insert/update statements failed.
  • The following error reports in the errorlog when trace flag 3687 is enable:

    kernel stack overflow first chance handler for task 49089076 at line 4453 in file /ase160sp03pl07x/SMP/porttree/svr/sql/generic/source/sequencer/s_stmtcache.c, current top of stack: 0x19d65c028. Cleanup will be attempted

  • The following error reports to the client:

    Error 3626, Level 17, State 1
    The transaction was aborted because it used too much stack space. Either use
    sp_configure to increase the stack size, or break the query into smaller pieces.
    spid: %d, suid: %d, hostname: %.*s, application name: %.*s


Read more...

Environment

  • Adaptive Server Enterprise 16.0 SP03 PL04
  • Adaptive Server Enterprise 16.0 SP02 PL08
  • Adaptive Server Enterprise 15.7 SP141

Product

SAP Adaptive Server Enterprise 15.7 ; 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.