Error 7783

Severity

10

Message text

Internal error -- server failed to do garbage collection on this procedure, id = %ld.  Please save the query tree and procedure text and inform the technical support.  This is not a critical error, so server continues processing.

Explanation

Remapping a stored procedure, view or trigger generally causes the object to grow. After remapping, Adaptive Server compresses the object. Error 7783 occurs when Adaptive Server is unable to reclaim space after remapping the query tree. This occurs during execution of:

• Stored procedures or triggers

• Recovery, usually following a load database

This error is an Adaptive Server problem and is frequently accompanied by error 7961 (“Remapping utility - Wrong kind of node passed to tree remapping. This is an internal system error.”).

Although the server is unable to reclaim space, error 7783 does not cause severe problems and the procedure or trigger continues processing.

Action

Take these steps to resolve the error:

1. Identify the stored procedure, view, or trigger:

   1> select object_name(<object_id>)
   2> go
   

   Where <object_id> is the ID named in the error message.

2. Check that the object text is available. It is important to verify this before you continue with the next step.

3. Drop and re-create the object. Note that you are re-creating the stored procedure, view, or trigger, and no changes are needed to the underlying tables.

4. If the error results in a stack trace or is accompanied by the 7961 error, you may need to upgrade to a version in which the problem is resolved. Call Sybase Technical Support for assistance.

Additional information