Home

	Expand Search

Troubleshooting and Error Messages Guide

Chapter 3 Error Message Writeups

Procedure Manager Errors

Error 2835

Error 2835

Severity

16

Error message text

The procedure tree is old. Use the sp_remap procedure to remap all the procedures in this database.

Explanation

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 cache from sysprocedures and recompiles it. Before Adaptive Server recompiles the procedure, it checks the 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.

This error can occur because the query remapping phase of an upgrade failed. If that is the case, all the query trees might need to be remapped.

Action

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_name2> 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, refer to "How to Remap All Objects in a Database" in the Encyclopedia of Tasks chapter.

Additional information

Refer to the Reference Manual for information about sp_remap.

Versions in which this error is raised

All versions