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

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

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

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

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

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

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

8 Are forinternal use only-205335544396fldnotdefColumn @1 is not defined in table @2-205335544552grant_fld_notfoundCould not find column for GRANT-205335544883fldnotdef2 Column @1 is not defined in procedure @2-206335544578dsql_field_errColumn unknown-206335544587dsql_blob_errColumn is not a BLOB-206335544596dsql_subselect_errSubse lect illegal in this context-206336397208dsql_line_col_errorA t line @1, column @2-206336397209dsql_unknown_posAt unknown line and column-206336397210dsql_no_dup_nameColum n @1 cannot be repeated in @2 statementFirebird Error Codes -208335544617order_by_errInvalid ORDER BY clause-219335544395relnotdefTable @1 is not defined-219335544872domnotdefDomain @1 is not defined-230335544487walw_errWAL Writer Error -231335544488logh_smallLog file header of @1 too small-232335544489logh_inv_versionInvali d version of log file @1-233335544490logh_open_flagLog file @1 not latest in the chain but open flagstill set-234335544491logh_open_flag2 Log file @1 not closed properly.

9 Databaserecovery may be required-235335544492logh_diff_dbnameDat abase name in the log file @1 is different-236335544493logf_unexpected_eo fUnexpected end of log file @1 at offset @2-237335544494logr_incompleteIncomplete log record at offset @1 in log file @2-238335544495logr_header_smallLog record header too small at offset @1 in logfile @2-239335544496logb_smallLog block too small at offset @1 in log file @2-239335544691cache_too_smallInsufficie nt memory to allocate page buffer cache-239335544693log_too_smallLog size too small-239335544694partition_too_smallLog partition size too small-243335544500no_walDatabase does not use Write-ahead Log-257335544566start_cm_for_walWAL defined; Cache Manager must be startedfirst-260335544690cache_redefCach e redefined-260335544692log_redefLog redefined-261335544695partition_not_supp Partitions not supported in series of log filespecification-261335544696log_length _specTotal length of a partitioned log must be specified-281335544637no_stream_planTabl e @1 is not referenced in plan-282335544638stream_twiceTable @1 is referenced more than once in plan;use aliases to distinguish-282335544643dsql_self_joinTh e table @1 is referenced twice; use aliases todifferentiate-282335544659duplicate_ba se_tableTable @1 is referenced twice in view; use an aliasFirebird Error Codesto distinguish-282335544660view_aliasView @1 has more than one base table.

10 Usealiases to distinguish-282335544710complex_viewNavi gational stream @1 references a view withmore than one base table-283335544639stream_not_foundTable @1 is referenced in the plan but not thefrom list-284335544642index_unusedIndex @1 cannot be used in the specified plan-291335544531primary_key_notnullColu mn used in a PRIMARY constraint must beNOT update constraints(RDB$REF_CONSTRAINTS).-293335 544535check_cnstrnt_updateCannot update constraints(RDB$CHECK_CONSTRAINTS).-2943 35544536check_cnstrnt_delCannot delete CHECK constraint entry(RDB$CHECK_CONSTRAINTS)-29533554454 5rel_cnstrnt_updateCannot update constraints(RDB$RELATION_CONSTRAINTS).-2 96335544547invld_cnstrnt_typeInternal gds software consistency check (invalidRDB$CONSTRAINT_TYPE)-29733554455 8check_constraintOperation violates CHECK constraint @1 onview or table @2-313336003099upd_ins_doesnt_match_pkUP DATE OR INSERT field list does not matchprimary key of table @1-313336003100upd_ins_doesnt_match_matc hingUPDATE OR INSERT fi