Firebird 2.1 Error Codes

1 Firebird Error CodesFirebird Error CodesSQLCODEGDSCODESYMBOLTEXT10133554436 6segmentSegment buffer length shorter than expected101335544366segmentSegment buffer length shorter than expected100335544338from_no_matchNo match for first value expression100335544354no_recordInvalid database key100335544367segstr_eofAttempted retrieval of more segments than exist100335544374stream_eofAttempt to fetch past the last record in a recordstream0335741039gfix_opt_SQL_diale ct-sql_dialectset database dialect n0335544875bad_debug_formatBad debug info format-84335544554nonsql_security_relTab le/procedure has non-SQL security classdefined-84335544555nonsql_security_ fldColumn has non-SQL security class defined-84335544668dsql_procedure_use_er rProcedure @1 does not return any values-85335544747usrname_too_longThe username entered is too is 31 password specified is too is 8 username is required for this password is required for this operation-85335544751bad_protocolThe network protocol specified is invalid-85335544752dup_usrname_foundA duplicate user name was found in the securitydatabase-85335544753usrname_not_ foundThe user name specified was not found in thesecurity database-85335544754error_adding_sec_rec ordAn Error occurred while

2 Attempting to add Error occurred while attempting to modify theuser Error occurred while attempting to delete theuser Error occurred while updating the securityFirebird Error type for constant unknown-104336003075dsql_transitional_nu mericPrecision 10 to 18 changed from DOUBLEPRECISION in SQL dialect 1 to 64-bit scaledinteger in SQL dialect 3-104336003077sql_db_dialect_dtype_unsup portDatabase SQL dialect @1 does not supportreference to @2 datatype-104336003087dsql_invalid_labelL abel @1 @2 in the current scope-104336003088dsql_datatypes_not_com parableDatatypes @1are not comparable in expression@2-104335544343invalid_blrInva lid request BLR at offset @1-104335544390syntaxerrBLR syntax Error .

3 Expected @1 at offset @2,encountered @3-104335544425ctxinuseContext already in use (BLR Error )-104335544426ctxnotdefContext not defined (BLR Error )-104335544429badparnumBad parameter number-104335544440bad_msg_vec-104335544 456invalid_sdlInvalid slice description language at offset @1-104335544570dsql_command_errInvalid command-104335544579dsql_internal_errInt ernal Error -104335544590dsql_dup_optionOption specified more than once-104335544591dsql_tran_errUnknown transaction option-104335544592dsql_invalid_arrayInv alid array reference-104335544608command_end_errUne xpected end of command-104335544612token_errToken unknown-104335544634dsql_token_unk_errTo ken unknown- line @1.

4 Column @2-104335544709dsql_agg_ref_errInvalid aggregate reference-104335544714invalid_array_idIn valid blob id-104335544730cse_not_supportedClient/S erver Express not supported in this release-104335544743token_too_longToken size exceeds limit-104335544763invalid_string_constan tA string constant is delimited by double quotes-104335544764transitional_dateDATE must be changed to TIMESTAMPF irebird Error Codes -104335544796sql_dialect_datatype_u nsupportClient SQL dialect @1 does not support referenceto @2 datatype-104335544798depend_on_uncommitt ed_relYou created an indirect dependency onuncommitted metadata. You must roll back thecurrent column position used in the @1 clause-104335544822dsql_agg_where_errCan not use an aggregate function in a WHERE clause, use HAVING instead-104335544823dsql_agg_group_errCa nnot use an aggregate function in a GROUPBY clause-104335544824dsql_agg_column_errIn valid expression in the @1 (not contained ineither an aggregate function or the GROUP BYclause)-104335544825dsql_agg_having_er rInvalid expression in the @1 (neither an aggregatefunction nor a part of the GROUP BY clause)

5 -104335544826dsql_agg_nested_errNested aggregate functions are not allowed-104335544849malformed_stringMalf ormed string-104335544851command_end_err2 Unexpected end of command- line @1, column@2-104336397215dsql_max_sort_items Cannot sort on more than 255 items-104336397216dsql_max_group_itemsCa nnot group on more than 255 items-104336397217dsql_conflicting_sort_ fieldCannot include the same field @2) twice inthe ORDER BY clause with conflicting sortingoptions-104336397218dsql_derived_ table_more_columnsColumn list from derived table @1 has morecolumns than the number of items in its SELECT statement-104336397219dsql_derived_table _less_columnsColumn list from derived table @1 has lesscolumns than the number of items in its SELECT statement-104336397220dsql_derived_field _unnamedNo column name specified for column number@1 in derived table @2-104336397221dsql_derived_field_dup_na meColumn @1 was specified multiple times forderived table @2-104336397222dsql_derived_alias_select Internal dsql Error .

