SAP Knowledge Base Article - Preview

2514941 - Querying derived table in stored procedure returns Msg 225, Level 16,state 3 - ASE


When querying a derived table within a stored procedure ASE will return:

Msg 225, Level 16,state 3

Cannot run query--referenced object (name NAME NOT RECOVERABLE) dropped during
query optimization.



  • SAP Adaptive Server Enterprise (ASE) 15.7
  • SAP Adaptive Server Enterprise (ASE) 16.0


SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0


CR810050, derived table in stored proc , 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.