[Libreoffice-bugs] [Bug 127040] Database HSQLDB to Firebird automated migration Failure

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=127040

Alex Thurgood <iplaw67 at tuta.io> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
     Ever confirmed|0                           |1
             Status|UNCONFIRMED                 |NEW

--- Comment #1 from Alex Thurgood <iplaw67 at tuta.io> ---
The migration isn't forced on you...yet. However, I am in agreement that the
Firebird migration still unfortunately isn't in a position to go primetime with
people's data, but that decision doesn't rest with me (or others who have
voiced similar concerns). It has been taken by the steering committee.

When the migration dialog appears, there is a link to a LO wiki page that
indicates where the main problems currently lie, and how to try and mitigate
those issues.

Anyway, it seems that the migration code is having an issue at least with the
IDENTITY sequence because you must have restarted the numbering in your hsqldb
table at some stage. Firebird relies on generators to create autoincremented ID
entries, and I'm guessing that the current migration code doesn't know how to
convert the renumbering here.


Created a test file from the SQL in your original report.
Chose 0 as the initial counter for the ID field, saved the DB, then altered it
to restart numbering at 140 as per the ALTER TABLE statement.
Saved the ODB, quit LO, made a copy, then loaded the copy of the original ODB
file and agreed to migration.
Error message as described by original poster.

Confirming.

Version: 6.3.0.4
Build ID: 057fc023c990d676a43019934386b85b21a9ee99
Threads CPU : 8; OS : Mac OS X 10.14.6; UI Render : par défaut; VCL: osx; 
Locale : fr-FR (fr_FR.UTF-8); Langue IHM : fr-FR
Calc: threaded

-- 
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/20190820/d7d09830/attachment.html>