Содержание
- SQL error code = -206 [CORE4197] #4522
- Comments
- Inserting data after update results in «Column unknown» or «Must declare the variable ‘@px’ errors [DNET945] #866
- Comments
SQL error code = -206 [CORE4197] #4522
Submitted by: Márson de Paula (marsonluis)
I’m trying to insert a record but the error occurs:
can’t format message 13:794 — message file C:Windowsfirebird.msg not found.
Dynamic SQL Error.
SQL error code = -206.
Column unknown.
VCST.
At line 1, column 108.
insert into MOVESTOQUE (CDLOJA, CDPOS, CDPRODUTO, CDHISTORICO, FLGMOVIMENTO, QUANTIDADE, DATA, HORA, QTDEANTERIOR,
QTDEATUAL, NRDOCUMENTO, VLRCUSTOCIMP, CDFORNCLI, LJFORNECEDOR, VLRCUSTMEDCIMP, VLRCUSTMEDCONT,
VLRCONTABIL, VLRSUGERIDO, SEQUENCIA)
values (77, 9, 8994, 15, ‘E’, -1, ‘28.08.2013’, ’15:09:00′, -3,- 3, ‘VCST’,1.1449996948, 0, 0, 7.8600001335144,
7.61999988555908, 8.18000030517578, 12.2700004577637, 3)
And, this the table’s DDL:
CREATE GENERATOR GEN_MOVESTOQUE;
CREATE TABLE MOVESTOQUE (
CDPOS INTEGER NOT NULL,
CDMOVIMENTO INTEGER NOT NULL,
CDLOJA INTEGER NOT NULL,
CDPRODUTO INTEGER,
CDHISTORICO INTEGER DEFAULT 0,
DATA TIMESTAMP,
HORA VARCHAR(8),
QUANTIDADE FLOAT DEFAULT 0,
FLGMOVIMENTO VARCHAR(1),
QTDEANTERIOR FLOAT,
QTDEATUAL FLOAT,
CDFORNCLI CODIGO /* CODIGO = INTEGER */,
NRDOCUMENTO VARCHAR(20),
VLRCUSTOCIMP VALOR /* VALOR = DECIMAL(18,2) */,
VLRCUSTMEDCIMP VALOR /* VALOR = DECIMAL(18,2) */,
LJFORNECEDOR CODIGO /* CODIGO = INTEGER */,
VLRCUSTMEDUNIT VALOR /* VALOR = DECIMAL(18,2) */,
VLRCUSTMEDCONT VALOR /* VALOR = DECIMAL(18,2) */,
FLGESTORNADO FLAG /* FLAG = VARCHAR(1) */,
VLRCONTABIL VALOR /* VALOR = DECIMAL(18,2) */,
VLRSUGERIDO VALOR /* VALOR = DECIMAL(18,2) */,
FLGALTERADO FLAG /* FLAG = VARCHAR(1) */,
FLGSIST FLAG /* FLAG = VARCHAR(1) */,
MD5 VARCHAR(40),
SEQUENCIA CODIGO /* CODIGO = INTEGER */
);
ALTER TABLE MOVESTOQUE ADD PRIMARY KEY (CDMOVIMENTO, CDPOS, CDLOJA);
ALTER TABLE MOVESTOQUE ADD FOREIGN KEY (CDPRODUTO) REFERENCES PRODUTOS (CDPRODUTO);
ALTER TABLE MOVESTOQUE ADD FOREIGN KEY (CDPOS, CDLOJA) REFERENCES POS (CDPOS, CDLOJA);
ALTER TABLE MOVESTOQUE ADD FOREIGN KEY (CDHISTORICO) REFERENCES HISTORICOS (CDHISTORICO);
CREATE INDEX XIE1MOVESTOQUE ON MOVESTOQUE (CDLOJA);
CREATE INDEX XIE2MOVESTOQUE ON MOVESTOQUE (DATA);
CREATE INDEX XIE3MOVESTOQUE ON MOVESTOQUE (FLGMOVIMENTO);
CREATE INDEX XIE4MOVESTOQUE ON MOVESTOQUE (CDPRODUTO);
CREATE INDEX XIE5MOVESTOQUE ON MOVESTOQUE (NRDOCUMENTO);
CREATE INDEX XIE6MOVESTOQUE ON MOVESTOQUE (CDFORNCLI);
CREATE INDEX XIE7MOVESTOQUE ON MOVESTOQUE (CDHISTORICO);
CREATE INDEX XIE8MOVESTOQUE ON MOVESTOQUE (CDMOVIMENTO);
CREATE INDEX XIE9MOVESTOQUE ON MOVESTOQUE (CDFORNCLI, LJFORNECEDOR);
CREATE INDEX XIF90MOVESTOQUE ON MOVESTOQUE (CDPOS, CDLOJA);
CREATE INDEX XIF91MOVESTOQUE ON MOVESTOQUE (CDPRODUTO);
The text was updated successfully, but these errors were encountered:
Источник
Inserting data after update results in «Column unknown» or «Must declare the variable ‘@px’ errors [DNET945] #866
Submitted by: Jan Pross (jan)
Is duplicated by DNET974
I’ve created simple web application where you can reproduce the issue https://filebin.net/cpfsuoh16xdl28xi
Steps to reproduce:
1. Build and run the web app
2. Repeat the same request e.g. 50 times by using some tool (if the requests are generated by refreshing the browser, the issue will not occur)
2. a. Capture the request e.g. with fiddler
2. b. Repeat the request from fiddler 50 times
3. An error occurs:
3. a.
Dynamic SQL Error
SQL error code = -206
Column unknown
P0
At line 2, column 9
at FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteReader(CommandBehavior behavior)
at System.Data.Common.DbCommand.ExecuteDbDataReaderAsync(CommandBehavior behavior, CancellationToken cancellationToken)
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at Microsoft.EntityFrameworkCore.Storage.Internal.RelationalCommand. d__17.MoveNext()
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at Microsoft.EntityFrameworkCore.Update.ReaderModificationCommandBatch. d__32.MoveNext()
Must declare the variable ‘@p1’
at FirebirdSql.Data.FirebirdClient.FbCommand.UpdateParameterValues()
at FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteCommand(CommandBehavior behavior, Boolean returnsSet)
at FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteReader(CommandBehavior behavior)
at System.Data.Common.DbCommand.ExecuteDbDataReaderAsync(CommandBehavior behavior, CancellationToken cancellationToken)
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at Microsoft.EntityFrameworkCore.Storage.Internal.RelationalCommand. d__17.MoveNext()
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at Microsoft.EntityFrameworkCore.Update.ReaderModificationCommandBatch. d__32.MoveNext()
Names of the columns and parameters can be different each time. Some requests will pass successfully some will result in beforehand mentioned errors. When an error occurs any other following request will result in an error unless the whole server is restarted.
We encountered this issue after switching some other parts of our solution to firebird. We are using 7.1.1 driver and we can not update to 7.5.0 for now (as it depends on EF core >= 3.0).
The text was updated successfully, but these errors were encountered:
Given the 2.2 is already EOL (and my limited resources), I’ll investigate only if you’ll replicate this on 3.1 (and I think I fixed issue around this). Thanks for understanding.
status: Open [ 1 ] => In Progress [ 3 ]
Commented by: Jan Pross (jan)
We will be able to upgrade to ef core >= 3.1 in the end I suppose, so I modified the test project by upgrading the ef core dependency to 3.1.1 and firebird to 7.5.0. I run the test case (50 requests) and it passed without any problem. I tried it again (clean test, delete database file etc.) and I hit the same error.
Dynamic SQL Error
SQL error code = -206
Column unknown
P0
I forgot to mention, that we are using Firebird-3.0.5.33220_0_x64
Commented by: Mattias Wijkström (omwijk)
We have seen the exact same issue with our .NET Framework 4.8 desktop application using Firebird .NET Provider 7.5.0 and Entity Framework Core 3.1.3. We run Firebird 3.0.5 in Super server mode.
We have observed the errors with the following stacktraces:
Dynamic SQL Error
SQL error code = -206
Column unknown
P0
At line 2, column 9
Источник
Submitted by: Ukrtelecom (ukrtelecom)
WORK —
insert into stat_wtmp (bill_serv_id,
login,
domain_name,
calling_station_id,
called_station_id,
nas_ip_address,
framed_ip_address,
nas_port_id,
session_id,
connect_info,
time_begin,
session_active,
cur_input_octets,
cur_output_octets,
/* connect_info,*/
time_end
)
values(:CUR_BILL_SERVICE_ID,
:login,
:domain_name,
:caller_id,
:called_id,
:nas_ip_addr,
:user_ip_addr,
:nas_port_id,
:session_id,
:connect_info,
:packet_timestamp,
:cur_session_active,
:input_octets,
:output_octets,
/* :connect_info,*/
:packet_timestamp);
NOT WORK —
insert into stat_wtmp (bill_serv_id,
login,
domain_name,
calling_station_id,
called_station_id,
nas_ip_address,
framed_ip_address,
nas_port_id,
session_id,
connect_info,
time_begin,
session_active,
cur_input_octets,
cur_output_octets,
connect_info,
time_end
)
values(:CUR_BILL_SERVICE_ID,
:login,
:domain_name,
:caller_id,
:called_id,
:nas_ip_addr,
:user_ip_addr,
:nas_port_id,
:session_id,
:connect_info,
:packet_timestamp,
:cur_session_active,
:input_octets,
:output_octets,
:connect_info,
:packet_timestamp);
Dynamic SQL Error.
SQL error code = -206.
unknown ISC error 336397210.
unknown ISC error 336397208.
FIELD — connect_info;
TABLE STAT_WTMP:
CREATE TABLE STAT_WTMP (
ID_WTMP_ITEM ID /* ID = INTEGER DEFAULT 0 */,
BILL_SERV_ID ID /* ID = INTEGER DEFAULT 0 */,
NAS_IP_ADDRESS IPADDRESS /* IPADDRESS = VARCHAR(15) */,
NAS_PORT_ID BIGINTEGER /* BIGINTEGER = BIGINT */,
TIME_BEGIN ACCOUNT /* ACCOUNT = INTEGER */,
TIME_END ACCOUNT /* ACCOUNT = INTEGER */,
SESSION_TIME COUNTER /* COUNTER = INTEGER */,
CALLING_STATION_ID VARCHAR128 /* VARCHAR128 = VARCHAR(128) */,
CALLED_STATION_ID VARCHAR128 /* VARCHAR128 = VARCHAR(128) */,
FRAMED_IP_ADDRESS IPADDRESS /* IPADDRESS = VARCHAR(15) */,
SESSION_ID VARCHAR128 /* VARCHAR128 = VARCHAR(128) */,
INPUT_OCTETS BIGINTEGER DEFAULT 0 /* BIGINTEGER = BIGINT */,
CUR_INPUT_OCTETS BIGINTEGER DEFAULT 0 /* BIGINTEGER = BIGINT */,
OUTPUT_OCTETS BIGINTEGER DEFAULT 0 /* BIGINTEGER = BIGINT */,
CUR_OUTPUT_OCTETS BIGINTEGER DEFAULT 0 /* BIGINTEGER = BIGINT */,
CONNECT_INFO VARCHAR64 /* VARCHAR64 = VARCHAR(64) */,
LOGIN VARCHAR32 /* VARCHAR32 = VARCHAR(32) */,
DOMAIN_NAME VARCHAR64 /* VARCHAR64 = VARCHAR(64) */,
SESSION_ACTIVE TRUEFALSE DEFAULT 1 /* TRUEFALSE = INTEGER */,
DATE_WR DATETIME DEFAULT ‘now’ /* DATETIME = TIMESTAMP */,
SPEED_UP VARCHAR16 /* VARCHAR16 = VARCHAR(16) */,
SPEED_DOWN VARCHAR16 /* VARCHAR16 = VARCHAR(16) */
);
501
335544802
dialect_reset_warning
Database dialect being changed from 3 to 1
301
335544808
dtype_renamed
DATE data type is now called TIMESTAMP
301
336003076
dsql_dialect_warning_expr
Use of @1 expression that returns different results in dialect 1 and dialect 3
301
336003080
dsql_warning_number_ambiguous
WARNING: Numeric literal @1 is interpreted as a floating-point
301
336003081
dsql_warning_number_ambiguous1
value in SQL dialect 1, but as an exact numeric value in SQL dialect 3.
301
336003082
dsql_warn_precision_ambiguous
WARNING: NUMERIC and DECIMAL fields with precision 10 or greater are stored
301
336003083
dsql_warn_precision_ambiguous1
as approximate floating-point values in SQL dialect 1, but as 64-bit
301
336003084
dsql_warn_precision_ambiguous2
integers in SQL dialect 3.
300
335544807
sqlwarn
SQL warning code = @1
106
336068855
dyn_miss_priv_warning
Warning: @1 on @2 is not granted to @3.
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
0
335544875
bad_debug_format
Bad debug info format
0
335544931
montabexh
Monitoring table space exhausted
-84
335544554
nonsql_security_rel
object 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 8 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
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
undefined 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 or window function in a WHERE clause, use HAVING (for aggregate only) instead
-104
335544823
dsql_agg_group_err
Cannot use an aggregate or window 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 and window functions are not allowed
-104
335544849
malformed_string
Malformed string
-104
335544851
command_end_err2
Unexpected end of command — line @1, column @2
-104
335544930
too_big_blr
BLR stream length @1 exceeds implementation limit @2
-104
335544980
internal_rejected_params
Incorrect parameters provided to internal function @1
-104
335545022
cannot_copy_stmt
Cannot copy statement @1
-104
335545023
invalid_boolean_usage
Invalid usage of boolean expression
-104
335545035
svc_no_stdin
No isc_info_svc_stdin in user request, but service thread requested stdin data
-104
335545037
svc_no_switches
All services except for getting server log require switches
-104
335545038
svc_bad_size
Size of stdin data is more than was requested from client
-104
335545039
no_crypt_plugin
Crypt plugin @1 failed to load
-104
335545040
cp_name_too_long
Length of crypt plugin name should not exceed @1 bytes
-104
335545045
null_spb
NULL data with non-zero SPB length
-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
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 (@[email protected]) 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
-104
336397238
dsql_col_more_than_once_view
column @1 appears more than once in ALTER VIEW
-104
336397257
dsql_max_distinct_items
Cannot have more than 255 items in DISTINCT list
-104
336397321
dsql_cte_recursive_aggregate
Recursive member of CTE cannot use aggregate or window function
-104
336397326
dsql_wlock_simple
WITH LOCK can be used only with a single physical table
-104
336397327
dsql_firstskip_rows
FIRST/SKIP cannot be used with OFFSET/FETCH or ROWS
-104
336397328
dsql_wlock_aggregates
WITH LOCK cannot be used with aggregates
-104
336397329
dsql_wlock_conflict
WITH LOCK cannot be used with @1
-105
335544702
escape_invalid
Invalid ESCAPE sequence
-105
335544789
extract_input_mismatch
Specified EXTRACT part does not exist in input datatype
-105
335544884
invalid_similar_pattern
Invalid SIMILAR TO pattern
-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
-170
335545101
fun_param_mismatch
Input parameter mismatch for function @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
-172
335544932
modnotfound
module name or entrypoint could not be found
-203
335544708
dyn_fld_ambiguous
Ambiguous column reference.
-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 object 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 256
-204
335544817
bad_limit_param
Invalid parameter to FETCH or FIRST. Only integers >= 0 are allowed.
-204
335544818
bad_skip_param
Invalid parameter to OFFSET or 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
-204
335545104
invalid_attachment_charset
CHARACTER SET @1 cannot be used as a attachment character set
-204
336003085
dsql_ambiguous_field_name
Ambiguous field name between @1 and @2
-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_small
Log record header too small at offset @1 in log file @2
-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
-240
335544497
wal_illegal_attach
Illegal attempt to attach to an uninitialized WAL segment for @1
-241
335544498
wal_invalid_wpb
Invalid WAL parameter block option @1
-242
335544499
wal_err_rollover
Cannot roll over to the next log file @1
-243
335544500
no_wal
database does not use Write-ahead Log
-244
335544503
wal_subsys_error
WAL subsystem encountered error
-245
335544504
wal_subsys_corrupt
WAL subsystem corrupted
-246
335544513
wal_bugcheck
Database @1: WAL subsystem bug for pid @2
@3
-247
335544514
wal_cant_expand
Could not expand the WAL segment for database @1
-248
335544521
wal_err_rollover2
Unable to roll over please see Firebird log.
-249
335544522
wal_err_logwrite
WAL I/O error. Please see Firebird log.
-250
335544523
wal_err_jrn_comm
WAL writer — Journal server communication error. Please see Firebird log.
-251
335544524
wal_err_expansion
WAL buffers cannot be increased. Please see Firebird log.
-252
335544525
wal_err_setup
WAL setup error. Please see Firebird log.
-253
335544526
wal_err_ww_sync
obsolete
-254
335544527
wal_err_ww_start
Cannot start WAL writer for the database @1
-255
335544556
wal_cache_err
Write-ahead Log without shared cache configuration not allowed
-257
335544566
start_cm_for_wal
WAL defined; Cache Manager must be started first
-258
335544567
wal_ovflow_log_required
Overflow log specification required for round-robin log
-259
335544629
wal_shadow_err
Write-ahead Log with shadowing configuration not allowed
-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.
-291
335545103
domain_primary_key_notnull
Domain used in the PRIMARY KEY constraint of table @1 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 Firebird consistency check (invalid RDB$CONSTRAINT_TYPE)
-297
335544558
check_constraint
Operation violates CHECK constraint @1 on view or table @2
-313
335544669
dsql_count_mismatch
count of column list and variable list do not match
-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
336003111
dsql_wrong_param_num
Wrong number of parameters (expected @1, got @2)
-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
-406
335545028
ss_out_of_bounds
Subscript @1 out of bounds [@2, @3]
-407
335544435
nullsegkey
null segment of UNIQUE KEY
-413
335544334
convert_error
conversion error from string «@1»
-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
335544574
dsql_decl_err
Invalid cursor declaration
-502
335544576
dsql_cursor_open_err
Attempt to reopen an open 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
-504
335544572
dsql_cursor_err
Invalid cursor reference
-504
336003089
dsql_cursor_invalid
Empty cursor name is not allowed
-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 and cannot be committed
-532
335545002
attachment_in_use
Attachment is in use
-532
335545003
transaction_in_use
Transaction is in use
-532
335545017
async_active
Asynchronous call is already running for this attachment
-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.
-551
335545033
trunc_limits
expected length @1, actual @2
-551
335545034
info_access
Wrong info requested in isc_svc_query() for anonymous service
-551
335545036
svc_start_failed
Start request for anonymous service is impossible
-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
-552
335545058
protect_ownership
Only the owner can change the ownership
-553
335544529
existing_priv_mod
cannot modify an existing user privilege
-595
335544645
stream_crack
the current position is on a crack
-596
335544374
stream_eof
attempt to fetch past the last record in a record stream
-596
335544644
stream_bof
attempt to fetch before the first record in a record stream
-596
335545092
cursor_not_positioned
Cursor @1 is not positioned in a valid record
-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
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
Function @1
-607
335544858
must_have_phys_field
Can’t have relation with only computed fields or constraints
-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
336003104
dsql_record_version_table
To be used with RDB$RECORD_VERSION, @1 must be a table or a view of single table
-607
336068845
dyn_cannot_del_syscoll
Cannot delete system collation
-607
336068866
dyn_cannot_mod_sysproc
Cannot ALTER or DROP system procedure @1
-607
336068867
dyn_cannot_mod_systrig
Cannot ALTER or DROP system trigger @1
-607
336068868
dyn_cannot_mod_sysfunc
Cannot ALTER or DROP system function @1
-607
336068869
dyn_invalid_ddl_proc
Invalid DDL statement for procedure @1
-607
336068870
dyn_invalid_ddl_trig
Invalid DDL statement for trigger @1
-607
336068878
dyn_invalid_ddl_func
Invalid DDL statement for function @1
-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
335544501
drop_wal
cannot drop log file when journaling is enabled
-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
335544533
foreign_key_notfound
Non-existent PRIMARY or UNIQUE KEY specified for FOREIGN KEY.
-660
335544628
idx_create_err
cannot create index @1
-660
336003098
primary_key_required
Primary key required on table @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 32765 bytes in length.
-802
335544914
string_truncation
string right truncation
-802
335544915
blob_truncation
blob truncation when converting to a string: length limit exceeded
-802
335544916
numeric_out_of_range
numeric value is out of range
-802
336003105
dsql_invalid_sqlda_version
SQLDA version expected between @1 and @2, found @3
-802
336003106
dsql_sqlvar_index
at SQLVAR index @1
-802
336003107
dsql_no_sqlind
empty pointer to NULL indicator variable
-802
336003108
dsql_no_sqldata
empty pointer to data
-802
336003109
dsql_no_input_sqlda
No SQLDA for input values provided
-802
336003110
dsql_no_output_sqlda
No SQLDA for output values provided
-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
335544380
wronumarg
wrong number of arguments on call
-804
335544583
dsql_sqlda_err
SQLDA error
-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
335545050
wrong_message_length
Message length passed from user application does not match set of columns
-804
335545051
no_output_format
Resultset is missing output format information
-804
335545052
item_finish
Message metadata not ready — item @1 is not finished
-804
335545100
interface_version_too_old
Interface @3 version too old: expected @1, found @2
-804
336003097
dsql_feature_not_supported_ods
Feature not supported on ODS version older than @[email protected]
-804
336397205
dsql_too_old_ods
ODS versions before [email protected] 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
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
-817
336003079
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
-820
335544356
obsolete_metadata
metadata is obsolete
-820
335544379
wrong_ods
unsupported on-disk structure for file @1; found @[email protected], support @[email protected]
-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
335544616
field_ref_err
invalid column reference
-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
336068857
dyn_cannot_addrem_computed
Cannot add or remove COMPUTED from column @1
-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
-833
335544912
time_range_exceeded
value exceeds the range for a valid time
-833
335544913
datetime_range_exceeded
value exceeds the range for valid timestamps
-833
335544937
invalid_type_datetime_op
Invalid data type in DATE/TIME/TIMESTAMP addition or subtraction in add_datettime()
-833
335544938
onlycan_add_timetodate
Only a TIME value can be added to a DATE value
-833
335544939
onlycan_add_datetotime
Only a DATE value can be added to a TIME value
-833
335544940
onlycansub_tstampfromtstamp
TIMESTAMP values can be subtracted only from another TIMESTAMP value
-833
335544941
onlyoneop_mustbe_tstamp
Only one operand can be of type TIMESTAMP
-833
335544942
invalid_extractpart_time
Only HOUR, MINUTE, SECOND and MILLISECOND can be extracted from TIME values
-833
335544943
invalid_extractpart_date
HOUR, MINUTE, SECOND and MILLISECOND cannot be extracted from DATE values
-833
335544944
invalidarg_extract
Invalid argument for EXTRACT() not being of DATE/TIME/TIMESTAMP type
-833
335544945
sysf_argmustbe_exact
Arguments for @1 must be integral types or NUMERIC/DECIMAL without scale
-833
335544946
sysf_argmustbe_exact_or_fp
First argument for @1 must be integral type or floating point type
-833
335544947
sysf_argviolates_uuidtype
Human readable UUID argument for @1 must be of string type
-833
335544948
sysf_argviolates_uuidlen
Human readable UUID argument for @2 must be of exact length @1
-833
335544949
sysf_argviolates_uuidfmt
Human readable UUID argument for @3 must have «-» at position @2 instead of «@1»
-833
335544950
sysf_argviolates_guidigits
Human readable UUID argument for @3 must have hex digit at position @2 instead of «@1»
-833
335544951
sysf_invalid_addpart_time
Only HOUR, MINUTE, SECOND and MILLISECOND can be added to TIME values in @1
-833
335544952
sysf_invalid_add_datetime
Invalid data type in addition of part to DATE/TIME/TIMESTAMP in @1
-833
335544953
sysf_invalid_addpart_dtime
Invalid part @1 to be added to a DATE/TIME/TIMESTAMP value in @2
-833
335544954
sysf_invalid_add_dtime_rc
Expected DATE/TIME/TIMESTAMP type in evlDateAdd() result
-833
335544955
sysf_invalid_diff_dtime
Expected DATE/TIME/TIMESTAMP type as first and second argument to @1
-833
335544956
sysf_invalid_timediff
The result of TIME-<value> in @1 cannot be expressed in YEAR, MONTH, DAY or WEEK
-833
335544957
sysf_invalid_tstamptimediff
The result of TIME-TIMESTAMP or TIMESTAMP-TIME in @1 cannot be expressed in HOUR, MINUTE, SECOND or MILLISECOND
-833
335544958
sysf_invalid_datetimediff
The result of DATE-TIME or TIME-DATE in @1 cannot be expressed in HOUR, MINUTE, SECOND and MILLISECOND
-833
335544959
sysf_invalid_diffpart
Invalid part @1 to express the difference between two DATE/TIME/TIMESTAMP values in @2
-833
335544960
sysf_argmustbe_positive
Argument for @1 must be positive
-833
335544961
sysf_basemustbe_positive
Base for @1 must be positive
-833
335544962
sysf_argnmustbe_nonneg
Argument #@1 for @2 must be zero or positive
-833
335544963
sysf_argnmustbe_positive
Argument #@1 for @2 must be positive
-833
335544964
sysf_invalid_zeropowneg
Base for @1 cannot be zero if exponent is negative
-833
335544965
sysf_invalid_negpowfp
Base for @1 cannot be negative if exponent is not an integral value
-833
335544966
sysf_invalid_scale
The numeric scale must be between -128 and 127 in @1
-833
335544967
sysf_argmustbe_nonneg
Argument for @1 must be zero or positive
-833
335544968
sysf_binuuid_mustbe_str
Binary UUID argument for @1 must be of string type
-833
335544969
sysf_binuuid_wrongsize
Binary UUID argument for @2 must use @1 bytes
-833
335544976
sysf_argmustbe_nonzero
Argument for @1 must be different than zero
-833
335544977
sysf_argmustbe_range_inc1_1
Argument for @1 must be in the range [-1, 1]
-833
335544978
sysf_argmustbe_gteq_one
Argument for @1 must be greater or equal than one
-833
335544979
sysf_argmustbe_range_exc1_1
Argument for @1 must be in the range ]-1, 1[
-833
335544981
sysf_fp_overflow
Floating point overflow in built-in function @1
-833
335545009
sysf_invalid_trig_namespace
Invalid usage of context namespace DDL_TRIGGER
-833
335545024
sysf_argscant_both_be_zero
Arguments for @1 cannot both be zero
-833
335545046
max_args_exceeded
Maximum (@1) number of arguments exceeded for function @2
-833
336397240
dsql_eval_unknode
Unknown node type @1 in dsql/GEN_expr
-833
336397241
dsql_agg_wrongarg
Argument for @1 in dialect 1 must be string or numeric
-833
336397242
dsql_agg2_wrongarg
Argument for @1 in dialect 3 must be numeric
-833
336397243
dsql_nodateortime_pm_string
Strings cannot be added to or subtracted from DATE or TIME types
-833
336397244
dsql_invalid_datetime_subtract
Invalid data type for subtraction involving DATE, TIME or TIMESTAMP types
-833
336397245
dsql_invalid_dateortime_add
Adding two DATE values or two TIME values is not allowed
-833
336397246
dsql_invalid_type_minus_date
DATE value cannot be subtracted from the provided data type
-833
336397247
dsql_nostring_addsub_dial3
Strings cannot be added or subtracted in dialect 3
-833
336397248
dsql_invalid_type_addsub_dial3
Invalid data type for addition or subtraction in dialect 3
-833
336397249
dsql_invalid_type_multip_dial1
Invalid data type for multiplication in dialect 1
-833
336397250
dsql_nostring_multip_dial3
Strings cannot be multiplied in dialect 3
-833
336397251
dsql_invalid_type_multip_dial3
Invalid data type for multiplication in dialect 3
-833
336397252
dsql_mustuse_numeric_div_dial1
Division in dialect 1 must be between numeric data types
-833
336397253
dsql_nostring_div_dial3
Strings cannot be divided in dialect 3
-833
336397254
dsql_invalid_type_div_dial3
Invalid data type for division in dialect 3
-833
336397255
dsql_nostring_neg_dial3
Strings cannot be negated (applied the minus operator) in dialect 3
-833
336397256
dsql_invalid_type_neg
Invalid data type for negation (minus operator)
-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
-836
335545016
formatted_exception
@1
-837
335544518
cache_restart
restart shared cache manager
-838
335544560
shutwarn
database @1 shutdown in @2 seconds
-839
335544686
jrn_format_err
journal file wrong format
-840
335544687
jrn_file_full
intermediate journal file full
-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
335544322
bad_dbkey
invalid database key
-901
335544326
bad_dpb_form
unrecognized database parameter block
-901
335544327
bad_req_handle
invalid request handle
-901
335544328
bad_segstr_handle
invalid BLOB handle
-901
335544329
bad_segstr_id
invalid BLOB ID
-901
335544330
bad_tpb_content
invalid parameter in transaction parameter block
-901
335544331
bad_tpb_form
invalid format for transaction parameter block
-901
335544332
bad_trans_handle
invalid transaction handle (expecting explicit transaction start)
-901
335544337
excess_trans
attempt to start more than @1 transactions
-901
335544339
infinap
information type inappropriate for object specified
-901
335544340
infona
no information of this type available for object specified
-901
335544341
infunk
unknown information item
-901
335544342
integ_fail
action cancelled by trigger (@1) to preserve data integrity
-901
335544345
lock_conflict
lock conflict on no wait transaction
-901
335544350
no_finish
program attempted to exit without finishing database
-901
335544353
no_recon
transaction is not in limbo
-901
335544355
no_segstr_close
BLOB was not closed
-901
335544357
open_trans
cannot disconnect database with open transactions (@1 active)
-901
335544358
port_len
message length error (encountered @1, expected @2)
-901
335544363
req_no_trans
no transaction for request
-901
335544364
req_sync
request synchronization error
-901
335544365
req_wrong_db
request referenced an unavailable database
-901
335544369
segstr_no_read
attempted read of a new, open BLOB
-901
335544370
segstr_no_trans
attempted action on BLOB outside transaction
-901
335544372
segstr_wrong_db
attempted reference to BLOB in unavailable database
-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
335544392
bdbincon
internal error
-901
335544407
dbbnotzer
database handle not zero
-901
335544408
tranotzer
transaction handle not zero
-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
335544431
blocking_signal
blocking signal has been received
-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
335544510
lock_timeout
lock time-out on wait transaction
-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
335544609
index_name
INDEX @1
-901
335544610
exception_name
EXCEPTION @1
-901
335544611
field_name
COLUMN @1
-901
335544613
union_err
union not supported
-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
335544719
net_init_error
Error initializing the network software.
-901
335544720
loadlib_failure
Unable to load required library @1.
-901
335544731
tra_must_sweep
-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 deciaml 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 ([email protected])
-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
335544885
bad_teb_form
Invalid TEB format
-901
335544886
tpb_multiple_txn_isolation
Found more than one transaction isolation in TPB
-901
335544887
tpb_reserv_before_table
Table reservation lock type @1 requires table name before in TPB
-901
335544888
tpb_multiple_spec
Found more than one @1 specification in TPB
-901
335544889
tpb_option_without_rc
Option @1 requires READ COMMITTED isolation in TPB
-901
335544890
tpb_conflicting_options
Option @1 is not valid if @2 was used previously in TPB
-901
335544891
tpb_reserv_missing_tlen
Table name length missing after table reservation @1 in TPB
-901
335544892
tpb_reserv_long_tlen
Table name length @1 is too long after table reservation @2 in TPB
-901
335544893
tpb_reserv_missing_tname
Table name length @1 without table name after table reservation @2 in TPB
-901
335544894
tpb_reserv_corrup_tlen
Table name length @1 goes beyond the remaining TPB size after table reservation @2
-901
335544895
tpb_reserv_null_tlen
Table name length is zero after table reservation @1 in TPB
-901
335544896
tpb_reserv_relnotfound
Table or view @1 not defined in system tables after table reservation @2 in TPB
-901
335544897
tpb_reserv_baserelnotfound
Base table or view @1 for view @2 not defined in system tables after table reservation @3 in TPB
-901
335544898
tpb_missing_len
Option length missing after option @1 in TPB
-901
335544899
tpb_missing_value
Option length @1 without value after option @2 in TPB
-901
335544900
tpb_corrupt_len
Option length @1 goes beyond the remaining TPB size after option @2
-901
335544901
tpb_null_len
Option length is zero after table reservation @1 in TPB
-901
335544902
tpb_overflow_len
Option length @1 exceeds the range for option @2 in TPB
-901
335544903
tpb_invalid_value
Option value @1 is invalid for the option @2 in TPB
-901
335544904
tpb_reserv_stronger_wng
Preserving previous table reservation @1 for table @2, stronger than new @3 in TPB
-901
335544905
tpb_reserv_stronger
Table reservation @1 for table @2 already specified and is stronger than new @3 in TPB
-901
335544906
tpb_reserv_max_recursion
Table reservation reached maximum recursion of @1 when expanding views in TPB
-901
335544907
tpb_reserv_virtualtbl
Table reservation in TPB cannot be applied to @1 because it’s a virtual table
-901
335544908
tpb_reserv_systbl
Table reservation in TPB cannot be applied to @1 because it’s a system table
-901
335544909
tpb_reserv_temptbl
Table reservation @1 or @2 in TPB cannot be applied to @3 because it’s a temporary table
-901
335544910
tpb_readtxn_after_writelock
Cannot set the transaction in read only mode after a table reservation isc_tpb_lock_write in TPB
-901
335544911
tpb_writelock_after_readtxn
Cannot take a table reservation isc_tpb_lock_write in TPB because the transaction is in read only mode
-901
335544917
shutdown_timeout
Firebird shutdown is still in progress after the specified timeout
-901
335544918
att_handle_busy
Attachment handle is busy
-901
335544919
bad_udf_freeit
Bad written UDF detected: pointer returned in FREE_IT function was not allocated by ib_util_malloc
-901
335544920
eds_provider_not_found
External Data Source provider ‘@1’ not found
-901
335544921
eds_connection
Execute statement error at @1 :
@2Data source : @3
-901
335544922
eds_preprocess
Execute statement preprocess SQL error
-901
335544923
eds_stmt_expected
Statement expected
-901
335544924
eds_prm_name_expected
Parameter name expected
-901
335544925
eds_unclosed_comment
Unclosed comment found near ‘@1’
-901
335544926
eds_statement
Execute statement error at @1 :
@2Statement : @3
Data source : @4
-901
335544927
eds_input_prm_mismatch
Input parameters mismatch
-901
335544928
eds_output_prm_mismatch
Output parameters mismatch
-901
335544929
eds_input_prm_not_set
Input parameter ‘@1’ have no value set
-901
335544933
nothing_to_cancel
nothing to cancel
-901
335544934
ibutil_not_loaded
ib_util library has not been loaded to deallocate memory returned by FREE_IT function
-901
335544973
bad_epb_form
Unrecognized events block
-901
335544982
udf_fp_overflow
Floating point overflow in result from UDF @1
-901
335544983
udf_fp_nan
Invalid floating point value returned by UDF @1
-901
335544985
out_of_temp_space
No free space found in temporary directories
-901
335544986
eds_expl_tran_ctrl
Explicit transaction control is not allowed
-901
335544988
package_name
PACKAGE @1
-901
335544989
cannot_make_not_null
Cannot make field @1 of table @2 NOT NULL because there are NULLs present
-901
335544990
feature_removed
Feature @1 is not supported anymore
-901
335544991
view_name
VIEW @1
-901
335544993
invalid_fetch_option
Fetch option @1 is invalid for a non-scrollable cursor
-901
335544994
bad_fun_BLR
Error while parsing function @1’s BLR
-901
335544995
func_pack_not_implemented
Cannot execute function @1 of the unimplemented package @2
-901
335544996
proc_pack_not_implemented
Cannot execute procedure @1 of the unimplemented package @2
-901
335544997
eem_func_not_returned
External function @1 not returned by the external engine plugin @2
-901
335544998
eem_proc_not_returned
External procedure @1 not returned by the external engine plugin @2
-901
335544999
eem_trig_not_returned
External trigger @1 not returned by the external engine plugin @2
-901
335545000
eem_bad_plugin_ver
Incompatible plugin version @1 for external engine @2
-901
335545001
eem_engine_notfound
External engine @1 not found
-901
335545004
pman_cannot_load_plugin
Error loading plugin @1
-901
335545005
pman_module_notfound
Loadable module @1 not found
-901
335545006
pman_entrypoint_notfound
Standard plugin entrypoint does not exist in module @1
-901
335545007
pman_module_bad
Module @1 exists but can not be loaded
-901
335545008
pman_plugin_notfound
Module @1 does not contain plugin @2 type @3
-901
335545010
unexpected_null
Value is NULL but isNull parameter was not informed
-901
335545011
type_notcompat_blob
Type @1 is incompatible with BLOB
-901
335545012
invalid_date_val
Invalid date
-901
335545013
invalid_time_val
Invalid time
-901
335545014
invalid_timestamp_val
Invalid timestamp
-901
335545015
invalid_index_val
Invalid index @1 in function @2
-901
335545018
private_function
Function @1 is private to package @2
-901
335545019
private_procedure
Procedure @1 is private to package @2
-901
335545021
bad_events_handle
invalid events id (handle)
-901
335545025
spb_no_id
missing service ID in spb
-901
335545026
ee_blr_mismatch_null
External BLR message mismatch: invalid null descriptor at field @1
-901
335545027
ee_blr_mismatch_length
External BLR message mismatch: length = @1, expected @2
-901
335545031
libtommath_generic
Libtommath error code @1 in function @2
-901
335545041
cp_process_active
Crypt failed — already crypting database
-901
335545042
cp_already_crypted
Crypt failed — database is already in requested state
-901
335545047
ee_blr_mismatch_names_count
External BLR message mismatch: names count = @1, blr count = @2
-901
335545048
ee_blr_mismatch_name_not_found
External BLR message mismatch: name @1 not found
-901
335545049
bad_result_set
Invalid resultset interface
-901
335545059
badvarnum
undefined variable number
-901
335545071
info_unprepared_stmt
Attempt to get information about an unprepared dynamic SQL statement.
-901
335545072
idx_key_value
Problematic key value is @1
-901
335545073
forupdate_virtualtbl
Cannot select virtual table @1 for update WITH LOCK
-901
335545074
forupdate_systbl
Cannot select system table @1 for update WITH LOCK
-901
335545075
forupdate_temptbl
Cannot select temporary table @1 for update WITH LOCK
-901
335545076
cant_modify_sysobj
System @1 @2 cannot be modified
-901
335545077
server_misconfigured
Server misconfigured — contact administrator please
-901
335545078
alter_role
Deprecated backward compatibility ALTER ROLE … SET/DROP AUTO ADMIN mapping may be used only for RDB$ADMIN role
-901
335545079
map_already_exists
Mapping @1 already exists
-901
335545080
map_not_exists
Mapping @1 does not exist
-901
335545081
map_load
@1 failed when loading mapping cache
-901
335545082
map_aster
Invalid name <*> in authentication block
-901
335545083
map_multi
Multiple maps found for @1
-901
335545084
map_undefined
Undefined mapping result — more than one different results found
-901
335545088
map_nodb
Global mapping is not available when database @1 is not present
-901
335545089
map_notable
Global mapping is not available when table RDB$MAP is not present in database @1
-901
335545090
miss_trusted_role
Your attachment has no trusted role
-901
335545091
set_invalid_role
Role @1 is invalid or unavailable
-901
335545093
dup_attribute
Duplicated user attribute @1
-901
335545094
dyn_no_priv
There is no privilege for this operation
-901
335545095
dsql_cant_grant_option
Using GRANT OPTION on @1 not allowed
-901
335545097
crdb_load
@1 failed when working with CREATE DATABASE grants
-901
335545098
crdb_nodb
CREATE DATABASE grants check is not possible when database @1 is not present
-901
335545099
crdb_notable
CREATE DATABASE grants check is not possible when table RDB$DB_CREATORS is not present in database @1
-901
335545102
savepoint_backout_err
Error during savepoint backout — transaction invalidated
-901
335545105
map_down
Some database(s) were shutdown when trying to read mapping data
-901
335545109
encrypt_error
Page requires encryption but crypt plugin is missing
-901
336068645
dyn_filter_not_found
BLOB Filter @1 not found
-901
336068649
dyn_func_not_found
Function @1 not found
-901
336068656
dyn_index_not_found
Index not found
-901
336068662
dyn_view_not_found
View @1 not found
-901
336068697
dyn_domain_not_found
Domain not found
-901
336068717
dyn_cant_modify_auto_trig
Triggers created automatically cannot be modified
-901
336068740
dyn_dup_table
Table @1 already exists
-901
336068748
dyn_proc_not_found
Procedure @1 not found
-901
336068752
dyn_exception_not_found
Exception not found
-901
336068754
dyn_proc_param_not_found
Parameter @1 in procedure @2 not found
-901
336068755
dyn_trig_not_found
Trigger @1 not found
-901
336068759
dyn_charset_not_found
Character set @1 not found
-901
336068760
dyn_collation_not_found
Collation @1 not found
-901
336068763
dyn_role_not_found
Role @1 not found
-901
336068767
dyn_name_longer
Name longer than database column size
-901
336068784
dyn_column_does_not_exist
column @1 does not exist in table/view @2
-901
336068796
dyn_role_does_not_exist
SQL role @1 does not exist
-901
336068797
dyn_no_grant_admin_opt
user @1 has no grant admin option on SQL role @2
-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
336068820
dyn_zero_len_id
Zero length identifiers are not allowed
-901
336068822
dyn_gen_not_found
Sequence @1 not found
-901
336068840
dyn_wrong_gtt_scope
@1 cannot reference @2
-901
336068843
dyn_coll_used_table
Collation @1 is used in table @2 (field name @3) and cannot be dropped
-901
336068844
dyn_coll_used_domain
Collation @1 is used in domain @2 and cannot be dropped
-901
336068846
dyn_cannot_del_def_coll
Cannot delete default collation of CHARACTER SET @1
-901
336068849
dyn_table_not_found
Table @1 not found
-901
336068851
dyn_coll_used_procedure
Collation @1 is used in procedure @2 (parameter name @3) and cannot be dropped
-901
336068856
dyn_ods_not_supp_feature
Feature ‘@1’ is not supported in ODS @[email protected]
-901
336068858
dyn_no_empty_pw
Password should not be empty string
-901
336068859
dyn_dup_index
Index @1 already exists
-901
336068864
dyn_package_not_found
Package @1 not found
-901
336068865
dyn_schema_not_found
Schema @1 not found
-901
336068871
dyn_funcnotdef_package
Function @1 has not been defined on the package body @2
-901
336068872
dyn_procnotdef_package
Procedure @1 has not been defined on the package body @2
-901
336068873
dyn_funcsignat_package
Function @1 has a signature mismatch on package body @2
-901
336068874
dyn_procsignat_package
Procedure @1 has a signature mismatch on package body @2
-901
336068875
dyn_defvaldecl_package_proc
Default values for parameters are allowed only in declaration of packaged procedure @[email protected]
-901
336068877
dyn_package_body_exists
Package body @1 already exists
-901
336068879
dyn_newfc_oldsyntax
Cannot alter new style function @1 with ALTER EXTERNAL FUNCTION. Use ALTER FUNCTION instead.
-901
336068886
dyn_func_param_not_found
Parameter @1 in function @2 not found
-901
336068887
dyn_routine_param_not_found
Parameter @1 of routine @2 not found
-901
336068888
dyn_routine_param_ambiguous
Parameter @1 of routine @2 is ambiguous (found in both procedures and functions). Use a specifier keyword.
-901
336068889
dyn_coll_used_function
Collation @1 is used in function @2 (parameter name @3) and cannot be dropped
-901
336068890
dyn_domain_used_function
Domain @1 is used in function @2 (parameter name @3) and cannot be dropped
-901
336068891
dyn_alter_user_no_clause
ALTER USER requires at least one clause to be specified
-901
336068894
dyn_duplicate_package_item
Duplicate @1 @2
-901
336068895
dyn_cant_modify_sysobj
System @1 @2 cannot be modified
-901
336068896
dyn_cant_use_zero_increment
INCREMENT BY 0 is an illegal option for sequence @1
-901
336068897
dyn_cant_use_in_foreignkey
Can’t use @1 in FOREIGN KEY constraint
-901
336068898
dyn_defvaldecl_package_func
Default values for parameters are allowed only in declaration of packaged function @[email protected]
-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
-901
336397239
dsql_unsupported_in_auto_trans
@1 is not supported inside IN AUTONOMOUS TRANSACTION block
-901
336397258
dsql_alter_charset_failed
ALTER CHARACTER SET @1 failed
-901
336397259
dsql_comment_on_failed
COMMENT ON @1 failed
-901
336397260
dsql_create_func_failed
CREATE FUNCTION @1 failed
-901
336397261
dsql_alter_func_failed
ALTER FUNCTION @1 failed
-901
336397262
dsql_create_alter_func_failed
CREATE OR ALTER FUNCTION @1 failed
-901
336397263
dsql_drop_func_failed
DROP FUNCTION @1 failed
-901
336397264
dsql_recreate_func_failed
RECREATE FUNCTION @1 failed
-901
336397265
dsql_create_proc_failed
CREATE PROCEDURE @1 failed
-901
336397266
dsql_alter_proc_failed
ALTER PROCEDURE @1 failed
-901
336397267
dsql_create_alter_proc_failed
CREATE OR ALTER PROCEDURE @1 failed
-901
336397268
dsql_drop_proc_failed
DROP PROCEDURE @1 failed
-901
336397269
dsql_recreate_proc_failed
RECREATE PROCEDURE @1 failed
-901
336397270
dsql_create_trigger_failed
CREATE TRIGGER @1 failed
-901
336397271
dsql_alter_trigger_failed
ALTER TRIGGER @1 failed
-901
336397272
dsql_create_alter_trigger_failed
CREATE OR ALTER TRIGGER @1 failed
-901
336397273
dsql_drop_trigger_failed
DROP TRIGGER @1 failed
-901
336397274
dsql_recreate_trigger_failed
RECREATE TRIGGER @1 failed
-901
336397275
dsql_create_collation_failed
CREATE COLLATION @1 failed
-901
336397276
dsql_drop_collation_failed
DROP COLLATION @1 failed
-901
336397277
dsql_create_domain_failed
CREATE DOMAIN @1 failed
-901
336397278
dsql_alter_domain_failed
ALTER DOMAIN @1 failed
-901
336397279
dsql_drop_domain_failed
DROP DOMAIN @1 failed
-901
336397280
dsql_create_except_failed
CREATE EXCEPTION @1 failed
-901
336397281
dsql_alter_except_failed
ALTER EXCEPTION @1 failed
-901
336397282
dsql_create_alter_except_failed
CREATE OR ALTER EXCEPTION @1 failed
-901
336397283
dsql_recreate_except_failed
RECREATE EXCEPTION @1 failed
-901
336397284
dsql_drop_except_failed
DROP EXCEPTION @1 failed
-901
336397285
dsql_create_sequence_failed
CREATE SEQUENCE @1 failed
-901
336397286
dsql_create_table_failed
CREATE TABLE @1 failed
-901
336397287
dsql_alter_table_failed
ALTER TABLE @1 failed
-901
336397288
dsql_drop_table_failed
DROP TABLE @1 failed
-901
336397289
dsql_recreate_table_failed
RECREATE TABLE @1 failed
-901
336397290
dsql_create_pack_failed
CREATE PACKAGE @1 failed
-901
336397291
dsql_alter_pack_failed
ALTER PACKAGE @1 failed
-901
336397292
dsql_create_alter_pack_failed
CREATE OR ALTER PACKAGE @1 failed
-901
336397293
dsql_drop_pack_failed
DROP PACKAGE @1 failed
-901
336397294
dsql_recreate_pack_failed
RECREATE PACKAGE @1 failed
-901
336397295
dsql_create_pack_body_failed
CREATE PACKAGE BODY @1 failed
-901
336397296
dsql_drop_pack_body_failed
DROP PACKAGE BODY @1 failed
-901
336397297
dsql_recreate_pack_body_failed
RECREATE PACKAGE BODY @1 failed
-901
336397298
dsql_create_view_failed
CREATE VIEW @1 failed
-901
336397299
dsql_alter_view_failed
ALTER VIEW @1 failed
-901
336397300
dsql_create_alter_view_failed
CREATE OR ALTER VIEW @1 failed
-901
336397301
dsql_recreate_view_failed
RECREATE VIEW @1 failed
-901
336397302
dsql_drop_view_failed
DROP VIEW @1 failed
-901
336397303
dsql_drop_sequence_failed
DROP SEQUENCE @1 failed
-901
336397304
dsql_recreate_sequence_failed
RECREATE SEQUENCE @1 failed
-901
336397305
dsql_drop_index_failed
DROP INDEX @1 failed
-901
336397306
dsql_drop_filter_failed
DROP FILTER @1 failed
-901
336397307
dsql_drop_shadow_failed
DROP SHADOW @1 failed
-901
336397308
dsql_drop_role_failed
DROP ROLE @1 failed
-901
336397309
dsql_drop_user_failed
DROP USER @1 failed
-901
336397310
dsql_create_role_failed
CREATE ROLE @1 failed
-901
336397311
dsql_alter_role_failed
ALTER ROLE @1 failed
-901
336397312
dsql_alter_index_failed
ALTER INDEX @1 failed
-901
336397313
dsql_alter_database_failed
ALTER DATABASE failed
-901
336397314
dsql_create_shadow_failed
CREATE SHADOW @1 failed
-901
336397315
dsql_create_filter_failed
DECLARE FILTER @1 failed
-901
336397316
dsql_create_index_failed
CREATE INDEX @1 failed
-901
336397317
dsql_create_user_failed
CREATE USER @1 failed
-901
336397318
dsql_alter_user_failed
ALTER USER @1 failed
-901
336397319
dsql_grant_failed
GRANT failed
-901
336397320
dsql_revoke_failed
REVOKE failed
-901
336397322
dsql_mapping_failed
@2 MAPPING @1 failed
-901
336397323
dsql_alter_sequence_failed
ALTER SEQUENCE @1 failed
-901
336397324
dsql_create_generator_failed
CREATE GENERATOR @1 failed
-901
336397325
dsql_set_generator_failed
SET GENERATOR @1 failed
-901
336397330
dsql_max_exception_arguments
Number of arguments (@1) exceeds the maximum (@2) number of EXCEPTION USING arguments
-901
336397331
dsql_string_byte_length
String literal with @1 bytes exceeds the maximum length of @2 bytes
-901
336397332
dsql_string_char_length
String literal with @1 characters exceeds the maximum length of @2 characters for the @3 character set
-901
336397333
dsql_max_nesting
Too many BEGIN…END nesting. Maximum level is @1
-902
335544333
bug_check
internal Firebird consistency check (@1)
-902
335544335
db_corrupt
database file appears corrupt (@1)
-902
335544344
io_error
I/O error during «@1» operation 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
-902
335544449
invalid_sec_info
-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
335544478
jrn_enable
enable journal for database before starting online dump
-902
335544479
old_failure
online dump failure. Retry dump
-902
335544480
old_in_progress
an online dump is already in progress
-902
335544481
old_no_space
no more disk/tape space. Cannot continue online dump
-902
335544482
no_wal_no_jrn
journaling allowed only if database has Write-ahead Log
-902
335544483
num_old_files
maximum number of online dump files that can be specified is 16
-902
335544484
wal_file_open
error in opening Write-ahead Log file during recovery
-902
335544486
wal_failure
Write-ahead log subsystem failure
-902
335544505
no_archive
must specify archive file when enabling long term journal for databases with round-robin log files
-902
335544506
shutinprog
database @1 shutdown in progress
-902
335544520
jrn_present
long-term journaling already enabled
-902
335544528
shutdown
database @1 shutdown
-902
335544557
shutfail
database shutdown unsuccessful
-902
335544564
no_jrn
long-term journaling not enabled
-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
Use of @1 at location @2 is not allowed by server configuration
-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)
-902
335544936
psw_db_error
Security database error
-902
335544970
missing_required_spb
Missing required item @1 in service parameter block
-902
335544971
net_server_shutdown
@1 server is shutdown
-902
335544974
no_threads
Could not start first worker thread — shutdown server
-902
335544975
net_event_connect_timeout
Timeout occurred while waiting for a secondary connection for event processing
-902
335544984
instance_conflict
Database is probably already opened by another engine instance in another Windows session
-902
335544987
no_trusted_spb
Use of TRUSTED switches in spb_command_line is prohibited
-902
335545029
missing_data_structures
Install incomplete, please read the Compatibility chapter in the release notes for this version
-902
335545030
protect_sys_tab
@1 operation is not allowed for system table @2
-902
335545032
wroblrver2
unsupported BLR version (expected between @1 and @2, encountered @3)
-902
335545043
decrypt_error
Missing crypt plugin, but page appears encrypted
-902
335545044
no_providers
No providers loaded
-902
335545053
miss_config
Missing configuration file: @1
-902
335545054
conf_line
@1: illegal line <@2>
-902
335545055
conf_include
Invalid include operator in @1 for <@2>
-902
335545056
include_depth
Include depth too big
-902
335545057
include_miss
File to include not found
-902
335545060
sec_context
Missing security context for @1
-902
335545061
multi_segment
Missing segment @1 in multisegment connect block parameter
-902
335545062
login_changed
Different logins in connect and attach packets — client library error
-902
335545063
auth_handshake_limit
Exceeded exchange limit during authentication handshake
-902
335545064
wirecrypt_incompatible
Incompatible wire encryption levels requested on client and server
-902
335545065
miss_wirecrypt
Client attempted to attach unencrypted but wire encryption is required
-902
335545066
wirecrypt_key
Client attempted to start wire encryption using unknown key @1
-902
335545067
wirecrypt_plugin
Client attempted to start wire encryption using unsupported plugin @1
-902
335545068
secdb_name
Error getting security database name from configuration file
-902
335545069
auth_data
Client authentication plugin is missing required data from server
-902
335545070
auth_datalength
Client authentication plugin expected @2 bytes of @3 from server, got @1
-902
335545106
login_error
Error occurred during login, please check server firebird.log for details
-902
335545107
already_opened
Database already opened with engine instance, incompatible with current
-902
335545108
bad_crypt_key
Invalid crypt key @1
-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
335544762
optimizer_blk_exc
size of optimizer block exceeded
-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
335544833
wal_backup_err
Physical backup is not allowed while Write-Ahead Log is in use
-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
-904
335544935
circular_computed
Cannot have circular dependencies with computed fields
-904
335544992
lock_dir_access
Can not access lock files directory @1
-904
335545020
request_outdated
Request can’t access new records in relation @1 and should be recompiled
-904
335545096
read_conflict
read conflicts with concurrent update
-906
335544452
unlicensed
product @1 is not licensed
-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
335544462
cant_start_journal
secondary server attachments cannot start journaling
-923
335544464
cant_start_logging
secondary server attachments cannot start logging
-924
335544325
bad_dpb_content
bad parameters on attach or create database
-924
335544433
journerr
communication error with journal «@1»
-924
335544441
bad_detach
database detach completed with errors
-924
335544648
conn_lost
Connection lost to pipe server
-924
335544972
bad_conn_str
Invalid connection string
-924
335545085
baddpb_damaged_mode
Incompatible mode of attachment to damaged database
-924
335545086
baddpb_buffers_range
Attempt to set in database number of buffers which is out of acceptable range [@1:@2]
-924
335545087
baddpb_temp_buffers
Attempt to temporarily set number of buffers less than @1
-926
335544447
no_rollback
no rollback performed
-999
335544689
ib_error
Firebird error
|
|
|
|
информация о разделе
 |
