Appendix B: Exception Codes and Messages

This appendix includes:

Custom Exceptions

Firebird DDL provides a simple syntax for creating custom exceptions for use in PSQL modules, with message text of up to 1,021 characters. For more information, see CREATE EXCEPTION in DDL Statements and, for usage, the statement EXCEPTION in PSQL Statements.

The Firebird SQLCODE error codes do not correlate with the standards-compliant SQLSTATE codes. SQLCODE has been used for many years and should be considered as deprecated now. Support for SQLCODE is likely to be dropped in a future version.

SQLSTATE Error Codes and Descriptions

This table provides the error codes and message texts for the SQLSTATE context variables.

The structure of an SQLSTATE error code is five characters comprising the SQL error class (2 characters) and the SQL subclass (3 characters).

Table 184. SQLSTATE Codes and Message Texts
SQLSTATEMapped Message

SQLCLASS 00 (Success)

00000

Success

SQLCLASS 01 (Warning)

01000

General warning

01001

Cursor operation conflict

01002

Disconnect error

01003

NULL value eliminated in set function

01004

String data, right-truncated

01005

Insufficient item descriptor areas

01006

Privilege not revoked

01007

Privilege not granted

01008

Implicit zero-bit padding

01100

Statement reset to unprepared

01101

Ongoing transaction has been committed

01102

Ongoing transaction has been rolled back

SQLCLASS 02 (No Data)

02000

No data found or no rows affected

SQLCLASS 07 (Dynamic SQL error)

07000

Dynamic SQL error

07001

Wrong number of input parameters

07002

Wrong number of output parameters

07003

Cursor specification cannot be executed

07004

USING clause required for dynamic parameters

07005

Prepared statement not a cursor-specification

07006

Restricted data type attribute violation

07007

USING clause required for result fields

07008

Invalid descriptor count

07009

Invalid descriptor index

SQLCLASS 08 (Connection Exception)

08001

Client unable to establish connection

08002

Connection name in use

08003

Connection does not exist

08004

Server rejected the connection

08006

Connection failure

08007

Transaction resolution unknown

SQLCLASS 0A (Feature Not Supported)

0A000

Feature Not Supported

SQLCLASS 0B (Invalid Transaction Initiation)

0B000

Invalid transaction initiation

SQLCLASS 0L (Invalid Grantor)

0L000

Invalid grantor

SQLCLASS 0P (Invalid Role Specification)

0P000

Invalid role specification

SQLCLASS 0U (Attempt to Assign to Non-Updatable Column)

0U000

Attempt to assign to non-updatable column

SQLCLASS 0V (Attempt to Assign to Ordering Column)

0V000

Attempt to assign to Ordering column

SQLCLASS 20 (Case Not Found For Case Statement)

20000

Case not found for case statement

SQLCLASS 21 (Cardinality Violation)

21000

Cardinality violation

21S01

Insert value list does not match column list

21S02

Degree of derived table does not match column list

SQLCLASS 22 (Data Exception)

22000

Data exception

22001

String data, right truncation

22002

Null value, no indicator parameter

22003

Numeric value out of range

22004

Null value not allowed

22005

Error in assignment

22006

Null value in field reference

22007

Invalid datetime format

22008

Datetime field overflow

22009

Invalid time zone displacement value

2200A

Null value in reference target

2200B

Escape character conflict

2200C

Invalid use of escape character

2200D

Invalid escape octet

2200E

Null value in array target

2200F

Zero-length character string

2200G

Most specific type mismatch

22010

Invalid indicator parameter value

22011

Substring error

22012

Division by zero

22014

Invalid update value

22015

Interval field overflow

22018

Invalid character value for cast

22019

Invalid escape character

2201B

Invalid regular expression

2201C

Null row not permitted in table

22012

Division by zero

22020

Invalid limit value

22021

Character not in repertoire

22022

Indicator overflow

22023

Invalid parameter value

22024

Character string not properly terminated

22025

Invalid escape sequence

22026

String data, length mismatch

22027

Trim error

22028

Row already exists

2202D

Null instance used in mutator function

2202E

Array element error

2202F

Array data, right truncation

SQLCLASS 23 (Integrity Constraint Violation)

23000

Integrity constraint violation

SQLCLASS 24 (Invalid Cursor State)

24000

Invalid cursor state

24504

The cursor identified in the UPDATE, DELETE, SET, or GET statement is not positioned on a row

SQLCLASS 25 (Invalid Transaction State)

25000

Invalid transaction state

25S01

Transaction state

25S02

Transaction is still active

25S03

Transaction is rolled back

SQLCLASS 26 (Invalid SQL Statement Name)

26000

Invalid SQL statement name

SQLCLASS 27 (Triggered Data Change Violation)

27000

Triggered data change violation

SQLCLASS 28 (Invalid Authorization Specification)

28000

Invalid authorization specification

SQLCLASS 2B (Dependent Privilege Descriptors Still Exist)

2B000

Dependent privilege descriptors still exist

SQLCLASS 2C (Invalid Character Set Name)

2C000

Invalid character set name

SQLCLASS 2D (Invalid Transaction Termination)

2D000

Invalid transaction termination

SQLCLASS 2E (Invalid Connection Name)

2E000

Invalid connection name

SQLCLASS 2F (SQL Routine Exception)

2F000

SQL routine exception

2F002

Modifying SQL-data not permitted

2F003

Prohibited SQL-statement attempted

2F004

Reading SQL-data not permitted

2F005

Function executed no return statement

SQLCLASS 33 (Invalid SQL Descriptor Name)

33000

Invalid SQL descriptor name

SQLCLASS 34 (Invalid Cursor Name)

34000

Invalid cursor name

SQLCLASS 35 (Invalid Condition Number)

35000

Invalid condition number

SQLCLASS 36 (Cursor Sensitivity Exception)

36001

Request rejected

36002

Request failed

SQLCLASS 37 (Invalid Identifier)

37000

Invalid identifier

37001

Identifier too long

SQLCLASS 38 (External Routine Exception)

38000

External routine exception

SQLCLASS 39 (External Routine Invocation Exception)

39000

External routine invocation exception

SQLCLASS 3B (Invalid Save Point)

3B000

Invalid save point

SQLCLASS 3C (Ambiguous Cursor Name)

3C000

Ambiguous cursor name

SQLCLASS 3D (Invalid Catalog Name)

3D000

Invalid catalog name

3D001

Catalog name not found

SQLCLASS 3F (Invalid Schema Name)

3F000

Invalid schema name

SQLCLASS 40 (Transaction Rollback)

40000

Ongoing transaction has been rolled back

40001

Serialization failure

40002

Transaction integrity constraint violation

40003

Statement completion unknown

SQLCLASS 42 (Syntax Error or Access Violation)

42000

Syntax error or access violation

42702

Ambiguous column reference

42725

Ambiguous function reference

42818

The operands of an operator or function are not compatible

42S01

Base table or view already exists

42S02

Base table or view not found

42S11

Index already exists

42S12

Index not found

42S21

Column already exists

42S22

Column not found

SQLCLASS 44 (With Check Option Violation)

44000

WITH CHECK OPTION Violation

SQLCLASS 45 (Unhandled User-defined Exception)

45000

Unhandled user-defined exception

SQLCLASS 54 (Program Limit Exceeded)

54000

Program limit exceeded

54001

Statement too complex

54011

Too many columns

54023

Too many arguments

SQLCLASS HY (CLI-specific Condition)

HY000

CLI-specific condition

HY001

Memory allocation error

HY003

Invalid data type in application descriptor

HY004

Invalid data type

HY007

Associated statement is not prepared

HY008

Operation canceled

HY009

Invalid use of null pointer

HY010

Function sequence error

HY011

Attribute cannot be set now

HY012

Invalid transaction operation code

HY013

Memory management error

HY014

Limit on the number of handles exceeded

HY015

No cursor name available

HY016

Cannot modify an implementation row descriptor

HY017

Invalid use of an automatically allocated descriptor handle

HY018

Server declined the cancellation request

HY019

Non-string data cannot be sent in pieces

HY020

Attempt to concatenate a null value

HY021

Inconsistent descriptor information

HY024

Invalid attribute value

HY055

Non-string data cannot be used with string routine

HY090

Invalid string length or buffer length

HY091

Invalid descriptor field identifier

HY092

Invalid attribute identifier

HY095

Invalid Function ID specified

HY096

Invalid information type

HY097

Column type out of range

HY098

Scope out of range

HY099

