Ask Your Question
0

Firebird Migration of Existing Database Error: firebird_sdbc_error

asked 2018-10-19 04:07:52 +0100

sdritchey gravatar image

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'

edit retag flag offensive close merge delete

Comments

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

Ratslinger gravatar imageRatslinger ( 2018-10-19 04:14:32 +0100 )edit

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.

sdritchey gravatar imagesdritchey ( 2018-10-19 04:18:42 +0100 )edit

2 Answers

Sort by » oldest newest most voted
0

answered 2018-10-19 04:44:25 +0100

Ratslinger gravatar image

updated 2018-10-19 04:47:59 +0100

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.

edit flag offensive delete link more

Comments

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.

sdritchey gravatar imagesdritchey ( 2018-10-19 05:12:45 +0100 )edit

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.

Ratslinger gravatar imageRatslinger ( 2018-10-19 05:34:48 +0100 )edit

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.

sdritchey gravatar imagesdritchey ( 2018-10-19 05:58:09 +0100 )edit

Yeah!

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

Ratslinger gravatar imageRatslinger ( 2018-10-19 06:01:07 +0100 )edit

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

sdritchey gravatar imagesdritchey ( 2018-10-19 06:07:47 +0100 )edit

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

Ratslinger gravatar imageRatslinger ( 2018-10-19 06:20:37 +0100 )edit
0

answered 2018-10-19 20:35:20 +0100

sdritchey gravatar image

Filed a bug report for this issue, see Bug 120691

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2018-10-19 04:07:52 +0100

Seen: 632 times

Last updated: Oct 19 '18