Sql error code 204 firebird

sql error -204 : similar to existing bug but with requested details [CORE2139] #2570

Submitted by: julian bui (jbu311)

Related to a bug found in the bug tracker. It looks like nobody did anything with that one because they didn’t have queries. I was able to duplicate the bug and here are the queries I used. Fields are censored for privacy reasons.

//NEXT THREE LINES EXECUTE WITHOUT ERRORS
String createTableQueryString = «CREATE TABLE MY_TABLE (aaaSMALLINT, bbbBIGINT, cccSMALLINT, ddd DOUBLE PRECISION, eee CHAR(16));»;
PreparedStatement ps = conn.prepareStatement(createTableQueryString);
ps.execute();

//NEXT FEWLINES PRODUCE ERROR:
try <
dataInsertPs = conn.prepareStatement(«INSERT INTO MY_TABLE (aaa, bbb, ccc, ddd, eee) VALUES (?, ?, ?, ?, ? )»);
> catch (SQLException ex) <
Logger.getLogger(Main.class.getName()).log(Level.SEVERE, «Could not create prepared statement», ex);
>

ERROR:
databaseURL = jdbc:firebirdsql:embedded:V:TempDB.FDB
Oct 22, 2008 1:24:06 PM Main createPreparedStatement
SEVERE: Could not create prepared statement
org.firebirdsql.jdbc.FBSQLException: GDS Exception. 335544569. Dynamic SQL Error
SQL error code = -204
Table unknown
MY_TABLE
At line 1, column 13
at org.firebirdsql.jdbc.AbstractPreparedStatement. (AbstractPreparedStatement.java:127)
at org.firebirdsql.jdbc.FBPreparedStatement. (FBPreparedStatement.java:41)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
at org.firebirdsql.jdbc.FBStatementFactory.createPreparedStatement(FBStatementFactory.java:90)
at org.firebirdsql.jdbc.AbstractConnection.prepareStatement(AbstractConnection.java:869)
at org.firebirdsql.jdbc.AbstractConnection.prepareStatement(AbstractConnection.java:824)
at org.firebirdsql.jdbc.AbstractConnection.prepareStatement(AbstractConnection.java:817)
at org.firebirdsql.jdbc.AbstractConnection.prepareStatement(AbstractConnection.java:293)
at Main.createPreparedStatement(Main.java:101)
at Main.main(Main.java:189)

The text was updated successfully, but these errors were encountered:

Источник

SQL error code = -204 [DNET514] #497

Submitted by: Rand Random (rand.random)

I installed the new .NET Provider and tried to update my EDMX Model (with Database First) but I am getting the following in my output window:

Unable to generate the model because of the following exception: ‘An error occurred while executing the command definition. See the inner exception for details.
Dynamic SQL Error
SQL error code = -204
Data type unknown
Implementation limit exceeded
COLUMN DSQL internal
Dynamic SQL Error
SQL error code = -204
Data type unknown
Implementation limit exceeded
COLUMN DSQL internal
‘.
Loading metadata from the database took 00:00:00.4426206.
Generating the model took 00:00:07.6167923.
Added the connection string to the App.Config file.
Writing the .edmx file took 00:00:00.0012551.

I am creating the following Domain, since Firebird 2.5 and earlier is lacking support for boolean:

SET TERM !! ;
EXECUTE BLOCK AS BEGIN

if (exists(select 1 from rdb$fields f, rdb$types t
where f.rdb$field_name=’BOOLEAN’
and f.rdb$field_type=t.rdb$type
and t.rdb$field_name=’RDB$FIELD_TYPE’)) then
execute statement ‘drop DOMAIN BOOLEAN;’;

execute statement ‘CREATE DOMAIN BOOLEAN
AS SMALLINT DEFAULT 0
CHECK (value in (0, 1));’;
END!!
SET TERM ; !!

could this be the root of the problem, and how would I fix it?

