| Firebird 2.5 Language Reference → Firebird 2.5 Language Reference → Exception Codes and Messages → 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.
![[Note]](file:/C:/Program%20Files/Oxygen%20XML%20Editor%2016/frameworks/docbook/css/img/note.png) |
Note |
|---|---|
|
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 B.2. SQLCODE and GDSCODE Error Codes and Message Texts (1)
| SQLCODE | GDSCODE | Symbol | Message Text |
|---|---|---|---|
| 101 | 335544366 | Segment | Segment buffer length shorter than expected |
| 100 | 335544338 | from_no_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 morethan 10 parametrs |
| -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 B.3. SQLCODE and GDSCODE Error Codes and Message Texts (2)
| SQLCODE | GDSCODE | Symbol | Message 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 B.4. SQLCODE and GDSCODE Error Codes and Message Texts (3)
| SQLCODE | GDSCODE | Symbol | Message Text |
|---|---|---|---|
| -901 | 335544329 | bad_segstr_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_$blob_info 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_$get_segment 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_$close_blob failed |
| -901 | 335740951 | gfix_retry_db | Please retry, giving a database name |
| -901 | 336330776 | gbak_open_blob_failed | Gds_$open_blob 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_$compile_request failed |
| -901 | 336330780 | gbak_start_req_failed | Gds_$start_request failed |
| -901 | 336723996 | gsec_err_find_disp | Find / display record error |
| -901 | 336330781 | gbak_rec_failed | gds_$receive failed |
| -901 | 336920605 | gstat_open_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_$release_request failed |
| -901 | 336723998 | gsec_op_specified | Operation already specified |
| -901 | 336920607 | gstat_sysmemex | System memory exhausted |
| -901 | 336330783 | gbak_db_info_failed | gds_$database_info 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_$create_blob 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_$put_segment 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 B.5. SQLCODE and GDSCODE Error Codes and Message Texts (4)
| SQLCODE | GDSCODE | Symbol | Message Text |
|---|---|---|---|
| -901 | 335544614 | dsql_construct_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 |
|
| Firebird 2.5 Language Reference → Firebird 2.5 Language Reference → Exception Codes and Messages → SQLCODE and GDSCODE Error Codes and Descriptions |