SAP Knowledge Base Article - Preview

2297847 - Error 2809 and 4401 after table is renamed using sp_rename - SAP ASE

Symptom

  • A stored procedure fails with Error 2809 and 4401

Msg 2809, Level 18, State 2:
Server 'ASE157', Procedure 'test_proc', Line 1:
The request for view 'obj_1' failed because 'obj_1' is a table object.
Msg 4401, Level 16, State 2:
Server 'ASE157', Procedure 'test_proc', Line 1:
View 'obj_1' no longer exists.

  • This occurs if the stored procedure accesses a table which is renamed later.
  • The original table name is used for a new view temporarily, and then, even after dropping the view and renaming the original table back into the original name, the stored procedure could not work.


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 15.7 SP63 and higher
  • SAP Adaptive Server Enterprise (ASE) 15.7 SP136 and higher

Product

SAP Adaptive Server Enterprise 15.7

Keywords

dbcc, upgrade_object, CR797450, CR#797450, 797450 , 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.