Error 2805

Severity

20

Message text

Bad pointer 0x%lx encountered while remapping stored procedure '%.*s'.  Must re-create procedure.

Explanation

When a stored procedure is created, Adaptive Server stores an efficient, normalized form of the procedure called a query tree in the sysprocedures table. When you upgrade the server, the query trees for stored procedures and certain other database objects may be remapped to be compatible with the new release.

Error 2805 is seen:

This error may be accompanied by error 2812.

Action

Resolve the problem by dropping and re-creating the procedure.

Versions in which this error is raised

All versions