Server Error Messages 2700–2799

Number

Severity

Text and Explanation

2701

10

 Database name `%.*s' ignored, creating table in Tempdb.

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

2702

16

 Database `%.*s' does not exist.

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

2703

16

 Segment `%.*s' does not exist.

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

2705

16

 Column names in each table must be unique. Column name `%.*s' in table `%.*s' is specified more than once.

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

2706

11

 Table `%.*s' does not exist.

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

2710

16

 You are not the owner specified for the object named `%.*s' in this command (CREATE, ALTER, TRUNCATE, UPDATE STATISTICS, or BULK INSERT).  The database owner can use the SETUSER command to assume the identity of another user.

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

2714

16

 There is already an object named `%.*s' in the database.

Explanation: Refer to the writeup for this error.

2715

16

Can't find type '%.*s'.

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

2716

16

Can't specify a length or scale on type '%.*s'. 

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.

2717

16

Specified length is too large for type '%.*s'. 

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.

2718

16

 Column or parameter #%d:  -- can't specify Null values on a column of type BIT.

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.

2719

14

You must be the owner of table '%.*s' or a System Administrator to update the table's statistics.

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.

2721

11

 Could not find a default segment to create the table on.  Contact a user with System administrator (SA) role to specify a default segment in syssegments.

Explanation: Command failed. Check syntax and your Adaptive Server environment.

2724

10

 Parameter `%.*s' has an invalid data type.

Explanation: An invalid datatype was specified for a table column or stored procedure parameter when creating the object. Check SQL syntax.

2727

11

 Cannot find index `%.*s'.

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

2728

21

 Could not find sysobjects row for table `%.*s'.

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.

2729

16

 Procedure `%.*s' group number 1 already exists in the database.  Choose another procedure name or procedure number.

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

2730

11

 Cannot create procedure `%.*s' with a group number of %d because a procedure with the same name and a group number of 1 does not currently exist in the database.  Must CREATE PROCEDURE `%.*s';1 first.

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

2731

16

 Column or parameter #%d: -- can't specify column width of zero for `%.*s'.

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.

2732

16

 User error number %ld is invalid. Number must be between %d and %d.

Explanation: SQL Server could not perform the requested action. Rewrite the command to conform to the requirement specified in the error message.

2734

16

 User name %.*s does not exist in sysusers.

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

2735

16

Object text is too long. Please shorten the object text or split into multiple objects. Text which caused overflow starts at: ’%.*s’.

Explanation: Adaptive Server could not perform the requested action. Determine the maximum text size using the information in the message, and use one of the recommended options to correct the problem.

2736

16

 Owner name that was specified is a group name.  Objects cannot be owned by groups.

Explanation: QL Server could not perform the requested action. Rewrite the command to conform to the requirement specified in the error message.

2737

16

 Message passed to %s must be of type CHAR or VARCHAR.

Explanation: QL Server could not perform the requested action. Rewrite the command to conform to the requirement specified in the error message.

2738

16

 A table can only have one timestamp column.  Since table `%.*s' already has one, you can't add the column `%.*s'.

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

2739

16

 TEXT and IMAGE datatypes are invalid for parameters or local variables.

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

2740

16

 SET LANGUAGE failed because `%.*s' is not an official language name or a language alias on this SQL Server.

Explanation: Command failed. Use sp_helplanguage and see the Adaptive Server Reference Manual for help with language maintenance.

2741

16

 SET DATEFORMAT date order `%.*s' is invalid.

Explanation: Command failed. See the Adaptive Server Reference Manual for help with dateformat.

2742

16

 SET DATEFIRST %d is out of range.

Explanation: Command failed. See the Adaptive Server Reference Manual for help with datefirst.

2743

16

 %s command requires %S_MSG parameter.

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

2744

16

 Index distribution page was %ld, now %ld.  Perhaps another UPDATE STATISTICS command is currently running.  Retry your command.

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

2745

16

 %s command is missing an argument position specifier.

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

2746

16

 Duplicate position specifier in format string of %s command.

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

2747

16

 Incorrect position specifier in format string of %s command.

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

2748

16

Message number %ld, passed to RAISERROR, does not exist in the %s catalog.

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

2749

16

 Number of argument position specifiers in %s command is greater than the number of arguments passed.

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

2750

16

 Can not have more than %d arguments in a call to %s.

Explanation: QL Server could not perform the requested action. Rewrite the command to conform to the requirement specified in the error message.

2751

16

 %s command failed because the resulting string exceeded the maximum length of %d bytes.

Explanation: QL Server could not perform the requested action. Rewrite the command to conform to the requirement specified in the error message.

2752

20

 The PRINT/RAISERROR function received an illegal datatype of `%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.

2753

20

 Received an error code of `%d' from `intl_strblist()'.

Explanation: Refer to the writeup for Error 2753.

2754

16

 There is an argument position specifier that is out of range in a call to %s.  Valid argument position specifiers must be in the range from 1 to %d.

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

2756

16

