<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><span class="vcard"><a class="email" href="mailto:serval2412@yahoo.fr" title="Julien Nabet <serval2412@yahoo.fr>"> <span class="fn">Julien Nabet</span></a>
</span> changed
<a class="bz_bug_link
bz_status_NEW "
title="NEW - Migration to Firebird db fails on "unknown token isc_dsql_prepare""
href="https://bugs.documentfoundation.org/show_bug.cgi?id=123020">bug 123020</a>
<br>
<table border="1" cellspacing="0" cellpadding="8">
<tr>
<th>What</th>
<th>Removed</th>
<th>Added</th>
</tr>
<tr>
<td style="text-align:right;">CC</td>
<td>
</td>
<td>btomi96@gmail.com
</td>
</tr></table>
<p>
<div>
<b><a class="bz_bug_link
bz_status_NEW "
title="NEW - Migration to Firebird db fails on "unknown token isc_dsql_prepare""
href="https://bugs.documentfoundation.org/show_bug.cgi?id=123020#c6">Comment # 6</a>
on <a class="bz_bug_link
bz_status_NEW "
title="NEW - Migration to Firebird db fails on "unknown token isc_dsql_prepare""
href="https://bugs.documentfoundation.org/show_bug.cgi?id=123020">bug 123020</a>
from <span class="vcard"><a class="email" href="mailto:serval2412@yahoo.fr" title="Julien Nabet <serval2412@yahoo.fr>"> <span class="fn">Julien Nabet</span></a>
</span></b>
<pre>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.</pre>
</div>
</p>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are the assignee for the bug.</li>
</ul>
</body>
</html>