Description: Opening a Base project with HSQL storage I attempted a conversion and was met with: firebird_sdbc error: *Dynamic SQL Error *SQL error code = -104 *Token unknown - line 1, column 23 *ID caused by 'isc_dsql_prepare' I have no idea what this means. As always the "More" info is completely lacking. Steps to Reproduce: 1.Open the database 2.Answer 'yes' to the question about migration 3. Actual Results: Error message as in the attachment, and a non-working database (and slow as molassess...) Expected Results: A working, migrated database Reproducible: Always User Profile Reset: No Additional Info:
Created attachment 148715 [details] Error dialog on failed migration
Would it be possible you attach the database? Of course, make a copy in order to remove any private/confidential part from it.
Created attachment 148716 [details] The database
Thank you Thomas for your feedback. I could reproduce this on pc Debian x86-64 with master sources updated yesterday.
Good. Thanks. Looking forward to any progress. I suppose it should be fairly high prio to get every bug out of the Firebird migration, hugh? Good that it's not blocking me. Not before HSQL is pulled, that is...
I retested this and had another result. First, when I downloaded this, I got this name on my laptop (Debian x86-64 with French UI): 'Poängdatabasen - kopia (2).odb' Here are the actions I done: - rename the file to avoid special characters - open the file and disable macros - accept migration when trying to open tables => errors Here are console logs: warn:connectivity.firebird:11528:11528:connectivity/source/drivers/firebird/Util.cxx:55: firebird_sdbc error: *Dynamic SQL Error *SQL error code = -104 *Name longer than database column size caused by 'isc_dsql_prepare' warn:connectivity.firebird:11528:11528:connectivity/source/drivers/firebird/Statement.cxx:122: isc_dsql_execute failed warn:connectivity.firebird:11528:11528:connectivity/source/drivers/firebird/Util.cxx:55: firebird_sdbc error: *unsuccessful metadata update *CREATE VIEW Transaktionssumma failed *Dynamic SQL Error *SQL error code = -206 *Column unknown *Ins\u00e4ttning caused by 'CREATE VIEW "Transaktionssumma" ("Transaktionsnr","Kontonr","Datum","Beskrivning","Ins\u00e4ttning","Uttag","Ej utnyttjat","Tillgodo") AS SELECT "Transaktionsnr" AS "Transaktionsnr", "Kontonr" AS "Kontonr", "Datum" AS "Datum", "Beskrivning" AS "Beskrivning", "Ins\u00e4ttning", "Uttag", "Ej utnyttjat", "Ins\u00e4ttning" - "Uttag" - "Ej utnyttjat" AS "Tillgodo" FROM "Transaktioner"' warn:connectivity.firebird:11528:11528:connectivity/source/drivers/firebird/Statement.cxx:122: isc_dsql_execute failed warn:connectivity.firebird:11528:11528:connectivity/source/drivers/firebird/Util.cxx:55: firebird_sdbc error: *unsuccessful metadata update *CREATE VIEW \u00c5rstransaktioner failed *Dynamic SQL Error *SQL error code = -206 *Column unknown *Ins\u00e4ttning caused by 'CREATE VIEW "\u00c5rstransaktioner" ("Kontonr","\u00c5r","Ins\u00e4ttningar","Uttag") AS SELECT "Kontonr", CAST( LEFT( "Datum", 4 ) AS INTEGER ) AS "\u00c5r", SUM( "Ins\u00e4ttning" ) AS "Ins\u00e4ttningar", SUM( "Uttag" ) AS "Uttag" FROM "Transaktioner" GROUP BY "Kontonr", LEFT( "Datum", 4 ) ORDER BY "Kontonr" ASC, "\u00c5r" ASC' warn:connectivity.firebird:11528:11528:connectivity/source/drivers/firebird/Statement.cxx:122: isc_dsql_execute failed warn:connectivity.firebird:11528:11528:connectivity/source/drivers/firebird/Util.cxx:55: firebird_sdbc error: *unsuccessful metadata update *CREATE VIEW Konto och transaktioner failed *Dynamic SQL Error *SQL error code = -206 *Column unknown *Transaktioner.Ins\u00e4ttning caused by 'CREATE VIEW "Konto och transaktioner" ("Kontonamn","Datum","Beskrivning","Ins\u00e4ttning","Uttag") AS SELECT "Konton"."Kontonamn", "Transaktioner"."Datum", "Transaktioner"."Beskrivning", "Transaktioner"."Ins\u00e4ttning", "Uttag" + "Ej utnyttjat" AS "Uttag" FROM "Transaktioner", "Konton" WHERE "Transaktioner"."Kontonr" = "Konton"."Kontonr"' warn:dbaccess:11528:11528:dbaccess/source/filter/hsqldb/hsqlimport.cxx:384: Error during migration Tamás: thought you might be interested in this one. It seems there are still part which need to take into account encoding.
Unzipping the odb file, I noticed that in content.xml, I got: "Vald person i formulär Konton" but in database/script, I got "Vald person i formul\u00e4r Konton"
@Julien : sounds like a DUP of bug 121469 ?
Indeed! *** This bug has been marked as a duplicate of bug 121469 ***
Now that tdf#121469 has been fixed, let's recycle this tracker. Indeed an empty error message appears and console indicates this: warn:dbaccess:18254:18254:dbaccess/source/filter/hsqldb/hsqlimport.cxx:390: Error during migration Some debugging shows it's due to the fact that an index fails to be parsed because it contains more that one word. SET TABLE "Vald person i formul\u00e4r Konton" INDEX'110032 0' See https://opengrok.libreoffice.org/xref/core/dbaccess/source/filter/hsqldb/parseschema.cxx?r=3fb5f718#getIndexes
(In reply to Julien Nabet from comment #10) ... > See > https://opengrok.libreoffice.org/xref/core/dbaccess/source/filter/hsqldb/ > parseschema.cxx?r=3fb5f718#getIndexes Rather https://opengrok.libreoffice.org/xref/core/dbaccess/source/filter/hsqldb/parseschema.cxx?r=3fb5f718#getTableName
I submitted a patch on gerrit: https://gerrit.libreoffice.org/#/c/67259/
Julien Nabet committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/+/b35a64be6025b59e88231a4dc0f025273adb63c5%5E%21 tdf#123020: migration to Firebird fix tablename for indexes It will be available in 6.3.0. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Patch on gerrit for 6.2 branch: https://gerrit.libreoffice.org/#/c/67274/ Patch on gerrit for 6.1 branch: https://gerrit.libreoffice.org/#/c/67275/
Sorry, patch was wrong.
Julien Nabet committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/+/850527869590094a29a5175779a0d984e4699763%5E%21 Revert "tdf#123020: migration to Firebird fix tablename for indexes" It will be available in 6.3.0. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Just for the record, new patch waiting for review is here: https://gerrit.libreoffice.org/#/c/67301/
Julien Nabet committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/+/2a08db9a0473e2f87715aacfc7b481beaa490dcf%5E%21 tdf#123020: migration to Firebird fix tablename for indexes (2) It will be available in 6.3.0. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
The second patch was wrong too.
Julien Nabet committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/+/95a0a24d6172c4620432c20798a6727c732d8e86%5E%21 Revert "tdf#123020: migration to Firebird fix tablename for indexes (2)" It will be available in 6.3.0. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
I'm now at 6.2.1 and an attempted migration gives a completely empty error dialog, "more" gives "SQL-status: invalid map<K, T> key"
Tamas Bunth committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/+/b5890bf269214a47833bc9514b80650455e77ef6%5E%21 tdf#123020 dbahsql: Support string delimiter It will be available in 6.4.0. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Tamas Bunth committed a patch related to this issue. It has been pushed to "libreoffice-6-3": https://git.libreoffice.org/core/+/47d6c43c19aa6ea05f0f65db58e5cdcf1c603660%5E%21 tdf#123020 dbahsql: Support string delimiter It will be available in 6.3.0.2. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Migration no longer fails in Version: 6.4.0.0.alpha0+ Build ID: cefce1a247a4674c5726a31b61571eab16328a0b CPU threads: 4; OS: Linux 4.15; UI render: default; VCL: gtk3; Locale: ca-ES (ca_ES.UTF-8); UI-Language: en-US Calc: threaded @Tamas, thanks for fixing this issue!! Can we close it as RESOLVED FIXED ?
Tamas Bunth committed a patch related to this issue. It has been pushed to "libreoffice-6-2": https://git.libreoffice.org/core/+/ed9acbe6057f535bca8d4ce98aa0eda7be34e15b%5E%21 tdf#123020 dbahsql: Support string delimiter It will be available in 6.2.6. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.