3378099 - ASE report Error 3626 and stack overflow messages - SAP ASE

• Running a select with large number of "OR" clauses. 
• The auditing is enable on the ASE.
• Client received error 3626:
  
  Msg 3626, Level 17, State 1:
  Server 'ASE', Line 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.
  
  
• ASE errorlog reports the following errors:
  
  stack overflow first chance handler for task 717555369 (spid 25226) at line 2847 in file /pbilam001_bld2/ase160sp02pl08x_oneoff/SMP/porttree/svr/sql/generic/source/sequencer/colnames.c, current top of stack: 0x2aacd5c5f698. Cleanup will be attempted
  task 717555369 prstack: 0x2aacd5c58710 prstackbound: 0x2aacd5c58710 prguardbound: 0x2aacd5c5f710
  stack_abort: kpid 717555369 spawn a stack tracer task with kpid 1256791322
  pc: 0x00002d1dcce5f850 ()
  stack overflow first chance handler for task 717555369 (spid 25226) at line 5653 in file /pbilam001_bld2/ase160sp02pl08x_oneoff/SMP/porttree/svr/sql/generic/source/sequencer/protect.c, current top of stack: 0x2aacd5c5f638. Cleanup will be attempted
  task 717555369 prstack: 0x2aacd5c58710 prstackbound: 0x2aacd5c58710 prguardbound: 0x2aacd5c5f710
  stack_abort: kpid 717555369 spawn a stack tracer task with kpid 1289318589
  kernel  pc: 0x00002d1dcce5f850 ()
  
  
• Under trace flag 3687, the sql generate the following stack in errorlog:
  
  stack overflow first chance handler for task 2293778 (spid 17) at line 5653 in file /pbilam001_bld2/ase160sp02pl08x_oneoff/SMP/porttree/svr/sql/generic/source/sequencer/protect.c, current top of stack: 0x16ab993d8. Cleanup will be attempted
  task 2293778 prstack: 0x16ab97430 prstackbound: 0x16ab97430 prguardbound: 0x16ab99430
  stack_abort: kpid 2293778 spawn a stack tracer task with kpid 2424851
  upsleepgeneric+0x513()
  upwait+0x58()
  stack_abort+0xca()
  stack_oflow+0x16a()
  prot__add_param+0x450()
  prot__add_param+0x1a8()
  prot__add_param+0x1a8()
  ...
  prot__add_param+0x1a8()
  prot__add_param_driver+0x59()
  prot_desc+0x4e1()
  colnames_driver+0x14a()
  s_normquery+0x135()
  s__call_normquery+0x66()
  s_normalize+0x67e()
  sequencer+0x2a1()
  tdsrecv_language+0x1df()
  conn_hdlr+0xe98()
  
  
  
  

SAP Adaptive Server Enterprise (ASE) 16.0

stack_oflow,prot__add_param,CR 824984 , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Product Enhancement