SAP Knowledge Base Article - Preview

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

Symptom

  • 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.

Examples:

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.


Read more...

Environment

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

Product

SAP Adaptive Server Enterprise 16.0

Keywords

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

Search for additional results

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