Firebird Migration of Existing Database Error: firebird_sdbc_error

I am attempting to migrate an existing ODB database to Firebird with the new migration assistant in LO 6.1.2 on MacOS. After selecting “Yes” to convert the database to Firebird I get the following 2 errors and the conversion will not complete:

firebird_sdbc error:
*Dynamic SQL Error
*SQL error code = -104
*Token unknown - line 1, column 22
*ID
caused by
‘isc_dsql_prepare’

firebird_sdbc error:
*Dynamic SQL Error
*SQL error code = -104
*Token unknown - line 1, column 24
*ID
caused by
‘isc_dsql_prepare’

Hope you are not intending to delete this question as I post an answer. Wasted time answering your last post.

Apologies, I downloaded an app that was able to unzip the archive and then was able to edit the content.xml file. The text I needed to edit that I thought was related to my issue was not in my .xml file, so I thought it best to simply post my complete error message for a more thorough help request for my issue. Certainly didnt mean to waste your time, again sorry for that.

Hello,

It appears your tables have converted but you need to be aware of potential problems. Please see my answer in this post → Firebird Migration Expectations.

Your particular errors seem to be related to Queries - either standalone or in forms. The noted post above includes a partial list of differences between HSQLDB and Firebird SQL. I have found more. There is also a link there to the Firebird documentation which has the latest version available (v2.5) of the Reference manual.

There are some other problems with Firebird not listed in that post or yet to be reported (at least not that I have seen). Be cautious. I have found ways around all problems thus far although some are not easy. I have run a three month test using Firebird embedded with my personal financial data and all checked out vs MySQL, Firebird Server v3.1 and PostgreSQL.

Thanks for this information and for the caution. This is indeed a test copy of my ‘real’ database. I’ve assumed there would be problems, so will be testing thoroughly before making the switch.

Per your feedback as a test I deleted all Queries and Forms from my test database before opening and trying the migration assistant again, so there was only one Table and zero Forms, Queries or Reports in my database file. Clicked on my table, started the conversion, same error message.

Does your .odb or any of the table names have a space in it such as My Table or My Base File as this can be another source. If so just rename without the spaces & retry. If not please post a sample.

Also, what type of fields are in the tables - standard Interger, Date, Time, Varchar stuff is OK. If you have pictures it may be a problem.

Yes, my Table name did indeed have a space in it. I eliminated the space and the migration completed without the error message. I then retested on a version of my database with all Queries and Forms included and with all spaces eliminated from the names, and it also completed the migration successfully. I noticed one issue with the data, and an issue with the form, but I’ll post those issues separately and any others that turn up in my testing. Thank you for your help.

Yeah!

Now if you could undo the delete of the other question, I had a good answer there for others.

Sure thing, just undeleted the previous question for others to reference.

Much appreciated - may help others & I won’t need to re-enter it all.

Filed a bug report for this issue, see Bug 120691