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 ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.