Server Error Messages 2500–2599

Number

Severity

Text and Explanation

2501

16

 Table named %.*s not found; check sysobjects

Explanation: Refer to the writeup for this error.

2502

16

 Table Corrupt: A page is linked in more than one chain; check this page:page number=%ld  allocation status=%d

Explanation: Refer to the writeup for this error.

2503

16

 Table Corrupt: Page linkage is not consistent; check the following pages: (current page#=%ld;  page# pointing to this page=%ld; previous page# indicated in this page=%ld)

Explanation: Refer to the writeup for this error.

2504

16

 Table Corrupt: The index id in alloc page does not match the index id in sysindexes (alloc page#=%ld;  extent id=%ld; index id in alloc=%d; index id in sysindexes=%d)

Explanation: There may be possible corruption in a database or a database object. Take any corrective action indicated by the message. Consult the Adaptive Server System Administration Guide and the Troubleshooting Guide.

2505

16

Table Corrupt: Free offset in page header is not reasonable; free offset should be >= %d and <= %d; check this page and offset (page#=%ld freeoffset on the page header=%ld)

Explanation: There may be possible corruption in a database or a database object. Take any corrective action indicated by the message. Consult the Adaptive Server System Administration Guide and the Troubleshooting Guide.

2506

16

 Table Corrupt: The values in adjust table should be in ascending order starting from the end of the table (page#=%ld  row#=%d); check adjust table in this row

Explanation: Refer to the writeup for this error.

2507

16

 Table Corrupt: Offset table is incorrect (page#=%ld  row#=%d offset in offset table is=%d  correct offset is=%d)

Explanation: Refer to the writeup for this error.

2508

16

 Table Corrupt: Row length is incorrect (page#=%d row#=%d minimum row length=%d row length=%d)

Explanation: A dbcc check detected table corruption. Refer to Encyclopedia of Tasks in this document, and Checking Database Consistency in the System Administration Guide, for help in identifying the affected object and determining appropriate corrective action.

2509

16

Table Corrupt: The row number and offset of each row in the page should have a matching entry in row number table; check this page (page#=%d row#=%d offset in row number table=%d)

Explanation: Refer to the writeup for this error.

2510

16

Key mismatch between index page %ld, at offset %d and data page %ld (row ID %d) in database ’%.*s’. Drop and re-create index id %d of table ’%.*s’.

Explanation: Refer to the writeup for this error.

2511

16

Keys of index id %d for table ’%.*s’ in %S_MSG not in correct order. Drop and re-create the index. (index page %d)

Explanation: Refer to the writeup for this error.

2512

16

 Table Corrupt: The specified row number %d in index page %ld cannot be found on data page %ld

Explanation: There may be possible corruption in a database or a database object. Take any corrective action indicated by the message. Consult the Adaptive Server System Administration Guide and the Troubleshooting Guide.

2513

16

 Table Corrupt: Object id %ld (object name = %S_OBJID) does not match between %.*s and %.*s

Explanation: Refer to the writeup for this error.

2514

16

 Table Corrupt: Type id %ld (type name = %.*s) does not match between %.*s and %.*s

Explanation: Refer to the writeup for this error.

2516

16

 Table Corrupt: Segment number %d does not match between %.*s and %.*s

Explanation: There may be possible corruption in a database or a database object. Take any corrective action indicated by the message. Consult the Adaptive Server System Administration Guide and the Troubleshooting Guide.

2517

16

 Table Corrupt: Procedure id %ld (procedure name = %S_OBJID) does not match between %.*s and %.*s

Explanation: Refer to the writeup for this error.

2518

16

 Database Corrupt: Incorrect last checkpoint in syslogs

Explanation: This message is generated when dbcc checkcatalog detects corruption in the syslogs table of a database. Collect dbcc output and report the error to Sybase Technical Support.

2519

16

 Database Corrupt: The last checkpoint in sysdatabases is incorrect.  Syslogs recorded a different checkpoint

Explanation: Refer to the writeup for this error.

2520

16

 Database named %.*s not found; check sysdatabases

Explanation: Refer to the writeup for this error.

2521

16

 Table Corrupt: Page is linked but not allocated. Run DBCC TABLEALLOC to correct the problem. (alloc page#=%ld, extent id=%ld, logical page#=%ld, object id in extent=%ld, index id in extent=%ld, object name=%S_OBJID)

Explanation: Refer to the writeup for this error.

2522

16

 Table Corrupt: The object id %ld (object name = %.*s) in page# %ld is different from the object id %ld (object name = %.*s) in sysindexes

Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by message.

2523

16

 Table Corrupt: Page number %ld is out of range for this database %S_DBID. The maximum page number in this database is %ld

Explanation: There may be possible corruption in a database or a database object. Collect dbcc output and report the error to Sybase Technical Support.

2524

16

 Table Corrupt: Row length is inconsistent between the computed row length and the recorded row length on page; check the following page and row: pageno=%ld row#=%d computed row length=%d row length on page=%ld

Explanation: Refer to the writeup for this error.

2525

16

 Table Corrupt: Object id wrong; tables: alloc page %ld  extent id=%ld  l page#=%ld objid in ext=%ld (name = %S_OBJID) objid in page=%ld (name = %S_OBJID) objid in sysindexes=%ld (name = %S_OBJID)

Explanation: Refer to the writeup for this error.

2526

16

 Incorrect DBCC command: Please see the SQL Server Reference Manual for DBCC commands and options.

Explanation: An attempt was made to execute an invalid dbcc command, or an incorrect number of parameters has been passed to a dbcc command.

2527

10

 DBCC detected internal database inconsistancy; contact a user with System Administrator (SA) role.

Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.

2528

10

 DBCC execution completed. If DBCC printed error messages, contact a user with System Administrator (SA) role.

Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.

2529

16

 Table Corrupt: Attempted to get page %ld, object %ld;  got page %ld, object %ld.

Explanation: Refer to the writeup for this error.

2531

16

 Table Corrupt: Index id on extent should be 0; check the following page and ids: alloc page=%ld  extent=%ld index id on extent=%d

Explanation: There may be possible corruption in a database or a database object. Takeany corrective action indicated by the message. Consult the Adaptive Server System Administration Guide and the Troubleshooting Guide.

2532

16

 Table Corrupt: No syslogs entry in sysindexes.

Explanation: There may be possible corruption in a database or a database object. Takeany corrective action indicated by the message. Consult the Adaptive Server System Administration Guide and the Troubleshooting Guide.

2533

16

 Table Corrupt: Incorrect index key length %d in internal (sarg) structure.

Explanation: There may be possible corruption in a database or a database object. Take any corrective action indicated by the message. Consult the Adaptive Server System Administration Guide and the Troubleshooting Guide.

2534

16

 Table Corrupt: No keys found on index page %ld. Offset for the free space: (freeoff=%ld)

Explanation: There may be possible corruption in a database or a database object. Take any corrective action indicated by the message. Consult the Adaptive Server System Administration Guide and the Troubleshooting Guide.

2535

16

 Table Corrupt: Page# %ld belongs to object id %ld (object name = %.*s) not object id %ld (object name = %.*s)

Explanation: There may be possible corruption in a database or a database object. Take any corrective action indicated by the message. Consult the Adaptive Server System Administration Guide and the Troubleshooting Guide.

2536

10

 Checking %.*s: Logical pagesize is %ld bytes

Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.

2537

10

 Checking %ld.

Explanation: This is an informational message. No action is required.

2538

10

 Alloc page %ld (# of extent=%ld used pages=%ld ref pages=%ld)

Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.

2539

10

 Total (# of extent=%ld used pages=%ld ref pages=%ld) in this database

Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.

2540

16

 Table Corrupt: Page is allocated but not linked; check the following pages and ids: allocation pg#=%ld extent id=%ld logical pg#=%ld  object id on extent=%ld (object name = %S_OBJID) indid on extent=%ld

Explanation: Refer to the writeup for this error.

2541

16

 Table Corrupt: object id does not match between extent in allocation page and sysindexes; check the following extent: alloc pg#=%ld extent#=%ld  object id on extent=%ld (object name = %.*s) object id in sysindexes=%ld (object name = %.*s)

Explanation: Refer to the writeup for this error.

2542

16

 Table Corrupt: Extent is linked in more than one chain.  Check the following allocation page and extent: alloc pg#=%ld extent#=%ld status=%d

Explanation: There may be possible corruption in a database or a database object. Take any corrective action indicated by the message. Consult the Adaptive Server System Administration Guide and the Troubleshooting Guide.

2543

16

 Table Corrupt: Extent structures are linked incorrectly; check the following extent: alloc pg#=%ld extent#=%ld previous extent# on this extent=%ld previous extent should be=%ld

Explanation: Refer to the writeup for this error.

2544

16

 Table Corrupt: Extent id %ld on allocation pg# %ld had object id %ld (object name = %.*s) on but used bit off

Explanation: Refer to the writeup for this error.

2545

16

 Table Corrupt: Extent#=%ld on allocation pg#=%ld was used but object id was 0,

Explanation: There may be possible corruption in a database or a database object. Takeany corrective action indicated by the message. Consult the Adaptive Server System Administration Guide and the Troubleshooting Guide.

2546

16

 Table Corrupt: Extent id %ld on allocation pg# %ld has objid %ld and used bit on, but reference bit off.

Explanation: Refer to the writeup for this error.

2547

16

 Table Corrupt: Segment number %d specified for use in the segment map in sysusages has no entry in syssegments. The entry in sysusages is for dbid %d (db name = %S_DBID), with a virtual starting address of %ld.

Explanation: Run dbcc checkcatalog, collect dbcc output and report the error to Sybase Technical Support.

2548

16

 There is no default segment specified in syssegments.

Explanation: Information in syssgements may be corrupt. Run dbcc checkcatalog, collect dbcc output and report the error to Sybase Technical Support.

2549

16

 There is more than one default segment specified in syssegments.

Explanation: Information in syssgements may be corrupt. Run dbcc checkcatalog, collect dbcc output and report the error to Sybase Technical Support.

2550

16

 Missing segment in sysusages segmap.

Explanation: Refer to the writeup for this error.

2551

10

 The following segments have been defined for database %d (database name %S_DBID).

Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.

2556

20

 Page #%ld of sysindexes in database %d not found in cache after read.

Explanation: Adaptive Server encountered an internal error affecting the current process. Reconnect to Adaptive Server. Report the error to your System Administrator so dbcc diagnostics can be run.

2557

14

 Only the owner of object `%.*s' or a user with System Administrator (SA) role can run DBCC %s on it.

Explanation: You do not have the permission to execute this command. Have the object owner or a user with the needed role run this command.

2558

16

 Extent not within segment: Object %ld, indid %d includes extents on allocation page %ld which is not in segment %d.

Explanation: Refer to the writeup for this error.

2559

16

 Data page number %ld is empty but is not the first page. Status = 0x%x.

Explanation: Refer to the writeup for this error.

2560

16

 Incorrect parameter passed to DBCC command.

Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by message.

2561

16

 Unable to open log for database %d.

Explanation: Adaptive Server could not perform the requested action. Contact your System Administrator.

2562

16

 %s cannot access object `%.*s' because it is not a table.

Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by message.

2563

14

 Only the DBO of database %S_DBID or a user with System Administrator (SA) role can run the DBCC CHECKCATALOG command.

Explanation: You do not have the permission to execute this command. Have the object owner or a user with the needed role run this command.

2564

14

 Only the DBO of database %S_DBID or a user with System Administrator (SA) role can run the DBCC CHECKDB command.

Explanation: You do not have the permission to execute this command. Have the object owner or a user with the needed role run this command.

2565

14

 Only the DBO of database %S_DBID or a user with System Administrator (SA) role can run the DBCC CHECKALLOC/CHECKGAM command.

Explanation: You do not have the permission to execute this command. Have the database owner or a user with SA role run this command.

2567

14

 Only the DBO of database %S_DBID or a user with System Administrator (SA) role can run the DBCC DBREPAIR command.

Explanation: You do not have the permission to execute this command. Have the object owner or a user with the needed role run this command.

2568

16

 Page %ld is out of range for this database

Explanation: There may be possible corruption in a database or a database object. Takeany corrective action indicated by the message. Consult the Adaptive Server System Administration Guide and the Troubleshooting Guide.

2570

10

 Warning - Page %ld has DEALLOC bit on - indid %d, status 0x%x

Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.

2571

14

 Permission denied.  Only a user with System Administrator (SA) role can use the DBCC command `%.*s'.

Explanation: Refer to the writeup for this error.

2572

10

 Database `%S_DBID' is not in single user mode - may find spurious allocation problems due to transactions in progress.

Explanation: Refer to the writeup for this error.

2573

16

 Database `%.*s' is not marked suspect. You cannot drop it with DBCC.

Explanation: Refer to the writeup for this error.

2574

16

 Index page number %ld is empty.  Status = 0x%x.

Explanation: There may be possible corruption in a database or a database object. Take any corrective action indicated by the message. Consult the Adaptive Server System Administration Guide and the Troubleshooting Guide.

2575

16

 The last page %ld in sysindexes for table `%.*s' has next page # %ld in its page header. The next page # should be NULL. Please check sysindexes.

Explanation: There may be possible corruption in a database or a database object. Takeany corrective action indicated by the message. Consult the Adaptive Server System Administration Guide and the Troubleshooting Guide.

2576

16

 The %S_MSG page %ld specified in sysindexes for table `%.*s' can not be found.  Please check sysindexes.

Explanation: There may be possible corruption in a database or a database object. Takeany corrective action indicated by the message. Consult the Adaptive Server System Administration Guide and the Troubleshooting Guide.

2577

16

 The root page %ld in sysindexes for table `%.*s' has next page # %ld and previous page # %ld in its page header. Both the next page # and the previous page # should be NULL.  Please check sysindexes.

Explanation: There may be possible corruption in a database or a database object. Takeany corrective action indicated by the message. Consult the Adaptive Server System Administration Guide and the Troubleshooting Guide.

2578

16

 The first page %d in sysindexes for table ’%.*s’ has previous page # %d in its page header. The previous page # should be NULL. Please check sysindexes.

Explanation: There may be possible corruption in a database or a database object. Take any corrective action indicated by the message. Consult the Adaptive Server System Administration Guide and the Troubleshooting Guide.

2579

10

 The total number of data pages in this table is %d.

Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.

2580

16

 The clustered index page (%S_PAGE) has an unexpected key pointer to an overflow data page (%S_PAGE).  Please check page status.

Explanation: There may be possible corruption in a database or a database object. Take any corrective action indicated by the message. Consult the Adaptive Server System Administration Guide and the Troubleshooting Guide.

2581

16

 Data page (%S_PAGE) indicates that an overflow page is linked to it; however, the next page (%S_PAGE) has not been marked as an overflow page.  Please check page status.

Explanation: There may be possible corruption in a database or a database object. Take any corrective action indicated by the message. Consult the Adaptive Server System Administration Guide and the Troubleshooting Guide.

2582

16

 Data page (%S_PAGE) has been marked as an overflow page; however, the previous page (%S_PAGE) does not indicate that there is an overflow page linked to it.

Explanation: See the writeup for Error 2582.

2583

10

 Number of data pages counted by DBCC differs from count in the data OAM.

Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.

2584

16

 The last key in the previous page (%S_PAGE) is equal to the first key in the current page (%S_PAGE); however, the status of current page does not indicate that it is an overflow page.

Explanation: There may be possible corruption in a database or a database object. Take any corrective action indicated by the message. Consult the Adaptive Server System Administration Guide and the Troubleshooting Guide.

2585

16

 The last key in the previouse page (%S_PAGE) is equal to the first key in the current page (%S_PAGE); however, the status of previous page indicates that there is a disconnected overflow page.

Explanation: There may be possible corruption in a database or a database object. Take any corrective action indicated by the message. Consult the Adaptive Server System Administration Guide and the Troubleshooting Guide.

2586

16

 The last key in the previous page (%S_PAGE) is equal to the first key in the current page (%S_PAGE); however, the status of previous page indicates that there is no overflow page.

Explanation: There may be possible corruption in a database or a database object. Take any corrective action indicated by the message. Consult the Adaptive Server System Administration Guide and the Troubleshooting Guide.

2587

16

 The last key in the previouse page (%S_PAGE) is not equal to the first key in the current page (%S_PAGE); the current page is an overflow page; however, the status of previous page indicates that there is no disconnected overflow page.

Explanation: There may be possible corruption in a database or a database object. Take any corrective action indicated by the message. Consult the Adaptive Server System Administration Guide and the Troubleshooting Guide.

2589

16

 Object `%.*s' must have its status updated in sysobjects, to reflect the intent of repairing the index on it.

Explanation: Adaptive Server could not perform the requested action. Contact your System Administrator.

2590

16

 DBCC option available for system tables only.

Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by message.

2591

16

 Could not find index row which has id %d for table `%.*s'.

Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by message.

2592

10

 %s index successfully restored for object `%.*s' in `%.*s' database.

Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.

2593

10

 There are %d rows in %ld pages for object `%.*s'.

Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.

2594

16

 Invalid index id specified (index id = %d).

Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by message.

2595

16

 Database `%.*s' must be set to single user mode before executing this command.

Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by message.

2596

16

 %S_PAGE has an incorrect pgfreeoff value of %d. The offset should be %d.

Explanation: Refer to the writeup for this error.

2597

16

 The database is not open. Please issue a `use %.*s' and re-run the DBCC command.

Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by message.

2598

16

 Indexes on sysobjects and sysindexes cannot be recreated.

Explanation: You cannot recreate the indexes on these system tables.

2599

16

 Invalid monitor group specified: `%.*s'. Please re-enter.

Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by message.