Error 7134

Severity

16

Message text

The text table and the table referenced by the text pointer value %s disagree. This text pointer references first text page %d, which belongs to object ID %d.

Explanation

Adaptive Server stores text, image, or unitext data in text extents separate from the rest of the table. Each extent contains text data for a given table, and may contain multiple text chains corresponding to text contained in different rows and text columns of the table.

The Adaptive Server Text Manager validates text, image, or unitext pages during processing. Error 7134 is raised if the Text Manager finds that the object ID of a text, image, or unitext page does not match the object ID of the text, image, or unitext extent to which the page belongs.

Action

If error 7134 is raised when you select text, image, or unitext columns within a trigger, note that Adaptive Server does not provide the ability to select text, image, or unitext datatypes from the inserted or deleted table. You must re-code the trigger to resolve this problem.

If the error is raised in some other context not involving triggers, the problem is typically due to a small number of bad rows in a table with text, image, or unitext data. To correct the problem, use the following procedure to drop and re-create those rows.

  1. Identify the table for which the error was raised.

  2. Run dbcc checktable on the table.

  3. Correct any errors detected by dbcc checktable using the sections in this manual that refer to those errors.

  4. If the error persists, contact Sybase Technical Support for assistance.

Additional information

When calling Technical Support, have the information available that is listed in “Reporting errors”.

Versions in which this error is raised

All versions