Nullable type out of range

HY100

Uniqueness option type out of range

HY101

Accuracy option type out of range

HY103

Invalid retrieval code

HY104

Invalid Length/Precision value

HY105

Invalid parameter type

HY106

Invalid fetch orientation

HY107

Row value out of range

HY109

Invalid cursor position

HY110

Invalid driver completion

HY111

Invalid bookmark value

HYC00

Optional feature not implemented

HYT00

Timeout expired

HYT01

Connection timeout expired

SQLCLASS XX (Internal Error)

XX000

Internal error

XX001

Data corrupted

XX002

Index corrupted

SQLCODE and GDSCODE Error Codes and Descriptions

The table provides the SQLCODE groupings, the numeric and symbolic values for the GDSCODE errors and the message texts.

SQLCODE has been used for many years and should be considered as deprecated now. Support for SQLCODE is likely to be dropped in a future version.

Table 185. SQLCODE and GDSCODE Error Codes and Message Texts (1)
SQL­CODEGDSCODESymbolMessage Text

101

335544366

Segment

Segment buffer length shorter than expected

100

335544338

fromno_match

No match for first value expression

100

335544354

no_record

Invalid database key

100

335544367

segstr_eof

Attempted retrieval of more segments than exist

100

335544374

stream_eof

Attempt to fetch past the last record in a record stream

0

335741039

gfix_opt_SQL_dialect

-sql_dialect | set database dialect n

0

335544875

bad_debug_format

Bad debug info format

-84

335544554

nonsql_security_rel

Table/procedure has non-SQL security class defined

-84

335544555

nonsql_security_fld

Column has non-SQL security class defined

-84

335544668

dsql_procedure_use_err

Procedure @1 does not return any values

-85

335544747

usrname_too_long

The username entered is too long. Maximum length is 31 bytes

-85

335544748

password_too_long

The password specified is too long. Maximum length is @1 bytes

-85

335544749

usrname_required

A username is required for this operation

-85

335544750

password_required

A password is required for this operation

-85

335544751

bad_protocol

The network protocol specified is invalid

-85

335544752

dup_usrname_found

A duplicate user name was found in the security database

-85

335544753

usrname_not_found

The user name specified was not found in the security database

-85

335544754

error_adding_sec_record

An error occurred while attempting to add the user

-85

335544755

error_modifying_sec_record

An error occurred while attempting to modify the user record

-85

335544756

error_deleting_sec_record

An error occurred while attempting to delete the user record

-85

335544757

error_updating_sec_db

An error occurred while updating the security database

-103

335544571

dsql_constant_err

Data type for constant unknown

-104

336003075

dsql_transitional_numeric

Precision 10 to 18 changed from DOUBLE PRECISION in SQL dialect 1 to 64-bit scaled integer in SQL dialect 3

-104

336003077

sql_db_dialect_dtype_unsupport

Database SQL dialect @1 does not support reference to @2 datatype

-104

336003087

dsql_invalid_label

Label @1 @2 in the current scope

-104

336003088

dsql_datatypes_not_comparable

Datatypes @1are not comparable in expression @2

-104

335544343

invalid_blr

Invalid request BLR at offset @1

-104

335544390

syntaxerr

BLR syntax error: expected @1 at offset @2, encountered @3

-104

335544425

ctxinuse

Context already in use (BLR error)

-104

335544426

ctxnotdef

Context not defined (BLR error)

-104

335544429

badparnum

Bad parameter number

-104

335544440

bad_msg_vec

-

-104

335544456

invalid_sdl

Invalid slice description language at offset @1

-104

335544570

dsql_command_err

Invalid command

-104

335544579

dsql_internal_err

Internal error

-104

335544590

dsql_dup_option

Option specified more than once

-104

335544591

dsql_tran_err

Unknown transaction option

-104

335544592

dsql_invalid_array

Invalid array reference

-104

335544608

command_end_err

Unexpected end of command

-104

335544612

token_err

Token unknown

-104

335544634

dsql_token_unk_err

Token unknown - line @1, column @2

-104

335544709

dsql_agg_ref_err

Invalid aggregate reference

-104

335544714

invalid_array_id

Invalid blob id

-104

335544730

cse_not_supported

Client/Server Express not supported in this release

-104

335544743

token_too_long

Token size exceeds limit

-104

335544763

invalid_string_constant

A string constant is delimited by double quotes

-104

335544764

transitional_date

DATE must be changed to TIMESTAMP

-104

335544796

sql_dialect_datatype_unsupport

Client SQL dialect @1 does not support reference to @2 datatype

-104

335544798

depend_on_uncommitted_rel

You created an indirect dependency on uncommitted metadata. You must roll back the current transaction

-104

335544821

dsql_column_pos_err

Invalid column position used in the @1 clause

-104

335544822

dsql_agg_where_err

Cannot use an aggregate function in a WHERE clause, use HAVING instead

-104

335544823

dsql_agg_group_err

Cannot use an aggregate function in a GROUP BY clause

-104

335544824

dsql_agg_column_err

Invalid expression in the @1 (not contained in either an aggregate function or the GROUP BY clause)

-104

335544825

dsql_agg_having_err

Invalid expression in the @1 (neither an aggregate function nor a part of the GROUP BY clause)

-104

335544826

dsql_agg_nested_err

Nested aggregate functions are not allowed

-104

335544849

malformed_string

Malformed string

-104

335544851

command_end_err2

Unexpected end of command- line @1, column @2

-104

336397215

dsql_max_sort_items

Cannot sort on more than 255 items

-104

336397216

dsql_max_group_items

Cannot group on more than 255 items

-104

336397217

dsql_conflicting_sort_field

Cannot include the same field (@1.@2) twice in the ORDER BY clause with conflicting sorting options

-104

336397218

dsql_derived_table_more_columns

Column list from derived table @1 has more columns than the number of items in its SELECT statement

-104

336397219

dsql_derived_table_less_columns

Column list from derived table @1 has less columns than the number of items in its SELECT statement

-104

336397220

dsql_derived_field_unnamed

No column name specified for column number @1 in derived table @2

-104

336397221

dsql_derived_field_dup_name

Column @1 was specified multiple times for derived table @2

-104

336397222

dsql_derived_alias_select

Internal dsql error: alias type expected by pass1_expand_select_node

-104

336397223

dsql_derived_alias_field

Internal dsql error: alias type expected by pass1_field

-104

336397224

dsql_auto_field_bad_pos

Internal dsql error: column position out of range in pass1_union_auto_cast

-104

336397225

dsql_cte_wrong_reference

Recursive CTE member (@1) can refer itself only in FROM clause

-104

336397226

dsql_cte_cycle

CTE ‘@1’ has cyclic dependencies

-104

336397227

dsql_cte_outer_join

Recursive member of CTE can’t be member of an outer join

-104

336397228

dsql_cte_mult_references

Recursive member of CTE can’t reference itself more than once

-104

336397229

dsql_cte_not_a_union

Recursive CTE (@1) must be an UNION

-104

336397230

dsql_cte_nonrecurs_after_recurs

CTE ‘@1’ defined non-recursive member after recursive

-104

336397231

dsql_cte_wrong_clause

Recursive member of CTE ‘@1’ has @2 clause

-104

336397232

dsql_cte_union_all

Recursive members of CTE (@1) must be linked with another members via UNION ALL

-104

336397233

dsql_cte_miss_nonrecursive

Non-recursive member is missing in CTE ‘@1’

-104

336397234

dsql_cte_nested_with

WITH clause can’t be nested

-104

336397235

dsql_col_more_than_once_using

Column @1 appears more than once in USING clause

-104

336397237

dsql_cte_not_used

CTE “@1” is not used in query

-105

335544702

like_escape_invalid

Invalid ESCAPE sequence

-105

335544789

extract_input_mismatch

Specified EXTRACT part does not exist in input datatype

-150

335544360

read_only_rel

Attempted update of read-only table

-150

335544362

read_only_view

Cannot update read-only view @1

-150

335544446

non_updatable

Not updatable

-150

335544546

constaint_on_view

Cannot define constraints on views

-151

335544359

read_only_field

Attempted update of read - only column

-155

335544658

dsql_base_table

@1 is not a valid base table of the specified view

-157

335544598

specify_field_err

Must specify column name for view select expression

-158

335544599

num_field_err

Number of columns does not match select list

-162

335544685

no_dbkey

Dbkey not available for multi - table views

-170

335544512

prcmismat

Input parameter mismatch for procedure @1

