SAP Knowledge Base Article - Preview

2778399 - After altering a table to drop a column, ASE may hit a 3916 error when running a previously compiled stored proc that references that table.

Symptom

After altering a table to drop a column, ASE may hit a 3916 error when running a previously compiled stored procedure that references that table.


Error: 3916, Severity: 26, State: 3
Internal transaction lock context chains mixed up.This is an internal system error.

xact__commit_internal
xact_commit
vu_redefine
vu_getviewdefn
vu_analyze_view
vu_call_analyze_view
vu_view_driver
vu_maincmdloop
vu_findviews
vu_res_view
pre_aggview
s_preprocess
s_compile


Read more...

Environment

  • Adaptive Server Enterprise (ASE) 12.5
  • Adaptive Server Enterprise (ASE) 15.x

Product

SAP Adaptive Server Enterprise 12.5 ; SAP Adaptive Server Enterprise 15.7

Keywords

error 3916, State: 3, alter table, Internal transaction lock contex, vu_getviewdefn, vu_analyze_view, vu_call_analyze_view, ASE , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , 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.