[Libreoffice-bugs] [Bug 123020] Migration to Firebird db fails on "unknown token isc_dsql_prepare"
bugzilla-daemon at bugs.documentfoundation.org
bugzilla-daemon at bugs.documentfoundation.org
Wed Jan 30 08:29:56 UTC 2019
https://bugs.documentfoundation.org/show_bug.cgi?id=123020
Julien Nabet <serval2412 at yahoo.fr> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |btomi96 at gmail.com
--- Comment #6 from Julien Nabet <serval2412 at yahoo.fr> ---
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.
--
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20190130/721c47c8/attachment.html>
More information about the Libreoffice-bugs
mailing list