Thanks in advance.

The text was updated successfully, but these errors were encountered:

Modified by: Rand Random (rand.random)

description: I installed the new .NET Provider and tried to update my EDMX Model (with Database First) but I am getting the following in my output window:

Unable to generate the model because of the following exception: ‘An error occurred while executing the command definition. See the inner exception for details.
Dynamic SQL Error
SQL error code = -204
Data type unknown
Implementation limit exceeded
COLUMN DSQL internal
Dynamic SQL Error
SQL error code = -204
Data type unknown
Implementation limit exceeded
COLUMN DSQL internal
‘.
Loading metadata from the database took 00:00:00.4426206.
Generating the model took 00:00:07.6167923.
Added the connection string to the App.Config file.
Writing the .edmx file took 00:00:00.0012551.

I am creating the following Domain, since Firebird 2.5 and earlier is lacking support for boolean:

SET TERM !! ;
EXECUTE BLOCK AS BEGIN

if (exists(select 1 from rdb$fields f, rdb$types t
where f.rdb$field_name=’BOOLEAN’
and f.rdb$field_type=t.rdb$type
and t.rdb$field_name=’RDB$FIELD_TYPE’)) then
execute statement ‘drop DOMAIN BOOLEAN;’;

execute statement ‘CREATE DOMAIN BOOLEAN
AS SMALLINT DEFAULT 0
CHECK (value in (0, 1));’;
END!!
SET TERM ; !!

could this be the root of the problem, and how would I fix it?

In my Database I have

I installed the new .NET Provider and tried to update my EDMX Model (with Database First) but I am getting the following in my output window:

Unable to generate the model because of the following exception: ‘An error occurred while executing the command definition. See the inner exception for details.
Dynamic SQL Error
SQL error code = -204
Data type unknown
Implementation limit exceeded
COLUMN DSQL internal
Dynamic SQL Error
SQL error code = -204
Data type unknown
Implementation limit exceeded
COLUMN DSQL internal
‘.
Loading metadata from the database took 00:00:00.4426206.
Generating the model took 00:00:07.6167923.
Added the connection string to the App.Config file.
Writing the .edmx file took 00:00:00.0012551.

I am creating the following Domain, since Firebird 2.5 and earlier is lacking support for boolean:

SET TERM !! ;
EXECUTE BLOCK AS BEGIN

if (exists(select 1 from rdb$fields f, rdb$types t
where f.rdb$field_name=’BOOLEAN’
and f.rdb$field_type=t.rdb$type
and t.rdb$field_name=’RDB$FIELD_TYPE’)) then
execute statement ‘drop DOMAIN BOOLEAN;’;

execute statement ‘CREATE DOMAIN BOOLEAN
AS SMALLINT DEFAULT 0
CHECK (value in (0, 1));’;
END!!
SET TERM ; !!

could this be the root of the problem, and how would I fix it?

Источник

