SAP Knowledge Base Article - Preview

2635224 - Error 225 or 11049 when table variable used in derived table - SAP ASE


  • ASE outputs error 225 the first time a table variable is used within a derived table in a statement while statement cache is on.
  • ASE outputs error 11049 for subsequent executions of the statement while statement cache is on.


Msg 225, Level 16, State 1:
Line 3:
Cannot run query--referenced object (name NAME NOT RECOVERABLE) dropped during
query optimization.

Msg 11049, Level 16, State 3:
Server 'ASE', Line 3:
The definition of table variable '@tt' is missing. Make sure it is declared with
a table schema in the same batch before using it.



  • SAP Adaptive Server Enterprise (ASE) version 16.0 SP02 and higher
  • Table variable
  • Derived table
  • Statement Cache


SAP Adaptive Server Enterprise 16.0


Sybase, ASEServer, SAPASE, dataserver, table variable, derived table, statement cache , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , BC-SYB-ASE-CE , ASE Cluster Edition (Standalone) , 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.