Server Error Messages 4900 - 4999

Number

Severity

Text and Explanation

4901

16

 ALTER TABLE only allows columns to be added which can contain nulls.  Column `%.*s' cannot be added to table `%.*s' because it does not allow nulls.

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

4902

11

 Cannot alter table `%.*s', because this table does not exist in database `%S_DBID'.

Explanation: Command failed. Check your database for the object not found and re-enter the command with the correct name.

4905

21

 ALTER TABLE failed because page %ld of the system catalog sysindexes in database `%.*s' is not in the cache.

Explanation: Adaptive Server encountered an internal error affecting all processes in the current database. Report the error to your System Administrator. Adaptive Server must be restarted and dbcc diagnostics run.

4909

16

 Can't alter %.*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.

4910

16

 Cannot alter table `%.*s' because you are not the owner or a user with System Administrator (SA) role.

Explanation: Adaptive Server could not perform the requested action. The command violates a permission or privilege restriction. Check the command and working database context.

4912

16

 Cannot replace default to `%.*s.%.*s' because it already has a default bound using sp_bindefault.

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

4913

16

 Alter table command has unrecognized action. Cannot process.

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

4914

16

 Cannot alter table `%.*s' because the alter table statement contains multiple identity fields.

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

4915

16

 Cannot add new identity field to `%.*s' via alter table because the table already contains an identity field.

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

4916

16

 Cannot add new identity field to `%.*s' via alter table because the number of existing rows (%ld) exceeds the maximum value for the specified precision (%d).

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

4917

20

 Failure adding identity column `%.*s' to table `%.*s'.

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.

4918

16

 Row length (%d) exceeds maximum row length (%d) when adding identity column ’%.*s’ to table ’%.*s’.

Explanation: Command failed due to invalid or illegal request. A server limit was exceeded.

4919

16

 Identity value overflow when adding column `%.*s' to table `%.*s'.

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

4920

16

Permission denied.  A table can only be altered if the table's hurdle equals the user's curwrite. 

Explanation: Adaptive Server could not perform the requested action. The command violates a permission or privilege restriction. Check the command and working database context.

4921

14

 Permission denied.  A table's labels cannot be altered while it is in use.

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.

4922

14

 Invalid hold label specified.

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.

4923

14

 Permission denied.  A table's maxhold should always dominate its minhold.

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.

4924

14

 Permission denied.  A table's maxhold should always be dominated by the maxhold of the database that contains 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.

4925

14

 Permission denied.  User maxwrite does not dominate specified maxhold.

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.

4926

14

 Permission denied. User minhold does not dominate specified minwrite.

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.

4927

14

 Permission denied.  Maxhold label specified is below previous table maxhold.

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.

4928

14

 Permission denied.  Minhold label specified is above previous table minhold.

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.

4929

14

 Permission denied.  User minwrite is not dominated by specified maxhold.

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.

4930

14

 Permission denied.  User maxwrite does not dominate specified minhold.

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.

4931

16

 Cannot alter the table ’%.*s’ because it is a system table. 

Explanation: Error raised if user attempts to add columns to a system table when allow updates is off.

4932

16

 Dropping a column from a system table is not allowed.

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

4933

16

 Dropping a column from a replicated table is not allowed.

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

4934

16

 A column by this name doesn't exist in the table `%.*s'.

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

4935

16

 Dropping the only column in a table is not allowed.

Explanation: Command failed due to invalid or illegal request.

4936

17

 Dropping the column failed while reformatting data on page %d, row %d. This command is being rolled back.

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.

4937

17

 Deleting text pages failed. This command is being rolled back.

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.

4938

20

 Cannot undo a drop column command because the number of rows on the log record does not match the number of rows on the data page.

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.

4939

16

 ALTER TABLE ’%.*s’ failed. You cannot drop column ’%.*s’ because it is being used by an index. Drop the index ’%.*s’ before dropping this column. 

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

4940

16

 ALTER TABLE failed. Dropping an identity column is not allowed. 

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

4941

16

ALTER TABLE ’%.*s’ failed. You cannot drop a column on which constraints are defined. Drop the constraints before dropping this column. 

