Server Error Messages 11700 - 11799

Number

Severity

Text and Explanation

11701

15

CREATE for extended stored routine cannot contain statements after EXTERNAL statement.

Explanation: Command failed. Check syntax and semantics. Rewrite the command to satisfy the condition indicated in the message.

11704

16

The specified option '%.*s' is not valid for this command. The option is valid for the LOAD TRANSACTION command. 

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

11706

16

Time value '%.*s' in the LOAD TRANSACTION UNTIL_TIME clause is not a legal value.

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

11707

16

Incorrect time syntax in time string '%.*s' used in the LOAD TRANSACTION UNTIL_TI ME statement. Correct format is month day, year hour:minute:seconds:milliseconds[am | pm]  

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

11710

16

Subqueries are not allowed in a DEFAULT clause. 

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

11711

16

The REORG option '%.*s' requires a value greater than 0 to be specified.  

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

11712

16

You cannot specify a value with the REORG option '%.*s'.  

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

11713

16

Index name is not allowed in UPDATE PARTITION STATISTICS statement. Use partition  number instead. 

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

11714

16

Partition number is not allowed in UPDATE STATISTICS statement. Use index name instead. 

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

11715

16

Options (index name, partition number) in UPDATE ALL STATISTICS statement are ignored. 

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

11717

16

The quoted identifier '%.*s' is illegal because its first character is '#', which  is ambiguous. Please use another character instead.  

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

11718

16

         %ld is not a valid partition number. Partition number must be greater than 0.  

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

11719

16

Error converting %ld to IDENTITY_START value.  

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

11720

16

%.*s' is not a REORG subcommand. The valid REORG subcommands are: REBUILD, FORWARDED_ROWS, RECLAIM_SPACE, and COMPACT. 

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

11721

16

Global variables not allowed as defaults.  

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

11722

15

The READPAST and HOLDLOCK object level locking options are incompatible.  

Explanation: Command failed. Check syntax and semantics. Rewrite the command to satisfy the condition indicated in the message.

11723

16

READPAST conflicts with AT ISOLATION LEVEL 3.  

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

11724

15

Target variable '%.*s' may not appear in both the SET and WHERE clauses of the UPDATE statement, nor in any subquery of the SET clause.

Explanation: Command failed. Check syntax and semantics. Rewrite the command to satisfy the condition indicated in the message.

11725

15

All result expressions in a CASE expression must not be NULL.

Explanation: Command failed. Check syntax and semantics. Rewrite the command to satisfy the condition indicated in the message.

11726

15

A single coalesce element is illegal in a COALESCE expression.

Explanation: Command failed. Check syntax and semantics. Rewrite the command to satisfy the condition indicated in the message.

11728

15

SELECT INTO cannot be used in an INSERT statement to pull values from tables.

Explanation: Command failed. Check syntax and semantics. Rewrite the command to satisfy the condition indicated in the message.

11729

15

The name '%.*s' is not a valid local variable name.

Explanation: Command failed. Check syntax and semantics. Rewrite the command to satisfy the condition indicated in the message.

11730

15

The PROXY option cannot be used in conjunction with other options in a SET command.

Explanation: Command failed. Check syntax and semantics. Rewrite the command to satisfy the condition indicated in the message.

11731

15

Duplicate option has been specified to UPDATE STATISTICS command. One or many options have been repeated.  

Explanation: Command failed. Check syntax and semantics. Rewrite the command to satisfy the condition indicated in the message.

11732

10

Warning : Ambiguous correlation names in the set clause  

Explanation: This warning is raised when the user use more than one correlated name in the set clause at the left of the assign sign.

11733

10

Warning : Ambiguous table to update; Using the table specified in the update clause.  

Explanation: This error is raised when Adaptive Server finds that the correlated name of the table in the READ_CURSOR entry of the range is not used in the set clause to the left of the assign sign.

11734

16

The quoted identifier '%.*s' is illegal because it contains an embedded period followed by an embedded double quote. Please substitute another character in place of one of these characters. 

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

11735

15

You specified an invalid password option.

Explanation: Command failed. Check syntax and semantics. Rewrite the command to satisfy the condition indicated in the message.

11736

16

line %d: You cannot specify this command in an ’execute immediate’ context. 

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

11737

16

You cannot specify outer joins in the HAVING clause of a query. 

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

11738

16

Table name ’%.*s’ is reserved for internal use by Adaptive Server. Please use a different name. 

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

11739

15

The value specified for identity gap ’%d’ is not legal; identity gap must be greater than 0. 

Explanation: Command failed. Check syntax and semantics. Rewrite the command to satisfy the condition indicated in the message.

11740

16

 UNICHAR and UNIVARCHAR datatypes are not supported when server’s default character set is not UTF-8. 

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

11741

15

Identity gap can be specified only for tables which have identity columns.                                                                                                                                                                                      

Explanation: Command failed. Check syntax and semantics. Rewrite the command to satisfy the condition indicated in the message.

11742

15

language java’ and ’parameter style java’ clauses must be specified when creating sqlj procedure/function.

Explanation: Command failed. Check syntax and semantics. Rewrite the command to satisfy the condition indicated in the message.

11743

15

CREATE for extended stored routine cannot contain statement ’%s’; it can only contain 1 EXTERNAL statement.

Explanation: Command failed. Check syntax and semantics. Rewrite the command to satisfy the condition indicated in the message.

11744

15

WITH CHECK OPTION is not allowed in the definition of a union view.

Explanation: Command failed. Check syntax and semantics. Rewrite the command to satisfy the condition indicated in the message.

11745

16

Function name ’%.*s’ is reserved for a T-SQL builtin function. Please use a different name. 

Explanation: Command failed. Check syntax and semantics. Rewrite the command to satisfy the condition indicated in the message.

11746

16

 Unable to create access rule. Please make sure the the row level access option is enabled and ASE_ASM license is available and enabled.

Explanation: Command failed. Check execution environment as indicated in the message.

11747

15

Java method ’%s’ has too many parameters. The maximum number is %d.

Explanation: Command failed. Check syntax and semantics. Rewrite the command to satisfy the condition indicated in the message.

11748

16

There are too many aggregates in the COMPUTE clause. The maximum number is %d.

Explanation: Command failed. Check syntax and semantics. Rewrite the command to satisfy the condition indicated in the message.

11749

15

 %s must be the only statement in a query batch.

Explanation: Command failed. Check syntax and semantics. Rewrite the command to satisfy the condition indicated in the message.