Firebird error message "Unsuccessful execution caused by a system error that precludes successful execution of subsequent statements"

delphi firebird uib
Harriv picture Harriv · Oct 18, 2012 · Viewed 20.3k times · Source

My application generates sometimes this kind of errors when accessing Firebird database:

Unsuccessful execution caused by a system error that precludes successful execution of subsequent statements GDS Code: 335544726 - SQL Code: -902 - Error Code: 406'

What could be the problem? Is there any way to debug this?

I'm running Firebird 2.5.1 on Windows 7. There are at least kinterbasdb with Python and UIB components with Delphi in use.

Answer

Harriv picture Harriv · Oct 19, 2012

Looks like the reason for this was using same connection/transaction from multiple threads.

Related questions

Firebird error "username and password are not defined" with Delphi application

I have an application made with Delphi 2006 and Firebird 2.5. For connection a use Interbase components from Delphi. I setting up in design time a TIBDatabase with username, password tc, and work ok, but when i want to run application in …

Read More
How do I explicitly insert nulls into a parametized query?

I'm using Delphi 7 and Firebird 1.5. I have a query that I create at runtime where some of the values might be null. I can't work out how to get Firebird to accept explicit nulls for values that I need to …

Read More
How can I get the table description (fields and types) from Firebird with dbExpress

I have written a tool for displaying database structures using the GetTableNames and GetFieldNames methods of TSQLConnection. How can I get the types of each field name similar to the following list (which is part of the DDL required to …

Read More