InterBase Status Array Error Codes
Go Up to Error Codes and Messages
This section lists InterBase error codes and associated messages returned in the status array in the following tables. When code messages include the name of a database object or object type, the name is represented by a code in the Message column:
- <string>: String value, such as the name of a database object or object type.
- <digit>: Integer value, such as the identification number or code 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.
The following table lists SQL Status Array codes for embedded SQL programs, DSQL, and isql
.
Error code | Number | Message |
---|---|---|
|
335544321L |
arithmetic exception, numeric overflow, or string truncation |
|
335544322L |
invalid database key |
|
335544323L |
file <string> is not a valid database |
|
335544324L |
invalid database handle (no active connection) |
|
335544325L |
bad parameters on attach or create database |
|
335544326L |
unrecognized database parameter block |
|
335544327L |
invalid request handle |
|
335544328L |
invalid Blob handle |
|
335544329L |
invalid Blob ID |
|
335544330L |
invalid parameter in transaction parameter block |
|
335544331L |
invalid format for transaction parameter block |
|
335544332L |
invalid transaction handle (expecting explicit transaction start) |
|
335544333L |
internal isc software consistency check (<string>) |
|
335544334L |
conversion error from string “<string>” |
|
335544335L |
database file appears corrupt (<string>) |
|
335544336L |
deadlock |
|
335544337L |
attempt to start more than <long> transactions |
|
335544338L |
no match for first value expression |
|
335544339L |
information type inappropriate for object specified |
|
335544340L |
no information of this type available for object specified |
|
335544341L |
unknown information item |
|
335544342L |
action cancelled by trigger (<long>) to preserve data integrity |
|
335544343L |
invalid request BLR at offset <long> |
|
335544344L |
I/O error during “<string>” operation for file “<string>” |
|
335544345L |
lock conflict on no wait transaction |
|
335544346L |
corrupt system table |
|
335544347L |
validation error for column <string>, value “<string>” |
|
335544348L |
no current record for fetch operation |
|
335544349L |
attempt to store duplicate value (visible to active transactions) in unique index “<string>” |
|
335544350L |
program attempted to exit without finishing database |
|
335544351L |
unsuccessful metadata update |
|
335544352L |
no permission for <string> access to <string> <string> |
|
335544353L |
transaction is not in limbo |
|
335544354L |
invalid database key |
|
335544355L |
Blob was not closed |
|
335544356L |
metadata is obsolete |
|
335544357L |
cannot disconnect database with open transactions (<long> active) |
|
335544358L |
message length error (encountered <long>, expected <long>) |
|
335544359L |
attempted update of read-only column |
|
335544360L |
attempted update of read-only table |
|
335544361L |
attempted update during read-only transaction |
|
335544362L |
cannot update read-only view <string> |
|
335544363L |
no transaction for request |
|
335544364L |
request synchronization error |
|
335544365L |
request referenced an unavailable database |
|
335544366L |
segment buffer length shorter than expected |
|
335544367L |
attempted retrieval of more segments than exist |
|
335544368L |
attempted invalid operation on a Blob |
|
335544369L |
attempted read of a new, open Blob |
|
335544370L |
attempted action on Blob outside transaction |
|
335544371L |
attempted write to read-only Blob |
|
335544372L |
attempted reference to Blob in unavailable database |
|
335544373L |
operating system directive <string> failed |
|
335544374L |
attempt to fetch past the last record in a record stream |
|
335544375L |
unavailable database |
|
335544376L |
Table <string> was omitted from the transaction reserving list |
|
335544377L |
request includes a DSRI extension not supported in this implementation |
|
335544378L |
feature is not supported |
|
335544379L |
unsupported on-disk structure for file <<string>>; found <<long>>, support <<long>> |
|
335544380L |
wrong number of arguments on call |
|
335544381L |
Implementation limit exceeded |
|
335544382L |
<<string>> |
|
335544383L |
unrecoverable conflict with limbo transaction <<long>> |
|
335544384L |
internal error |
|
335544385L |
internal error |
|
335544386L |
too many requests |
|
335544387L |
internal error |
|
335544388L |
block size exceeds implementation restriction |
|
335544389L |
buffer exhausted |
|
335544390L |
BLR syntax error: expected <string> at offset <long>, encountered <long> |
|
335544391L |
buffer in use |
|
335544392L |
internal error |
|
335544393L |
request in use |
|
335544394L |
incompatible version of on-disk structure |
|
335544395L |
table <string> is not defined |
|
335544396L |
column <string> is not defined in table <string> |
|
335544397L |
internal error |
|
335544398L |
internal error |
|
335544399L |
internal error |
|
335544400L |
internal error |
|
335544401L |
internal error |
|
335544402L |
internal error |
|
335544403L |
page <long> is of wrong type (expected <long>, found <long>) |
|
335544404L |
database corrupted |
|
335544405L |
checksum error on database page <long> |
|
335544406L |
index is broken |
|
335544407L |
database handle not zero |
|
335544408L |
transaction handle not zero |
|
335544409L |
transaction—request mismatch (synchronization error) |
|
335544410L |
bad handle count |
|
335544411L |
wrong version of transaction parameter block |
|
335544412L |
unsupported BLR version (expected <long>, encountered <long>) |
|
335544413L |
wrong version of database parameter block |
|
335544414L |
Blob and array data types are not supported for <string> operation |
|
335544415L |
database corrupted |
|
335544416L |
internal error |
|
335544417L |
internal error |
|
335544418L |
transaction in limbo |
|
335544419L |
transaction not in limbo |
|
335544420L |
transaction outstanding |
|
335544421L |
connection rejected by remote interface |
|
335544422L |
internal error |
|
335544423L |
internal error |
|
335544424L |
no lock manager available |
|
335544425L |
context already in use (BLR error) |
|
335544426L |
context not defined (BLR error) |
|
335544427L |
data operation not supported |
|
335544428L |
undefined message number |
|
335544429L |
bad parameter number |
|
335544430L |
unable to allocate memory from operating system |
|
335544431L |
blocking signal has been received |
|
335544432L |
lock manager error |
|
335544433L |
communication error with journal “<string>” |
|
335544434L |
key size exceeds implementation restriction for index “<string>” |
|
335544435L |
null segment of |
|
335544436L |
SQL error code = <long> |
|
335544437L |
wrong DYN version |
|
335544438L |
function <string> is not defined |
|
335544439L |
function <string> could not be matched |
|
335544440L |
|
|
335544441L |
database detach completed with errors |
|
335544442L |
database system cannot read argument <long> |
|
335544443L |
database system cannot write argument <long> |
|
335544444L |
operation not supported |
|
335544445L |
<string> extension error |
|
335544446L |
not updatable |
|
335544447L |
no rollback performed |
|
335544448L |
|
|
335544449L |
|
|
335544450L |
<string> |
|
335544451L |
update conflicts with concurrent update |
|
335544452L |
product <string> is not licensed |
|
335544453L |
object <string> is in use |
|
335544454L |
filter not found to convert type <long> to type <long> |
|
335544455L |
cannot attach active shadow file |
|
335544456L |
invalid slice description language at offset <long> |
|
335544457L |
subscript out of bounds |
|
335544458L |
column not array or invalid dimensions (expected <long>, encountered <long>) |
|
335544459L |
record from transaction <long> is stuck in limbo |
|
335544460L |
a file in manual shadow <long> is unavailable |
|
335544461L |
secondary server attachments cannot validate databases |
|
335544462L |
secondary server attachments cannot start journaling |
|
335544463L |
generator <string> is not defined |
|
335544464L |
secondary server attachments cannot start logging |
|
335544465L |
invalid Blob type for operation |
|
335544466L |
violation of |
|
335544467L |
minor version too high found <long> expected <long> |
|
335544468L |
transaction <long> is <string> |
|
335544469L |
transaction marked invalid by I/O error |
|
335544470L |
cache buffer for page <long> invalid |
|
335544471L |
there is no index in table <string> with id <digit> |
|
335544472L |
Your user name and password are not defined. Ask your database administrator to set up an InterBase login. |
|
335544473L |
invalid bookmark handle |
|
335544474L |
invalid lock level <digit> |
|
335544475L |
lock on table <string> conflicts with existing lock |
|
335544476L |
requested record lock conflicts with existing lock |
|
335544477L |
maximum indexes per table (<digit>) exceeded |
|
335544478L |
enable journal for database before starting online dump |
|
335544479L |
online dump failure. Retry dump |
|
335544480L |
an online dump is already in progress |
|
335544481L |
no more disk/tape space. Cannot continue online dump |
|
335544483L |
maximum number of online dump files that can be specified is 16 |
|
335544485L |
invalid statement handle |
|
335544502L |
reference to invalid stream number |
|
335544506L |
database <string> shutdown in progress |
|
335544507L |
refresh range number <long> already in use |
|
335544508L |
refresh range number <long> not found |
|
335544509L |
character set <string> is not defined |
|
335544510L |
lock time-out on wait transaction |
|
335544511L |
procedure <string> is not defined |
|
335544512L |
parameter mismatch for procedure <string> |
|
335544515L |
status code <string> unknown |
|
335544516L |
exception <string> not defined |
|
335544517L |
exception <digit> |
|
335544518L |
restart shared cache manager |
|
335544519L |
invalid lock handle |
|
335544528L |
database <string> shutdown |
|
335544529L |
cannot modify an existing user privilege |
|
335544530L |
Cannot delete |
|
335544531L |
Column used in a |
|
335544532L |
Name of Referential Constraint not defined in constraints table. |
|
335544533L |
Non-existent |
|
335544534L |
Cannot update constraints ( |
|
335544535L |
Cannot update constraints ( |
|
335544536L |
Cannot delete |
|
335544537L |
Cannot delete index segment used by an Integrity Constraint |
|
335544538L |
Cannot update index segment used by an Integrity Constraint |
|
335544539L |
Cannot delete index used by an Integrity Constraint |
|
335544540L |
Cannot modify index used by an Integrity Constraint |
|
335544541L |
Cannot delete trigger used by a |
|
335544542L |
Cannot update trigger used by a |
|
335544543L |
Cannot delete column being used in an Integrity Constraint. |
|
335544544L |
Cannot rename column being used in an Integrity Constraint. |
|
335544545L |
Cannot update constraints ( |
|
335544546L |
Cannot define constraints on views |
|
335544547L |
internal isc software consistency check (invalid |
|
335544548L |
Attempt to define a second |
|
335544549L |
cannot modify or erase a system trigger |
|
335544550L |
only the owner of a table may reassign ownership |
|
335544551L |
could not find table/procedure for |
|
335544552L |
could not find column for |
|
335544553L |
user does not have |
|
335544554L |
table/procedure has non-SQL security class defined |
|
335544555L |
column has non-SQL security class defined |
|
335544557L |
database shutdown unsuccessful |
|
335544558L |
Operation violates |
|
335544559L |
invalid service handle |
|
335544560L |
database <string> shutdown in <digit> seconds |
|
335544561L |
wrong version of service parameter block |
|
335544562L |
unrecognized service parameter block |
|
335544563L |
service <string> is not defined |
|
335544564L |
long-term journaling not enabled |
|
335544565L |
Cannot transliterate character between character sets |
|
335544568L |
Implementation of text subtype <digit> not located. |
|
335544569L |
Dynamic SQL Error |
|
335544570L |
Invalid command |
|
335544571L |
Datatype for constant unknown |
|
335544572L |
Cursor unknown |
|
335544573L |
Datatype unknown |
|
335544574L |
Declared cursor already exists |
|
335544575L |
Cursor not updatable |
|
335544576L |
Attempt to reopen an open cursor |
|
335544577L |
Attempt to reclose a closed cursor |
|
335544578L |
Column unknown |
|
335544579L |
Internal error |
|
335544580L |
Table unknown |
|
335544581L |
Procedure unknown |
|
335544582L |
Request unknown |
|
335544583L |
|
|
335544584L |
Count of columns not equal count of values |
|
335544585L |
Invalid statement handle |
|
335544586L |
Function unknown |
|
335544587L |
Column is not a Blob |
|
335544588L |
|
|
335544589L |
|
|
335544590L |
Option specified more than once |
|
335544591L |
Unknown transaction option |
|
335544592L |
Invalid array reference |
|
335544593L |
Array declared with too many dimensions |
|
335544594L |
Illegal array dimension range |
|
335544595L |
Trigger unknown |
|
335544596L |
Subselect illegal in this context |
|
335544597L |
Cannot prepare a |
|
335544598L |
must specify column name for view select expression |
|
335544599L |
number of columns does not match select list |
|
335544600L |
Only simple column names permitted for |
|
335544601L |
No WHERE clause for |
|
335544602L |
Only one table allowed for |
|
335544603L |
|
|
335544604L |
|
|
335544605L |
No subqueries permitted for |
|
335544606L |
expression evaluation not supported |
|
335544607L |
gen.c: node not supported |
|
335544608L |
Unexpected end of command |
|
335544609L |
|
|
335544610L |
|
|
335544611L |
|
|
335544612L |
Token unknown |
|
335544613L |
union not supported |
|
335544614L |
Unsupported DSQL construct |
|
335544615L |
column used with aggregate |
|
335544616L |
invalid column reference |
|
335544617L |
invalid |
|
335544618L |
Return mode by value not allowed for this datatype |
|
335544619L |
External functions cannot have more than 10 parameters |
|
335544620L |
alias <string> conflicts with an alias in the same statement |
|
335544621L |
alias <string> conflicts with a procedure in the same statement |
|
335544622L |
alias <string> conflicts with a table in the same statement |
|
335544623L |
Illegal use of keyword |
|
335544624L |
segment count of 0 defined for index <string> |
|
335544625L |
A node name is not permitted in a secondary, shadow, cache or log file name |
|
335544626L |
|
|
335544627L |
|
|
335544628L |
cannot create index <string> |
|
335544630L |
there are <long> dependencies |
|
335544631L |
too many keys defined for index <string> |
|
335544632L |
Preceding file did not specify length, so <string> must include starting page number |
|
335544633L |
Shadow number must be a positive integer |
|
335544634L |
Token unknown - line <long>, char <long> |
|
335544635L |
there is no alias or table named <string> at this scope level |
|
335544636L |
there is no index <string> for table <string> |
|
335544637L |
table <string> is not referenced in plan |
|
335544638L |
table <string> is referenced more than once in plan; use aliases to distinguish |
|
335544639L |
table <string> is referenced in the plan but not the from list |
|
335544640L |
Invalid use of |
|
335544641L |
Specified domain or source column does not exist |
|
335544642L |
index <string> cannot be used in the specified plan |
|
335544643L |
the table <string> is referenced twice; use aliases to differentiate |
|
335544644L |
illegal operation when at beginning of stream |
|
335544645L |
the current position is on a crack |
|
335544646L |
database or file exists |
|
335544647L |
invalid comparison operator for find operation |
|
335544648L |
Connection lost to pipe server |
|
335544649L |
bad checksum |
|
335544650L |
wrong page type |
|
335544651L |
external file could not be opened for output |
|
335544652L |
multiple rows in singleton select |
|
335544653L |
cannot attach to password database |
|
335544654L |
cannot start transaction for password database |
|
335544655L |
invalid direction for find operation |
|
335544656L |
variable <string> conflicts with parameter in same procedure |
|
335544657L |
Array/Blob/ |
|
335544658L |
<string> is not a valid base table of the specified view |
|
335544659L |
table <string> is referenced twice in view; use an alias to distinguish |
|
335544660L |
view <string> has more than one base table; use aliases to distinguish |
|
335544661L |
cannot add index, index root page is full. |
|
335544662L |
|
|
335544663L |
Too many concurrent executions of the same request |
|
335544664L |
duplicate specification of <string> - not supported |
|
335544665L |
violation of |
|
335544666L |
server version too old to support all |
|
335544667L |
drop database completed with errors |
|
335544668L |
procedure <string> does not return any values |
|
335544669L |
count of column list and variable list do not match |
|
335544670L |
attempt to index Blob column in index <string> |
|
335544671L |
attempt to index array column in index <string> |
|
335544672L |
too few key columns found for index <string> (incorrect column name?) |
|
335544673L |
cannot delete |
|
335544674L |
last column in a table cannot be deleted |
|
335544675L |
sort error |
|
335544676L |
sort error: not enough memory |
|
335544677L |
too many versions |
|
335544678L |
invalid key position |
|
335544679L |
segments not allowed in expression index <string> |
|
335544680L |
sort error: corruption in data structure |
|
335544681L |
new record size of <long> bytes is too big |
|
335544682L |
Inappropriate self-reference of column |
|
335544683L |
request depth exceeded. (Recursive definition?) |
|
335544684L |
cannot access column <string> in view <string> |
|
335544685L |
dbkey not available for multi-table views |
|
335544688L |
The prepare statement identifies a prepare statement with an open cursor |
|
335544689L |
InterBase error |
|
335544690L |
Cache redefined |
|
335544691L |
Cache length too small |
|
335544697L |
Precision should be greater than 0 |
|
335544698L |
Scale cannot be greater than precision |
|
335544699L |
Short integer expected |
|
335544700L |
Long integer expected |
|
335544701L |
Unsigned short integer expected |
|
335544702L |
Invalid |
|
335544703L |
service <string> does not have an associated executable |
|
335544704L |
Network lookup failure for host “<string>” |
|
335544705L |
Undefined service <string>/<string> |
|
335544706L |
Host unknown |
|
335544707L |
user does not have |
|
335544708L |
Ambiguous column reference. |
|
335544709L |
Invalid aggregate reference |
|
335544710L |
navigational stream <long> references a view with more than one base table. |
|
335544711L |
attempt to execute an unprepared dynamic SQL statement |
|
335544712L |
Positive value expected. |
|
335544713L |
Incorrect values within |
|
335544714L |
invalid Blob id |
|
335544715L |
operation not supported for |
|
335544716L |
service is currently busy: <<string>> |
|
335544717L |
stack size insufficient to execute current request |
|
335544718L |
invalid key for find operation |
|
335544719L |
error initializing the network software |
|
335544720L |
unable to load required library <<string>> |
|
335544721L |
unable to complete network request to host “<<string>>” |
|
335544722L |
failed to establish a connection |
|
335544723L |
error while listening for an incoming connection |
|
335544724L |
failed to establish a secondary connection for event processing |
|
335544725L |
error while listening for an incoming event connection request |
|
335544726L |
error reading data from the connection |
|
335544727L |
error writing data to the connection |
|
335544728L |
cannot deactivate index used by an Integrity Constraint |
|
335544729L |
cannot deactivate primary index |
|
335544732L |
access to databases on file servers is not supported |
|
335544733L |
error while trying to create file |
|
335544734L |
error while trying to open file |
|
335544735L |
error while trying to close file |
|
335544736L |
error while trying to read from file |
|
335544737L |
error while trying to write to file |
|
335544738L |
error while trying to delete file |
|
335544739L |
error while trying to access file |
|
335544740L |
exception <<integer>> detected in blob filter or user defined function |
|
335544741L |
connection lost to database |
|
335544742L |
user cannot write to |
|
335544743L |
token size exceeds limit |
|
335544744L |
maximum user count exceeded; contact your database administrator |
|
335544745L |
your login <<string>> is same as one of the SQL role names; ask your database administrator to set up a valid InterBase login |
|
335544746L |
“ |
|
335544747L |
the username entered is too long. Maximum length is 31 bytes. |
|
335544748L |
the password specified is too long. Maximum length is 8 bytes. |
|
335544749L |
a username is required for this operation. |
|
335544750L |
a password is required for this operation |
|
335544751L |
the network protocol specified is invalid |
|
335544752L |
a duplicate user name was found in the security database |
|
335544753L |
the user name specified was not found in the security database |
|
335544754L |
error while attempting to add the user |
|
335544755L |
error while attempting to modify the user record |
|
335544756L |
error while attempting to delete the user record |
|
335544757L |
error while updating the security database |
|
335544758L |
sort record size is too big |
|
335544759L |
cannot assign a |
|
335544760L |
the specified user-entered string is not valid |
|
335544761L |
too many open handles to database |
|
335544762L |
optimizer implementation limits are exceeded; for example, only 256 conjuncts ( |