16
The procedure tree is old. Use the sp_remap procedure to remap all the procedures in this database.
When you execute a stored procedure, Adaptive Server checks to determine whether the procedure is already in cache. If the procedure is not in cache, Adaptive Server reads the procedure into the sysprocedures cache and recompiles it. Before Adaptive Server recompiles the procedure, it checks the Adaptive Server release number of the procedure to make sure it is up-to-date for the current release.
Error 2835 occurs when:
The procedure is not up-to-date for the current release.
The query remapping phase of an upgrade failed. In this case, you may need to remap all the query trees.
Use sp_remap to remap each procedure, trigger, rule, default, and view in the current database:
1> use <database_name> 2> go
1> sp_remap <object_name> 2> go
Where <database_name> is the name of the database where the object resides and <object_name> is the name of the object to remap.
If you have many objects to remap, perform the procedure in “Remapping all database objects” in the most recent version of the Troubleshooting and Disaster Recovery guide.
Refer to the Reference Manual: Procedures for information about using sp_remap.
All versions