-170

335544619

extern_func_err

External functions cannot have more than 10 parameters

-170

335544850

prc_out_param_mismatch

Output parameter mismatch for procedure @1

-171

335544439

funmismat

Function @1 could not be matched

-171

335544458

invalid_dimension

Column not array or invalid dimensions (expected @1, encountered @2)

-171

335544618

return_mode_err

Return mode by value not allowed for this data type

-171

335544873

array_max_dimensions

Array data type can use up to @1 dimensions

-172

335544438

funnotdef

Function @1 is not defined

-203

335544708

dyn_fld_ambiguous

Ambiguous column reference

-204

336003085

dsql_ambiguous_field_name

Ambiguous field name between @1 and @2

-204

335544463

gennotdef

Generator @1 is not defined

-204

335544502

stream_not_defined

Reference to invalid stream number

-204

335544509

charset_not_found

CHARACTER SET @1 is not defined

-204

335544511

prcnotdef

Procedure @1 is not defined

-204

335544515

codnotdef

Status code @1 unknown

-204

335544516

xcpnotdef

Exception @1 not defined

-204

335544532

ref_cnstrnt_notfound

Name of Referential Constraint not defined in constraints table

-204

335544551

grant_obj_notfound

Could not find table/procedure for GRANT

-204

335544568

text_subtype

Implementation of text subtype @1 not located

-204

335544573

dsql_datatype_err

Data type unknown

-204

335544580

dsql_relation_err

Table unknown

-204

335544581

dsql_procedure_err

Procedure unknown

-204

335544588

collation_not_found

COLLATION @1 for CHARACTER SET @2 is not defined

-204

335544589

collation_not_for_charset

COLLATION @1 is not valid for specified CHARACTER SET

-204

335544595

dsql_trigger_err

Trigger unknown

-204

335544620

alias_conflict_err

Alias @1 conflicts with an alias in the same statement

-204

335544621

procedure_conflict_error

Alias @1 conflicts with a procedure in the same statement

-204

335544622

relation_conflict_err

Alias @1 conflicts with a table in the same statement

-204

335544635

dsql_no_relation_alias

There is no alias or table named @1 at this scope level

-204

335544636

indexname

There is no index @1 for table @2

-204

335544640

collation_requires_text

Invalid use of CHARACTER SET or COLLATE

-204

335544662

dsql_blob_type_unknown

BLOB SUB_TYPE @1 is not defined

-204

335544759

bad_default_value

Can not define a not null column with NULL as default value

-204

335544760

invalid_clause

Invalid clause - ‘@1’

-204

335544800

too_many_contexts

Too many Contexts of Relation/Procedure/Views. Maximum allowed is 255

-204

335544817

bad_limit_param

Invalid parameter to FIRST.Only integers >= 0 are allowed

-204

335544818

bad_skip_param

Invalid parameter to SKIP. Only integers >= 0 are allowed

-204

335544837

bad_substring_offset

Invalid offset parameter @1 to SUBSTRING. Only positive integers are allowed

-204

335544853

bad_substring_length

Invalid length parameter @1 to SUBSTRING. Negative integers are not allowed

-204

335544854

charset_not_installed

CHARACTER SET @1 is not installed

-204

335544855

collation_not_installed

COLLATION @1 for CHARACTER SET @2 is not installed

-204

335544867

subtype_for_internal_use

Blob sub_types bigger than 1 (text) are for internal use only

-205

335544396

fldnotdef

Column @1 is not defined in table @2

-205

335544552

grant_fld_notfound

Could not find column for GRANT

-205

335544883

fldnotdef2

Column @1 is not defined in procedure @2

-206

335544578

dsql_field_err

Column unknown

-206

335544587

dsql_blob_err

Column is not a BLOB

-206

335544596

dsql_subselect_err

Subselect illegal in this context

-206

336397208

dsql_line_col_error

At line @1, column @2

-206

336397209

dsql_unknown_pos

At unknown line and column

-206

336397210

dsql_no_dup_name

Column @1 cannot be repeated in @2 statement

-208

335544617

order_by_err

Invalid ORDER BY clause

-219

335544395

relnotdef

Table @1 is not defined

-219

335544872

domnotdef

Domain @1 is not defined

-230

335544487

walw_err

WAL Writer error

-231

335544488

logh_small

Log file header of @1 too small

-232

335544489

logh_inv_version

Invalid version of log file @1

-233

335544490

logh_open_flag

Log file @1 not latest in the chain but open flag still set

-234

335544491

logh_open_flag2

Log file @1 not closed properly; database recovery may be required

-235

335544492

logh_diff_dbname

Database name in the log file @1 is different

-236

335544493

logf_unexpected_eof

Unexpected end of log file @1 at offset @2

-237

335544494

logr_incomplete

Incomplete log record at offset @1 in log file @2

-238

335544495

logr_header_small2

Log record header too small at offset @1 in log file @

-239

335544496

logb_small

Log block too small at offset @1 in log file @2

-239

335544691

cache_too_small

Insufficient memory to allocate page buffer cache

-239

335544693

log_too_small

Log size too small

-239

335544694

partition_too_small

Log partition size too small

-243

335544500

no_wal

Database does not use Write-ahead Log

-257

335544566

start_cm_for_wal

WAL defined; Cache Manager must be started first

-260

335544690

cache_redef

Cache redefined

-260

335544692

log_redef

Log redefined

-261

335544695

partition_not_supp

Partitions not supported in series of log file specification

-261

335544696

log_length_spec

Total length of a partitioned log must be specified

-281

335544637

no_stream_plan

Table @1 is not referenced in plan

-282

335544638

stream_twice

Table @1 is referenced more than once in plan; use aliases to distinguish

-282

335544643

dsql_self_join

The table @1 is referenced twice; use aliases to differentiate

-282

335544659

duplicate_base_table

Table @1 is referenced twice in view; use an alias to distinguish

-282

335544660

view_alias

View @1 has more than one base table; use aliases to distinguish

-282

335544710

complex_view

Navigational stream @1 references a view with more than one base table

-283

335544639

stream_not_found

Table @1 is referenced in the plan but not the from list

-284

335544642

index_unused

Index @1 cannot be used in the specified plan

-291

335544531

primary_key_notnull

Column used in a PRIMARY constraint must be NOT NULL

-292

335544534

ref_cnstrnt_update

Cannot update constraints (RDB$REF_CONSTRAINTS)

-293

335544535

check_cnstrnt_update

Cannot update constraints (RDB$CHECK_CONSTRAINTS)

-294

335544536

check_cnstrnt_del

Cannot delete CHECK constraint entry (RDB$CHECK_CONSTRAINTS)

-295

335544545

rel_cnstrnt_update

Cannot update constraints (RDB$RELATION_CONSTRAINTS)

-296

335544547

invld_cnstrnt_type

Internal gds software consistency check (invalid RDB$CONSTRAINT_TYPE)

-297

335544558

check_constraint

Operation violates check constraint @1 on view or table @2

-313

336003099

upd_ins_doesnt_match_pk

UPDATE OR INSERT field list does not match primary key of table @1

-313

336003100

upd_ins_doesnt match _matching

UPDATE OR INSERT field list does not match MATCHING clause

-313

335544669

dsql_count_mismatch

Count of column list and variable list do not match

-314

335544565

transliteration_failed

Cannot transliterate character between character sets

-315

336068815

dyn_dtype_invalid

Cannot change datatype for column @1.Changing datatype is not supported for BLOB or ARRAY columns

-383

336068814

dyn_dependency_exists

Column @1 from table @2 is referenced in @3

-401

335544647

invalid_operator

Invalid comparison operator for find operation

-402

335544368

segstr_no_op

Attempted invalid operation on a BLOB

-402

335544414

blobnotsup

BLOB and array data types are not supported for @1 operation

-402

335544427

datnotsup

Data operation not supported

-406

335544457

out_of_bounds

Subscript out of bounds

-407

335544435

nullsegkey

Null segment of UNIQUE KEY

-413

335544334

convert_error

Conversion error from string “@1”

Table 186. SQLCODE and GDSCODE Error Codes and Message Texts (2)
SQL­CODEGDSCODESymbolMessage Text

-413

335544454

nofilter

Filter not found to convert type @1 to type @2

-413

335544860

blob_convert_error

Unsupported conversion to target type BLOB (subtype @1)

-413

335544861

array_convert_error

Unsupported conversion to target type ARRAY

-501

335544577

dsql_cursor_close_err

