Header Ads

List of SQL Error Codes

The table below lists the SQL error codes and error message text
SQL Error CodesMeaning
0Successful Completion
1Invalid SQL statement
2Exponent digits missing after 'E'
3Closing quote (") missing
4A term expected, beginning with one of the following: identifier, constant, aggregate, %ALPHAUP, %EXACT, %MVR, %SQLSTRING, %SQLUPPER, %STRING, %UPPER, $$, :, +, -, (, NOT, EXISTS, or FOR
5Column number specified in ORDER does not match SELECT list
6ORDER must specify column number, not names, when after UNION
7ORDER column is not in the SELECT list
9Incompatible SELECT lists used in UNION
10The SELECT list of the subquery must have exactly one item
11A scalar expression expected, not a condition
12A term expected, beginning with one of the following: identifier, constant, aggregate, $$, :, (, +, -, %ALPHAUP, %EXACT, %MVR, %SQLSTRING, %SQLUPPER, %STRING, or %UPPER
13An expression other than a subquery expected here
14A comparison operator is required here
15A condition expected after NOT
16A qualifier SOME or ALL expected after the FOR in the for-expression
17A for-condition expected after the ( in the for-expression
18IS (or IS NOT) NULL predicate can be applied only to a field
19An aggregate function cannot be used in a WHERE clause
20Name conflict in the FROM list over label
21Pointer->Field reference may not be modified by an INSERT or UPDATE statement
22ORDER must specify column names, not numbers, when after 'SELECT *'
23Label is not listed among the applicable tables
24Ambiguous sort column:
25Input encountered after end of query
26Missing FROM clause
27Field is ambiguous among the applicable tables
28Host variable name must begin with either % or a letter
29Field not found in the applicable tables
30Table or View not found
31Field not (Found/Unique) in Table(s)
32Outer-join symbol ( =* or *= ) must be between two fields
33No field(s) found for table
34Optimizer failed to find a usable join order
35INSERT/UPDATE/DELETE not allowed for non-updateable view
36WITH CHECK OPTION (CHECKOPTION class parameter) not allowed for non-updateable views
37SQL Scalar/Aggregate/Unary function not supported for Stream fields
38No master map for table
39No RowID field for table
40ODBC escape extension not supported
41An extrinsic function call must have the form '$$tag^routine(...)'
42Closing quotes ("") missing following pattern match
43Table is ambiguous within #IMPORT schema name list
44Duplicate method or query characteristic
45Duplicate method in Caché ObjectScript query body
46Required method missing in Caché ObjectScript query body
47Invalid method or query characteristic
48Invalid trigger REFERENCING clause for the trigger's event
49Trigger REFERENCING clause cannot be specified when trigger language not SQL
50Trigger specifies UPDATE OF clause when trigger language not SQL
51SQL statement expected
52Cursor (Already/Was Not) DECLAREd
53Constant or variable expected as new value
54Array designator (last subscript omitted) expected after VALUES
56GRANT/REVOKE action not applicable to an object of this type
57Trigger specifies WHEN clause when trigger language not SQL
58Duplicate field found in trigger UPDATE of clause
59Cannot have more than one field
60An action (%ALTER, SELECT, UPDATE, etc.) expected
61Cursor not updateable
62Additional new values expected for INSERT/UPDATE
63Data Exception — invalid escape character
64Incompatible SELECT list is used in INSERT
65Positive integer constant or variable expected
66Redundant Fields Found in SELECT list
67Implicit join (arrow syntax) not supported in ON clause
68Legacy outer join (=*, *=) not supported in ON clause
69SET = not allowed with WHERE CURRENT OF
70Multi-Line Field only valid for LIKE, Contains ([), or NULL Comparison
71Multi-Line Field must be the Left operand of the Comparison
72Multi-Line Field not valid in ORDER BY clause
73Aggregates not supported in ORDER BY clause
74Duplicate select-list alias names found
75Trim spec and/or trim char required before FROM in TRIM function
76Cardinality mismatch between the SELECT-list and INTO-list
77Qualified column reference not allowed in this JOIN context
78Invalid transaction state
79Referencing key and referenced key must be the same size
80Integer expected
81Column Constraint expected
82Multiple table %DESCRIPTION definitions found
83Multiple table %FILE definitions found
84Multiple table %NUMROWS definitions found
85Multiple table %ROUTINE definitions found
86Invalid field definition, no datatype defined
87Invalid table name
88Invalid field name
89Invalid index name
90Invalid view name
91Transaction mode cannot be specified more than once
92Level of isolation cannot be READ UNCOMMITTED if READ WRITE specified
93Number of conditions for the DIAGNOSTICS SIZE must be exact numeric
94Unsupported usage of OUTER JOIN
95Operation Disallowed by Operation Table
96Specified level of isolation is not supported
97Duplicate select-list names found
98License Violation
99Privilege Violation
100No (more) data
101Attempt to open a cursor that is already open
102Operation (FETCH/CLOSE/UPDATE/DELETE/...) attempted on an unopened cursor
103Positioned UPDATE or DELETE attempted, but the cursor is not positioned on any row
104Field validation failed in INSERT, or value failed to convert in DisplayToLogical or OdbcToLogical
105Field validation failed in UPDATE
106Row to DELETE not found
107Cannot UPDATE RowID or RowID based on Fields
108Required field missing; INSERT or UPDATE not allowed
109Cannot find the row designated for UPDATE
110Locking conflict in filing
111Cannot INSERT into a 'Default Only' RowID or RowID based on field
112Access violation
113%THRESHOLD Violation
114One or more matching rows is locked by another user
115Cannot INSERT/UPDATE/DELETE on a read only table
116Cardinality mismatch on INSERT/UPDATE between values list and number of table columns
117Aggregates not supported in Views
118Unknown or non-unique User or Role
119UNIQUE or PRIMARY KEY Constraint failed uniqueness check upon INSERT
120UNIQUE or PRIMARY KEY Constraint failed uniqueness check upon UPDATE
121FOREIGN KEY Constraint failed referential check upon INSERT of row in referencing table
122FOREIGN KEY Constraint failed referential check upon UPDATE of row in referencing table
123FOREIGN KEY Constraint failed referential check upon UPDATE of row in referenced table
124FOREIGN KEY Constraint failed referential check upon DELETE of row in referenced table
125UNIQUE or PRIMARY KEY Constraint failed uniqueness check upon creation of the constraint
126REVOKE with RESTRICT failed
127FOREIGN KEY Constraint failed referential check upon creation of the constraint
128Argument to scalar function %OBJECT() must be a stream field
129Illegal value for SET OPTION locale property
130Before Insert trigger failed
131After Insert trigger failed
132Before Update trigger failed
133After Update trigger failed
134Before Delete trigger failed
135After Delete trigger failed
136View's WITH CHECK OPTION validation failed in INSERT
137View's WITH CHECK OPTION validation failed in UPDATE
138Cannot INSERT/UPDATE a value for a ReadOnly field
139Concurrency failure on update: row versions not the same
140Invalid length parameter passed to the SUBSTRING function
141Invalid input value passed to the CONVERT function
142Cardinality mismatch between the View-Column-list and View Query's SELECT clause
143ORDER BY not valid in a view's query
201Table or View name not unique
300DDL not allowed on this table definition
301No Savepoint name
302Savepoint names starting with "SYS" are reserved
303No implicit conversion of Stream value to non-Stream field in UPDATE assignment is supported
304Attempt to add a NOT NULL field with no default value to a table which contains data
305Attempt to make field required when the table has one or more rows where the column value is NULL
306Column with this name already exists
307Primary key already defined for this table
308Identity column already defined for this table
309The left operand of %CONTAINS is not a property that supports the %Text interface
310Foreign key references non-existent table
311Foreign key with same name already defined for this table
312Invalid schema name. Must use delimited identifiers to reference this schema name
313Condition expression not supported for Stream fields
314Foreign key references non-unique key/column collection
315Constraint or Key not found
316Foreign key references non-existent key/column collection
317Cannot DROP Constraint — One or more Foreign Key constraints reference this Unique constraint
319Referenced table has no primary key defined
320Cannot DROP table — One or more Foreign Key constraints reference this table
321Cannot DROP view — One or more views reference this view
324Index with this name already defined for this table
325Index cannot be dropped because it is the IDKEY index and the table has data
333No such index defined
356SQL Function (function Stored Procedure) is not defined to return a value
357SQL Function (function Stored Procedure) is not defined as a function procedure
358SQL Function (function Stored Procedure) name not unique
359SQL Function (function Stored Procedure) not found
360Class not found
361Method or Query name not unique
362Method or Query not found
363Trigger not found
364Trigger with same EVENT, TIME, and ORDER already defined
365Trigger name not unique
366Schema name mismatch between trigger name and table name
370Embedded SQL CALL Statement can only be used for Method Procedures
371:HVar = CALL ... Specified for a Procedure which does not return a value
372Support for extrinsic function calls are disabled
373An extrinsic function call may not call a % routine
374Cannot alter the datatype of a field to/from a stream type when the table contains data
375Cannot ROLLBACK to unestablished savepoint
376Unsupported CAST target specified
377Field name 'table.field' appears more than once in assignment list of insert or update statement
378Datatype mismatch, explicit CAST is required
400Fatal error occurred
401Fatal Connection error
402Invalid Username/Password
405Unable to read from communication device
406Unable to Write to Server
407Unable to Write to Server Master
408Unable to start server
409Invalid server function
410Invalid Directory
411No stream object defined for field
412General Stream Error
413Incompatible Client/Server Protocol
415Fatal error occurred within the SQL filer
416CacheInfo Error
417Cache Security Error
421Warning: UPDATE or DELETE statement does not contain a WHERE clause
422SELECT request processed via ODBC, JDBC, or Dynamic SQL cannot contain an INTO clause
425Error processing Stored Procedure request
426Error preparing Stored Procedure
427Invalid Stored Procedure Name
428Stored Procedure Not Found
429Invalid number of input/output parameters for Stored Procedure
430Cannot initialize procedure context
431Stored procedure parameter type mismatch
450Request timed out due to user timeout
451Unable to receive server message
452Message sequencing error
453Error in User Initialization Code
459Kerberos authentication failure
460General error
461Communication link failure
462Memory allocation failure
463Invalid column number
464Function sequence error
465Invalid string or buffer length
466Invalid parameter number
467Column type out of range
468Fetch type out of range
469Driver not capable
470Option value changed
471Duplicate cursor name
478Query recompiled: Result Set mismatch
500Fetch row count limit reached
10050WinSock:Network is down
10051WinSock:Network is unreachable
10052WinSock:Net dropped connection or reset
10054WinSock:Connection reset by peer (due to timeout or reboot
10055WinSock:No buffer space available
10056WinSock:Socket is already connected
10057WinSock:WinSock: Socket is not connected
10058WinSock:Cannot send after socket shutdown
10060WinSock:Connection timed out
10061WinSock:Connection refused
10064WinSock:Host is down
10065WinSock:No route to host
10070WinSock:Stale NFS file handle
10091WinSock:Network subsystem is unavailable
10092WinSock:WINSOCK DLL version out of range
10093WinSock:Successful WSASTARTUP not yet performed
11001WinSock:Host not found
11002WinSock:Nonauthoritative host not found

No comments:

Powered by Blogger.