6 Alias type expected bypass1_expand_select_node-104336397223d sql_derived_alias_fieldInternal dsql Error : alias type expected bypass1_field-104336397224dsql_auto_fiel d_bad_posInternal dsql Error : column position out of rangeFirebird Error Codesin pass1_union_auto_cast-104336397225dsql_c te_wrong_referenceRecursive CTE member (@1) can refer itself onlyin FROM clause-104336397226dsql_cte_cycleCTE '@1' has cyclic dependencies-104336397227dsql_cte_outer_ joinRecursive member of CTE can't be member of anouter join-104336397228dsql_cte_mult_reference sRecursive member of CTE can't reference itselfmore than once-104336397229dsql_cte_not_a_unionRec ursive CTE (@1)

7 Must be an UNION-104336397230dsql_cte_nonrecurs_aft er_recursCTE '@1' defined non-recursive member afterrecursive-104336397231dsql_cte_wron g_clauseRecursive member of CTE '@1' has @2 clause-104336397232dsql_cte_union_allRec ursive members of CTE (@1) must be linkedwith another members via UNION ALL-104336397233dsql_cte_miss_nonrecursi veNon-recursive member is missing in CTE '@1'-104336397234dsql_cte_nested_withWIT H clause can't be nested-104336397235dsql_col_more_than_on ce_usingColumn @1 appears more than once in USING clause-104336397237dsql_cte_not_usedCTE "@1" is not used in query-105335544702like_escape_invalidInv alid ESCAPE sequence-105335544789extract_input_misma tchSpecified EXTRACT part does not exist in inputdatatype-150335544360read_only_relA ttempted update of read-only table-150335544362read_only_viewCannot update read-only view

8 @1-150335544446non_updatableNot updatable-150335544546constaint_on_viewC annot define constraints on views-151335544359read_only_fieldAttempt ed update of read-only column-155335544658dsql_base_table@1 is not a valid base table of the specified view-157335544598specify_field_errMust specify column name for view selectexpression-158335544599num_field_e rrNumber of columns does not match select list-162335544685no_dbkeyDbkey not available for multi-table views-170335544512prcmismatInput parameter mismatch for procedure @1-170335544619extern_func_err External functions cannot have more than 10 Firebird Error Codesparameters-170335544850prc_out_para m_mismatchOutput parameter mismatch for procedure @1-171335544439funmismatFunction @1 could not be matched-171335544458invalid_dimensionCol umn not array or invalid dimensions (expected@1, encountered @2)

9 -171335544618return_mode_errReturn mode by value not allowed for this datatype-171335544873array_max_dimension sArray data type can use up to @1 dimensions-172335544438funnotdefFunction @1 is not defined-203335544708dyn_fld_ambiguousAmb iguous column field name between @1 and @2-204335544463gennotdefGenerator @1 is not defined-204335544502stream_not_definedRe ference to invalid stream number-204335544509charset_not_foundCHAR ACTER SET @1 is not defined-204335544511prcnotdefProcedure @1 is not defined-204335544515codnotdefStatus code @1 unknown-204335544516xcpnotdefException @1 not defined-204335544532ref_cnstrnt_notfound Name of Referential Constraint not defined inconstraints not find table/procedure for GRANT-204335544568text_subtypeImplementa tion of text subtype @1 not type unknown-204335544580dsql_relation_errTab le unknown-204335544581dsql_procedure_errPr ocedure unknown-204335544588collation_not_foundC OLLATION @1 for CHARACTER SET @2 isnot defined-204335544589collation_not_for_ch arsetCOLLATION @1 is not valid for specifiedCHARACTER SET-204335544595dsql_trigger_errTrigger unknown-204335544620alias_conflict_errAl ias @1 conflicts with an alias in the

10 Samestatement-204335544621procedure_conf lict_errorAlias @1 conflicts with a procedure in the samestatementFirebird Error Codes -204335544622relation_conflict_errA lias @1 conflicts with a table in the samestatement-204335544635dsql_no_relati on_aliasThere is no alias or table named @1 at this scopelevel-204335544636indexnameThere is no index @1 for table @2-204335544640collation_requires_textIn valid use of CHARACTER SET or COLLATE-204335544662dsql_blob_type_unkno wnBLOB SUB_TYPE @1 is not defined-204335544759bad_default_valueCan not define a not null column with NULL asdefault value-204335544760invalid_clauseInvalid clause--- '@1'-204335544800too_many_contextsToo many Contexts of Relation/ allowed is 255-204335544817bad_limit_paramInvalid parameter to integers >= 0are parameter to integers >= 0 offset parameter @1 to positive integers are length parameter @1 to integers are not SET @1 is not installed-204335544855collation_not_inst alledCOLLATION @1 for CHARACTER SET @2 isnot installed-204335544867subtype_for_intern al_useBlob sub_types bigger than 1 (text) are forinternal use only-2