Attempt to reclose a closed cursor

-502

336003090

dsql_cursor_redefined

Statement already has a cursor @1 assigned

-502

336003091

dsql_cursor_not_found

Cursor @1 is not found in the current context

-502

336003092

dsql_cursor_exists

Cursor @1 already exists in the current context

-502

336003093

dsql_cursor_rel_ambiguous

Relation @1 is ambiguous in cursor @2

-502

336003094

dsql_cursor_rel_not_found

Relation @1 is not found in cursor @2

-502

336003095

dsql_cursor_not_open

Cursor is not open

-502

335544574

dsql_decl_err

Invalid cursor declaration

-502

335544576

dsql_cursor_open_err

Attempt to reopen an open cursor

-504

336003089

dsql_cursor_invalid

Empty cursor name is not allowed

-504

335544572

dsql_cursor_err

Invalid cursor reference

-508

335544348

no_cur_rec

No current record for fetch operation

-510

335544575

dsql_cursor_update_err

Cursor @1 is not updatable

-518

335544582

dsql_request_err

Request unknown

-519

335544688

dsql_open_cursor_request

The prepare statement identifies a prepare statement with an open cursor

-530

335544466

foreign_key

Violation of FOREIGN KEY constraint “@1” on table “@2”

-530

335544838

foreign_key_target_doesnt_exist

Foreign key reference target does not exist

-530

335544839

foreign_key_references_present

Foreign key references are present for the record

-531

335544597

dsql_crdb_prepare_err

Cannot prepare a CREATE DATABASE/SCHEMA statement

-532

335544469

trans_invalid

Transaction marked invalid by I/O error

-551

335544352

no_priv

No permission for @1 access to @2 @3

-551

335544790

insufficient_svc_privileges

Service @1 requires SYSDBA permissions. Reattach to the Service Manager using the SYSDBA account

-552

335544550

not_rel_owner

Only the owner of a table may reassign ownership

-552

335544553

grant_nopriv

User does not have GRANT privileges for operation

-552

335544707

grant_nopriv_on_base

User does not have GRANT privileges on base table/view for operation

-553

335544529

existing_priv_mod

Cannot modify an existing user privilege

-595

335544645

stream_crack

The current position is on a crack

-596

335544644

stream_bof

Illegal operation when at beginning of stream

-597

335544632

dsql_file_length_err

Preceding file did not specify length, so @1 must include starting page number

-598

335544633

dsql_shadow_number_err

Shadow number must be a positive integer

-599

335544607

node_err

Gen.c: node not supported

-599

335544625

node_name_err

A node name is not permitted in a secondary, shadow, cache or log file name

-600

335544680

crrp_data_err

Sort error: corruption in data structure

-601

335544646

db_or_file_exists

Database or file exists

-604

335544593

dsql_max_arr_dim_exceeded

Array declared with too many dimensions

-604

335544594

dsql_arr_range_error

Illegal array dimension range

-605

335544682

dsql_field_ref

Inappropriate self-reference of column

-607

336003074

dsql_dbkey_from_non_table

Cannot SELECT RDB$DB_KEY from a stored procedure

-607

336003086

dsql_udf_return_pos_err

External function should have return position between 1 and @1

-607

336003096

dsql_type_not_supp_ext_tab

Data type @1 is not supported for EXTERNAL TABLES. Relation ‘@2’, field ‘@3’

-607

335544351

no_meta_update

Unsuccessful metadata update

-607

335544549

systrig_update

Cannot modify or erase a system trigger

-607

335544657

dsql_no_blob_array

Array/BLOB/DATE data types not allowed in arithmetic

-607

335544746

reftable_requires_pk

“REFERENCES table” without “(column)” requires PRIMARY KEY on referenced table

-607

335544815

generator_name

GENERATOR @1

-607

335544816

udf_name

UDF @1

-607

335544858

must_have_phys_field

Can’t have relation with only computed fields or constraints

-607

336397206

dsql_table_not_found

Table @1 does not exist

-607

336397207

dsql_view_not_found

View @1 does not exist

-607

336397212

dsql_no_array_computed

Array and BLOB data types not allowed in computed field

-607

336397214

dsql_only_can_subscript_array

Scalar operator used on field @1 which is not an array

-612

336068812

dyn_domain_name_exists

Cannot rename domain @1 to @2. A domain with that name already exists

-612

336068813

dyn_field_name_exists

Cannot rename column @1 to @2.A column with that name already exists in table @3

-615

335544475

relation_lock

Lock on table @1 conflicts with existing lock

-615

335544476

record_lock

Requested record lock conflicts with existing lock

-615

335544507

range_in_use

Refresh range number @1 already in use

-616

335544530

primary_key_ref

Cannot delete PRIMARY KEY being used in FOREIGN KEY definition

-616

335544539

integ_index_del

Cannot delete index used by an Integrity Constraint

-616

335544540

integ_index_mod

Cannot modify index used by an Integrity Constraint

-616

335544541

check_trig_del

Cannot delete trigger used by a CHECK Constraint

-616

335544543

cnstrnt_fld_del

Cannot delete column being used in an Integrity Constraint

-616

335544630

dependency

There are @1 dependencies

-616

335544674

del_last_field

Last column in a table cannot be deleted

-616

335544728

integ_index_deactivate

Cannot deactivate index used by an integrity constraint

-616

335544729

integ_deactivate_primary

Cannot deactivate index used by a PRIMARY/UNIQUE constraint

-617

335544542

check_trig_update

Cannot update trigger used by a CHECK Constraint

-617

335544544

cnstrnt_fld_rename

Cannot rename column being used in an Integrity Constraint

-618

335544537

integ_index_seg_del

Cannot delete index segment used by an Integrity Constraint

-618

335544538

integ_index_seg_mod

Cannot update index segment used by an Integrity Constraint

-625

335544347

not_valid

Validation error for column @1, value “@2”

-625

335544879

not_valid_for_var

Validation error for variable @1, value “@2”

-625

335544880

not_valid_for

Validation error for @1, value “@2”

-637

335544664

dsql_duplicate_spec

Duplicate specification of @1- not supported

-637

336397213

dsql_implicit_domain_name

Implicit domain name @1 not allowed in user created domain

-660

336003098

primary_key_required

Primary key required on table @1

-660

335544533

foreign_key_notfound

Non-existent PRIMARY or UNIQUE KEY specified for FOREIGN KEY

-660

335544628

idx_create_err

Cannot create index @1

-663

335544624

idx_seg_err

Segment count of 0 defined for index @1

-663

335544631

idx_key_err

Too many keys defined for index @1

-663

335544672

key_field_err

Too few key columns found for index @1 (incorrect column name?)

-664

335544434

keytoobig

Key size exceeds implementation restriction for index “@1”

-677

335544445

ext_err

@1 extension error

-685

335544465

bad_segstr_type

Invalid BLOB type for operation

-685

335544670

blob_idx_err

Attempt to index BLOB column in index @1

-685

335544671

array_idx_err

Attempt to index array column in index @1

-689

335544403

badpagtyp

Page @1 is of wrong type (expected @2, found @3)

-689

335544650

page_type_err

Wrong page type

-690

335544679

no_segments_err

Segments not allowed in expression index @1

-691

335544681

rec_size_err

New record size of @1 bytes is too big

-692

335544477

max_idx

Maximum indexes per table (@1) exceeded

-693

335544663

req_max_clones_exceeded

Too many concurrent executions of the same request

-694

335544684

no_field_access

Cannot access column @1 in view @2

-802

335544321

arith_except

Arithmetic exception, numeric overflow, or string truncation

-802

335544836

concat_overflow

Concatenation overflow. Resulting string cannot exceed 32K in length

-803

335544349

no_dup

Attempt to store duplicate value ( visible to active transactions ) in unique index “@1”

-803

335544665

unique_key_violation

Violation of PRIMARY or UNIQUE KEY constraint “@1” on table “@2”

-804

336003097

dsql_feature_not_supported_ods

Feature not supported on ODS version older than @1.@2

-804

335544380

wronumarg

Wrong number of arguments on call

-804

335544583

dsql_sqlda_err

SQLDA missing or incorrect version, or incorrect number/type of variables

-804

335544584

dsql_var_count_err

Count of read - write columns does not equal count of values

-804

335544586

dsql_function_err

Function unknown

-804

335544713

dsql_sqlda_value_err

Incorrect values within SQLDA structure

-804

336397205

dsql_too_old_ods

ODS versions before ODS@1 are not supported

