The Firebird SQLCODE
error codes do not correlate with the standards-compliant 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.
This table provides the error codes and message texts for the 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).
SQLSTATE | Mapped 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 | GDSCODE | Symbol | Message 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 | 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” |
SQLCODE | GDSCODE | Symbol | Message 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 |
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 |