Explanation: Command failed due to invalid or illegal request. Use sp_helpconstraint for information on the object.

4942

16

ALTER TABLE ’%.*s’ failed. You cannot drop column ’%.*s’ which has a default bound to it. Unbind the default (object id ’%ld’) before dropping this column. 

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

4943

16

 Dropping a column which is a primary key is not allowed. Drop the constraint (object id `%ld') before dropping this column.

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

4944

16

 Dropping a column which is a foreign key is not allowed. Drop the constraint (object id `%s') before dropping this column.

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

4945

16

 Cannot drop the column because cursor `%.*s' is still open. Close the cursor(s) before dropping the column.

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

4946

16

 Dropping a column from a table which has a constraint associated with it is not allowed. Drop the constraint (object id `%ld') before dropping this column.

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

4947

16

 Dropping an identity column from a table while identity_insert is `on' is not allowed. Set identity_insert to `off' before dropping this column.

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

4948

25

 Dropping the column failed while logging data from page %d. This command is being rolled back.

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.

4949

20

 The alttab_begin() function is trying to put too many lock requests in the lock_requests[] array.

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.

4950

16

 Cannot partition table `%.*s' because it is a system table.

Explanation: The partition clause of the alter table command allows you to partition user tables that do not have a clustered index. Partitioning is not allowed for system tables.

4951

16

Cannot create %d partitions on the table '%.*s' with clustered index because the maximum number of partitions allowed on a table with clustered index is %d.

Explanation: Refer to the writeup for this error.

4953

16

 Cannot partition table `%.*s' because it is already partitioned.

Explanation: Refer to the writeup for this error.

4954

16

 Cannot unpartition table `%.*s' because it is not partitioned.

Explanation: Refer to the writeup for this error.

4955

16

 Number of partitions must be greater than one

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

4956

16

Cannot alter table if REORG command or level 0 scans are active. 

Explanation: Refer to the writeup for this error.

4958

16

 Cannot partition table `%.*s' because it is in a pre-System 11 database.

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

4959

16

 Dropping a TEXT/IMAGE column is not allowed.

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

4960

16

 Lock scheme currently on the table `%.*s' is corrupted. For this version of SQL server it should have been set properly.

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

4961

16

Cannot partition table '%.*s' because it has been partitioned and unpartitioned too many times. 

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

4962

16

To partition: bcp the data out of the table, drop and recreate the table, and then bcp into a partitioned/unpartitioned table. 

Explanation: Follow the steps in the message to partitioned a table.

4963

16

Table '%.*s' is already locked in the desired locking scheme.

Explanation: This is an informational message. The command did not execute.

4964

17

Lock scheme conversion failed due to insufficient SQL Server memory. Please retry  later when there is less load/users on the SQL server, or ask your System Administrator to reconfigure SQL Server with more memory. 

Explanation: See the writeup for Error 4964.

4965

16

Lock scheme conversion on system tables not supported.  

Explanation: You can only change lock schemes on a user table.

4966

10

Warning: Table '%.*s' with a clustered index has been partitioned. All data rows are in the first partition and all data insertions will go to the first partition. To distribute the data to all the partitions, re-create the clustered index.  

Explanation: The table is partitioned but will not stay balanced unless you take the specified action.

4967

16

Cannot execute '%.*s' command on table '%.*s', because this table does not exist in database '%S_DBID'.  

Explanation: Check syntax and working database.

4968

16

The table '%.*s' you've specified is a system table. Executing the '%.*s' command is not permitted on system tables.

Explanation: Invalid command.

4969

16

The table '%.*s' you've specified is a temporary table. Executing the '%.*s' command is not permitted on temporary tables. 

Explanation: Invalid command.

4970

16

Cannot unlock this table because the table is not locked in that mode.  

Explanation: Invalid command.

4971

16

This table cannot be locked in '%.*s' mode because it was already locked in '%.*s ' mode.  

Explanation: Invalid command.

4972

10

Warning: Empty Table '%.*s' with a clustered index has been partitioned. All data insertions will go to the first partition. To distribute the data to all the partitions, re-create the clustered index after loading the data.  

Explanation: Table is partitioned but will become unbalanced with future inserts. Take the recommended action to maintain partition balance.

4973

20

Row size (%d bytes) exceeded the maximum row size limit (%d bytes) for data only locked format while changing the lock scheme from ALLPAGES to DATAONLY for object ’%.*s’ (ID %d) in database ’%.*s’ (ID %d). The lock scheme for the object was not changed.

Explanation: Consult the System Administration Guide for more information.

4974

21

Process %d was expected to hold logical lock on object %ld.  

Explanation: Adaptive Server encountered an internal error affecting all processes using the current database. Report the error to your System Administrator.

4975

16

Cannot alter table for lockscheme change because cursor '%.*s' is still open. Close the cursor(s) before lockscheme change. 

Explanation: Wait for the process holding the cursor to complete.

4977

16

You cannot run ALTER TABLE LOCK in this database because the 'select into/bulkcopy' option is off. Please check with the DBO. 

Explanation: Invalid or illegal command.

4978

16

User aborted ALTER TABLE LOCK change command for table %.*s  

Explanation: DDL command aborted.

4979

20

ALTER TABLE LOCK change for table '%.*s' failed: insufficient memory to allocate backout structure. 

Explanation: Retry the DDL command when there is more memory available for the task.

4980

17

No space left in database '%S_DBID'; Use ALTER DATABASE to increase size of database. Else, an old transaction may be active; see Syslogshold table. 

Explanation: Check the syslogshold table for long-running transactions.

4981

16

Column offset, %d bytes, for variable-length column number %d exceeds the maximum start offset for variable-length columns in DOL tables (%d bytes). The lock scheme for the object ’%.*s’ was not changed.

Explanation: To change the lock scheme, bulk copy the table out, drop and re-create the table with the new scheme, and bulk copy data back in.

4982

10

Due to an internal error the table '%.*s' cannot be converted to new lock scheme. Please contact your System Administrator (SA) for help 

Explanation: An Adaptive Server error occurred. Notify the System Administrator.

4983

10

Primary index (indid = %d) is suspect for table '%.*s'. Please check and reissue the lock change command. 

Explanation: Check the index and table using dbcc. You may need to recreate the index.

4984

10

Computed effective expected row size value(%d) for the table '%.*s' with the expected row size value(%d) is invalid. Forcing the default value.

Explanation: This is an informational message.

4985

10

Warning: trigger ’%.*s’ is already enabled.

Explanation: This is an informational message.

4986

10

Warning: trigger ’%.*s’ is already disabled.

Explanation: This is an informational message.

4987

10

Enabling trigger ’%.*s’.

Explanation: This is an informational message.

4988

10

Disabling trigger ’%.*s’.

Explanation: This is an informational message.

4989

16

The trigger you specified (’%.*s’) does not exist. The ALTER TABLE command is being terminated. 

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

4990

17

ALTER TABLE ’%.*s’ failed due to insufficient procedure cache. Retry later when there is less load/users on Adaptive Server, or ask your System Administrator to reconfigure Adaptive Server with more procedure cache. 

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.

4991

17

ALTER TABLE ’%S_OBJID’ in database %S_DBID (objectid %d) failed due to 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.

4993

16

ALTER TABLE ’%.*s’ failed. Dropping all columns in a table is not allowed. 

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

4994

16

ALTER TABLE ’%.*s’ failed. The number of columns in the resultant table (%d) exceeds the current limit %d. 

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

4995

16

ALTER TABLE ’%.*s’ failed. Multiple references to the same column in ALTER TABLE statements are not allowed. 

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

4996

16

ALTER TABLE ’%.*s’ failed. Adding non-NULL timestamp column ’%.*s’ is not allowed. 

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

4997

16

ALTER TABLE ’%.*s’ failed. Default clause is required in order to add non-NULL column ’%.*s’. 

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

4998

16

ALTER TABLE ’%.*s’ failed. Default value cannot be NULL when adding a non-NULL column. 

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

4999

16

ALTER TABLE ’%.*s’ failed. You cannot drop column ’%.*s’ on which a primary or foreign key constraint is defined. 

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