-806

335544600

col_name_err

Only simple column names permitted for VIEW WITH CHECK OPTION

-807

335544601

where_err

No WHERE clause for VIEW WITH CHECK OPTION

-808

335544602

table_view_err

Only one table allowed for VIEW WITH CHECK OPTION

-809

335544603

distinct_err

DISTINCT, GROUP or HAVING not permitted for VIEW WITH CHECK OPTION

-810

335544605

subquery_err

No subqueries permitted for VIEW WITH CHECK OPTION

-811

335544652

sing_select_err

Multiple rows in singleton select

-816

335544651

ext_readonly_err

Cannot insert because the file is readonly or is on a read only medium

-816

335544715

extfile_uns_op

Operation not supported for EXTERNAL FILE table @1

-817

336003079

isc_sql_dialect_conflict_num

DB dialect @1 and client dialect @2 conflict with respect to numeric precision @3

-817

336003101

upd_ins_with_complex_view

UPDATE OR INSERT without MATCHING could not be used with views based on more than one table

-817

336003102

dsql_incompatible_trigger_type

Incompatible trigger type

-817

336003103

dsql_db_trigger_type_cant_change

Database trigger type can’t be changed

-817

335544361

read_only_trans

Attempted update during read - only transaction

-817

335544371

segstr_no_write

Attempted write to read-only BLOB

-817

335544444

read_only

Operation not supported

-817

335544765

read_only_database

Attempted update on read - only database

-817

335544766

must_be_dialect_2_and_up

SQL dialect @1 is not supported in this database

-817

335544793

ddl_not_allowed_by_db_sql_dial

Metadata update statement is not allowed by the current database SQL dialect @1

-820

335544356

obsolete_metadata

Metadata is obsolete

-820

335544379

wrong_ods

Unsupported on - disk structure for file @1; found @2.@3, support @4.@5

-820

335544437

wrodynver

Wrong DYN version

-820

335544467

high_minor

Minor version too high found @1 expected @2

-820

335544881

need_difference

Difference file name should be set explicitly for database on raw device

-823

335544473

invalid_bookmark

Invalid bookmark handle

-824

335544474

bad_lock_level

Invalid lock level @1

-825

335544519

bad_lock_handle

Invalid lock handle

-826

335544585

dsql_stmt_handle

Invalid statement handle

-827

335544655

invalid_direction

Invalid direction for find operation

-827

335544718

invalid_key

Invalid key for find operation

-828

335544678

inval_key_posn

Invalid key position

-829

336068816

dyn_char_fld_too_small

New size specified for column @1 must be at least @2 characters

-829

336068817

dyn_invalid_dtype_conversion

Cannot change datatype for @1.Conversion from base type @2 to @3 is not supported

-829

336068818

dyn_dtype_conv_invalid

Cannot change datatype for column @1 from a character type to a non-character type

-829

336068829

max_coll_per_charset

Maximum number of collations per character set exceeded

-829

336068830

invalid_coll_attr

Invalid collation attributes

-829

336068852

dyn_scale_too_big

New scale specified for column @1 must be at most @2

-829

336068853

dyn_precision_too_small

New precision specified for column @1 must be at least @2

-829

335544616

field_ref_err

Invalid column reference

-830

335544615

field_aggregate_err

Column used with aggregate

-831

335544548

primary_key_exists

Attempt to define a second PRIMARY KEY for the same table

-832

335544604

key_field_count_err

FOREIGN KEY column count does not match PRIMARY KEY

-833

335544606

expression_eval_err

Expression evaluation not supported

-833

335544810

date_range_exceeded

Value exceeds the range for valid dates

-834

335544508

range_not_found

Refresh range number @1 not found

-835

335544649

bad_checksum

Bad checksum

-836

335544517

except

Exception @1

-836

335544848

except2

Exception @1

-837

335544518

cache_restart

Restart shared cache manager

-838

335544560

shutwarn

Database @1 shutdown in @2 seconds

-841

335544677

version_err

Too many versions

-842

335544697

precision_err

Precision must be from 1 to 18

-842

335544698

scale_nogt

Scale must be between zero and precision

-842

335544699

expec_short

Short integer expected

-842

335544700

expec_long

Long integer expected

-842

335544701

expec_ushort

Unsigned short integer expected

-842

335544712

expec_positive

Positive value expected

-901

335740929

gfix_db_name

Database file name (@1) already given

-901

336330753

gbak_unknown_switch

Found unknown switch

-901

336920577

gstat_unknown_switch

Found unknown switch

-901

336986113

fbsvcmgr_bad_am

Wrong value for access mode

-901

335740930

gfix_invalid_sw

Invalid switch @1

-901

335544322

bad_dbkey

Invalid database key

-901

336986114

fbsvcmgr_bad_wm

Wrong value for write mode

-901

336330754

gbak_page_size_missing

Page size parameter missing

-901

336920578

gstat_retry

Please retry, giving a database name

-901

336986115

fbsvcmgr_bad_rs

Wrong value for reserve space

-901

336920579

gstat_wrong_ods

Wrong ODS version, expected @1, encountered @2

-901

336330755

gbak_page_size_toobig

Page size specified (@1) greater than limit (16384 bytes)

-901

335740932

gfix_incmp_sw

Incompatible switch combination

-901

336920580

gstat_unexpected_eof

Unexpected end of database file

-901

336330756

gbak_redir_ouput_missing

Redirect location for output is not specified

-901

336986116

fbsvcmgr_info_err

Unknown tag (@1) in info_svr_db_info block after isc_svc_query()

-901

335740933

gfix_replay_req

Replay log pathname required

-901

336330757

gbak_switches_conflict

Conflicting switches for backup/restore

-901

336986117

fbsvcmgr_query_err

Unknown tag (@1) in isc_svc_query() results

-901

335544326

bad_dpb_form

Unrecognized database parameter block

-901

335740934

gfix_pgbuf_req

Number of page buffers for cache required

-901

336986118

fbsvcmgr_switch_unknown

Unknown switch “@1”

-901

336330758

gbak_unknown_device

Device type @1 not known

-901

335544327

bad_req_handle

Invalid request handle

-901

335740935

gfix_val_req

Numeric value required

-901

336330759

gbak_no_protection

Protection is not there yet

-901

335544328

bad_segstr_handle

Invalid BLOB handle

-901

335740936

gfix_pval_req

Positive numeric value required

-901

336330760

gbak_page_size_not_allowed

Page size is allowed only on restore or create

Table 187. SQLCODE and GDSCODE Error Codes and Message Texts (3)
SQL­CODEGDSCODESymbolMessage Text

-901

335544329

badsegstr_id

Invalid BLOB ID

-901

335740937

gfix_trn_req

Number of transactions per sweep required

-901

336330761

gbak_multi_source_dest

Multiple sources or destinations specified

-901

335544330

bad_tpb_content

Invalid parameter in transaction parameter block

-901

336330762

gbak_filename_missing

Requires both input and output filenames

-901

335544331

bad_tpb_form

Invalid format for transaction parameter block

-901

336330763

gbak_dup_inout_names

Input and output have the same name. Disallowed

-901

335740940

gfix_full_req

“full” or “reserve” required

-901

335544332

bad_trans_handle

Invalid transaction handle (expecting explicit transaction start)

-901

336330764

gbak_inv_page_size

Expected page size, encountered “@1”

-901

335740941

gfix_usrname_req

User name required

-901

336330765

gbak_db_specified

REPLACE specified, but the first file @1 is a database

-901

335740942

gfix_pass_req

Password required

-901

336330766

gbak_db_exists

Database @1 already exists.To replace it, use the -REP switch

-901

335740943

gfix_subs_name

Subsystem name

-901

336723983

gsec_cant_open_db

Unable to open database

-901

336330767

gbak_unk_device

Device type not specified

-901

336723984

gsec_switches_error

Error in switch specifications

-901

335740945

gfix_sec_req

Number of seconds required

-901

335544337

excess_trans

Attempt to start more than @1 transactions

-901

336723985

gsec_no_op_spec

No operation specified

-901

335740946

gfix_nval_req

Numeric value between 0 and 32767 inclusive required

-901

336723986

gsec_no_usr_name

No user name specified

-901

335740947

gfix_type_shut

Must specify type of shutdown

-901

335544339

infinap

Information type inappropriate for object specified

-901

335544340

infona

No information of this type available for object specified

-901

336723987

gsec_err_add

Add record error

-901

336723988

gsec_err_modify

Modify record error

