SAP Knowledge Base Article - Preview

1906578 - Base table being altered causing error 208 / 4413 when selecting from view - SAP ASE

Symptom

  • Create view that involves 2 tables with ‘union’
  • Alter the base table to modify one column that does not involve in the views, select from view got error 208/4413:

1> select * from tempdb..v2
2> go
Msg 208, Level 16, State 1:
Server 'ase157', Line 1:
t1 not found. Specify owner.objectname or use sp_help to check whether the
object exists (sp_help may produce lots of output).
Msg 4413, Level 16, State 1:
Server 'ase157', Line 1:
View resolution could not succeed because the previously mentioned objects, upon
which the view 'a' directly or indirectly relies, do not currently exist. These
objects need to be recreated for the view to be usable.


Read more...

Environment

SAP Adaptive Server Enterprise (ASE) ALL Versions

Product

SAP Adaptive Server Enterprise all versions

Keywords

view,alter table,view resolution,Msg 4413 , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Bug Filed

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.