SAP Knowledge Base Article - Preview

2391577 - Msg 7941 on first execution of stored procedure - SAP ASE


  • Error #7941 with a message "Couldn't find table <derived_tablename>" rmay raise when a stored procedure selects from a derived table based on a table that has been modified using ALTER TABLE.

1> sp_emplist
2> go
Msg 7941, Level 16, State 10:
Server 'SERVER', Procedure 'sp_emplist', Line 4:
Couldn't find table e.

empname salary
------------------------------ -------------
xyz 3000.00
abc 4000.00

(2 rows affected)
(return status = 0)



  • SAP Adaptive Server Enterprise 15.7
  • SAP Adaptive Server Enterprise 16.0


Sybase Adaptive Server Enterprise 15.0


ASE, SP, recompile, cross database , 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.