SAP Knowledge Base Article - Preview

3653581 - querying show_plan report a failure in VEH handler - ASE

Symptom

Querying show_plan reports the following stack trace in the error log:

SQL Text:
select @return_value = show_plan(@spid, @batch_id, @context_id, -1, @display_level)

curdb = 1 tempdb = 52 pstat = 0x10000 p2stat = 0x40001000
p3stat = 0x800 p4stat = 0x0 p5stat = 0x8 p6stat = 0x11 p7stat = 0x0
p8stat = 0x100 p9stat = 0x4010 p10stat = 0x1000
lasterror = 0 preverror = 0 transtate = 1
isolation = 1 tranmode = 0 xactcnt = 0 attn = 0 extattn = 0 memusage = 280
curcmd = 193 (SELECT) program = sqsh-3.0
extended error information: hostname: <hostname> login: <login>
The Adaptive Server will continue its execution as signal 11 is handled by vectored exception handler
VEH recovery in showplan module succeeds


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 16.0 SP04
  • SAP Adaptive Server Enterprise (ASE) 16.1

Product

SAP Adaptive Server Enterprise 16.0.4 ; SAP Adaptive Server Enterprise 16.1

Keywords

VEH, 831200, FR 831200, CR 831200, feature, request , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Product Enhancement

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.