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 , SAP Business Suite on Sybase ASE Database Platform , 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.