ISC error 336068728

[Ertan Küçükoglu]

Hello,

I am using FirebirdSQL 4.0.2 64bit on Windows.

Following SQL gives ISC error code instead of a meaningful error message

create table a (a varchar(10));

commit;

/* there is no column named B in table A */

/* it is fine below should give an error */

create index idx_test on a(b); 

unsuccessful metadata update

CREATE INDEX IDX_TEST failed

unknown ISC error 336068728

I just don't understand that code and could not find it in FirebirdSQL Github sources using github search in the repository.

I wonder if this is something known?

I personally prefer a meaningful message for such an error as it is not always obvious using the wrong column name. Should I report it in Github issues?

Thanks & Regards,

Ertan

[Mark Rotteveel]

It sounds like you have an outdated firebird.msg in your
Windows\System32 or Windows\SysWOW64 directory (or at least in the same
directory as the fbclient.dll used by your application). Error code is
"Unknown columns in index %s".

Mark
--
Mark Rotteveel

[Mark Rotteveel]

To demonstrate this works fine in Firebird 4.0.2:

D:\DevSoft\Firebird\Firebird-4.0.2.2816-0-x64>isql -user sysdba
e:\db\fb4\FB4TESTDATABASE.FDB
Database: e:\db\fb4\FB4TESTDATABASE.FDB, User: SYSDBA
SQL> create table a (a varchar(10));
SQL> create index idx_test on a(b);
Statement failed, SQLSTATE = 42000
unsuccessful metadata update
-CREATE INDEX IDX_TEST failed
-Unknown columns in index IDX_TEST
SQL>

Mark
--
Mark Rotteveel

[Ertan Küçükoglu]

Yes, since fbclient.dll has to be put in c:\windows\system32 (I use 64bit application) that I do manually, and I didn't copy firebird.msg file together with fbclient.dll.

Though, I expected that error to be initiated from the server side where it has necessary files installed. Seems design is not that I thought of.

I will test with firebird.msg file copied to c:\windows\system32

Thanks & Regards,

Ertan

Mark Rotteveel <ma...@lawinegevaar.nl>, 2 Eyl 2022 Cum, 13:13 tarihinde şunu yazdı:

--
You received this message because you are subscribed to the Google Groups "firebird-support" group.
To unsubscribe from this group and stop receiving emails from it, send an email to firebird-suppo...@googlegroups.com.
To view this discussion on the web, visit https://groups.google.com/d/msgid/firebird-support/1374357d-bc51-fb92-97ed-c611cff35d94%40lawinegevaar.nl.

[Ertan Küçükoglu]

Works as expected after copying firebird.msg file in the same directory as fbclient.dll.

Thank you.

Mark Rotteveel <ma...@lawinegevaar.nl>, 2 Eyl 2022 Cum, 13:19 tarihinde şunu yazdı:

--
You received this message because you are subscribed to the Google Groups "firebird-support" group.
To unsubscribe from this group and stop receiving emails from it, send an email to firebird-suppo...@googlegroups.com.

To view this discussion on the web, visit https://groups.google.com/d/msgid/firebird-support/c7f12895-7603-fe24-f544-a9809c1b3d63%40lawinegevaar.nl.

[Dimitry Sibiryakov]

Ertan Küçükoglu wrote 02.09.2022 12:21:
> Though, I expected that error to be initiated from the server side where it has
> necessary files installed. Seems design is not that I thought of.

Errors are delivered to client (mostly) as gdscodes and client transform them
into text messages using built-in array or firebird.msg (which may be localized).
If you gen "unknown ISC error" it means that outdated client is not aware of
the code has been sent from server.

--
WBR, SD.

[Mark Rotteveel]

On 02-09-2022 12:21, Ertan Küçükoglu wrote:
> Yes, since fbclient.dll has to be put in c:\windows\system32 (I use
> 64bit application) that I do manually, and I didn't copy firebird.msg
> file together with fbclient.dll.
>
> Though, I expected that error to be initiated from the server side where
> it has necessary files installed. Seems design is not that I thought of.

Firebird only reports the error codes and parameter values. It is the
responsibility of the client to lookup the message template for the
error code and apply the parameters. The basic idea of this is to avoid
bulky messages (basically 4 bytes instead of however long the error
message is). This also allows localization of error messages (though
that is - as far as I know - hardly ever used).

Mark
--
Mark Rotteveel