Данный раздел предназначается исключительно для обсуждения вопросов использования языка запросов SQL. Обсуждение общих вопросов, связанных с тематикой баз данных — обсуждаем в разделе «Базы данных: общие вопросы». Убедительная просьба — соблюдать «Правила форума» и не пренебрегать «Правильным оформлением своих тем». Прежде, чем создавать тему, имеет смысл заглянуть в раздел «Базы данных: FAQ», возможно там уже есть ответ. |
[Firebird] В запросе не определяется поле
, Рекурсивный запрос не разруливает поле
- Подписаться на тему
- Сообщить другу
- Скачать/распечатать тему
|
|
|
|
Full Member
Рейтинг (т): 5 |
Привет. У меня есть иерархическая таблица XXXX. Пытаюсь для нода определить парентов и чайлдов, чтобы произвести вставку в другую таблицу. Однако Firebird 2.1 ругается на: Column does not belong to referenced table. Сам текст запроса: поля есть. Если поменять куски CHILDREN и PARENT_LIST местами, то будет ругаться на то, что нет PT.ID. В чем может быть проблема?
MERGE INTO MO_DATAGROUP_LINK DGL USING ( WITH RECURSIVE CHILDREN AS ( SELECT 923 ID FROM RDB$DATABASE UNION ALL SELECT S.ID FROM SPRT S JOIN CHILDREN C ON C.ID = S.PARENTID ), PARENT_LIST AS ( SELECT PARENTID ID FROM SPRT WHERE ID = 923 UNION ALL SELECT PARENTID ID FROM SPRT T JOIN PARENT_LIST PT ON T.ID = PT.ID) SELECT ID FROM PARENT_LIST WHERE ID IS NOT NULL UNION ALL SELECT ID FROM CHILDREN ) PX ON DGL.DATAID = PX.ID AND DGL.DATAGROUPID = 896 AND DGL.TABLENAME = ‘XXXX’ WHEN NOT MATCHED THEN INSERT (DATAGROUPID, TABLENAME, DATAID) VALUES (:D_VALUE, ‘XXXX’, PX.ID); |
|
Romkin |
|
|
А где у тебя таблица C? |
|
spy_ |
|
|
Full Member
Рейтинг (т): 5 |
Romkin, «JOIN CHILDREN C ON», не? |
|
Romkin |
|
|
Присоедини псевдоним ко всем полям, оно путается скорее всего |
|
spy_ |
|
|
Full Member
Рейтинг (т): 5 |
Если присоединять сюда «SELECT S.ID FROM SPRT S JOIN CHILDREN C ON C.ID = S.PARENTID» по аналогии с выборкой PARENT_LIST, то толку никакого, к сожалению, та же ошибка. Кстати, если поменять местами блоки CHILDREN и PARENT_LIST как есть, то будет уже ругаться на выборку PARENT_LIST аналогично. |
|
Игорь Акопян |
|
|
простите, а это что без запятой пишется?
SELECT PARENTID ID FROM |
|
spy_ |
|
|
Full Member
Рейтинг (т): 5 |
Игорь Акопян, а почему оно должно писаться с запятой? Добавлено 23.10.12, 14:05 |
|
Alex2011 |
|
|
Member
Рейтинг (т): 1 |
Думаю что проще(или даже НАДО) в хр.процедуре сделать,особенно если там рекурсия.(Разбираться с твоим запросом лень) Я когда-то писал хр.процедуру (с запросом выходил большой гемор-я решил,что это невозможно сделать,хотя может и не так-не претендую на истину в последней инстанции),в которой определял верхнего парента,всех чайдлов,если не ошибаюсь.(давно было,но процедуру найти,думаю, можно) Похоже и тебе что-то аналогичное надо? Сообщение отредактировано: Alex2011 — 08.11.12, 10:14 |
0 пользователей читают эту тему (0 гостей и 0 скрытых пользователей)
0 пользователей:
- Предыдущая тема
- Базы данных: SQL
- Следующая тема
[ Script execution time: 0,0621 ] [ 15 queries used ] [ Generated: 9.02.23, 18:48 GMT ]
SQL error code = -206 [CORE4197] #4522
Comments
firebird-issue-importer commented Aug 29, 2013
Submitted by: Márson de Paula (marsonluis)
I’m trying to insert a record but the error occurs:
can’t format message 13:794 — message file C:Windowsfirebird.msg not found.
Dynamic SQL Error.
SQL error code = -206.
Column unknown.
VCST.
At line 1, column 108.
insert into MOVESTOQUE (CDLOJA, CDPOS, CDPRODUTO, CDHISTORICO, FLGMOVIMENTO, QUANTIDADE, DATA, HORA, QTDEANTERIOR,
QTDEATUAL, NRDOCUMENTO, VLRCUSTOCIMP, CDFORNCLI, LJFORNECEDOR, VLRCUSTMEDCIMP, VLRCUSTMEDCONT,
VLRCONTABIL, VLRSUGERIDO, SEQUENCIA)
values (77, 9, 8994, 15, ‘E’, -1, ‘28.08.2013’, ’15:09:00′, -3,- 3, ‘VCST’,1.1449996948, 0, 0, 7.8600001335144,
7.61999988555908, 8.18000030517578, 12.2700004577637, 3)
And, this the table’s DDL:
CREATE GENERATOR GEN_MOVESTOQUE;
CREATE TABLE MOVESTOQUE (
CDPOS INTEGER NOT NULL,
CDMOVIMENTO INTEGER NOT NULL,
CDLOJA INTEGER NOT NULL,
CDPRODUTO INTEGER,
CDHISTORICO INTEGER DEFAULT 0,
DATA TIMESTAMP,
HORA VARCHAR(8),
QUANTIDADE FLOAT DEFAULT 0,
FLGMOVIMENTO VARCHAR(1),
QTDEANTERIOR FLOAT,
QTDEATUAL FLOAT,
CDFORNCLI CODIGO /* CODIGO = INTEGER */,
NRDOCUMENTO VARCHAR(20),
VLRCUSTOCIMP VALOR /* VALOR = DECIMAL(18,2) */,
VLRCUSTMEDCIMP VALOR /* VALOR = DECIMAL(18,2) */,
LJFORNECEDOR CODIGO /* CODIGO = INTEGER */,
VLRCUSTMEDUNIT VALOR /* VALOR = DECIMAL(18,2) */,
VLRCUSTMEDCONT VALOR /* VALOR = DECIMAL(18,2) */,
FLGESTORNADO FLAG /* FLAG = VARCHAR(1) */,
VLRCONTABIL VALOR /* VALOR = DECIMAL(18,2) */,
VLRSUGERIDO VALOR /* VALOR = DECIMAL(18,2) */,
FLGALTERADO FLAG /* FLAG = VARCHAR(1) */,
FLGSIST FLAG /* FLAG = VARCHAR(1) */,
MD5 VARCHAR(40),
SEQUENCIA CODIGO /* CODIGO = INTEGER */
);
ALTER TABLE MOVESTOQUE ADD PRIMARY KEY (CDMOVIMENTO, CDPOS, CDLOJA);
ALTER TABLE MOVESTOQUE ADD FOREIGN KEY (CDPRODUTO) REFERENCES PRODUTOS (CDPRODUTO);
ALTER TABLE MOVESTOQUE ADD FOREIGN KEY (CDPOS, CDLOJA) REFERENCES POS (CDPOS, CDLOJA);
ALTER TABLE MOVESTOQUE ADD FOREIGN KEY (CDHISTORICO) REFERENCES HISTORICOS (CDHISTORICO);
CREATE INDEX XIE1MOVESTOQUE ON MOVESTOQUE (CDLOJA);
CREATE INDEX XIE2MOVESTOQUE ON MOVESTOQUE (DATA);
CREATE INDEX XIE3MOVESTOQUE ON MOVESTOQUE (FLGMOVIMENTO);
CREATE INDEX XIE4MOVESTOQUE ON MOVESTOQUE (CDPRODUTO);
CREATE INDEX XIE5MOVESTOQUE ON MOVESTOQUE (NRDOCUMENTO);
CREATE INDEX XIE6MOVESTOQUE ON MOVESTOQUE (CDFORNCLI);
CREATE INDEX XIE7MOVESTOQUE ON MOVESTOQUE (CDHISTORICO);
CREATE INDEX XIE8MOVESTOQUE ON MOVESTOQUE (CDMOVIMENTO);
CREATE INDEX XIE9MOVESTOQUE ON MOVESTOQUE (CDFORNCLI, LJFORNECEDOR);
CREATE INDEX XIF90MOVESTOQUE ON MOVESTOQUE (CDPOS, CDLOJA);
CREATE INDEX XIF91MOVESTOQUE ON MOVESTOQUE (CDPRODUTO);
The text was updated successfully, but these errors were encountered:
Источник
Dynamic SQL Error SQL error code = -206 Column unknown [CORE1765] #2189
Comments
firebird-issue-importer commented Feb 26, 2008
Submitted by: Ionut Perianu (pia_ro)
The:
select t.ntip,m.nmodel,f.identif,f.nrfabric,v.temporara,max(v.scadenta) scadenta from tip t,model m,flota f left join verificari v on f.nrfabric=v.nrfabric where t.idtip=m.idtip and m.idmodel=f.idmodel and f.idpctlucru=2 and (f.casat=0 OR f.casat IS NULL) group by 1,2,3,4,5 ORDER BY 1,2,5
Generates the error: Dynamic SQL Error SQL error code = -206 Column unknown V.NRFABRIC At line 1, column 148.
The text was updated successfully, but these errors were encountered:
firebird-issue-importer commented Feb 26, 2008
Modified by: Ionut Perianu (pia_ro)
security: Developers [ 10012 ] =>
Component: Scripts [ 10013 ] =>
firebird-issue-importer commented Mar 8, 2008
How can someone reproduce this issue ?
firebird-issue-importer commented Sep 16, 2008
We cannot resolve this ticket because of lack of a proper test case.
firebird-issue-importer commented Sep 16, 2008
status: Open [ 1 ] => Resolved [ 5 ]
resolution: Incomplete [ 4 ]
firebird-issue-importer commented Sep 16, 2008
status: Resolved [ 5 ] => Closed [ 6 ]
Footer
© 2023 GitHub, Inc.
You can’t perform that action at this time.
You signed in with another tab or window. Reload to refresh your session. You signed out in another tab or window. Reload to refresh your session.
Источник
iBase.ru Forum
Форум по InterBase, Firebird и Yaffil
- Темы без ответов
- Активные темы
- Поиск
- Наша команда
Проблема с простым запросом
Проблема с простым запросом
Сообщение SeGun » 14 янв 2012, 21:59
Скачал Firebird-2.5.1.26351_1_Win32
Среда Delphi 7
Пытаюсь выполнить запрос
DM1.QAnketa_Rep.SQL.Text:=’SELECT country, count(country) FROM TESTS WHERE DZT Between ‘+’»‘+SD1+’»‘+’ AND ‘+’»‘+SD2+’»‘+’ GROUP BY COUNTRY’;
Где SD1 и SD2
SD1:=DateToStr(Form2.DateTimePicker1.DateTime);
SD2:=DateToStr(IncDay((Form2.DateTimePicker2.DateTime),1));
В ответ получаю сообщение:
EIBInterBase error
Dynamic SQL Error
SQL Error Code = -206 column UnKnown
14.12.11 <Это дата из базы поле DZT>
at line 1 column 72
Хотя такой запрос:
select country, count(country) from tests where dzt between ‘09.01.12’ and ‘09.01.12’ group by country
Успешно возвращает результат в IBExpert
Re: Проблема с простым запросом
Сообщение kdv » 14 янв 2012, 22:51
Вообще-то, поскольку формат даты может отличаться на разных компьютерах, я бы рекомендовал использовать параметры вместо подстановки дат в виде строк в запрос.
собственно, по проблеме — используйте компонент IBSQLMonitor или отладчик, чтобы увидеть, какой запрос на самом деле находится в SQL.Text. Вы уверены, что там то же самое, что вы выполняете в IBExpert? А там не то же самое, там вот что
select country, count(country) from tests where dzt between «09.01.12» and «09.01.12» group by country
а двойные кавычки, как известно, в третьем диалекте служат для обрамления «квотируемых идентификаторов»
http://www.ibase.ru/ibfaq.htm#dial
Re: Проблема с простым запросом
Сообщение SeGun » 14 янв 2012, 23:18
Re: Проблема с простым запросом
Сообщение kdv » 15 янв 2012, 14:27
Источник
Sql error code 206 firebird
Опытный 
Профиль
Группа: Участник
Сообщений: 349
Регистрация: 18.8.2006
Репутация: нет
Всего: 7
Привет. У меня есть иерархическая таблица XXXX. Пытаюсь для нода определить парентов и чайлдов, чтобы произвести вставку в другую таблицу. Однако Firebird 2.1 ругается на:
Column does not belong to referenced table.
Dynamic SQL Error.
SQL error code = -206.
Column unknown.
C.ID.
At line 8, column 46.
Сам текст запроса: поля есть. Если поменять куски CHILDREN и PARENT_LIST местами, то будет ругаться на то, что нет PT.ID. В чем может быть проблема?
| spyswamp |
|
||
Загрузка .
| Код |
| MERGE INTO MO_DATAGROUP_LINK DGL USING ( WITH RECURSIVE |
CHILDREN AS (
SELECT 923 ID FROM RDB$DATABASE
UNION ALL
SELECT S.ID FROM SPRT S JOIN CHILDREN C ON C.ID = S.PARENTID
),
PARENT_LIST AS (
SELECT PARENTID ID FROM SPRT WHERE/> UNION ALL
SELECT PARENTID ID FROM SPRT T JOIN PARENT_LIST PT ON T.ID = PT.ID)
SELECT ID FROM PARENT_LIST WHERE ID IS NOT NULL
UNION ALL
SELECT ID FROM CHILDREN
) PX ON DGL.DATAID = PX.ID AND DGL.DATAGROUPID = 896 AND DGL.TABLENAME = ‘XXXX’
WHEN NOT MATCHED THEN INSERT (DATAGROUPID, TABLENAME, DATAID) VALUES (:D_VALUE, ‘XXXX’, PX.ID);
1. Версию InterBase (Firebird, Yaffil)
2. Способа доступа (ADO, BDE, IBX и т.д.)
- КАК ПРАВИЛЬНО ОФОРМИТЬ КОД — ЗДЕСЬ
- КАК ПРАВИЛЬНО УКАЗАТЬ ТЕКСТ ОШИБКИ — ЗДЕСЬ
- Действия модераторов можно обсудить здесь
- С просьбами о написании курсовой, реферата и т.п. обращаться сюда
- FAQ раздела лежит здесь!
Если Вам понравилась атмосфера форума, заходите к нам чаще! С Уважением, Akella.
| 0 Пользователей читают эту тему (0 Гостей и 0 Скрытых Пользователей) |
| 0 Пользователей: |
| « Предыдущая тема | Firebird, Interbase | Следующая тема » |
[ Время генерации скрипта: 0.0829 ] [ Использовано запросов: 21 ] [ GZIP включён ]
Источник
EssentialPIM
Dynamic SQL Error SQL error code = -206 Column unknown
Dynamic SQL Error SQL error code = -206 Column unknown
Post by richardri » Sat Jan 22, 2011 8:35 pm
Is this something I can fix myself?
Should I discontinue using your product??
Thank you, Richardri
Dynamic SQL Error
SQL error code = -206
Column unknown
USEGLOBALFOLDERS
At line 1, column 209.
——————————————————————————
Exception log with detailed tech info. Generated on 01/22/2011 2:16 PM.
You may send it to the application vendor, helping him to understand what had happened.
Application title: TEST.EPIM — EssentialPIM
Application file: C:Program Files (x86)EssentialPIMEssentialPIM.exe
Application: EssentialPIM 3.74
——————————————————————————
Exception class: EIBInterBaseError
Exception message: Dynamic SQL Error
SQL error code = -206
Column unknown
USEGLOBALFOLDERS
At line 1, column 209.
Exception address: 004D1E4F
——————————————————————————
Main thread > Exception thread > ——————————————————————————
Acive Controls:
8240191 ExceptionDialog TextMemo
——————————————————————————
Exception stack
Stack list, generated 01/22/2011 2:16 PM
[004D1E4A] IB.IBDataBaseError (Line 411, «IB.pas» + 38)
[004D5AC4] IBDatabase.TIBTransaction.Call (Line 1592, «IBDatabase.pas» + 11)
[004CAD87] IBSQL.TIBSQL.Call (Line 2343, «IBSQL.pas» + 3)
[004CBB7D] IBSQL.TIBSQL.Prepare (Line 2775, «IBSQL.pas» + 17)
[0080F021] Data.TDB.PrepareReadSQL (Line 470, «Data.pas» + 14)
[0080F055] Data.TDB.ExecReadSQL (Line 475, «Data.pas» + 1)
[007AA349] MailThrFrm.TMailCheckManager.Startup (Line 2931, «MailThrFrm.pas» + 1)
[0083D5A2] Main.TMainForm.OpenLastDB (Line 1735, «Main.pas» + 25)
[0083A96B] Main.TMainForm.AppIdle (Line 723, «Main.pas» + 25)
[004A163D] Forms.TApplication.Idle
[004A0C1B] Forms.TApplication.HandleMessage
[00857516] EssentialPIM.EssentialPIM (Line 57, «» +
——————————————————————————
Call stack for main thread
Stack list, generated 01/22/2011 2:16 PM
(0004945E) [776DA45E]
——————————————————————————
System : Windows Vista Home Edition, Version: 6.0, Build: 1772, «Service Pack 2»
Memory: 4095; free 4095
Display : 1024×768 pixels, 32 bpp
——————————————————————————
Re: Dynamic SQL Error SQL error code = -206 Column unknown
Post by Max » Sun Jan 23, 2011 10:37 am
Re: Dynamic SQL Error SQL error code = -206 Column unknown
Post by richardri » Sun Jan 23, 2011 8:06 pm
I updated today. jan 23.
It refuses to open the database at all in version 4.
In version 3, when I got the message on startup no database was displayed.
I would then exit out and start the program from quick start icon in the tray.
Again I got the same message but this time my database was open.
I could add to it but could not export it. It does save any changes on exit though.
Now I cannot access the current database.
here are the two messages.
WHEN I FIRST START THE PROGRAM:
There was an error during the execution of this program.
The application might become unstable and even useless.
It’s recommended that you save your work and close this application.
Dynamic SQL Error
SQL error code = -206
Column unknown
OLD.USEGLOBALFOLDERS
Exception log with detailed tech info. Generated on 01/23/2011 1:53 PM.
You may send it to the application vendor, helping him to understand what had happened.
Application title: EssentialPIM
Application file: C:Program Files (x86)EssentialPIMEssentialPIM.exe
Application: EssentialPIM 4.01
——————————————————————————
Exception class: EIBInterBaseError
Exception message: Dynamic SQL Error
SQL error code = -206
Column unknown
OLD.USEGLOBALFOLDERS
At line 5, column 10.
Exception address: 004CEEB3
——————————————————————————
Main thread > Exception thread > ——————————————————————————
Active Controls:
1927376 ExceptionDialog TextMemo
NOW AFTER I EXIT AND TRY TO START WITH THE QUICK START ICONIN THE TRAY
There was an error during the execution of this program.
The application might become unstable and even useless.
It’s recommended that you save your work and close this application.
unsuccessful metadata update
STORE RDB$RELATION_FIELDS failed
attempt to store duplicate value (visible to active transactions) in unique index «RDB$INDEX_15».
Источник
Adblock
detector
Проблема с простым запросом
-
SeGun
- Сообщения: 5
- Зарегистрирован: 29 ноя 2005, 17:55
Проблема с простым запросом
Здравствуйте.
Скачал Firebird-2.5.1.26351_1_Win32
Среда Delphi 7
Пытаюсь выполнить запрос
DM1.QAnketa_Rep.SQL.Text:=’SELECT country, count(country) FROM TESTS WHERE DZT Between ‘+'»‘+SD1+'»‘+’ AND ‘+'»‘+SD2+'»‘+’ GROUP BY COUNTRY’;
Где SD1 и SD2
SD1:=DateToStr(Form2.DateTimePicker1.DateTime);
SD2:=DateToStr(IncDay((Form2.DateTimePicker2.DateTime),1));
В ответ получаю сообщение:
EIBInterBase error
Dynamic SQL Error
SQL Error Code = -206 column UnKnown
14.12.11 {Это дата из базы поле DZT}
at line 1 column 72
Хотя такой запрос:
select country, count(country) from tests where dzt between ‘09.01.12’ and ‘09.01.12’ group by country
Успешно возвращает результат в IBExpert
-
kdv
- Forum Admin
- Сообщения: 6595
- Зарегистрирован: 25 окт 2004, 18:07
Re: Проблема с простым запросом
Сообщение
kdv » 14 янв 2012, 22:51
Вообще-то, поскольку формат даты может отличаться на разных компьютерах, я бы рекомендовал использовать параметры вместо подстановки дат в виде строк в запрос.
собственно, по проблеме — используйте компонент IBSQLMonitor или отладчик, чтобы увидеть, какой запрос на самом деле находится в SQL.Text. Вы уверены, что там то же самое, что вы выполняете в IBExpert? А там не то же самое, там вот что
select country, count(country) from tests where dzt between «09.01.12» and «09.01.12» group by country
а двойные кавычки, как известно, в третьем диалекте служат для обрамления «квотируемых идентификаторов»
http://www.ibase.ru/ibfaq.htm#dial
-
SeGun
- Сообщения: 5
- Зарегистрирован: 29 ноя 2005, 17:55
Re: Проблема с простым запросом
Сообщение
SeGun » 14 янв 2012, 23:18
Спасибо за подсказку.
Нашел вот такое решение:
DM1.QAnketa_Rep.SQL.Text:=’SELECT country, count(country) FROM TESTS WHERE DZT Between »’+FormatDateTime(‘dd/mm/yyyy’,DTS)+»’ AND »’+FormatDateTime(‘dd/mm/yyyy’,DTPO)+»’ GROUP BY COUNTRY’;
где:
DTS:=Form2.DateTimePicker1.DateTime;
DTPO:=Form2.DateTimePicker2.DateTime;
Проблема решена.
-
kdv
- Forum Admin
- Сообщения: 6595
- Зарегистрирован: 25 окт 2004, 18:07
Re: Проблема с простым запросом
Сообщение
kdv » 15 янв 2012, 14:27
используйте ПАРАМЕТРЫ! К чему эти лишние преобразования?
Код: Выделить всё
QAnketa_Rep.SQL.Clear;
QAnketa_Rep.SQL.Add('select country, count(country) from tests where dzt between :dt1 and :dt2 group by country');
QAnketa_Rep.Prepare;
QAnketa_Rep.ParamByName('dt1').asDateTime:=DateTimePicker1.DateTime;
QAnketa_Rep.ParamByName('dt2').asDateTime:=DateTimePicker2.DateTime;
QAnketa_Rep.Open;И все. Откуда это стремление нагородить побольше кривого кода?