Error 225



Message text

Cannot run query--referenced object (name  %.*s) dropped during query optimization.


This error occurs when Adaptive Server fails to build an execution plan for a stored procedure or an ad-hoc query because a referenced object was not found.

Some reasons for this error include:

This is not a serious error and does not indicate corruption. However, it may prevent you from running some stored procedures and ad hoc queries.

This error usually means a problem has occurred with Adaptive Server.


Using sp_configure, review the value of the configuration parameter number of open objects and increase this value if feasible. For information about memory-related configuration parameters, refer to:

If you cannot increase the value of number of open objects or the 225 error occurs again, call Sybase Technical Support for assistance.

Versions in which this error is raised

All versions