Select on empty database generate: internal Firebird consistency check (cannot find tip page (165), file: tra.cpp line: 2369 [CORE4734] #5040

Submitted by: Carl-Johan Wik (cjwik)

Below you will find the code for the connection information object that the test program.

This done in Visual Studio 2013, Windows 8.1, Firebird 2.5.4 and Firebird http://ADO.NET Data provider. 4.5.0.0

The thing I find is that if the database is empty and I do select, then it goes into a failed state that I cannot resolve and have to recreate the database.

Procedure to reproduce:
Run the program, the program will pass con.Open and throw exception on the cmd.ExecuteScalar and the exception says table unknown. I.e. an expected exception.
Re-run the program, now the con.Open will throw an exception with the information: internal Firebird consistency check (cannot find tip page (165), file: tra.cpp line: 2369
If I try to re-run the program again the same exception happen on the con.Open statement. I cannot get pass this and have to recreate the database. I.e. the database in failed state.

New test run.
I run the program but this time execute the create table statement. No exception.
Re-run the program but with the select statement on a table that do not exist. Program will pass con.Open and throw exception on the cmd.ExecuteScalar and the exception says table unknown. I.e. an expected exception.
I can now re-run the program several times and the con.Open will always work and I get the expected exception of table unknown.

It seems that if I do a Select on at table on an empty database then this error happen, otherwise not.

Was not sure to report this as blocker, but it is a blocker for me as I cannot use Firebird with such a error in a production environment.

The text was updated successfully, but these errors were encountered:

Modified by: Carl-Johan Wik (cjwik)

Below you will find the code for the connection information object that the test program.

This done in Visual Studio 2013, Windows 8.1, Firebird 2.5.4 and Firebird http://ADO.NET Data provider. 4.5.0.0

The thing I find is that if the database is empty and I do select, then it goes into a failed state that I cannot resolve and have to recreate the database.

Procedure to reproduce:
Run the program, the program will pass con.Open and throw exception on the cmd.ExecuteScalar and the exception says table unknown. I.e. an expected exception.
Re-run the program, now the con.Open will throw an exception with the information: internal Firebird consistency check (cannot find tip page (165), file: tra.cpp line: 2369
If I try to re-run the program again the same exception happen on the con.Open statement. I cannot get pass this and have to recreate the database. I.e. the database in failed state.

New test run.
I run the program but this time execute the create table statement. No exception.
Re-run the program but with the select statement on a table that do not exist. Program will pass con.Open and throw exception on the cmd.ExecuteScalar and the exception says table unknown. I.e. an expected exception.
I can now re-run the program several times and the con.Open will always work and I get the expected exception of table unknown.

It seems that if I do a Select on at table on an empty database then this error happen, otherwise not.

Was not sure to report this as blocker, but it is a blocker for me as I cannot use Firebird with such a error in a production environment.

*************************************************************
class ConnectionInformation
<
public ConnectionInformation()
<
this.User = «SYSDBA»;
this.Password = «masterkey»;
this.ServerType = FbServerType.Embedded;
this.DatabaseFileName = «TaragonTrader.fdb»;
this.CharacterSet = «UTF8»;
this.ClientLibraryPath = @»fbembed.dll»;
this.Dialect = 3;

Below you will find the code for the connection information object that the test program.

This done in Visual Studio 2013, Windows 8.1, Firebird 2.5.4 and Firebird http://ADO.NET Data provider. 4.5.0.0

The thing I find is that if the database is empty and I do select, then it goes into a failed state that I cannot resolve and have to recreate the database.

Procedure to reproduce:
Run the program, the program will pass con.Open and throw exception on the cmd.ExecuteScalar and the exception says table unknown. I.e. an expected exception.
Re-run the program, now the con.Open will throw an exception with the information: internal Firebird consistency check (cannot find tip page (165), file: tra.cpp line: 2369
If I try to re-run the program again the same exception happen on the con.Open statement. I cannot get pass this and have to recreate the database. I.e. the database in failed state.

New test run.
I run the program but this time execute the create table statement. No exception.
Re-run the program but with the select statement on a table that do not exist. Program will pass con.Open and throw exception on the cmd.ExecuteScalar and the exception says table unknown. I.e. an expected exception.
I can now re-run the program several times and the con.Open will always work and I get the expected exception of table unknown.

It seems that if I do a Select on at table on an empty database then this error happen, otherwise not.

Was not sure to report this as blocker, but it is a blocker for me as I cannot use Firebird with such a error in a production environment.

[In next time, please, create compact example]

>>> Win7 x64 ();
throw ex;
>
>
catch(Exception exc)
<
Console.WriteLine(«ERROR: <0>— <1>«,
exc.Source,
exc.Message);
>
>//Main
>;//class Program

—————-
With other http://ADO.NET provider — no any problems also 🙂

I think, your problem in «unhandled» exception.

Unhandled Exception: FirebirdSql.Data.FirebirdClient.FbException: Dynamic SQL Error
SQL error code = -204
Table unknown
QUOTEDATAPROVIDER2
At line 1, column 22 —> FirebirdSql.Data.Common.IscException: Dynamic SQL Error
SQL error code = -204
Table unknown
QUOTEDATAPROVIDER2
At line 1, column 22
at FirebirdSql.Data.Client.Native.FesDatabase.ParseStatusVector(IntPtr[] statusVector) in c:UsersJiriDocumentsdevelNETProviderworkingNETProvidersrcFirebirdSql.Data.FirebirdClientClientNativeFesDa
tabase.cs:line 420
at FirebirdSql.Data.Client.Native.FesStatement.Prepare(String commandText) in c:UsersJiriDocumentsdevelNETProviderworkingNETProvidersrcFirebirdSql.Data.FirebirdClientClientNativeFesStatement.cs:l
ine 308
at FirebirdSql.Data.FirebirdClient.FbCommand.Prepare(Boolean returnsSet) in c:UsersJiriDocumentsdevelNETProviderworkingNETProvidersrcFirebirdSql.Data.FirebirdClientFirebirdClientFbCommand.cs:line
1187
at FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteCommand(CommandBehavior behavior, Boolean returnsSet) in c:UsersJiriDocumentsdevelNETProviderworkingNETProvidersrcFirebirdSql.Data.FirebirdClient
FirebirdClientFbCommand.cs:line 1201
at FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteScalar() in c:UsersJiriDocumentsdevelNETProviderworkingNETProvidersrcFirebirdSql.Data.FirebirdClientFirebirdClientFbCommand.cs:line 595
— End of inner exception stack trace —
at Program.Main(String[] args) in d:UsersDimaTemp2015_04_04__testConsoleApplication2__fbProgram.cs:line 63

Unhandled Exception: FirebirdSql.Data.FirebirdClient.FbException: internal Firebird consistency check (Internal error code (165), file: tra.cpp line: 2369) —> FirebirdSql.Data.Common.IscException: internal Fi
rebird consistency check (Internal error code (165), file: tra.cpp line: 2369)
at FirebirdSql.Data.Client.Native.FesDatabase.ParseStatusVector(IntPtr[] statusVector) in c:UsersJiriDocumentsdevelNETProviderworkingNETProvidersrcFirebirdSql.Data.FirebirdClientClientNativeFesDa
tabase.cs:line 420
at FirebirdSql.Data.Client.Native.FesDatabase.Attach(DatabaseParameterBuffer dpb, String dataSource, Int32 port, String database) in c:UsersJiriDocumentsdevelNETProviderworkingNETProvidersrcFirebird
Sql.Data.FirebirdClientClientNativeFesDatabase.cs:line 291
at FirebirdSql.Data.FirebirdClient.FbConnectionInternal.Connect() in c:UsersJiriDocumentsdevelNETProviderworkingNETProvidersrcFirebirdSql.Data.FirebirdClientFirebirdClientFbConnectionInternal.cs:l
ine 191
— End of inner exception stack trace —
at Program.Main(String[] args) in d:UsersDimaTemp2015_04_04__testConsoleApplication2__fbProgram.cs:line 63

Unhandled Exception: lcpi.data.oledb.OleDbException: 1. [LCPI.IBProvider.3] Prepare SQL statement failed.
Dynamic SQL Error
SQL error code = -204
Table unknown
QUOTEDATAPROVIDER2
At line 1, column 22

The COM error code: DB_E_NOTABLE. SQL State: «42S02». Native DBMS Error Code: 335544580.
———————————
2. [lcpi.data.oledb.OleDbCommand] Prepare of command has been finished with errors.

The COM error code: DB_E_NOTABLE.
at Program.Main(String[] args) in d:UsersDimaTemp2015_04_04__testConsoleApplication1Program.cs:line 62

Unhandled Exception: lcpi.data.oledb.OleDbException: 1. [LCPI.IBProvider.3] Prepare SQL statement failed.
Dynamic SQL Error
SQL error code = -204
Table unknown
QUOTEDATAPROVIDER2
At line 1, column 22

The COM error code: DB_E_NOTABLE. SQL State: «42S02». Native DBMS Error Code: 335544580.
———————————
2. [lcpi.data.oledb.OleDbCommand] Prepare of command has been finished with errors.

The COM error code: DB_E_NOTABLE.
at Program.Main(String[] args) in d:UsersDimaTemp2015_04_04__testConsoleApplication1Program.cs:line 62

class Program
<
static void Main(string[] args)
<
//try
<
System.Threading.Thread.CurrentThread.CurrentUICulture
=new System.Globalization.CultureInfo(«EN»);

var strBuilder = new OleDbConnectionStringBuilder();

strBuilder.Provider=»LCPI.IBProvider.3″; // 3.23.0.17515
strBuilder.UserID = «SYSDBA»;
strBuilder.Password = «masterkey»;
strBuilder.IBProvider.ctype = «UTF8»;

strBuilder.IBProvider.auto_commit=true;
strBuilder.Location = @»d:databaseTaragonTrader.fdb»;

var con=new OleDbConnection(strBuilder.ConnectionString);

try
<
if (File.Exists(strBuilder.Location))
<
Console.WriteLine(«Open»);

>
catch (Exception ex)
<
throw ex;
>

string sqlStatement = «Select Count(*) From QuoteDataProvider2»;

Источник

Submitted by: julian bui (jbu311)

Related to a bug found in the bug tracker. It looks like nobody did anything with that one because they didn’t have queries. I was able to duplicate the bug and here are the queries I used. Fields are censored for privacy reasons.

//NEXT THREE LINES EXECUTE WITHOUT ERRORS
String createTableQueryString = «CREATE TABLE MY_TABLE (aaaSMALLINT, bbbBIGINT, cccSMALLINT, ddd DOUBLE PRECISION, eee CHAR(16));»;
PreparedStatement ps = conn.prepareStatement(createTableQueryString);
ps.execute();

//NEXT FEWLINES PRODUCE ERROR:
try {
dataInsertPs = conn.prepareStatement(«INSERT INTO MY_TABLE (aaa, bbb, ccc, ddd, eee) VALUES (?, ?, ?, ?, ? )»);
} catch (SQLException ex) {
Logger.getLogger(Main.class.getName()).log(Level.SEVERE, «Could not create prepared statement», ex);
}

ERROR:
databaseURL = jdbc:firebirdsql:embedded:V:TempDB.FDB
Oct 22, 2008 1:24:06 PM Main createPreparedStatement
SEVERE: Could not create prepared statement
org.firebirdsql.jdbc.FBSQLException: GDS Exception. 335544569. Dynamic SQL Error
SQL error code = -204
Table unknown
MY_TABLE
At line 1, column 13
at org.firebirdsql.jdbc.AbstractPreparedStatement.<init>(AbstractPreparedStatement.java:127)
at org.firebirdsql.jdbc.FBPreparedStatement.<init>(FBPreparedStatement.java:41)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
at org.firebirdsql.jdbc.FBStatementFactory.createPreparedStatement(FBStatementFactory.java:90)
at org.firebirdsql.jdbc.AbstractConnection.prepareStatement(AbstractConnection.java:869)
at org.firebirdsql.jdbc.AbstractConnection.prepareStatement(AbstractConnection.java:824)
at org.firebirdsql.jdbc.AbstractConnection.prepareStatement(AbstractConnection.java:817)
at org.firebirdsql.jdbc.AbstractConnection.prepareStatement(AbstractConnection.java:293)
at Main.createPreparedStatement(Main.java:101)
at Main.main(Main.java:189)

Модераторы: kdv, Alexey Kovyazin