SQLCODE Codes and Messages
Go Up to SQLCODE Error Codes and Messages
The following table lists SQLCODE
s and associated messages for SQL and DSQL. Some SQLCODE
values have more than one text message associated with them. In these cases, InterBase returns the most relevant string message for the error that occurred.
When code messages include the name of a database object or object type, the name is represented by a code in the SQLCODE
Text column:
- <string>: String value, such as the name of a database object or object type.
- <long>: Long integer value, such as the identification number or code of a database object or object type.
- <digit>: Integer value, such as the identification number or code of a database object or object type.
- The InterBase number in the right-hand column is the actual error number returned in the error status vector. You can use InterBase error-handling functions to report messages based on these numbers instead of SQL code, but doing so results in non-portable SQL programs.
SQLCODE | SQLCODE text | InterBase number |
---|---|---|
101 |
Segment buffer length shorter than expected. |
335544366L |
100 |
No match for first value expression. |
335544338L |
100 |
Invalid database key. |
335544354L |
100 |
Attempted retrieval of more segments than exist. |
335544367L |
100 |
Attempt to fetch past the last record in a record stream. |
335544374L |
-84 |
Table/procedure has non-SQL security class defined. |
335544554L |
-84 |
Column has non-SQL security class defined. |
335544555L |
-84 |
Procedure <string> does not return any values. |
335544668L |
-103 |
Data Type for constant unknown. |
335544571L |
-104 |
Invalid request BLR at offset <long>. |
335544343L |
-104 |
BLR syntax error: expected <string> at offset <long>, encountered <long>. |
335544390L |
-104 |
Context already in use (BLR error). |
335544425L |
-104 |
Context not defined (BLR error). |
335544426L |
-104 |
Bad parameter number. |
335544429L |
-104 |
335544440L | |
-104 |
Invalid slice description language at offset <long>. |
335544456L |
-104 |
Invalid command. |
335544570L |
-104 |
Internal error. |
335544579L |
-104 |
Option specified more than once. |
335544590L |
-104 |
Unknown transaction option. |
335544591L |
-104 |
Invalid array reference. |
335544592L |
-104 |
Token unknown—line <long>, char <long>. |
335544634L |
-104 |
Unexpected end of command. |
335544608L |
-104 |
Token unknown. |
335544612L |
-150 |
Attempted update of read-only table. |
335544360L |
-150 |
Cannot update read-only view <string>. |
335544362L |
-150 |
Not updatable. |
335544446L |
-150 |
Cannot define constraints on views. |
335544546L |
-151 |
Attempted update of read-only column. |
335544359L |
-155 |
<string> is not a valid base table of the specified view. |
335544658L |
-157 |
Must specify column name for view select expression. |
335544598L |
-158 |
Number of columns does not match select list. |
335544599L |
-162 |
Dbkey not available for multi-table views. |
335544685L |
-170 |
Parameter mismatch for procedure <string>. |
335544512L |
-170 |
External functions cannot have more than10 parameters. |
335544619L |
-171 |
Function <string> could not be matched. |
335544439L |
-171 |
Column not array or invalid dimensions (expected <long>, encountered <long>). |
335544458L |
-171 |
Return mode by value not allowed for this data type. |
335544618L |
-172 |
Function <string> is not defined. |
335544438L |
-204 |
Generator <string> is not defined. |
335544463L |
-204 |
Encryption <string> has bad length of <string> bits. |
336003096L |
-204 |
Reference to invalid stream number. |
335544502L |
-204 |
|
335544509L |
-204 |
Procedure <string> is not defined. |
335544511L |
-204 |
Status code <string> unknown. |
335544515L |
-204 |
Exception <string> not defined. |
335544516L |
-204 |
Name of Referential Constraint not defined in constraints table. |
335544532L |
-204 |
Could not find table/procedure for |
335544551L |
-204 |
Implementation of text subtype <digit> not located. |
335544568L |
-204 |
Data Type unknown. |
335544573L |
-204 |
Table unknown. |
335544580L |
-204 |
Procedure unknown. |
335544581L |
-204 |
|
335544588L |
-204 |
|
335544589L |
-204 |
Trigger unknown. |
335544595L |
-204 |
Alias <string> conflicts with an alias in the same statement. |
335544620L |
-204 |
Alias <string> conflicts with a procedure in the same statement. |
335544621L |
-204 |
Alias <string> conflicts with a table in the same statement. |
335544622L |
-204 |
There is no alias or table named <string> at this scope level. |
335544635L |
-204 |
There is no index <string> for table <string>. |
335544636L |
-204 |
Invalid use of |
335544640L |
-204 |
|
335544662L |
-204 |
EXECUTE STATEMENT could not prepare statement : <string>. |
335544850 |
-204 |
SQL statement invalid as it returns no records. SQL : <string>. |
335544851 |
-204 |
Parameter mis-match for the statement : <string>. |
335544852 |
-204 |
Could not execute statement : <string>. |
335544853 |
-204 |
EXECUTE STATEMENT fetch error. |
335544854 |
-204 |
EXECUTE STATEMENT in this form must return single row, not multiple rows. |
335544855 |
-204 |
SQL statement not allowed in EXECUTE STATEMENT : <string>. |
335544857 |
-204 |
Statement evaluated to a NULL statement. EXECUTE STATEMENT cannot execute a NULL statement. |
335544858 |
-205 |
Column <string> is not defined in table <string>. |
335544396L |
-205 |
Could not find column for |
335544552L |
-206 |
Column unknown. |
335544578L |
-206 |
Column is not a Blob. |
335544587L |
-206 |
Subselect illegal in this context. |
335544596L |
-208 |
Invalid |
335544617L |
-219 |
Table <string> is not defined. |
335544395L |
-239 |
Cache length too small. |
335544691L |
-260 |
Cache redefined. |
335544690L |
-281 |
Table <string> is not referenced in plan. |
335544637L |
-282 |
Table <string> is referenced more than once in plan; use aliases to distinguish. |
335544638L |
-282 |
The table <string> is referenced twice; use aliases to differentiate. |
335544643L |
-282 |
Table <string> is referenced twice in view; use an alias to distinguish. |
335544659L |
-282 |
View <string> has more than one base table; use aliases to distinguish. |
335544660L |
-283 |
Table <string> is referenced in the plan but not the from list. |
335544639L |
-284 |
Index <string> cannot be used in the specified plan. |
335544642L |
-291 |
Column used in a |
335544531L |
-292 |
Cannot update constraints ( |
335544534L |
-293 |
Cannot update constraints ( |
335544535L |
-294 |
Cannot delete |
335544536L |
-295 |
Cannot update constraints ( |
335544545L |
-296 |
Internal isc software consistency check (invalid |
335544547L |
-297 |
Operation violates |
335544558L |
-313 |
Count of column list and variable list do not match. |
335544669L |
-314 |
Cannot transliterate character between character sets. |
335544565L |
-401 |
Invalid comparison operator for find operation. |
335544647L |
-402 |
Attempted invalid operation on a Blob. |
335544368L |
-402 |
Blob and array data types are not supported for <string> operation. |
335544414L |
-402 |
Data operation not supported. |
335544427L |
-406 |
Subscript out of bounds |
335544457L |
-407 |
Null segment of |
335544435L |
-413 |
Conversion error from string “ <string>” |
335544334L |
-413 |
Filter not found to convert type <long> to type <long>. |
335544454L |
-501 |
Invalid request handle. |
335544327L |
-501 |
Attempt to reclose a closed cursor. |
335544577L |
-502 |
Declared cursor already exists. |
335544574L |
-502 |
Attempt to reopen an open cursor. |
335544576L |
-504 |
Cursor unknown. |
335544572L |
-508 |
No current record for fetch operation. |
335544348L |
-510 |
Cursor not updatable. |
335544575L |
-518 |
Request unknown. |
335544582L |
-519 |
The |
335544688L |
-530 |
Violation of |
335544466L |
-530 |
Cannot prepare a |
335544597L |
-532 |
Transaction marked invalid by I/O error. |
335544469L |
-551 |
No permission for <string> access to <string> <string>. |
335544352L |
-552 |
Only the owner of a table can reassign ownership. |
335544550L |
-552 |
User does not have |
335544553L |
-553 |
Cannot modify an existing user privilege. |
335544529L |
-595 |
The current position is on a crack. |
335544645L |
-596 |
Illegal operation when at beginning of stream. |
335544644L |
-597 |
Preceding file did not specify length, so <string> must include starting page number. |
335544632L |
-598 |
Shadow number must be a positive integer. |
335544633L |
-599 |
Gen.c: node not supported. |
335544607L |
-600 |
A node name is not permitted in a secondary, shadow, cache or log file name. |
335544625L |
-600 |
Sort error: corruption in data structure. |
335544680L |
-601 |
Database or file exists. |
335544646L |
-604 |
Array declared with too many dimensions. |
335544593L |
-604 |
Illegal array dimension range. |
335544594L |
-605 |
Inappropriate self-reference of column. |
335544682L |
-607 |
Unsuccessful metadata update. |
335544351L |
-607 |
Cannot modify or erase a system trigger. |
335544549L |
-607 |
Array/Blob/ |
335544657L |
-615 |
Lock on table <string> conflicts with existing lock. |
335544475L |
-615 |
Requested record lock conflicts with existing lock. |
335544476L |
-615 |
Refresh range number <long> already in use. |
335544507L |
-616 |
Cannot delete |
335544530L |
-616 |
Cannot delete index used by an integrity constraint. |
335544539L |
-616 |
Cannot modify index used by an integrity constraint. |
335544540L |
-616 |
Cannot delete trigger used by a |
335544541L |
-616 |
Cannot delete column being used in an integrity constraint. |
335544543L |
-616 |
There are <long> dependencies. |
335544630L |
-616 |
Last column in a table cannot be deleted. |
335544674L |
-617 |
Cannot update trigger used by a |
335544542L |
-617 |
Cannot rename column being used in an integrity constraint. |
335544544L |
-618 |
Cannot delete index segment used by an integrity constraint. |
335544537L |
-618 |
Cannot update index segment used by an integrity constraint. |
335544538L |
-625 |
Validation error for column <string>, value “ <string>” |
335544347L |
-637 |
Duplicate specification of <string> not supported. |
335544664L |
-660 |
Non-existent |
335544533L |
-660 |
Cannot create index <string>. |
335544628L |
-663 |
Segment count of 0 defined for index <string>. |
335544624L |
-663 |
Too many keys defined for index <string>. |
335544631L |
-663 |
Too few key columns found for index <string> (incorrect column name?) |
335544672L |
-664 |
key size exceeds implementation restriction for index “ <string>” |
335544434L |
-677 |
<string> extension error. |
335544445L |
-685 |
Invalid Blob type for operation. |
335544465L |
-685 |
Attempt to index Blob column in index <string>. |
335544670L |
-685 |
Attempt to index array column in index <string>. |
335544671L |
-689 |
Page <long> is of wrong type (expected <long>, found <long>) |
335544403L |
-689 |
Wrong page type. |
335544650L |
-690 |
Segments not allowed in expression index <string>. |
335544679L |
-691 |
New record size of <long> bytes is too big. |
335544681L |
-692 |
Maximum indexes per table ( <digit>) exceeded. |
335544477L |
-693 |
Too many concurrent executions of the same request. |
335544663L |
-694 |
Cannot access column <string> in view <string>. |
335544684L |
-802 |
Arithmetic exception, numeric overflow, or string truncation. |
335544321L |
-803 |
Attempt to store duplicate value (visible to active transactions) in unique index “ <string>” |
335544349L |
-803 |
Violation of |
335544665L |
-804 |
Wrong number of arguments on call. |
335544380L |
-804 |
|
335544583L |
-804 |
Count of columns not equal count of values. |
335544584L |
-804 |
Function unknown. |
335544586L |
-806 |
Only simple column names permitted for |
335544600L |
-807 |
No where clause for |
335544601L |
-808 |
Only one table allowed for |
335544602L |
-809 |
|
335544603L |
-810 |
No subqueries permitted for |
335544605L |
-811 |
Multiple rows in singleton select. |
335544652L |
-816 |
External file could not be opened for output. |
335544651L |
-817 |
Attempted update during read-only transaction. |
335544361L |
-817 |
Attempted write to read-only Blob. |
335544371L |
-817 |
Operation not supported. |
335544444L |
-820 |
Metadata is obsolete. |
335544356L |
-820 |
Unsupported on-disk structure for file <string>; found <long>, support <long>. |
335544379L |
-820 |
Wrong |
335544437L |
-820 |
Minor version too high found <long> expected <long>. |
335544467L |
-823 |
Invalid bookmark handle. |
335544473L |
-824 |
Invalid lock level <digit>. |
335544474L |
-825 |
Invalid lock handle. |
335544519L |
-826 |
Invalid statement handle. |
335544585L |
-827 |
Invalid direction for find operation. |
335544655L |
-828 |
Invalid key position. |
335544678L |
-829 |
Invalid column reference. |
335544616L |
-830 |
Column used with aggregate. |
335544615L |
-831 |
Attempt to define a second |
335544548L |
-832 |
|
335544604L |
-833 |
Expression evaluation not supported. |
335544606L |
-834 |
Refresh range number <long> not found. |
335544508L |
-835 |
Bad checksum. |
335544649L |
-836 |
Exception <digit>. |
335544517L |
-837 |
Restart shared cache manager. |
335544518L |
-838 |
Database <string> shutdown in <digit> seconds |
335544560L |
-839 |
journal file wrong format. |
335544686L |
-840 |
Intermediate journal file full. |
335544687L |
-841 |
Too many versions. |
335544677L |
-842 |
Precision should be greater than 0 |
335544697L |
-842 |
Scale cannot be greater than precision. |
335544698L |
-842 |
Short integer expected. |
335544699L |
-842 |
Long integer expected. |
335544700L |
-842 |
Unsigned short integer expected. |
335544701L |
-901 |
Invalid database key. |
335544322L |
-901 |
Unrecognized database parameter block. |
335544326L |
-901 |
Invalid Blob handle. |
335544328L |
-901 |
Invalid Blob ID. |
335544329L |
-901 |
Invalid parameter in transaction parameter block. |
335544330L |
-901 |
Invalid format for transaction parameter block. |
335544331L |
-901 |
Invalid transaction handle (expecting explicit transaction start) |
335544332L |
-901 |
Attempt to start more than <long> transactions. |
335544337L |
-901 |
Information type inappropriate for object specified. |
335544339L |
-901 |
No information of this type available for object specified. |
335544340L |
-901 |
Unknown information item. |
335544341L |
-901 |
Action cancelled by trigger ( <long>) to preserve data integrity. |
335544342L |
-901 |
Lock conflict on no wait transaction. |
335544345L |
-901 |
Program attempted to exit without finishing database. |
335544350L |
-901 |
Transaction is not in limbo. |
335544353L |
-901 |
Blob was not closed. |
335544355L |
-901 |
Cannot disconnect database with open transactions ( <long> active) |
335544357L |
-901 |
Message length error (encountered <long>, expected <long>) |
335544358L |
-901 |
No transaction for request. |
335544363L |
-901 |
Request synchronization error. |
335544364L |
-901 |
Request referenced an unavailable database. |
335544365L |
-901 |
Attempted read of a new, open Blob. |
335544369L |
-901 |
Attempted action on blob outside transaction. |
335544370L |
-901 |
Attempted reference to Blob in unavailable database. |
335544372L |
-901 |
Table <string> was omitted from the transaction reserving list. |
335544376L |
-901 |
Request includes a DSRI extension not supported in this implementation. |
335544377L |
-901 |
Feature is not supported. |
335544378L |
-901 |
<string>. |
335544382L |
-901 |
Unrecoverable conflict with limbo transaction <long>. |
335544383L |
-901 |
Internal error. |
335544392L |
-901 |
Database handle not zero. |
335544407L |
-901 |
Transaction handle not zero. |
335544408L |
-901 |
Transaction in limbo. |
335544418L |
-901 |
Transaction not in limbo. |
335544419L |
-901 |
Transaction outstanding. |
335544420L |
-901 |
Undefined message number. |
335544428L |
-901 |
Blocking signal has been received. |
335544431L |
-901 |
Database system cannot read argument <long>. |
335544442L |
-901 |
Database system cannot write argument <long>. |
335544443L |
-901 |
<string>. |
335544450L |
-901 |
Transaction <long> is <string>. |
335544468L |
-901 |
Invalid statement handle. |
335544485L |
-901 |
Lock time-out on wait transaction. |
335544510L |
-901 |
Invalid service handle. |
335544559L |
-901 |
Wrong version of service parameter block. |
335544561L |
-901 |
Unrecognized service parameter block. |
335544562L |
-901 |
Service <string> is not defined. |
335544563L |
-901 |
|
335544609L |
-901 |
|
335544610L |
-901 |
Column <string>. |
335544611L |
-901 |
Union not supported. |
335544613L |
-901 |
Unsupported |
335544614L |
-901 |
Illegal use of keyword |
335544623L |
-901 |
Table <string>. |
335544626L |
-901 |
Procedure <string>. |
335544627L |
-901 |
Specified domain or source column does not exist. |
335544641L |
-901 |
Variable <string> conflicts with parameter in same procedure. |
335544656L |
-901 |
Server version too old to support all |
335544666L |
-901 |
Cannot delete. |
335544673L |
-901 |
Sort error. |
335544675L |
-902 |
Internal isc software consistency check ( <string>) |
335544333L |
-902 |
Database file appears corrupt ( <string>) |
335544335L |
-902 |
I/O error during “ <string>” operation for file “ <string>” |
335544344L |
-902 |
Corrupt system table. |
335544346L |
-902 |
Operating system directive <string> failed. |
335544373L |
-902 |
Internal error. |
335544384L |
-902 |
Internal error. |
335544385L |
-902 |
Internal error. |
335544387L |
-902 |
Block size exceeds implementation restriction. |
335544388L |
-902 |
Incompatible version of on-disk structure. |
335544394L |
-902 |
Internal error. |
335544397L |
-902 |
Internal error. |
335544398L |
-902 |
Internal error. |
335544399L |
-902 |
Internal error. |
335544400L |
-902 |
Internal error. |
335544401L |
-902 |
Internal error. |
335544402L |
-902 |
Database corrupted. |
335544404L |
-902 |
Checksum error on database page <long>. |
335544405L |
-902 |
Index is broken. |
335544406L |
-902 |
Transaction--request mismatch (synchronization error) |
335544409L |
-902 |
Bad handle count. |
335544410L |
-902 |
Wrong version of transaction parameter block. |
335544411L |
-902 |
Unsupported BLR version (expected <long>, encountered <long>) |
335544412L |
-902 |
Wrong version of database parameter block. |
335544413L |
-902 |
Database corrupted. |
335544415L |
-902 |
Internal error. |
335544416L |
-902 |
Internal error. |
335544417L |
-902 |
Internal error. |
335544422L |
-902 |
Internal error. |
335544423L |
-902 |
Lock manager error. |
335544432L |
-902 |
SQL error code = <long>. |
335544436L |
-902 |
335544448L | |
-902 |
335544449L | |
-902 |
Cache buffer for page <long> invalid. |
335544470L |
-902 |
There is no index in table <string> with id <digit>. |
335544471L |
-902 |
Your user name and password are not defined. Ask your database administrator to set up an InterBase login. |
335544472L |
-902 |
Enable journal for database before starting online dump. |
335544478L |
-902 |
Online dump failure. Retry dump. |
335544479L |
-902 |
An online dump is already in progress. |
335544480L |
-902 |
No more disk/tape space. Cannot continue online dump. |
335544481L |
-902 |
Maximum number of online dump files that can be specified is 16 |
335544483L |
-902 |
Database <string> shutdown in progress. |
335544506L |
-902 |
Long-term journaling already enabled. |
335544520L |
-902 |
Database <string> shutdown. |
335544528L |
-902 |
Database shutdown unsuccessful. |
335544557L |
-902 |
Cannot attach to password database. |
335544653L |
-902 |
Cannot start transaction for password database. |
335544654L |
-902 |
Long-term journaling not enabled. |
335544564L |
-902 |
Dynamic SQL Error. |
335544569L |
-904 |
Invalid database handle (no active connection) |
335544324L |
-904 |
Unavailable database. |
335544375L |
-904 |
Implementation limit exceeded. |
335544381L |
-904 |
Too many requests. |
335544386L |
-904 |
Buffer exhausted. |
335544389L |
-904 |
Buffer in use. |
335544391L |
-904 |
Request in use. |
335544393L |
-904 |
No lock manager available. |
335544424L |
-904 |
Unable to allocate memory from operating system. |
335544430L |
-904 |
Update conflicts with concurrent update. |
335544451L |
-904 |
Object <string> is in use. |
335544453L |
-904 |
Cannot attach active shadow file. |
335544455L |
-904 |
A file in manual shadow <long> is unavailable. |
335544460L |
-904 |
Cannot add index, index root page is full. |
335544661L |
-904 |
Sort error: not enough memory. |
335544676L |
-904 |
Request depth exceeded. (Recursive definition?) |
335544683L |
-904 |
Size of optimizer block exceeded. |
335544762L |
-906 |
Product <string> is not licensed. |
335544452L |
-909 |
Drop database completed with errors. |
335544667L |
-911 |
Record from transaction <long> is stuck in limbo. |
335544459L |
-913 |
Deadlock. |
335544336L |
-922 |
File <string> is not a valid database. |
335544323L |
-923 |
Connection rejected by remote interface. |
335544421L |
-923 |
Secondary server attachments cannot validate databases. |
335544461L |
-923 |
Secondary server attachments cannot start journaling. |
335544462L |
-924 |
Bad parameters on attach or create database. |
335544325L |
-924 |
Database detach completed with errors. |
335544441L |
-924 |
Connection lost to pipe server. |
335544648L |
-926 |
No rollback performed. |
335544447L |
-999 |
InterBase error. |
335544689L |