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

2 Securitydatabase-85335544753usrname_not_ foundThe user name specified was not found in thesecurity database-85335544754error_adding_sec_rec ordAn Error occurred while 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.

5 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)-104335544826dsql_agg_nested_errN ested 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)

6 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 : 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 .

7 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) 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)

8 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 @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

9 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)-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

10 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 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-204335544636i