Number
|
Severity
|
Text and Explanation
|
9901
|
14
|
Permission denied. Only a user with curread set to @@data_high can perform the DBCC command `%.*s'.
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.
|
9902
|
14
|
Only users with SA and SSO roles can run this dbcc dbrepair command for the database %S_DBID.
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.
|
9903
|
14
|
Only users with SA and SSO roles having their curread dominating the maxhold of the database can run this dbcc dbrepair command for the database `%S_DBID'.
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.
|
9904
|
10
|
Total (# of text chains = %ld text pages = %ld) in this table.
Explanation: This is an informational message. Unless otherwise specified,
no action is required. Contact your System Administrator about any
warning issued in the message.
|
9905
|
10
|
Processed %ld tables. Found %ld good text entries, %ld bad text entries 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.
|
9906
|
16
|
Unrecognized option. Available options: dbcc engine(net, show, engine#), dbcc engine(net, showall), dbcc engine(net, netengine)
Explanation: Command failed due to invalid or illegal request. Check syntax,
semantics, and permissions. Take any corrective action indicated
by message.
|
9908
|
16
|
Syspartitions system table does not exist in database id %S_DBID.
Explanation: Adaptive Server could not perform the requested action. Modify
your command to meet the Adaptive Server requirement for the objects
or variables shown in the error message.
|
9909
|
10
|
The total number of data pages in partition %d 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.
|
9911
|
10
|
Object %ld has one row in Syspartitions
Explanation: This is an informational message. Unless otherwise specified,
no action is required. Contact your System Administrator about any
warning issued in the message.
|
9912
|
10
|
Object %ld has partition %ld instead of %ld in Syspartitions
Explanation: This is an informational message. Unless otherwise specified,
no action is required. Contact your System Administrator about any
warning issued in the message.
|
9913
|
16
|
MAX_ROWS_PER_PAGE value of %d is invalid. It must be between 0 and %d.
Explanation: Command failed due to invalid or illegal request. Check syntax,
semantics, and permissions. Take any corrective action indicated
by message.
|
9914
|
16
|
Amount of memory transferred (%dk) is less than the amount of memory requested (%dk).
Explanation: Command failed due to invalid or illegal request. Check syntax,
semantics, and permissions. Take any corrective action indicated
by message.
|
9915
|
16
|
I/O size must be a power of 2.
Explanation: Command failed due to invalid or illegal request. Check syntax,
semantics, and permissions. Take any corrective action indicated
by message.
|
9916
|
16
|
I/O size must be a power of 2.
Explanation: Command failed due to invalid or illegal request. Check syntax,
semantics, and permissions. Take any corrective action indicated
by message.
|
9917
|
16
|
Can't find database id for %.*s. Check that this database exists and re-run the command.
Explanation: Command failed due to invalid or illegal request. Check syntax,
semantics, and permissions. Take any corrective action indicated
by message.
|
9918
|
16
|
Encountered error using dbid %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.
|
9919
|
16
|
Can't find object id for %.*s. Check the object name and re-run this command.
Explanation: Command failed due to invalid or illegal request. Check syntax,
semantics, and permissions. Take any corrective action indicated
by message.
|
9920
|
16
|
Index id %d not found for object id %d, dbid %d.
Explanation: Command failed due to invalid or illegal request. Check syntax,
semantics, and permissions. Take any corrective action indicated
by message.
|
9921
|
16
|
Index %.*s not found for object id %d dbid %d.
Explanation: Command failed due to invalid or illegal request. Check syntax,
semantics, and permissions. Take any corrective action indicated
by message.
|
9922
|
16
|
The first page %ld in sysindexes for table `%.*s' does not match with first page %ld for the table's first partition in Syspartitions.
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.
|
9923
|
16
|
The first page %ld in syspartitions for partition %ld of table `%.*s' has previous page # %ld in its page header. The previous page # should be NULL.
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.
|
9924
|
16
|
The last page %ld in syspartitions for partition %ld of table `%.*s' has next page # %ld in its page header. The next page # should be NULL.
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.
|
9926
|
16
|
This option has been converted to the configuration parameter `%s'. Use `sp_configure' to set it.
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.
|
9927
|
16
|
This option requries a table name as the third parameter. Use `sp_configure `%s'' to set the option serverwide.
Explanation: Command failed due to invalid or illegal request. Check syntax,
semantics, and permissions. Take any corrective action indicated
by message.
|
9928
|
16
|
This option has been disabled. Use `sp_poolconfig' instead.
Explanation: Command failed due to invalid or illegal request. Check syntax,
semantics, and permissions. Take any corrective action indicated
by message.
|
9929
|
14
|
Only the DBO of database %S_DBID or a user with System Administrator (SA) role can run DBCC TEXTALLOC 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.
|
9931
|
22
|
The %S_MSG page (%ld) found in the page chain does not match with the %S_MSG page (%ld) found in the slice control page (%ld), for table `%.*s', on slice %ld. The table may be corrupt.
Explanation: A table or index may be corrupt. Report the error to your
System Administrator. Adaptive Server must be restarted and dbcc
diagnostics run.
|
9932
|
22
|
The %S_MSG page (%d) found in the page chain doesn’t match with the %S_MSG page (%d) stored in the Sysindexes for table ’%.*s’. The table may be corrupt.
Explanation: A table or index may be corrupt. Report the error to your
System Administrator. Adaptive Server must be restarted and dbcc
diagnostics run.
|
9933
|
16
|
The option max_rows_per_page cannot be set for a text/image index (%d) on table `%.*s'.
Explanation: Command failed due to invalid or illegal request. Check syntax,
semantics, and permissions. Take any corrective action indicated
by message. Not raised in 11.9.2.
|
9934
|
16
|
Invalid index ID %d. Values for index ID must be between 0 and %d.
Explanation: Command failed due to invalid or illegal request. Check syntax,
semantics, and permissions. Take any corrective action indicated
by message.
|
9935
|
10
|
SQL Server will not refresh index descriptor as the object descriptor for objid % ld in dbid %d is not installed in cache.
Explanation: There may be a potential problem with a database or database
object. Contact your System Administrator.
|
9936
|
20
|
Error while trying to refresh sysindexes row within index descriptor with indid % d objid %ld and dbid %d.
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.
|
9938
|
16
|
Table with ID %d not found; check sysobjects.
Explanation: Command failed due to invalid or illegal request. Check syntax,
semantics, and permissions. Take any corrective action indicated
by message.
|
9939
|
16
|
DBCC %s command is not supported anymore.
Explanation: Refer to the System Administration Guide for details on supported
dbcc commands and usage.
|
9940
|
16
|
The source text of object named '%s' with object id '%d' has already been hidden.
Explanation: Command failed due to invalid or illegal request. Check syntax,
semantics, and permissions. Take any corrective action indicated
by message.
|
9941
|
16
|
The source text of object named '%s' with object id '%d' is missing and it is not hidden.
Explanation: Command failed due to invalid or illegal request. Check syntax,
semantics, and permissions. Take any corrective action indicated
by message.
|
9942
|
16
|
Failed to hide the source text.
Explanation: Command failed due to invalid or illegal request. Check syntax,
semantics, and permissions. Take any corrective action indicated
by message.
|
9943
|
16
|
The hidden text of object named '%s' with object id '%d' does not exist.
Explanation: Command failed due to invalid or illegal request. Check syntax,
semantics, and permissions. Take any corrective action indicated
by message.
|
9944
|
10
|
Too many errors have been detected on device '%.*s' (physical device: %.*s). Page and object checking on that device has been discontinued. (The CHECKSTORAGE operation stops when more than 25%% of the checks are abandoned.)
Explanation: This is an informational message but may require follow-up
action. Contact your System Administrator.
|
9945
|
10
|
Too many errors have been detected on table '%.*s' index '%.*s'. Checking for that object will be discontinued. (The CHECKSTORAGE operation stops when more than 25 %% of the checks are abandoned.)
Explanation: Run dbcc checktable to determine the state of this object.
|
9946
|
17
|
An attempt to reserve a %dK buffer failed. Increase the size of the %dK buffer pool in the buffer cache ’%.*s’.
Explanation: Command failed due to resource limitation. Modify the command
to fit available resources, retry when the resource is available,
or contact your System Administrator to address the resource problem.
|
9947
|
17
|
An attempt to allocate memory failed due to insufficient SQL Server memory.
Explanation: Command failed due to resource limitation. Modify the command
to fit available resources, retry when the resource is available,
or contact your System Administrator to address the resource problem.
|
9948
|
17
|
The CHECKSTORAGE operation failed to cache a scan workspace row because of a cache overflow. This is an internal error. Please contact Sybase Technical Support.
Explanation: Command failed due to resource limitation. Modify the command
to fit available resources, retry when the resource is available,
or contact your System Administrator to address the resource problem.
|
9949
|
24
|
An I/O in a workspace failed, page %d in database %d. Check your hardware for problems that could cause I/O failures.
Explanation: Hardware error detected. Report the error to your System
Administrator. The database may have to be reloaded. It may be necessary
to contact your hardware vendor.
|
9950
|
17
|
Workspace '%.*s' is incorrectly allocated. Use sp_dbcc_createws to create a new workspace.
Explanation: Command failed due to resource limitation. Modify the command
to fit available resources, retry when the resource is available,
or contact your System Administrator to address the resource problem.
|
9951
|
17
|
Workspace '%.*s' is too fragmented to be used. Use sp_dbcc_createws and sp_dbcc_updateconfig to correct the problem.
Explanation: Command failed due to resource limitation. Modify the command
to fit available resources, retry when the resource is available,
or contact your System Administrator to address the resource problem.
|
9952
|
17
|
Workspace '%.*s' is too small to permit the CHECKSTORAGE operation to proceed. Use sp_dbcc_alterws and sp_dbcc_updateconfig to correct the problem.
Explanation: Command failed due to resource limitation. Modify the command
to fit available resources, retry when the resource is available,
or contact your System Administrator to address the resource problem.
|
9953
|
20
|
SQL Server failed to synchronize the activity of a worker process with the coordinating process. This is an internal error. Please contact Sybase Technical Support.
Explanation: Adaptive Server encountered an internal error affecting the
current process. Report the error to your System Administrator.
|
9954
|
10
|
Storage checks for '%.*s' are complete. DBCC is now recording the results in the dbccdb database.
Explanation: This is an informational message or a message header. No action
is required.
|
9955
|
20
|
A worker process could not access database '%.*s'. This is an internal error. Please contact Sybase Technical support.
Explanation: Adaptive Server encountered an internal error affecting the
current process. Report the error to your System Administrator.
|
9956
|
10
|
A worker process failed to complete its assigned work during the scan phase. The results of the CHECKSTORAGE operation will be incomplete.
Explanation: Informational message but may impact outcome of dbcc checkstorage.
|
9957
|
10
|
A worker process failed to complete its assigned work during the page chain check phase. The results of the CHECKSTORAGE operation will be incomplete.
Explanation: Informational message but may impact outcome of dbcc checkstorage.
|
9958
|
10
|
A worker process failed to complete its assigned work during the OAM check phase. The results of the CHECKSTORAGE operation will be incomplete.
Explanation: Informational message but may impact outcome of dbcc checkstorage.
|
9959
|
10
|
The CHECKSTORAGE operation has aborted.
Explanation: Problem impacts outcome of dbcc checkstorage.
|
9960
|
10
|
A non-recoverable error has occurred in the CHECKSTORAGE operation. The operation has been aborted.
Explanation: Problem impacts outcome of dbcc checkstorage.
|
9961
|
17
|
DBCC failed to connect to the requested number of worker processes. The number of workers configured is insufficient, or the number of workers exceeds 128. Use sp_dbcc_updateconfig to reduce 'max worker processes' for this database.
Explanation: Problem impacts outcome of dbcc checkstorage.
|
9962
|
17
|
Access to table '%.*s' index '%.*s' in the target database failed.
Explanation: Problem impacts outcome of dbcc checkstorage.
|
9963
|
16
|
An error occurred while attempting to insert a row into the dbcc_faults table or the dbcc_fault_params table.
Explanation: Problem impacts outcome of dbcc checkstorage.
|
9964
|
16
|
Database '%.*s' was not found. Use sp_helpdb to list the available databases.
Explanation: Problem impacts outcome of dbcc checkstorage.
|
9965
|
16
|
The entries in dbcc_config for database '%.*s' are either missing or invalid. Use sp_dbcc_evaluatedb to determine appropriate values for the entries and sp_dbcc_updateconfig to set them.
Explanation: Problem impacts outcome of dbcc checkstorage.
|
9966
|
16
|
DBCC could not access the scan workspace '%.*s'. Verify that the workspace exists .
Explanation: Problem impacts outcome of dbcc checkstorage.
|
9967
|
16
|
DBCC could not access the text workspace '%.*s'. Verify that the workspace exists .
Explanation: Problem impacts outcome of dbcc checkstorage. Check the SA
Guide for assistance.
|
9968
|
16
|
DBCC could not evaluate SQL Server's device configuration. Check the contents of the dbcc_dev_info table.
Explanation: Problem impacts outcome of dbcc checkstorage. Check the SA
Guide for assistance.
|
9969
|
16
|
The operation sequence number update for database '%.*s' in the dbcc_config table failed.
Explanation: Problem impacts outcome of dbcc checkstorage. Check the SA
Guide for assistance.
|
9970
|
16
|
DBCC failed to either insert or update the row in the dbcc_operation_log table for this check of database '%.*s'.
Explanation: Problem impacts outcome of dbcc checkstorage. Check the SA
Guide for assistance.
|
9971
|
20
|
DBCC failed to schedule work for the worker processes. This is an internal error. Please contact Sybase Technical Support.
Explanation: Internal error affecting the current process. Contact your
SA.
|
9972
|
16
|
An error occurred while inserting the results into the dbcc_counters table.
Explanation: Problem impacts outcome of dbcc checkstorage. Check the SA
Guide for assistance.
|
9973
|
16
|
An error occurred while inserting the results into the dbcc_operation_results table.
Explanation: Problem impacts outcome of dbcc checkstorage. Check the SA
Guide for assistance.
|
9974
|
10
|
DBCC CHECKSTORAGE for database '%.*s' sequence %d completed at %s. %d faults and %d suspect conditions were located. %d checks were aborted. You should investigate the recorded faults, and plan a course of action that will correct them.
Explanation: This is an informational message but may require follow-up
action. Contact your System Administrator.
|
9975
|
10
|
DBCC CHECKSTORAGE for database '%.*s' encountered an error. Some results may not be available. Correct the problems reported and reexecute the CHECKSTORAGE command.
Explanation: This is an informational message but may require follow-up
action. Contact your System Administrator.
|
9976
|
10
|
There is an inconsistency between the dbcc_dev_info table and the sysdevices table. Use DBCC CHECKDEVINFO to regenerate the dbcc_dev_info table.
Explanation: This is an informational message but may require follow-up
action. Contact your System Administrator.
|
9977
|
16
|
The cache '%.*s' specified in the dbcc_config table does not exist.
Explanation: Problem impacts outcome of dbcc checkstorage. Check the SA
Guide for assistance.
|
9978
|
16
|
The %dK buffer pool in the configured cache is too small. %dK is the minimum size .
Explanation: Check the System Administration Guide for assistance.
|
9979
|
10
|
Too many worker processes (%d) are configured for the available %dK buffer pool. This buffer pool can only support %d workers.
Explanation: Check the SA Guide for assistance.
|
9980
|
10
|
%d text column values were not checked because the text workspace was too small. Use sp_dbcc_alterws to increase its size by %dK.
Explanation: Problem impacts outcome of dbcc checkstorage. Check the SA
Guide for assistance.
|
9981
|
16
|
Correct syntax is:
dbcc createws({dbccdb|dbccalt}, segment name, workspace name, {scan|text}, size) dbcc alterws({dbccdb|dbccalt}, workspace name, {scan|text}, size)
Explanation: Adaptive Server could not perform the requested action. Rewrite
the command to conform to the requirement specified in the error
message.
|
9982
|
16
|
The minimum size for a DBCC workspace is %d pages.
Explanation: Problem impacts outcome of dbcc checkstorage. Check the SA
Guide for assistance.
|
9983
|
16
|
DBCC failed to create the workspace '%.*s'.
Explanation: Problem impacts outcome of dbcc checkstorage. Check the SA
Guide for assistance.
|
9984
|
16
|
DBCC could not expand the size of workspace '%.*s' in database '%.*s' to %d pages .
Explanation: Problem impacts outcome of dbcc checkstorage. Check the SA
Guide for assistance.
|
9985
|
16
|
DBCC could not truncate the size of workspace '%.*s' in database '%.*s' by %d pages.
Explanation: Problem impacts outcome of dbcc checkstorage. Check the SA
Guide for assistance.
|
9986
|
10
|
Suspect conditions are to be treated as faults if the same suspect condition persists in subsequent CHECKSTORAGE operations, or if they are also detected by other DBCC functions.
Explanation: This is an informational message but may require follow-up
action. Contact your System Administrator.
|
9987
|
16
|
DOL datapage %d of object %d does not have extended page header bits set correctly.
Explanation: Command failed due to invalid or illegal request. Check syntax,
semantics, and permissions. Take any corrective action indicated
by the message.
|
9988
|
16
|
NCFS value %ld in DOL datapage %ld is larger than available space %ld in the page
Explanation: Command failed due to invalid or illegal request. Check syntax,
semantics, and permissions. Take any corrective action indicated
by the message.
|
9989
|
16
|
Number of deleted rows %ld in page header of DOL datapage %ld is incorrect. This value cannot be negative.
Explanation: Command failed due to invalid or illegal request. Check syntax,
semantics, and permissions. Take any corrective action indicated
by the message.
|
9990
|
10
|
Insert free space value %ld in page header of DOL datapage %ld is greater than sum of cfs and ncfs (%ld) in the page
Explanation: This is an informational message but may require follow-up
action. Contact your System Administrator.
|
9991
|
16
|
Orphan row at offset %ld in page %ld of object %ld must be marked committed delete and is not
Explanation: Command failed due to invalid or illegal request. Check syntax,
semantics, and permissions. Take any corrective action indicated
by the message.
|
9992
|
16
|
Actual #rows %ld in DOL datapage %ld and count of #rows - nextrno - %ld in page header do not match
Explanation: Command failed due to invalid or illegal request. Check syntax,
semantics, and permissions. Take any corrective action indicated
by the message.
|
9993
|
16
|
There is a mismatch between value of ncfs counter %ld in page header of DOL datapage %ld and the actual amount of garbage %ld in the page
Explanation: Command failed due to invalid or illegal request. Check syntax,
semantics, and permissions. Take any corrective action indicated
by the message.
|
9994
|
16
|
There is a mismatch between count of #deleted rows %ld in page header of DOL data page %ld and the actual # deleted rows %ld in the page
Explanation: Command failed due to invalid or illegal request. Check syntax,
semantics, and permissions. Take any corrective action indicated
by the message.
|
9995
|
16
|
There is a mismatch between value of insert free space %ld in page header of DOL datapage %ld and actual value of insert free space %ld computed from the page with expected row size as %ld
Explanation: Command failed due to invalid or illegal request. Check syntax,
semantics, and permissions. Take any corrective action indicated
by the message.
|
9996
|
16
|
Keys of index id %d for table '%.*s' in %S_MSG not in proper order. Drop and recreate the index. (index page %ld)
Explanation: Command failed due to invalid or illegal request. Check syntax,
semantics, and permissions. Take any corrective action indicated
by the message.
|
9997
|
16
|
Root page %ld in index id %ld of object id %ld does not have BT_ROOT bit set
Explanation: Command failed due to invalid or illegal request. Check syntax,
semantics, and permissions. Take any corrective action indicated
by the message.
|
9998
|
16
|
Index page %ld has object id %ld which is different from object id %ld
Explanation: Command failed due to invalid or illegal request. Check syntax,
semantics, and permissions. Take any corrective action indicated
by the message.
|
9999
|
16
|
Rids not in ascending order in index page %ld for row %ld at offset %ld (indid %l d, object %ld). Drop and recreate the index.
Explanation: Command failed due to invalid or illegal request. Check syntax,
semantics, and permissions. Take any corrective action indicated
by the message.
|