-901

336330772

gbak_blob_info_failed

Gds$blobinfo failed

-901

335740948

gfix_retry

Please retry, specifying an option

-901

335544341

infunk

Unknown information item

-901

336723989

gsec_err_find_mod

Find / modify record error

-901

336330773

gbak_unk_blob_item

Do not understand BLOB INFO item @1

-901

335544342

integ_fail

Action cancelled by trigger (@1) to preserve data integrity

-901

336330774

gbak_get_seg_failed

Gds$getsegment failed

-901

336723990

gsec_err_rec_not_found

Record not found for user: @1

-901

336723991

gsec_err_delete

Delete record error

-901

336330775

gbak_close_blob_failed

Gds$closeblob failed

-901

335740951

gfix_retry_db

Please retry, giving a database name

-901

336330776

gbak_open_blob_failed

Gds$openblob failed

-901

336723992

gsec_err_find_del

Find / delete record error

-901

335544345

lock_conflict

Lock conflict on no wait transaction

-901

336330777

gbak_put_blr_gen_id_failed

Failed in put_blr_gen_id

-901

336330778

gbak_unk_type

Data type @1 not understood

-901

336330779

gbak_comp_req_failed

Gds$compilerequest failed

-901

336330780

gbak_start_req_failed

Gds$startrequest failed

-901

336723996

gsec_err_find_disp

Find / display record error

-901

336330781

gbak_rec_failed

gds$receive failed

-901

336920605

gstatopen_err

Can’t open database file @1

-901

336723997

gsec_inv_param

Invalid parameter, no switch defined

-901

335544350

no_finish

Program attempted to exit without finishing database

-901

336920606

gstat_read_err

Can’t read a database page

-901

336330782

gbak_rel_req_failed

Gds$releaserequest failed

-901

336723998

gsec_op_specified

Operation already specified

-901

336920607

gstat_sysmemex

System memory exhausted

-901

336330783

gbak_db_info_failed

gds$databaseinfo failed

-901

336723999

gsec_pw_specified

Password already specified

-901

336724000

gsec_uid_specified

Uid already specified

-901

336330784

gbak_no_db_desc

Expected database description record

-901

335544353

no_recon

Transaction is not in limbo

-901

336724001

gsec_gid_specified

Gid already specified

-901

336330785

gbak_db_create_failed

Failed to create database @1

-901

336724002

gsec_proj_specified

Project already specified

-901

336330786

gbak_decomp_len_error

RESTORE: decompression length error

-901

335544355

no_segstr_close

BLOB was not closed

-901

336330787

gbak_tbl_missing

Cannot find table @1

-901

336724003

gsec_org_specified

Organization already specified

-901

336330788

gbak_blob_col_missing

Cannot find column for BLOB

-901

336724004

gsec_fname_specified

First name already specified

-901

335544357

open_trans

Cannot disconnect database with open transactions (@1 active)

-901

336330789

gbak_create_blob_failed

Gds$createblob failed

-901

336724005

gsec_mname_specified

Middle name already specified

-901

335544358

port_len

Message length error ( encountered @1, expected @2)

-901

336330790

gbak_put_seg_failed

Gds$putsegment failed

-901

336724006

gsec_lname_specified

Last name already specified

-901

336330791

gbak_rec_len_exp

Expected record length

-901

336724008

gsec_inv_switch

Invalid switch specified

-901

336330792

gbak_inv_rec_len

Wrong length record, expected @1 encountered @2

-901

336330793

gbak_exp_data_type

Expected data attribute

-901

336724009

gsec_amb_switch

Ambiguous switch specified

-901

336330794

gbak_gen_id_failed

Failed in store_blr_gen_id

-901

336724010

gsec_no_op_specified

No operation specified for parameters

-901

335544363

req_no_trans

No transaction for request

-901

336330795

gbak_unk_rec_type

Do not recognize record type @1

-901

336724011

gsec_params_not_allowed

No parameters allowed for this operation

-901

335544364

req_sync

Request synchronization error

-901

336724012

gsec_incompat_switch

Incompatible switches specified

-901

336330796

gbak_inv_bkup_ver

Expected backup version 1..8. Found @1

-901

335544365

req_wrong_db

Request referenced an unavailable database

-901

336330797

gbak_missing_bkup_desc

Expected backup description record

-901

336330798

gbak_string_trunc

String truncated

-901

336330799

gbak_cant_rest_record

warning — record could not be restored

-901

336330800

gbak_send_failed

Gds$send failed

-901

335544369

segstr_no_read

Attempted read of a new, open BLOB

-901

336330801

gbak_no_tbl_name

No table name for data

-901

335544370

segstr_no_trans

Attempted action on blob outside transaction

-901

336330802

gbak_unexp_eof

Unexpected end of file on backup file

-901

336330803

gbak_db_format_too_old

Database format @1 is too old to restore to

-901

335544372

segstr_wrong_db

Attempted reference to BLOB in unavailable database

-901

336330804

gbak_inv_array_dim

Array dimension for column @1 is invalid

-901

336330807

gbak_xdr_len_expected

Expected XDR record length

-901

335544376

unres_rel

Table @1 was omitted from the transaction reserving list

-901

335544377

uns_ext

Request includes a DSRI extension not supported in this implementation

-901

335544378

wish_list

Feature is not supported

-901

335544382

random

@1

-901

335544383

fatal_conflict

Unrecoverable conflict with limbo transaction @1

-901

335740991

gfix_exceed_max

Internal block exceeds maximum size

-901

335740992

gfix_corrupt_pool

Corrupt pool

-901

335740993

gfix_mem_exhausted

Virtual memory exhausted

-901

336330817

gbak_open_bkup_error

Cannot open backup file @1

-901

335740994

gfix_bad_pool

Bad pool id.

-901

336330818

gbak_open_error

Cannot open status and error output file @1

-901

335740995

gfix_trn_not_valid

Transaction state @1 not in valid range

-901

335544392

bdbincon

Internal error

-901

336724044

gsec_inv_username

Invalid user name (maximum 31 bytes allowed)

-901

336724045

gsec_inv_pw_length

Warning - maximum 8 significant bytes of password used

-901

336724046

gsec_db_specified

Database already specified

-901

336724047

gsec_db_admin_specified

Database administrator name already specified

-901

336724048

gsec_db_admin_pw_specified

Database administrator password already specified

-901

336724049

gsec_sql_role_specified

SQL role name already specified

-901

335741012

gfix_unexp_eoi

Unexpected end of input

-901

335544407

dbbnotzer

Database handle not zero

-901

335544408

tranotzer

Transaction handle not zero

-901

335741018

gfix_recon_fail

Failed to reconnect to a transaction in database @1

-901

335544418

trainlim

Transaction in limbo

-901

335544419

notinlim

Transaction not in limbo

-901

335544420

traoutsta

Transaction outstanding

-901

335544428

badmsgnum

Undefined message number

-901

335741036

gfix_trn_unknown

Transaction description item unknown

-901

335741038

gfix_mode_req

“read_only” or “read_write” required

-901

335544431

blocking_signal

Blocking signal has been received

-901

335741042

gfix_pzval_req

Positive or zero numeric value required

-901

335544442

noargacc_read

Database system cannot read argument @1

-901

335544443

noargacc_write

Database system cannot write argument @1

-901

335544450

misc_interpreted

@1

-901

335544468

tra_state

Transaction @1 is @2

-901

335544485

bad_stmt_handle

Invalid statement handle

-901

336330934

gbak_missing_block_fac

Blocking factor parameter missing

-901

336330935

gbak_inv_block_fac

Expected blocking factor, encountered “@1”

-901

336330936

gbak_block_fac_specified

A blocking factor may not be used in conjunction with device CT

-901

336068796

dyn_role_does_not_exist

SQL role @1 does not exist

-901

336330940

gbak_missing_username

User name parameter missing

-901

336330941

gbak_missing_password

Password parameter missing

-901

336068797

dyn_no_grant_admin_opt

User @1 has no grant admin option on SQL role @2

-901

335544510

lock_timeout

Lock time-out on wait transaction

-901

336068798

dyn_user_not_role_member

User @1 is not a member of SQL role @2

-901

336068799

dyn_delete_role_failed

@1 is not the owner of SQL role @2

-901

336068800

dyn_grant_role_to_user

@1 is a SQL role and not a user

-901

336068801

dyn_inv_sql_role_name

User name @1 could not be used for SQL role

-901

336068802

dyn_dup_sql_role

