Subject Re: [firebird-support] Restore on firebird 2.0.3 from Interbase5.5
Author Helen Borrie
At 06:20 PM 7/02/2008, you wrote:
>Attempting to restore an Interbase 5.5 (metadata only) backup to
>Firebird 2.0.3 I receive the following error:
>
>gbak: ERROR:invalid request BLR at offset 6
>
>gbak: ERROR: context already in use (BLR error)
>
>I understand that this is not the "proper" way of migrating an Interbase
>db but it has "worked" for another Interbase db.

In theory, it should work. However, Fb 2 is a whole lot more fussy about correct syntax than poor old buggy old IB 5. Somewhere in your definitions you have a statement that's making two separate references to a single cursor context. You'll find this is in a view definition; or in some constraint, stored procedure or trigger definition that uses a SELECT statement with a subquery in it.

>Question: How can I investigate this error further ?

Knowing a bit about what you're trying to achieve, I would recommend not bothering with this approach at all. Make a metadata extract under the IB 5.5 server and save it as your blueprint for the database you're going to pump into. You'll be able to fix up the metadata definitions right at the source, move things like UDF declarations into the right place, and use it to create a *native* Fb 2 dialect 3 database.

./heLen