Error 15056

Severity

16

Message text

The root page %1! of index ID %2! for empty table '%3! can have at most one entry pointing to the first page %4!. However, it has either an incorrect entry, or more than one entries.

Explanation

In an empty table with an all-pages-locked (APL) clustered index, the root page should normally have only one entry pointing to the first data page. Similarly, in an empty table with an APL non-clustered index, the root page should normally be the same as first index page and have no entries or the root page may have one entry pointing to an index page. In any case, it should not have more than one entry. This error indicates that the root page was found to have more than one entry and is raised when the inconsistency is detected by dbcc checktable or dbcc checkdb.

Action

To correct the problem, drop and recreate the affected index.

Additional information

If the problem persists, contact Sybase Technical Support. If possible, have the details on hand about how this table is used, which may be helpful in determining the cause of the error.

Versions in which this error is raised

Version 12.0.0.8 and later