SQL role @1 already exists

-901

336068803

dyn_kywd_spec_for_role

Keyword @1 can not be used as a SQL role name

-901

336068804

dyn_roles_not_supported

SQL roles are not supported in on older versions of the database. A backup and restore of the database is required

-901

336330952

gbak_missing_skipped_bytes

missing parameter for the number of bytes to be skipped

-901

336330953

gbak_inv_skipped_bytes

Expected number of bytes to be skipped, encountered “@1”

-901

336068820

dyn_zero_len_id

Zero length identifiers are not allowed

-901

336330965

gbak_err_restore_charset

Character set

-901

336330967

gbak_err_restore_collation

Collation

-901

336330972

gbak_read_error

Unexpected I/O error while reading from backup file

-901

336330973

gbak_write_error

Unexpected I/O error while writing to backup file

-901

336068840

dyn_wrong_gtt_scope

@1 cannot reference @2

-901

336330985

gbak_db_in_use

Could not drop database @1 (database might be in use)

-901

336330990

gbak_sysmemex

System memory exhausted

-901

335544559

bad_svc_handle

Invalid service handle

-901

335544561

wrospbver

Wrong version of service parameter block

-901

335544562

bad_spb_form

Unrecognized service parameter block

-901

335544563

svcnotdef

Service @1 is not defined

-901

336068856

dyn_ods_not_supp_feature

Feature ‘@1’ is not supported in ODS @2.@3

-901

336331002

gbak_restore_role_failed

SQL role

-901

336331005

gbak_role_op_missing

SQL role parameter missing

-901

336331010

gbak_page_buffers_missing

Page buffers parameter missing

-901

336331011

gbak_page_buffers_wrong_param

Expected page buffers, encountered “@1”

-901

336331012

gbak_page_buffers_restore

Page buffers is allowed only on restore or create

-901

336331014

gbak_inv_size

Size specification either missing or incorrect for file @1

-901

336331015

gbak_file_outof_sequence

File @1 out of sequence

-901

336331016

gbak_join_file_missing

Can’t join - one of the files missing

-901

336331017

gbak_stdin_not_supptd

standard input is not supported when using join operation

-901

336331018

gbak_stdout_not_supptd

Standard output is not supported when using split operation

-901

336331019

gbak_bkup_corrupt

Backup file @1 might be corrupt

-901

336331020

gbak_unk_db_file_spec

Database file specification missing

-901

336331021

gbak_hdr_write_failed

Can’t write a header record to file @1

-901

336331022

gbak_disk_space_ex

Free disk space exhausted

-901

336331023

gbak_size_lt_min

File size given (@1) is less than minimum allowed (@2)

-901

336331025

gbak_svc_name_missing

Service name parameter missing

-901

336331026

gbak_not_ownr

Cannot restore over current database, must be SYSDBA or owner of the existing database

-901

336331031

gbak_mode_req

“read_only” or “read_write” required

-901

336331033

gbak_just_data

Just data ignore all constraints etc.

-901

336331034

gbak_data_only

Restoring data only ignoring foreign key, unique, not null & other constraints

-901

335544609

index_name

INDEX @1

-901

335544610

exception_name

EXCEPTION @1

-901

335544611

field_name

COLUMN @1

-901

335544613

union_err

Union not supported

Table 188. SQLCODE and GDSCODE Error Codes and Message Texts (4)
SQL­CODEGDSCODESymbolMessage Text

-901

335544614

dsqlconstruct_err

Unsupported DSQL construct

-901

335544623

dsql_domain_err

Illegal use of keyword VALUE

-901

335544626

table_name

TABLE @1

-901

335544627

proc_name

PROCEDURE @1

-901

335544641

dsql_domain_not_found

Specified domain or source column @1 does not exist

-901

335544656

dsql_var_conflict

Variable @1 conflicts with parameter in same procedure

-901

335544666

srvr_version_too_old

Server version too old to support all CREATE DATABASE options

-901

335544673

no_delete

Cannot delete

-901

335544675

sort_err

Sort error

-901

335544703

svcnoexe

Service @1 does not have an associated executable

-901

335544704

net_lookup_err

Failed to locate host machine

-901

335544705

service_unknown

Undefined service @1/@2

-901

335544706

host_unknown

The specified name was not found in the hosts file or Domain Name Services

-901

335544711

unprepared_stmt

Attempt to execute an unprepared dynamic SQL statement

-901

335544716

svc_in_use

Service is currently busy: @1

-901

335544731

tra_must_sweep

[no associated message]

-901

335544740

udf_exception

A fatal exception occurred during the execution of a user defined function

-901

335544741

lost_db_connection

Connection lost to database

-901

335544742

no_write_user_priv

User cannot write to RDB$USER_PRIVILEGES

-901

335544767

blob_filter_exception

A fatal exception occurred during the execution of a blob filter

-901

335544768

exception_access_violation

Access violation.The code attempted to access a virtual address without privilege to do so

-901

335544769

exception_datatype_missalignment

Datatype misalignment. The attempted to read or write a value that was not stored on a memory boundary

-901

335544770

exception_array_bounds_exceeded

Array bounds exceeded. The code attempted to access an array element that is out of bounds.

-901

335544771

exception_float_denormal operand

Float denormal operand. One of the floating-point operands is too small to represent a standard float value.

-901

335544772

exception_float_divide_by_zero

Floating-point divide by zero. The code attempted to divide a floating-point value by zero.

-901

335544773

exception_float_inexact_result

Floating-point inexact result. The result of a floating-point operation cannot be represented as a decimal fraction

-901

335544774

exception _float_invalid_operand

Floating-point invalid operand. An indeterminant error occurred during a floating-point operation

-901

335544775

exception_float_overflow

Floating-point overflow. The exponent of a floating-point operation is greater than the magnitude allowed

-901

335544776

exception_float_stack_check

Floating-point stack check. The stack overflowed or underflowed as the result of a floating-point operation

-901

335544777

exception_float_underflow

Floating-point underflow. The exponent of a floating-point operation is less than the magnitude allowed

-901

335544778

exception_integer_divide_by_zero

Integer divide by zero. The code attempted to divide an integer value by an integer divisor of zero

-901

335544779

exception_integer_overflow

Integer overflow. The result of an integer operation caused the most significant bit of the result to carry

-901

335544780

exception_unknown

An exception occurred that does not have a description.Exception number @1

-901

335544781

exception_stack_overflow

Stack overflow. The resource requirements of the runtime stack have exceeded the memory available to it

-901

335544782

exception_sigsegv

Segmentation Fault. The code attempted to access memory without privileges

-901

335544783

exception_sigill

Illegal Instruction. The Code attempted to perfrom an illegal operation

-901

335544784

exception_sigbus

Bus Error. The Code caused a system bus error

-901

335544785

exception_sigfpe

Floating Point Error. The Code caused an Arithmetic Exception or a floating point exception

-901

335544786

ext_file_delete

Cannot delete rows from external files

-901

335544787

ext_file_modify

Cannot update rows in external files

-901

335544788

adm_task_denied

Unable to perform operation. You must be either SYSDBA or owner of the database

-901

335544794

cancelled

Operation was cancelled

-901

335544797

svcnouser

User name and password are required while attaching to the services manager

-901

335544801

datype_notsup

Data type not supported for arithmetic

-901

335544803

dialect_not_changed

Database dialect not changed

-901

335544804

database_create_failed

Unable to create database @1

-901

335544805

inv_dialect_specified

Database dialect @1 is not a valid dialect

-901

335544806

valid_db_dialects

Valid database dialects are @1

-901

335544811

inv_client_dialect_specified

Passed client dialect @1 is not a valid dialect

-901

335544812

valid_client_dialects

Valid client dialects are @1

-901

335544814

service_not_supported

Services functionality will be supported in a later version of the product

-901

335544820

invalid_savepoint

Unable to find savepoint with name @1 in transaction context

-901

335544835

bad_shutdown_mode

Target shutdown mode is invalid for database “@1”

-901

335544840

no_update

Cannot update

-901

335544842

stack_trace

@1

-901

335544843

ctx_var_not_found

Context variable @1 is not found in namespace @2

-901

335544844

ctx_namespace_invalid

Invalid namespace name @1 passed to @2

-901

335544845

ctx_too_big

Too many context variables

-901

335544846

ctx_bad_argument

Invalid argument passed to @1

-901

335544847

identifier_too_long

BLR syntax error. Identifier @1…​ is too long

-901

335544859

invalid_time_precision

