SAP Knowledge Base Article - Preview

3380150 - Signal 11 in function opt_like_and() with configurable parameters ‘statement cache size’ >0 and ‘enable literal autoparam’=1 -- SAP ASE


  • A query having LIKE CLAUSE sometimes caused signal 11 in function opt_like_and() with stack trace.
  • Configurable parameters ‘statement cache size’ > 0 and ‘enable literal autoparam = 1’.
  • Boot time trace flag -T7739 is on, this trace flag enables literal parameterization for strings in LIKE pattern and escape clause.
  • Statement cache memory usage (including SQL text and their query plans) had reached ‘statement cache size’ limit.



SAP Adaptive Server Enterprise (ASE) 16.0 SP04 PL01 HF2


SAP Adaptive Server Enterprise 16.0


CR 828452, 828452, -T7739, LIKE, like clause, literal parameterization, set literal_autoparam off , 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.