Specified type precision %d more than the maximum precision %d. 

Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions.

2757

16

Specified scale %d more than 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.

2758

16

 Resdom says that column or parameter has no arguments but the length is non-zero. Given length %d.

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

2759

10

 Internal error: illegal tree encountered.

Explanation: This is an informational message but may require follow-up action. Contact your System Administrator.

2760

10

 Column name `%.*s' does not exist in target 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.

2761

10

 Failed to create declarative constraints on table `%.*s' in database `%.*s'.

Explanation: There may be a potential problem with a database or database object. Contact your System Administrator.

2762

16

 The `%s' command is not allowed within a multi-statement transaction in the `%.*s' database.

Explanation: QL Server could not perform the requested action. Rewrite the command to conform to the requirement specified in the error message.

2763

16

 An attempt to grant CREATE TABLE permission to PUBLIC in tempdb failed.

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

2764

16

 Identity field `%.*s' must be a numeric with a scale of 0 and not null allowed.

Explanation: QL Server could not perform the requested action. Rewrite the command to conform to the requirement specified in the error message.

2765

16

 A table can only have one identity column. Since table `%.*s' already has one, you can't add the column `%.*s'.

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

2766

16

 Cannot use logsegment to create a user table or an index.

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

2767

16

 The table with id=<%ld> in dbid=<%d> does not exist. It may have been created in a concurrently running transaction that rolled back and is now inaccessible.

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

2768

16

 SET label (CURREAD, CURWRITE) failed because new value is an invalid label, or new value doesn't satisfy the dominance relationships among session labels.

Explanation: An invalid label was encountered in `set curread' or `set curwrite' command.

2769

16

 Invalid maxhold label specified for the table.

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

2770

16

 Invalid minhold label specified for the table.

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

2771

16

 Invalid hold label specified.  A table's maxhold label should always dominate it's minhold label.

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

2772

16

 Invalid hold label specified.  Only labels below your @@maxwrite are acceptable.

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

2773

16

 Invalid hold label specified.  Only labels above your @@minwrite are acceptable.

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

2774

16

 Hold label provided is above database maxhold.  Please provide a label below the database maxhold.

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

2775

20

 Object is not a table, or table has NULL maxhold and/or minhold value.

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.

2776

16

 The `set update_mode' command only takes in a CHAR or VARCHAR argument.

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

2777

16

 Invalid update_mode provided. The only allowable update modes are: reclassify, over_range, and standard.

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

2778

12

 The object `%.*s' is not a table. Update statistics can be used only on user tables or system tables

Explanation: UPDATE STATISTICS can only be run on a table. The operation is illegal for other objects.

2779

20

 Lock request count has overrun the lock request array boundary. This is an internal error.

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.

2780

20

 maxlen (%d) is less than length (%d)

Explanation: Adaptive Server encountered an internal error affecting the current process. Report the error to your System Administrator.

2781

18

 Internal Error.  Master to DB SLID conversion failed.

Explanation: Command failed due to internal Adaptive Server problem. Perform any diagnostic action indicated by message. Report the error to your System Administrator.

2782

16

 An untyped variable in the PREPARE statement `%.*s' is being resolved to a TEXT or IMAGE type. This is illegal in a dynamic PREPARE statement.

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

2783

14

 The user's curwrite needs to be at the table's hurdle when updating a table's statistics.

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.

2784

18

 Internal row labeling error occured.

Explanation: Command failed due to internal Adaptive Server problem. Perform any diagnostic action indicated by message. Report the error to your System Administrator.

2786

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.

2787

16

 Cache, %s, cannot be found in sysconfigures.

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

2790

16

 Setting maximum online engines to %d causes number of engine freelocks (%d) to fall below half the value of freelock transfer block size (%d). Please increase maximum engine freelocks to %d and reattempt this command.

Explanation: Adaptive Server could not perform the requested action. Rewrite the command to conform to the requirement specified in the error message.

2792

16

 Cannot change curread label with open cursors. Please contact a user with System Security Officer (SSO) role for help.

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

2793

16

 User error number %ld is of invalid type. Number must be an integer.

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

2794

16

SET PROCESS_LIMIT_ACTION { ABORT | QUIET | WARNING } failed because '%. *s' is not a valid parameter. 

Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. .

2795

10

The value of 'parallel_degree' (`%d') cannot be larger than the value of configuration parameter 'max parallel degree' (`%d'). The value '%d' is used for 'parallel_degree'. 

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

2796

16

The values of 'parallel_degree' and 'scan_parallel_degree' cannot be less than zero. 

Explanation: Command failed due to invalid or illegal request. .

2797

10

The value of 'parallel_degree' (`%d') cannot be larger than the value of 'parallel_degree' set by a calling procedure. The value '%d' is used. 

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

2798

10

The value of 'scan_parallel_degree' (`%d') cannot be larger than the lesser of the configuration parameter 'max scan parallel degree' (`%d') and current 'parallel_degree' (`%d'). The value `%d' is used for 'scan_parallel_degree'. 

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