11
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:
The value of the number of open objects configuration parameter is too low
A problem exists in Adaptive Server
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:
The chapter “Setting Configuration Parameters” in the System Administration Guide: Volume 1
Adaptive Server Enterprise performance and tuning guides
If you cannot increase the value of number of open objects or the 225 error occurs again, call Sybase Technical Support for assistance.
All versions