Time precision exceeds allowed range (0-@1)

-901

335544866

met_wrong_gtt_scope

@1 cannot depend on @2

-901

335544868

illegal_prc_type

Procedure @1 is not selectable (it does not contain a SUSPEND statement)

-901

335544869

invalid_sort_datatype

Datatype @1 is not supported for sorting operation

-901

335544870

collation_name

COLLATION @1

-901

335544871

domain_name

DOMAIN @1

-901

335544874

max_db_per_trans_allowed

A multi database transaction cannot span more than @1 databases

-901

335544876

bad_proc_BLR

Error while parsing procedure @1’ s BLR

-901

335544877

key_too_big

Index key too big

-901

336397211

dsql_too_many_values

Too many values (more than @1) in member list to match against

-901

336397236

dsql_unsupp_feature_dialect

Feature is not supported in dialect @1

-902

335544333

bug_check

Internal gds software consistency check (@1)

-902

335544335

db_corrupt

Database file appears corrupt (@1)

-902

335544344

io_error

I/O error for file “@2”

-902

335544346

metadata_corrupt

Corrupt system table

-902

335544373

sys_request

Operating system directive @1 failed

-902

335544384

badblk

Internal error

-902

335544385

invpoolcl

Internal error

-902

335544387

relbadblk

Internal error

-902

335544388

blktoobig

Block size exceeds implementation restriction

-902

335544394

badodsver

Incompatible version of on-disk structure

-902

335544397

dirtypage

Internal error

-902

335544398

waifortra

Internal error

-902

335544399

doubleloc

Internal error

-902

335544400

nodnotfnd

Internal error

-902

335544401

dupnodfnd

Internal error

-902

335544402

locnotmar

Internal error

-902

335544404

corrupt

Database corrupted

-902

335544405

badpage

Checksum error on database page @1

-902

335544406

badindex

Index is broken

-902

335544409

trareqmis

Transaction - request mismatch ( synchronization error )

-902

335544410

badhndcnt

Bad handle count

-902

335544411

wrotpbver

Wrong version of transaction parameter block

-902

335544412

wroblrver

Unsupported BLR version (expected @1, encountered @2)

-902

335544413

wrodpbver

Wrong version of database parameter block

-902

335544415

badrelation

Database corrupted

-902

335544416

nodetach

Internal error

-902

335544417

notremote

Internal error

-902

335544422

dbfile

Internal error

-902

335544423

orphan

Internal error

-902

335544432

lockmanerr

Lock manager error

-902

335544436

sqlerr

SQL error code = @1

-902

335544448

bad_sec_info

[no associated message]

-902

335544449

invalid_sec_info

[no associated message]

-902

335544470

buf_invalid

Cache buffer for page @1 invalid

-902

335544471

indexnotdefined

There is no index in table @1 with id @2

-902

335544472

login

Your user name and password are not defined. Ask your database administrator to set up a Firebird login

-902

335544506

shutinprog

Database @1 shutdown in progress

-902

335544528

shutdown

Database @1 shutdown

-902

335544557

shutfail

Database shutdown unsuccessful

-902

335544569

dsql_error

Dynamic SQL Error

-902

335544653

psw_attach

Cannot attach to password database

-902

335544654

psw_start_trans

Cannot start transaction for password database

-902

335544717

err_stack_limit

Stack size insufficent to execute current request

-902

335544721

network_error

Unable to complete network request to host “@1”

-902

335544722

net_connect_err

Failed to establish a connection

-902

335544723

net_connect_listen_err

Error while listening for an incoming connection

-902

335544724

net_event_connect_err

Failed to establish a secondary connection for event processing

-902

335544725

net_event_listen_err

Error while listening for an incoming event connection request

-902

335544726

net_read_err

Error reading data from the connection

-902

335544727

net_write_err

Error writing data to the connection

-902

335544732

unsupported_network_drive

Access to databases on file servers is not supported

-902

335544733

io_create_err

Error while trying to create file

-902

335544734

io_open_err

Error while trying to open file

-902

335544735

io_close_err

Error while trying to close file

-902

335544736

io_read_err

Error while trying to read from file

-902

335544737

io_write_err

Error while trying to write to file

-902

335544738

io_delete_err

Error while trying to delete file

-902

335544739

io_access_err

Error while trying to access file

-902

335544745

login_same_as_role_name

Your login @1 is same as one of the SQL role name. Ask your database administrator to set up a valid Firebird login.

-902

335544791

file_in_use

The file @1 is currently in use by another process.Try again later

-902

335544795

unexp_spb_form

Unexpected item in service parameter block, expected @1

-902

335544809

extern_func_dir_error

Function @1 is in @2, which is not in a permitted directory for external functions

-902

335544819

io_32bit_exceeded_err

File exceeded maximum size of 2GB. Add another database file or use a 64 bit I/O version of Firebird

-902

335544831

conf_access_denied

Access to @1 “@2” is denied by server administrator

-902

335544834

cursor_not_open

Cursor is not open

-902

335544841

cursor_already_open

Cursor is already open

-902

335544856

att_shutdown

Connection shutdown

-902

335544882

long_login

Login name too long (@1 characters, maximum allowed @2)

-904

335544324

bad_db_handle

Invalid database handle (no active connection)

-904

335544375

unavailable

Unavailable database

-904

335544381

imp_exc

Implementation limit exceeded

-904

335544386

nopoolids

Too many requests

-904

335544389

bufexh

Buffer exhausted

-904

335544391

bufinuse

Buffer in use

-904

335544393

reqinuse

Request in use

-904

335544424

no_lock_mgr

No lock manager available

-904

335544430

virmemexh

Unable to allocate memory from operating system

-904

335544451

update_conflict

Update conflicts with concurrent update

-904

335544453

obj_in_use

Object @1 is in use

-904

335544455

shadow_accessed

Cannot attach active shadow file

-904

335544460

shadow_missing

A file in manual shadow @1 is unavailable

-904

335544661

index_root_page_full

Cannot add index, index root page is full

-904

335544676

sort_mem_err

Sort error: not enough memory

-904

335544683

req_depth_exceeded

Request depth exceeded. (Recursive definition?)

-904

335544758

sort_rec_size_err

Sort record size of @1 bytes is too big ????

-904

335544761

too_many_handles

Too many open handles to database

-904

335544792

service_att_err

Cannot attach to services manager

-904

335544799

svc_name_missing

The service name was not specified

-904

335544813

optimizer_between_err

Unsupported field type specified in BETWEEN predicate

-904

335544827

exec_sql_invalid_arg

Invalid argument in EXECUTE STATEMENT-cannot convert to string

-904

335544828

exec_sql_invalid_req

Wrong request type in EXECUTE STATEMENT ‘@1’

-904

335544829

exec_sql_invalid_var

Variable type (position @1) in EXECUTE STATEMENT ‘@2’ INTO does not match returned column type

-904

335544830

exec_sql_max_call_exceeded

Too many recursion levels of EXECUTE STATEMENT

-904

335544832

wrong_backup_state

Cannot change difference file name while database is in backup mode

-904

335544852

partner_idx_incompat_type

Partner index segment no @1 has incompatible data type

-904

335544857

blobtoobig

Maximum BLOB size exceeded

-904

335544862

record_lock_not_supp

Stream does not support record locking

-904

335544863

partner_idx_not_found

Cannot create foreign key constraint @1. Partner index does not exist or is inactive

-904

335544864

tra_num_exc

Transactions count exceeded. Perform backup and restore to make database operable again

-904

335544865

field_disappeared

Column has been unexpectedly deleted

-904

335544878

concurrent_transaction

Concurrent transaction number is @1

-906

335544744

max_att_exceeded

Maximum user count exceeded.Contact your database administrator

-909

335544667

drdb_completed_with_errs

Drop database completed with errors

-911

335544459

rec_in_limbo

Record from transaction @1 is stuck in limbo

-913

335544336

deadlock

Deadlock

-922

335544323

bad_db_format

File @1 is not a valid database

-923

335544421

connect_reject

Connection rejected by remote interface

-923

335544461

cant_validate

Secondary server attachments cannot validate databases

-923

335544464

cant_start_logging

Secondary server attachments cannot start logging

-924

335544325

bad_dpb_content

Bad parameters on attach or create database

-924

335544441

bad_detach

Database detach completed with errors

-924

335544648

conn_lost

Connection lost to pipe server

-926

335544447

no_rollback

No rollback performed

-999

335544689

ib_error

Firebird error