Ошибка dynamic sql error sql - ErrorsMaster.ru - большая энциклопедия ошибок и их решений

Here is the error:

Dynamic SQL Error    
SQL error code = -104    
Token unknown - line 1, column 162    
VALUE

Here is the code:

using (FbDataAdapter da = new FbDataAdapter(@"SELECT DOC_ITEMS.ID, PRODUCTS.PRODUCTKEY, PRODUCTS.NAME, DOC_ITEMS.QUANTITY, UNITS.UNIT, DOC_ITEMS.PRICE, DOC_ITEMS.TAX, (DOC_ITEMS.PRICE * DOC_ITEMS.QUANTITY) AS VALUE
                        FROM PRODUCTS INNER JOIN
                        DOC_ITEMS ON PRODUCTS.PRODUCTID = DOC_ITEMS.PRODUCTID INNER JOIN
                        UNITS ON PRODUCTS.UNITID = UNITS.UNITID
                        WHERE (DOC_ITEMS.DOCUMENTID = @DocumentID)", con))

{
    da.SelectCommand.Parameters.AddWithValue("@DocumentID", documentId);

    DataTable dt = new DataTable();
    da.Fill(dt);
    dataGridView1.DataSource = dt;

    dataGridView1.Columns["PRODUCTKEY"].AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells;
    dataGridView1.Columns["ID"].Visible = false;
    dataGridView1.Columns["NAME"].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
    dataGridView1.Columns["QUANTITY"].AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells;
    dataGridView1.Columns["QUANTITY"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight;
    dataGridView1.Columns["UNIT"].AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells;
    dataGridView1.Columns["PRICE"].AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells;
    dataGridView1.Columns["PRICE"].DefaultCellStyle.Format = "0.00 $";
    dataGridView1.Columns["TAX"].AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells;
    dataGridView1.Columns["TAX"].DefaultCellStyle.Format = "0\%";
    dataGridView1.Columns["VALUE"].AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells;
    dataGridView1.Columns["VALUE"].DefaultCellStyle.Format = "0.00 $";
}

When I run this command through my database directly it is working ok but inside my c# code it drops this error.

asked Nov 19, 2017 at 11:06

Use ""VALUE"" with double quotes since one quote will close your string.

answered Nov 19, 2017 at 11:23

Aleksa RisticAleksa Ristic

2,3743 gold badges23 silver badges53 bronze badges

VALUE is a reserved word in Firebird, this means it can’t be used in a query as an object name. You need to either use a different name, or explicitly quote it as "VALUE", so the query parser knows it is not a reserved word.

answered Nov 19, 2017 at 11:56

Mark RotteveelMark Rotteveel

99.4k188 gold badges137 silver badges192 bronze badges

I’m trying to create a table in my Interbase database.

Dynamic SQL Error
SQL error code = -104
Unexpected end of command

and this is my table :

CREATE TABLE Medecin(
    Code Integer ,
    Nom varchar(30) ,
    prénom varchar(30) ,
    spécialité varchar(30) ,
    Adresse varchar(50) ,
    telephone varchar(14)
);

What is wrong here?

answered Apr 3, 2018 at 8:39

Источник

Remove From My Forums

Вопрос

I can’t figure out why this dynamic SQL query is throwing the following error …

DECLARE @WorksheetDate date;
SET @sqlStr = N'SELECT @WorksheetDate = CAST(ltrim(rtrim(F2)) as date)
	FROM OPENROWSET(''Microsoft.ACE.OLEDB.12.0''
	,''Excel 8.0; Database=' + @FromFile + ''' 
	,''SELECT * FROM [Sheet1$] WHERE F1 like ''''AUM as of%'''''');'
EXEC sp_executesql @sqlStr, N'@WorksheetDate date OUTPUT', @WorksheetDate OUT

Error #137: «Must declare the scalar variable «@WorksheetDate».

Any help?

Darrell H Burns

Источник

�� 10. ��

�� , �� PSQL �� Firebird 1.5.0, �� . �10.1. �� Firebird. �� , �� firebird.msg (interbase.msg �� Firebird 1.0.x), �� Firebird. �� MSG-�� , �� , �� .

�� 10.1. �� Firebird 1.5.0

SQLCODE

GDSCODE

��

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.

�� , ��

100

335544374

stream eof

-Attempt to fetch past the last record in a record stream.

��

-84

335544554

nonsql security rel

-Table/procedure has non-SQL security class defined.

�� /�� , �� SQL

-84

335544555

nonsql security fid

-Column has non-SQL security class defined.

�� , �� SQL

-84

335544668 —

dsql_procedure use err

-Procedure <string> does not return any values.

�� <��> ��

-85

335544747

usrname too_long

-The username entered is too long. Maximum length is 31 bytes.

�� . �� 31 ��

-85

335544748

password too long

-The password specified is too long. Maximum length is 8 bytes.

�� . �� 8 ��

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

�� BLR �� <��>

-104

335544390

syntaxerr

-BLR syntax error: expected <string> at offset <number>, encountered <number>.

�� BLR: �� <��> �� <��>, �� <��>

-104

335544425

ctxinuse

-Context already in use (BLR error).

�� (�� BLR)

-104

335544426

ctxnotdef

-Context not defined (BLR error). �� (�� BLR)

-104

335544429

badparnum

-Bad parameter number. ��

-104

335544440

bad msg vec

—

-104

335544456

invalid sdl

-Invalid slice description language at offset <number>.

�� <��>

-104

335544570

dsql_comrttand_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 <number>, char <number>.

�� — �� <��>, �� <��>

-104

335544709

dsql agg_ref err

-Invalid aggregate reference. ��

-104

335544714

invalid_array_id

-Invalid blob id. �� BLOB

-104

335544730

cse not_supported

-Client/Server Express not supported in this release.

Client/Server Express ��

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

DATE �� TIMESTAMP

-104

335544796

sql dialect datatype_ unsupport

-Client SQL dialect <number> does not support reference to <string> datatype.

SQL-�� <��> �� <��>

-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 <string> clause.

� �� <��> ��

-104

335544822

dsql agg_where err

-Cannot use an aggregate function in a WHERE clause, use HAVING instead.

�� WHERE, �� HAVING

-104

335544823

dsql_agg_group_err

-Cannot use an aggregate function in a GROUP BY clause.

�� GROUP BY

-104

335544824

dsql_agg_column_err

-Invalid expression in the <string> (not contained in either an aggregate function or the GROUP BY clause).

�� <��> (�� , �� GROUP BY)

-104

335544825

dsql_agg_having_err

-Invalid expression in the <string> (neither an aggregate function nor a part of the GROUP BY clause).

�� <��> (�� , �� GROUP BY)

-104

335544826

dsql_agg nested_err

-Nested aggregate functions are not allowed.

��

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

�� 10 �� 18 � SQL-�� 1 �� DOUBLE PRECISION �� 64-�� SQL-�� 3

-104

336003077

sql db_dialect_dtype unsupport

-Database SQL dialect <number> does not support reference to <string> datatype.

�� SQL <��> �� <��>

-104

336003087

dsql invalid label

-Label <string> <string> in the current scope.

�� <��> <��> ��

-104

336003088

dsql datatypes not comparable

-Datatypes <string> are not comparable in expression <string>.

�� <��> �� <��>

-105

335544702

like_escape invalid

-Invalid ESCAPE sequence. �� ESCAPE

-105

335544789

extract input_mismatch

-Specified EXTRACT part does not exist in input datatype.

�� EXTRACT ��

-150

335544360

read only rel

-Attempted update of read-only table.

��

-150

335544362

read only view

-Cannot update read-only view <string>.

�� <��>

-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

-<string> is not a valid base table of the specified view.

<��> ��

-157

335544598

specify_field err

-Must specify column name for view select expression.

�� SELECT ��

-158

335544599

num field_err

-Number of columns does not match select list.

�� SELECT

-162

335544685

no dbkey

-Dbkey not available for multi- table views.

��

-170

335544512

prcmismat

-Parameter mismatch for procedure <string>.

�� <��>

-170

335544619

extern_func_err

-External functions cannot have more than 10 parameters.

�� 10 ��

-171

335544439

funmismat

-Function <string> could not be matched.

�� <��> ��

-171

335544458

invalid_dimens ion

-Column not array or invalid dimensions (expected <number>, encountered <number>).

�� (�� <��>, �� <��>)

-171

335544618

return_mode err

-Return mode by value not allowed for this data type.

��

-172

335544438

funnotdef

-Function <string> is not defined.

�� <��> ��

-203

335544708

dyn fld_ambiguous

-Ambiguous column reference. ��

-204

335544463

gennotdef

-Generator <string> is not defined.

�� <��> ��

-204

335544502

stream not defined

-Reference to invalid stream number.

��

-204

335544509

charset_not found

-CHARACTER SET <string> is not defined.

�� <��> ��

-204

335544511

prcnotdef

-Procedure <stiing> is not defined.

�� <��> ��

-204

335544515

codnotdef

-Status code <string> unknown. �� <��>

-204

335544516

xcpnotdef

-Exception <string> not defined. He �� <��>

-204

335544532

ref cnstrnt_notfound

-Name of Referential Constraint not defined in constraints table.

��

-204

335544551

grant obj_notfound

-Could not find table/procedure for GRANT.

�� /��

�� GRANT

-204

335544568

text_subtype

-Implementation of text subtype . <number> 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 <string> is not defined.

�� <��> ��

-204

335544589

collation not for charset

-COLLATION <string> is not valid for specified CHARACTER SET..

�� <��> ��

-204

335544595

dbql_trigge r_e � �

-Trigger unknown. ��

-204

335544620

alias conflict err

-Alias <string> conflicts with an alias in the same statement. �� <��> ��

-204

335544621

procedure conflict_error

-Alias <string> conflicts with a procedure in the same statement.

�� <��> ��

-204

335544622

relation_conflict err

-Alias <string> conflicts with a table in the same statement.

�� <��> ��

-204

335544635

dsql_no relation_alias

-There is no alias or table named <string> at this scope level.

�� <��> ��

-204

335544636

indexname

-There is no index <string> for table <string>.

�� <��> �� <��>

-204

335544640

collation requires_text

-Invalid use of CHARACTER SET or COLLATE.

��

-204

335544662

dsql blob type unknown

-BLOB SUB_TYPE <string> is not defined.

�� BLOB <��> ��

-204

335544759

bad default value

-Can not define a not null column with NOLL as default value.

�� (NOT NULL) �� NULL

-204

335544760

invalid clause

-Invalid clause-‘<string>’. �� — ‘<��>’

-204

335544800

too many contexts

-Too many Contexts of Relation/Procedure/Views. Maximum allowed is 127.

�� /��/��. �� 127

-204

335544817

bad limitjparam

-Invalid parameter to FIRST. Only integers >= 0 are allowed.

�� FIRST. �� >= 0

-204

335544818

bad skipjparam

-Invalid parameter to SKIP. Only integers >= 0 are allowed.

�� SKIP. �� >= 0

-204

336003085

dsql ambiguous field_name

-Ambiguous field name between <string> and <string>.

�� <��> � <��>

-205

335544396

fldnotdef

-Column <string> is not defined in table <string>.

�� <��> �� <��>

-205

335544552

grant fid notfound

-Could not find column for GRANT.

�� GRANT

-206

335544578

dsql_field_err

-Column unknown. ��

-206

335544587

dsql blob err

-Column is not a BLOB.

�� BLOB

-206

335544596

dsql_subselect_err

-Subselect illegal in this context.

�� SELECT ��

-208

335544617

order by err

-Invalid ORDER BY clause. �� ORDER BY

-219

335544395

relnotdef

-Table <string> is not defined. �� <��> ��

-239

335544691

cache too small

-Insufficient memory to allocate page buffer cache.

��

-260

335544690

cache_redef

-Cache redefined. ��

-281

335544637

no stream_jplan

-Table <string> is not referenced in plan.

�� <��> ��

-282

335544638

stream twice

-Table <string> is referenced more than once in plan; use aliases to distinguish.

�� <��> �� ; ��

-282

335544643

ds ql_s elf_j oin

-The table <string> is referenced twice; use aliases to differentiate.

�� <��> � �� ; ��

-282

335544659

duplicate base_table

-Table <string> is referenced twice in view; use an alias to distinguish.

�� <��> � �� ; ��

-282

335544660

view_alias

-View <string> has more than one base table; use aliases to distinguish.

�� <��> �� ; ��

-282

335544710

complex view

-Navigational stream <number> references a view with more than one base table.

�� <��> ��

-283

335544639

stream_not_found

-Table <string> is referenced in the plan but not the from list.

�� <��> �� , ��

-284

335544642

-index unused

-Index <string> cannot be used in the specified plan.

�� <��> ��

-291

335544531

primary_key_notnull

-Column used in a PRIMARY KEY constraint must be NOT NOLL.

��, �� , �� NOT NULL

-292

335544534 1

ref cnstrnt update

-Cannot update constraints (RDB$REF_CONSTRAINTS).

�� (RDB$REF CONSTRAINTS)

-293

335544535

check_cnstrnt_update

-Cannot update constraints (RDB$CHECK_CONSTRAINTS).

�� (RDB$REF_CONSTRAINTS)

-294

335544536

check cnstrnt del

-Cannot delete CHECK constraint entry (RDB$CHECK_CONSTRAINTS).

�� CHECK (RDB$REF_CONSTRAINTS)

-295

335544545

rel cnstrnt update

-Cannot update constraints (RDB$RELATION_CONSTRAINTS) .

�� (RDB$RELATION_CONSTRAINTS)

-296

335544547

invld_cnstrnt_type

-Internal gds software consistency check (invalid RDB$CONSTRAINT_TYPE).

�� gds (�� RDB$CONSTRAINT_YYPE)

-297

335544558

check constraint

-Operation violates CHECK constraint <string> on view or table <stiing>.

�� CHECK <��> �� <��>

-313

335544669

dsql count mismatch

-Count of column list and variable list do not match.

��

-314

335544565

transliteration failed

-Cannot transliterate character between character sets.

��

-315

336068815

dyn dtype invalid

-Cannot change datatype for column <string>. Changing datatype is not supported for BLOB or ARRAY columns. �� <��>. �� BLOB � ��

-383

336068814

dyn dependency exists

-Column <string> from table <string> is referenced in <string>.

�� <��> �� <��> �� <��>

-401

335544647

invalid_operator

-Invalid comparison operator for find operation.

��

-402

335544368

segstr_no_op

-Attempted invalid operation on a BLOB.

�� BLOB

-402

335544414

blobnotsup

-BLOB and array data types are not supported for <string> operation.

�� BLOB � �� <��>

-402

335544427

datnotsup

-Data operation not supported. ��

-406

335544457

out of_bounds

-Subscript out of bounds. ��

-407

335544435

nullsegkey

-Null segment of UNIQUE KEY. ��

-413

335544334

convert error

-Conversion error from string «<string>».

�� ‘<��>’

-413

335544454

nofilter

-Filter not found to convert type <number> to type <number>.

�� <��> � �� <��>

-501

335544327

bad_req_handle

-Invalid request handle. ��

-501

335544577

dsql cursor close err

-Attempt to reclose a closed cursor.

��

-502

-335544574

-dsql decl err

-Declared cursor already exists. ��

-502

-335544576

-dsql cursor_open err

-Attempt to reopen an open cursor.

��

-504

-335544572

-dsql_cursor_err

-Cursor unknown.

��

-508

-335544348

-no_cur_rec

-No current record for fetch operation.

��

-510

-335544575

-dsql cursor update err

-Cursor 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 «<string>» on table «<string>».

�� «<��>» �� «<��>»

-531

-335544597

-dsql crdb_prepare err

-Cannot prepare a CREATE DATABASE/SCHEMA statement.

�� CREATE DATABASE/SCHEMA

-532

-335544469

-trans invalid

-Transaction marked invalid by I/O error.

�� -�� /��

-551

-335544352

-no_priv

-No permission for <string> access to <string> <string>.

�� <��> � <��>

-551

-335544790

-insufficient svcjorivile ges

-Service <string> requires SYSDBA permissions. Reattach to the Service Manager using the SYSDBA account.

�� <��> �� SYSDBA. �� SYSDBA

-552

-335544550

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

�� /��

-553

-335544529

-existing_priv mod

-Cannot modify an existing user privilege.

��

-595

-335544645

-stream crack

-The current position is on a crack.

��

-596

-335544644

-stream bof

-Illegal operation when at beginning of stream.

�� , ��

-597

-335544632

-dsql_file length err

-Preceding file did not specify length, so <string> must include starting page number.

�� , ��, <��> ��

-598

-335544633

-dsql_shadow number err

-Shadow number must be a positive integer.

��

-599

-335544607

-node err

-Gen.�: node not supported. �� Gen, � ��

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

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

�� /BLOB/DATE ��

-607

-335544746

-reftable requires_pk

-«REFERENCES table» without «(column)» requires PRIMARY KEY on referenced table.

«REFERENCES ��» �� , ��

-607

-335544815

-generator name

-GENERATOR <string>. �� <��>

-607

-335544816

-udf name

-UDF <string>.

UDF <��>

-607

-336003074

-dsql_dbkey_fram_non_table

-Cannot SELECT RDB$DB_KEY from a stored procedure.

�� SELECT RDB$DB_KEY ��

-607

-336003086

?-dsql udf return_pos err

-External function should have return position between 1 and <number>.

�� 1 � <��>

-612

-336068812

-dyn_domain_name exists

-Cannot rename domain <string> to <string>. A domain with that name already exists.

�� <��> � <��>. ��

-612

-336068813

-dyn field name exists

-Cannot rename column <string> to <string>. A column with that name already exists in table <string>.

�� <��> � <��>. �� <��>

-615

-335544475

-relation lock

-Lock on table <string> conflicts with existing lock.

�� <��> ��

-615

-335544476

-record_lock

-Requested record lock conflicts with existing lock.

��

-615

-335544507

-range in_use

-Refresh range number <number> 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.

�� , ��

?3?

-616

-33554454?

-check trig del

-Cannot delete trigger used by a CHECK Constraint.

�� , �� CHECK

-616

-335544543

-cnstrnt_fld_del

-Cannot delete column being used in an Integrity Constraint.

�� , ��

-616

-335544630

-dependency

-There are <number> 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 primary index.

��

-617

-335544542

— che � k_t r i g_upda t e

-Cannot update trigger used by a CHECK Constraint.

�� , �� CHECK

-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

-lot valid

-Validation error for column <string>, value «<string>».

�� <��>, �� «<��>»

-637

-335544664

-dsql duplicate spec

-Duplicate specification of <string> — not supported.

�� <��> ��

-660

-335544533

-foreign key notfound

-Non-existent PRIMARY or UNIQUE KEY specified for FOREIGN KEY.

�� , ��

-660

-335544628

-idx create err

-Cannot create index <string>. �� <��>

-663

-335544624

-idx seg err

-Segment count of 0 defined for index <string>.

�� 0 �� <��>

-663

-335544631

-idx key err

-Too many keys defined for index <string>.

�� <��>

-663

-335544672

-key field err

-Too few key columns found for index <string> (incorrect column name?).

�� <��> (�� ?)

-664

-335544434

-keytoobig

-Key size exceeds implementation restriction for index «<string>».

�� «<��>»

-677

-335544445

-ext err

-<string> extension error/ �� <��>

-685

-335544465

-bad segstr type

-Invalid BLOB type for operation. �� BLOB ��

-685

-335544670

-blob idx err

-Attempt to index BLOB column in index <string>.

�� BLOB � �� <��>

-685

-335544671

-array_idx_err

-Attempt to index array column in index <string>.

�� <��>

-689

-335544403

-badpagtyp

-Page <numbe2T> is of wrong type (expected <number>, found <number>) .

�� <��> �� (�� <��>, �� <��>)

-689

-335544650

-page_type_err

-Wrong page type. ��

-690

-335544679

-no segments_err

-Segments not allowed in expression index <string>.

�� <��>

-691

-335544681

-rec size err

-New record size of <number> bytes is too big.

�� <��> ��

-692

-335544477

-max_idx

-Maximum indexes per table (<number>) exceeded.

�� (<��>)

-693

-335544663

-req_max clones exceeded

-Too many concurrent executions of the same request.

��

-694

-335544684

-no field access

-Cannot access column <string> in view <strlng>.

�� <��> � �� <��>

-802

-335544321

-arith except

-Arithmetic exception, numeric overflow, or string truncation.

�� , ��

-803

-335544349

-no dup

-Attempt to store duplicate value (visible to active transactions) in unique index «<string>».

�� (�� ) � �� <��>

-803

-3355446651

-unique key violation

-Violation of PRIMARY or UNIQUE KEY constraint «<string>» on table «<string>».

�� «<��>» �� «<��>»

-804

-335544380

-wronumarg

-Wrong number of arguments on call.

��

-804

-335544583

-dsql_sqlda_err

-SQLDA missing or incorrect version, or incorrect number/type of variables.

SQLDA ��

-804

-335544586

-dsql_function_err

-Function unknown. ��

-804

-335544713

-dsql sqlda value_err

-Incorrect values within SQLDA structure.

�� SQLDA

-806

-335544600

-col name err

-Only simple column names permitted for VIEW WITH CHECK OPTION.

�� VIEW WITH CHECK OPTION

-807

-335544601

-where_err

-No WHERE clause for VIEW WITH CHECK OPTION.

�� WHERE �� VIEW WITH CHECK OPTION

-808

-335544602

-table view err

-Only one table allowed for VIEW WITH CHECK OPTION.

�� VIEW WITH CHECK OPTION

-809

-335544603

-distinct err

-DISTINCT, GROUP or HAVING not permitted for VIEW WITH CHECK OPTION.

�� DISTINCT, GROUP �� HAVING � VIEW WITH CHECK OPTION

-810

-335544605

-subquery err

-No subqueries permitted for VIEW WITH CHECK OPTION.

�� VIEW WITH CHECK OPTION

-811

-335544652

-sing select_err

-Multiple rows in singleton select.

�� 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 <string>.

�� <��>

-817

-335544361

-read only trans

-Attempted update during readonly transaction.

��

-817

-335544371

-segstr no write

-Attempted write to read-only BLOB.

�� 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 <string> is not supported in this database.

�� SQL <��> ��

-817

-335544793

-ddl not allowed_by_db sq 1 dial

-Metadata update statement is not allowed by the current database SQL dialect <number>.

�� SQL �� <��>

-817

-336003079

-isc sql dialect_conflict num

-DB dialect <number> and client dialect <number> conflict with respect to numeric precision <number>.

�� <��> � �� <��> �� <��>

-820

-335544356

-obsolete metadata

-Metadata is obsolete. ��

-820

-335544379

-wrong ods

-Unsupported on-disk structure for file <string>; found <number>, support <number>.

�� (ODS) �� <��> �� <��>, �� <��>

-820

-335544437

-wrodynver

-Wrong DYN version. �� DYN

-820

-335544467

-high minor

-Minor version too high found <number> expected <number>.

�� <��>, �� <��>

-823

-335544473

-invalid_bookmark

-Invalid bookmark handle. ��

-824

-335544474

-bad lock_level

-Invalid lock level <number>.

�� <��>

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

-Invalid key position. ��

-829

-335544616

-field ref err

-Invalid column reference. ��

-829

-336068816

-dyn char fid too small

-New size specified for column <string> must be at least <number> characters.

�� <��> �� , �� , <��> ��

-829

-336068817

-dyn invalid dtype conversion

-Cannot change datatype for <string>. Conversion from base type <string> to <string> is not supported.

�� <��>. �� <��> � <��> ��

-829

-336068818

-dyn dtype conv_invalid

-Cannot change datatype for column <string> from a character type to a non-character type.

�� <��> �� , ��

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

��

-834

-335544508

-range not_found

-Refresh range number <number> not found.

�� <��> ��

-835

-335544649

-bad checksum

-Bad checksum. ��

-836

-335544517

-except

-Exception <number>. �� <��>

-837

-335544518

-cache_restart

-Restart shared cache manager.

��

-838

-335544560

-shutwarn

-Database <string> shutdown in <number> seconds.

�� <��> �� <��> ��

-841

-335544677

-version err

-Too many versions. ��

-842

-335544697

-precision_err

-Precision must be from 1 to 18. �� 1 � 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

-335544328

-bad segstr handle

Invalid BLOB handle. �� BLOB

-901

-335544329

-bad_segstr id

Invalid BLOB ID. �� BLOB

-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 <number> 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 (<number>) to preserve data integrity.

�� (<��>) ��

-901

-335544345

-lock conflict

-Lock conflict on no wait transaction.

�� NO WAIT

-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. BLOB ��

-901

-335544357

-open_trans

-Cannot disconnect database with open transactions (<number> active).

�� (�� <��>)

-901

-335544358

-port_len

-Message length error (encountered <number>, expected <number>) .

�� (�� <��>, �� <��>)

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

�� , �� BLOB

-901

-335544370

-segstr no trans

-Attempted action on blob outside transaction.

�� BLOB ��

-901

-335544372

-segstr_wrong db

-Attempted reference to BLOB in unavailable database.

�� BLOB � ��

-901

-335544376

-unres rel

-Table <string> was omitted from the transaction reserving list.

�� <��> ��

-901

-335544377

-uns_ext

-Request includes a DSRI extension not supported in this implementation.

�� DSRI, ��

-901

-335544378

-wish_list

-Feature is not supported. ��

-901

-335544382

-random

-<string>. <��>

-901

-335544383

-fatal conflict

-Unrecoverable conflict with limbo transaction <number>.

�� <��>

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

�� <��>

-901

-335544443

-noargacc_write

-Database system cannot write argument <number>.

�� <��>

-901

-335544450

-misc interpreted

-<string>. <��>

-901

-335544468

-tra state

-Transaction <number> is <string> �

�� <��> �� <��>

-901

-335544485

-bad stmt_handle

-Invalid statement handle. ��

-901

-335544510

-lock timeout

-Lock time-out on wait transaction.

�� WAIT

-901

-335544559

-bad svc_handle

-Invalid service handle. ��

-901

-335544S61

-wrospbver

-Wrong version of service parameter block.

��

-901

-335544562

-bad_spb_form

-Unrecognized service parameter block.

��

-901

-335544563

-svcnotdef

-Service <string> is not defined. �� <��> ��

-901

-335544609

-index name

-INDEX <string>. �� <��>

-901

-335544610

-exception_name

-EXCEPTION <string>. �� <��>

-901

-335544611

-field_name

-COLUMN <string>. �� <��>

-901

-335544613

-union_err

-Union not supported. ��

-901

-335544614

-dsql_construct err

-Unsupported DSQL construct. �� DSQL

-901

-335544623

-dsql_domain err

-Illegal use of keyword VALUE. �� VALUE

-901

-335544626

-table name

-TABLE <string>. �� <��>

-901

-335544627

-proc_name

-PROCEDURE <string>. �� <��>

-901

-335544641

-dsql domain not found

-Specified domain or source column <string> does not exist.

�� <��> ��

-901

-335544656

-dsql_var conflict

-Variable <string> conflicts with parameter in same procedure.

�� <��> ��

-901

-335544666

-srvr_version_too_old

-Server version too old to support all CREATE DATABASE options.

�� CREATE DATABASE

-901

-335544673

-no delete

-Cannot delete. ��

-901

-335544675

-sort err

-Sort error. ��

-901

-335544703

-svpnoexe

-Service <string> does not have an associated executable.

�� <��> ��

-901

-335544704

-net lookup err

-Failed to locate host machine. �� -��

-901

-335544705

— s e rvi ce_un known

-Undefined service <string>/<string>.

�� <cmpo- ��>/<��>

-901

-335544706

-host unknown

-The specified name was not found in the hosts file or Domain Name Services.

�� hosts ��

-901

-335544711

-unprepared stmt

-Attempt to execute an unprepared dynamic SQL statement.

�� SQL

-901

-335544716

-svc in use

-Service is currently busy: <string>.

� ��

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

��

� RDB$USER PRIVILEGES

-901

-335544767

-blob filter exception

-A fatal exception occurred during the execution of a blob filter.

�� BLOB

-901

-335544768

-exception_access_ violation

-Access violation. The code attempted to access a virtual address without privilege to do so.

�� . ��

-901

-335544769

-Datatype misalignment. The attempted to read or write a value that was not stored on a memory boundary.

�� . �� , ��

-901

-335544770

-Array bounds exceeded. The code attempted to access an array element that is out of bounds.

�� . �� , ��

-901

-335544771

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

-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 %X.

�� , �� . �� %x

-901

-335544781

-except.ion_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 perform 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.

�� . �� SYSDBA, ��

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

�� <��>

-901

-335544805

-inv dialect specified

-Database dialect <number> is not a valid dialect.

�� <��> ��

-901

-335544806

-valid_db_dialects

-Valid database dialects are <string>.

�� <��>

-901

-335544811

-inv_client_dialect_speci fied

-Passed client dialect <number> is not a valid dialect.

�� <��> ��

-901

-335544812

-valid_client_dialects

-Valid client dialects are <string>.

�� <��>

-901

-335544814

-service_not supported

-Services functionality will be supported in a later version of the product

��

-901

-335740929

-gfix db name

-Data base file name (<string>) already given.

�� (<��>) ��

-901

-335740930

-gfix_invalid_sw

-Invalid switch <string>. �� <��>

-901

-335740932

-gfix incmp sw

-Incompatible switch combination.

��

-901

-335740933

-gfix_replay_req

-Replay log pathname required. ��

-901

-335740934

-gfix pgbuf req

-Number of page buffers for cache required.

��

-901

-335740935

-gfix val req

-Numeric value required. ��

-901

-335740936

-gfix_pval req

-Positive numeric value required.

��

-901

-335740937

-gfix trn_req

-Number of transactions per sweep required.

��

-901

-335740940

-gfix_full_req

-«full» or «reserve» required �� «full» �� «reserve»

-901

-335740941

-gfix usrname req

-User name required. ��

-901

-335740942

-gfix_pass req

-Password required. ��

-901

-335740943

-gfix subs name

-Subsystem name. ��

-901

-335740945

-gfix sec req

-Number of seconds required. ��

-901

-335740946

-gfix nval req

-Numeric value between 0 and 32767 inclusive required.

�� 9 � 32 767, ��

-901

-335740347

-gfix type shut

-Must specify type of shutdown. ��

-901

-335740948

-gfix retry

-Please retry, specifying an option.

��, ��, ��

-901

-335740951

-gfix retry db

-Please retry, giving a database name.

��, ��, ��

-901

-335740991

-gfix exceed max

-Internal block exceeds maximum size.

��

-901

-335740992

-gfix_corrupt pool

-Corrupt pool. ��

-901

-335740993

-gfix mem exhausted

-Virtual memory exhausted. ��

-901

-335740994

-gfix bad_pool

-Bad pool id.

��

-901

-335740995

-gfix trn_not_valid

-Transaction state <number> not in valid range.

�� <��> ��

-901

-335741012

-gfix unexp eoi

-Unexpected end of input. ��

-901

-335741018

-gfix recon fail

-Failed to reconnect to a transaction in database <string>.

�� <��>

-901

-335741036

-gfix trn unknown

-Transaction description item unknown.

��

-901

-335744038

-gfix mode req

-«read only» or «read write» required.

�� «�� » �� «�� »

-901

-336068796

-dyn_role_does_not_exist

-SQL role <string> does not exist.

�� SQL <��>

-901

-336068797

-dyn no grant admin opt

-Dser <string> has no grant admin option on SQL role <string>.

�� <��> �� SQL <��>

-901

-336068798

-dyn user not role member

-User <string> is not a member of SQL role <string>.

�� <��> �� SQL <��>

-901

-336068799

-dyn delete role failed

-<string> is not the owner of SQL role <string>.

<��> �� SQL <��>

-901

-336068800

-dyn grant role to user

-<string> is a SQL role and not a user.

<��> �� SQL, � ��

-901

-336068801

-dyn inv sql role name

-User name <string> could not be used for SQL role. �� <��> �� SQL

-901

-336068802

-dyn dup sql role

-SQL role <string> already exists.

�� SQL <��> ��

-901

-336068803

-dyn_kywd_spec for role

-Keyword <string> can not be used as a SQL role name.

�� <��> �� SQL

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

�� SQL �� . ��

-901

-336068820

-dyn_zero_len_id

-Zero length identifiers are not allowed.

��

-901

-336330753

-gbak unknown switch

-Found unknown switch. ��

-901

-336330754

-gbak_page size missing

-Page size parameter missing.

��

-901

-336330755

-gbak_page size toobig

-Page size specified (<number>) greater than limit (8192 bytes).

�� (<��>) �� (8192 ��)

-901

-336330756

-gbak redir_ouput missing

-Redirect location for output is not specified.

��

-901

-336330757

-gbak_switches_conflict

-Conflicting switches for backup/restore.

�� /��

-901

-336330758

-gbak_unknown_device

-Device type <string> not known. �� <��> ��

-901

-336330759

-gbak_no_protection

-Protection is not there yet. ��

-901

-336330760

-gbak_page size not allow ed

-Page size is allowed only on restore or create.

��

-901

-336330761

-gbak multi source dest

-Multiple sources or destinations specified.

��

-901

-336330762

-gbak filename missing

-Requires both input and output filenames.

��

-901

-336330763

-gbak dup_inout_names

-Input and output have the same name. Disallowed.

�� . ��

-901

-336330764

-gbak_inv_page_size

-Expected page size, encountered «<string>».

�� , �� «<��>»

-901

-336330765

-gbak db specified

-REPLACE specified, but the first file <string> is a database.

�� REPLACE, �� <��> ��

-901

-336330766

-gbak_db exists

-Database <string> already exists. To replace it, use the-R switch.

�� <��> �� . �� -R

-901

-336330767

-gbak_unk_device

-Device type not specified. He ��

-901

-336330772

-gbak_blob_jlnfo_f ailed

-Gds_$blob_info failed. �� Gds $blob info

-901

-336330773

-gbak unk_blob_item

-Do not understand BLOB INFO item <number>.

�� BLOB INFO <��>

-901

-336330774

-gbak get seg failed

-Gds Sget segment failed. �� B Gds $get segment

-901

-336330775

-gbak close blob failed

-Gds $close blob failed. �� B Gds_$close_blob

-901

-336330776

-gbak open blob failed

-Gds $open_blob failed. �� Gds_$open_blob

-901

-336330777

-gbak_put blr gen id fail ed

-Failed in put blr gen_id. �� B put blr gen id

-901

-336330778

-gbak_unk_type

-Data type <number> not understood.

�� <��> ��

-901

-336330779

-gbak_comp_req_failed

-Gds $compile request failed. �� Gds $compile request

-901

-336330780

-gbak start_req_failed

-Gds Sstart_request failed. �� Gds $start request

-901

-336330781

-gbak_rec failed

— gds $receive failed. �� gds $receive

-901

-336330782

-gbak rel_req_failed

-Gds $ release request failed. �� Gds Srelease request

-901

-336330783

-gbak db info failed

-gds $database info failed. �� gds $database info

-901

-336330784

-gbak no db desc

-Expected database description record.

��

-901

-336330785

-gbak db create failed

-Failed to create database <string>.

�� <��>

-901

-336330786

-gbak decomp len error

-RESTORE: decompression length error.

RESTORE: ��

-901

-336330787

-gbak tbl missing

-Cannot find table <string>. �� <��>

-901

-336330788

-gbak blob col missing

-Cannot find column for BLOB. �� BLOB

-901

-336330789

-gbak create blob failed

-Gds Screate blob failed. �� Gds_$create_blob

-901

-336330790

-gbak_put seg failed

-Gds $put segment failed. �� Gds_$put_segment

-901

-336330791

-gbak rec_len exp

-Expected record length. ��

-901

-336330792

-gbak inv rec len

-Wrong length record, expected <number> encountered <number>.

�� , �� <��>, �� <��>

-901

-336330793

-gbak_exp_data type

-Expected data attribute. ��

-901

-336330794

-gbak gen id failed

-Failed in store blr_gen id. �� store blr gen id

-901

-336330795

-gbak unk_rec type

-Do not recognize record type <number>.

�� <��>

-901

-336330796

-gbak inv_bkup_ver

-Expected backup version 1, 2, or 3. Found <number>.

�� 1, 2 �� 3. �� <��>

-901

-336330797

-gbak missing bkup desc

-Expected backup description record.

��

-901

-336330798

-gbak string trunc

-String truncated. ��

-901

-336330799

-gbak cant rest_record

-Warning-record could not be restored.

�� — ��

-901

-336330800

-gbak send failed

-Gds $send failed. �� Gds_$send

-901

-336330801

-gbak no tbl name

-No table name for data. ��

-901

-336330802

-gbak unexp_eof

-Unexpected end of file on backup file.

��

-901

-336330803

-gbak db_format_too old

-Database format <number> is too old to restore to.

�� <��> ��

-901

-336330804

-gbak inv array_dim

-Array dimension for column <string> is invalid.

�� <��>

-901

-336330807

-gbak xdr_len expected

-Expected XDR record length. ��

-901

-336330817

-gbak open bkup_error

-Cannot open backup file <string>.

�� <��>

-901

-336330818

-gbak open error

-Cannot open status and error output file <string>.

�� <��>

-901

-336330934

-gbak missing block fac

-Blocking factor parameter missing.

�� «�� »

-901

-336330935

-gbak_inv_block_fac

-Expected blocking factor, encountered «<string>».

�� , �� «<��>»

-901

-336330936

-gbak block_fac_specified

-A blocking factor may not be used in conjunction with device CT.

��

-901

-336330940

-gbak missing username

-User name parameter missing.

�� «�� »

-901

-336330941

-gbak missing_password

-Password parameter missing. �� «��»

-901

-336330952

-gbak missing_skipped_byt es

-Missing parameter for the number of bytes to be skipped.

��

-901

-336330953

-gbak inv skipped_bytes

-Expected number of bytes to be skipped, encountered «<string>».

�� , �� «<��>»

-901

-336330965

-gbak err restore charset

-Bad attribute for RDB$CHARACTER_SETS.

�� RDB$CHARACTER SETS

-901

-336330967

-gbak err restore_collati on

-Bad attribute for RDB$COLLATIONS.

�� RDB$COLLATIONS

-901

-336330972

-gbak read error

-Unexpected I/O error while reading from backup file.

�� /��

-901

-336330973

-gbak write_error

-Unexpected I/O error while writing to backup file. �� /��

-901

-336330985

-gbak db in_use

-Could not drop database <string> (database might be in use) .

�� <��> (�� )

-901

-336330990

-gbak sysmemex

-System memory exhausted. ��

-901

-336331002

-gbak restore role failed

-Bad attributes for restoring SQL role.

�� SQL

-901

-336331005

-gbak_role_op_missing

-SQL role parameter missing. �� SQL

-901

-336331010

-gbak_page buffers missing

-Page buffers parameter missing.

��

-901

-336331011

-gbak_page buffers wrong_param

-Expected page buffers, encountered «<string>».

�� , �� «<��>»

-901

-336331012

-gbak_page buffers restore

-Page buffers is allowed only on restore or create.

��

-901

-336331014

-gbak inv size

-Size specification either missing or incorrect for file <string>.

�� <��>

-901

-336331015

-gbak file outof sequence

-File <string> out of sequence.

�� <��> ��

-901

-336331016

-gbak_join file missing

-Can’t join-one of the files missing.

�� — ��

-901

-336331017

-gbak stdin not supptd

-Standard input is not supported when using join operation.

��

-901

-336331018

-gbak_stdout not supptd

-Standard output is not supported when using split operation.

��

-901

-336331019

-gbak bkup corrupt

-Backup file <string> might be corrupt.

�� <��> ��

-901

-336331020

-gbak unk db_file spec

-Database file specification missing.

��

-901

-336331021

-gbak hdr_write failed

-Can’t write a header record to file <string>.

�� <��>

-901

-336331022

-gbak disk space ex

-Free disk space exhausted.

��

-901

-336331023

-gbak size_lt_min

-File size given (<number>) is less than minimum allowed (<number>) .

�� (<��>) �� (<��>)

-901

-336331025

-gbak svc name missing

-Service name parameter missing. ��

-901

-336331026

-gbak not ownr

-Cannot restore over current database, must be SYSDBA or owner of the existing database.

�� , �� SYSDBA ��

-901

-336331031

-gbak mode_req

-«read_only» or «read write» required.

�� «read_only» �� «read write»

-901

-336331033

-gbak just data

-Just data ignore all constraints, etc.

��

-901

-336331034

-gbak data only

-Restoring data only ignoring foreign key, unique, not null s other constraints.

�� , �� , NOT NULL � ��

-901

-33672398�

-gsec cant open_db

-Unable to open database. ��

-901

-336723984

-gsec switches_error

-Error in switch specifications. ��

-901

-336723985

-gsec no op_spec

-No operation specified. He ��

-901

-336723986

-gsec no usr_name

-No user name specified. He ��

-901

-336723987

-gsec err add

-Add record error. ��

-901

-336723988

-gsec err modify

-Modify record error. ��

-901

-336723989

-gsec err find mod

-Find/modify record error. �� /��

-901

-336723990

-gsec err rec_not_found

-Record not found for user: <string>.

�� <��>

-901

-336723991

-gsec err delete

-Delete record error. ��

-901

-336723992

-gsec err find_del

-Find/delete record error. �� /��

-901

-336723996

-gsec err find_disp

-Find/display record error. �� /��

-901

-336723997

-gsec inv _param

-Invalid parameter, no switch defined.

�� , ��

-901

-336723998

-gsec op specified

-Operation already specified. ��

-901

-336723999

-gsec_pw specified

-Password already specified. ��

-901

-336724000

-gsec uid specified

-Uid already specified.

UID ��

-901

-336724001

-gsec gid specified

-Gid already specified. GID ��

-901

-336724002

-gsec_proj_specified

-Project already specified. ��

-901

-336724003

-gsec org specified

-Organization already specified. ��

-901

-336724004

-gsec fname specified

-First name already specified. ��

-901

-336724005

-gsec mname specified

-Middle name already specified. ��

-901

-336724006

-gsec lname specified

-Last name already specified. ��

-901

-336724008

-gsec inv switch

-Invalid switch specified. ��

-901

-336724009

-gsec amb switch

-ambiguous switch specified. ��

-901

-336724010

-gsec no op specified

-No operation specified for parameters.

��

-901

-336724011

-gsec_params not allowed

-No parameters allowed for this operation.

��

-901

-336724012

-gsec incompat switch

-Incompatible switches specified.

��

-901

-336724044

-gsec inv username

-Invalid user name (maximum 31 bytes allowed).

�� (�� 31 ��)

-901

-336724045

-gsec inv_jpw_length

-Warning-maximum 8 significant bytes of password used.

�� — �� 8 ��

-901

-336724046

-gsec_db_specified

-Database already specified. ��

-901

-336724047

-gsec db admin specified

-Database administrator name already specified.

��

-901

-336724048

-gsec db admin_pw_specifi ed

-Database administrator password already specified.

��

-901

-336724049

-gsec sql role specified

-SQL role name already specified.

�� SQL ��

-901

-336920577

-gstat unknown_switch

-Found unknown switch. ��

-901

-336920578

-gstat retry

-Please retry, giving a database name.

��, ��, ��

-901

-336920579

-gstat wrong_ods

-Wrong ODS version, expected <number>, encountered <number>.

�� ODS, �� <��>,�� <��>

-901

-336920580

-gstat unexpected eof

-Unexpected end of database file. ��

-901

-336920605

-gstat open err

-Can’t open database file <string>.

�� <��>

-901

-336920606

-gstat read err

-Can’t read a database page.

��

-901

-336920607

-gstat sysmemex

-System memory exhausted. ��

-902

-335544333

-bug check

-Internal gds software consistency check (<string>).

�� gds (<��>)

-902

-335544335

-db corrupt

-Database file appears corrupt (<string>).

�� (<��>)

-902

-335544344

-io error

-I/O error for file %.0s»<string>» .

�� /�� «<��>»

-902

-335544346

-metadata corrupt

-Corrupt system table. ��

-902

-335544373

-sys request

-Operating system directive <string> 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.

�� ODS

-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 <numbe r>.

�� <��>

-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 <number>, encountered <number>) .

�� BLR (�� <��>, �� <��>)

-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 = <number>. �� SQL = <��>

-902

-335544448

-bad sec_info

—

-902

-335544449

-invalid sec info

—

-902

-335544470

-buf invalid

-Cache buffer for page <number> invalid.

�� <��>

-902

-335544471

-indexnotdefined

-There is no index in table <string> with id <number>.

�� <��> � �� <��>

-902

-335544472

-login

-Your user name and password are not defined. Ask your database administrator to set up a Firebird login.

�� . �� Firebird, ��

-902

-335544506

-shutinprog

-Database <string> shutdown in progress.

�� <��>

-902

-335544528

-shutdown

-Database <string> shutdown. �� <��> ��

-902

-335544557

-shutfail

-Database shutdown unsuccessful. ��

-902

-335544569

-dsql error

-Dynamic SQL Error. �� SQL

-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 insufficient to execute current request.

��

-902

-335544721

-network error

-Unable to complete network request to host «<string>».

�� «<��>»

-902

-335544722

-net_connect_err

-Failed to establish � 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 <string> is same as one of the SQL role name. Ask your database administrator to set up a valid Firebird login.

�� <��> �� , �� SQL. �� Firebird

-902

-335544791

-file_in use

-The file <string> is currently in use by another process. Try again later.

�� <��> � �� . ��

-902

-335544795

-unexp spb form

-Unexpected item in service parameter block, expected <string>.

�� , �� <��>

-902

-335544809

-extern func dir error

-Function <string> is in <string>, 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.

�� 2 ��. �� 64-�� Firebird

-902

-335544820

-invalid_savepoint

-Unable to find savepoint with name <string> in transaction context.

�� <��> � ��

-902

-335544831

-conf access_denied

-Access to <string> «<string>» is denied by server administrator.

�� <��> «<��>» ��

-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 <string> is in use. �� <��> ��

-904

-335544455

-shadow accessed

-Cannot attach active shadow file.

��

-904

-335544460

-shadow missing

-A file in manual shadow <number> 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 <number> bytes is too big.

�� <��> ��

-904

-335544761

-too_many handles

-Too many open handles to database.

��

-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

-Dnsupported field type specified in BETWEEN predicate.

�� BETWEEN

-904

-335544827

-exec sql invalid arg

-Invalid argument in EXECUTE STATEMENT- cannot convert to string.

�� EXECUTE STATEMENT — ��

-904

-335544828

-exec sql invalid req

-Wrong request type in EXECUTE STATEMENT ‘<stzing>’.

�� EXECUTE STATEMENT ‘<��>’

-904

-335544829

-exec sql invalid var

-Variable type (position <number>) in EXECUTE STATEMENT ‘<string>’ INTO does not match returned column type.

�� (�� <��>)

� EXECUTE STATEMENT ‘<��>’ INTO �� .

-904

-335544830

-exec sql max call exceed ed

-Too many recursion levels of EXECUTE STATEMENT.

��

� EXECUTE STATEMENT

-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 <number> is stuck in limbo. �� <��> ��

-913

-335544336

-deadlock

-Deadlock. ��

-922

-335544323

-bad db format

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

-335544464

-cant start logging

-Secondary server attachments cannot start logging.

��

-924

-335544325

-bad dpb content

-Bad parameters on attach or create database.

��

-924

-335544441

-bad detach

-Database detach completed with errors.

��

-924

-335544648

-conn_lost

-Connection lost to pipe server. ��

-926

-335544447

-no rollback

-No rollback performed. ��

-999

-335544689

-ib error

-Firebird error. �� Firebird

Источник

Hi,

I am getting the error below when Adding a Child. The size of the EPIM FRee database is 7G = 7,086,788KB. I am not doing anything special. I am only adding a new child. Have a reach a limit of some sort? At the moment, I can still read current notes and stuff, delete etc. but can’t add. I’ve empty the trash, run optimize and still the same problem. I thought I can delete some, empty trash and then delete but it is the same error message. I am now trying to make a copy of the current file and then delete lots to size it down and se if that helps. Hopefully it does but then that means I am hitting some kind of limits somewhere, number of notes

Any advice much appreciated. Thanks in advance.

There was an error during the execution of this program.
Click «Send» to submit the report to the developer. Please also provide any steps necessary to reproduce the problem.

Dynamic SQL Error
SQL error code = -303
arithmetic exception, numeric overflow, or string truncation.

——————————————————————————
Exception log with detailed tech info. Generated on 25/09/2014 2:05 p.m..
You may send it to the application vendor, helping him to understand what had happened.
Application title: [ Name of the EPIM file and the EPIM Executable = Essential PImportEssentialPIM.exe ]
Application: EssentialPIM Portable 5.82
——————————————————————————
Exception class: EIBInterBaseError
Exception message: Dynamic SQL Error
SQL error code = -303
arithmetic exception, numeric overflow, or string truncation.
Exception address: 00874014
——————————————————————————
Main thread ID = 9664
Exception thread ID = 9664
——————————————————————————
Object Logs:
12839646 SetViewMode OK
12839521 SetViewMode 3
12837837 SetViewMode OK
12837649 SetViewMode 0
12823984 DBOpen

——————————————————————————
Active Controls:
12863873 ExceptionDialog TextMemo
12859240 NotePropDialog Panel1 NameEd
12857181 MainForm FormPan FormPan2 NotesForm TreesTC NotesVT
12855652 MainForm FormPan FormPan2 NotesForm RichEditFrame1 TabsTC RichViewEdit
12855137 AdvertForm HtmlViewer1 TPaintPanel ThtTabControl
12854903 MainForm FormPan FormPan2 NotesForm RichEditFrame1 TabsTC RichViewEdit
12837337 MainForm
12824186 PassDialog GroupBox1 PasswordEd

——————————————————————————
Exception stack
Stack list, generated 25/09/2014 2:05 p.m.
[0087400F] IB.IBDataBaseError (Line 420, «IB.pas» + 39) [0089804E] IBDatabase.TIBTransaction.Call (Line 1665, «IBDatabase.pas» + 11) [0087BB21] IBSQL.TIBSQL.Call (Line 2483, «IBSQL.pas» + 3) [0087BE04] IBSQL.TIBSQL.ExecQuery (Line 2556, «IBSQL.pas» + 50) [00D44166] SyncObj.TNote.StoreUserDataToSQL (Line 5310, «SyncObj.pas» + 7) [0054DB5F] Vcl.Controls.TControl.Click (Line 7340, «Vcl.Controls.pas» + 9)
——————————————————————————
Call stack for main thread
Stack list, generated 25/09/2014 2:05 p.m.
(000460F4) [775F70F4]
——————————————————————————
System : Windows 7 Professional, Version: 6.1, Build: 1DB1, «Service Pack 1»
Memory: 2993; free 1891
Display : 1920×1080 pixels, 32 bpp, 96 PPI
——————————————————————————

Источник

msm.ru

Нравится ресурс?
Помоги проекту!

Ошибка последней таблицы
, FireBird 1.5

Подписаться на тему
Сообщить другу
Скачать/распечатать тему

Сообщ.
#1

,
21.12.06, 12:09

Junior

Открываю любую таблицу в базе данных при помощи запроса:
select * from <имя таблицы>
Всё в порядке, но при попытки открыть последнюю таблицу выскакивает ошибка:
Dynamic SQL Error
SQL error code = -104
Token unknown — line 1, char 15
user.
Что это значит ?! Что я делаю не так ?!
И где можно взять описания ошибок ?! с SQL сталкнулся впервый раз

MIF

Сообщ.
#2

,
21.12.06, 12:15

А какое у таблицы имя? Не служебное ли это слово?

Bas

Сообщ.
#3

,
21.12.06, 12:20

Цитата fwsoft @ 21.12.06, 12:09

SQL error code = -104

Конфликт использования зарезирвированного слова user.
Взять в кавычки, говорят помогает .

Добавлено 21.12.06, 12:36

Цитата fwsoft @ 21.12.06, 12:09

И где можно взять описания ошибок ?!

Легче выучить список зарезервированных слов (Reserved words)

MIF

Сообщ.
#4

,
21.12.06, 13:03

Цитата Bas @ 21.12.06, 12:20

Взять в кавычки,

Символы, используемые для экранизации, зависят от типа БД.

fwsoft

Сообщ.
#5

,
21.12.06, 14:48

Junior

Цитата MIF @ 21.12.06, 12:15

А какое у таблицы имя? Не служебное ли это слово?

USER

Bas

Сообщ.
#6

,
21.12.06, 14:59

Цитата fwsoft @ 21.12.06, 14:48

USER

USER есть в списке Reserved words

fwsoft

Сообщ.
#7

,
22.12.06, 09:20

Junior

Цитата Bas @ 21.12.06, 14:59

USER есть в списке Reserved words

А как тогда добраться до этой таблицы ?! В чём фокус ?!

MIF

Сообщ.
#8

,
22.12.06, 10:15

Цитата fwsoft @ 22.12.06, 09:20

А как тогда добраться до этой таблицы ?! В чём фокус ?!

Цитата Bas @ 21.12.06, 12:20

Взять в кавычки

Coala

Сообщ.
#9

,
22.12.06, 10:46

Цитата fwsoft @ 22.12.06, 09:20

А как тогда добраться до этой таблицы ?! В чём фокус ?!

Если поезд далеко не ушел — переименовать таблицу. Хотя бы в _USER или USERS.

Цитата MIF @ 21.12.06, 13:03

Символы, используемые для экранизации, зависят от типа БД.

Попробуй «USER», [USER]…но не гарантирую

fwsoft

Сообщ.
#10

,
26.12.06, 09:53

Junior

Запрос типа:

select * from «USER»

работает, но что самое интересное, если в БД есть например таблица BARCODE, то запрос типа:

select * from BARCODE или select * from barcode или select * from «BARCODE»

проходит, а комбинация типа:

select * from «barcode»

нет

Coala

Сообщ.
#11

,
26.12.06, 10:02

Цитата fwsoft @ 26.12.06, 09:53

что самое интересное

есть синтаксис SQL применительно к конкретному серверу. Рекомендую почитать документацию и посмотреть, как там используется регистр для названий. В доках по InterBase почему-то все названия — в верхнем регистре. Наверное — неспроста. Да и имена системных таблиц и их полей — тоже.

fwsoft

Сообщ.
#12

,
26.12.06, 10:16

Junior

Самое оптимальное, это вытащить имена таблиц из БД и обращаться к ним через скобки

Coala

Сообщ.
#13

,
26.12.06, 10:21

Самое оптимальное — изучить список зарезервированных слов до начала проектирования БД, а не после.

H.Iglesias II

Сообщ.
#14

,
26.12.06, 10:39

Цитата

работает, но что самое интересное, если в БД есть например таблица BARCODE, то запрос типа:

в этом и есть смысл двойных кавычек. Если без кавычек, то регистр роль не играет. Если в кавычках, то регистр имеет значение

fwsoft

Сообщ.
#15

,
09.01.07, 11:35

Junior

Цитата Coala @ 26.12.06, 10:21

Самое оптимальное — изучить список зарезервированных слов до начала проектирования БД, а не после.

Ну да … если сам проектируешь БД, но если БД просто стянул, то тут уже ничего не сделать и приходиться извращяться

0 пользователей читают эту тему (0 гостей и 0 скрытых пользователей)

0 пользователей:

Предыдущая тема
Delphi: Базы данных
Следующая тема

[ Script execution time: 0,0358 ] [ 16 queries used ] [ Generated: 9.06.23, 20:09 GMT ]

Источник

Вопрос