Description: Database had four tables... Followed the notes to convert dates to text in each table... ran upgrade utility... DOUBLE Fields did not process... Reloaded another back up and converted dates and DOUBLE to text and then ran utility and converted fine... BUT one table lost 200 or so records that just disappeared... Ran out of time, so reloaded back to 6.2.5 to continue database use... will try again when I have more time... Steps to Reproduce: 1. Process Base Table Upgrade to Firebird 2. 3. Actual Results: See above in description field.... Expected Results: Lost 200 table records.... Reproducible: Always User Profile Reset: No Additional Info: Process all tables properly....
Thank you for reporting the bug. Please attach a sample document, as this makes it easier for us to verify the bug. (Please note that the attachment will be public, remove any sensitive information before attaching it. See https://wiki.documentfoundation.org/QA/FAQ#How_can_I_eliminate_confidential_data_from_a_sample_document.3F for help on how to do so.) I have set the bug's status to 'NEEDINFO'. Please change it back to 'UNCONFIRMED' once the requested document is provided.
Created attachment 153387 [details] Sample database This is as sample database with only 2 tables... the two tables would have the same # of records 358 normally... but the Invoice table only coverted 158 records... No data is included... just an anonymous sample....
Added testing... 1. Stopping of the upgrade utility and missing rows of data was linked to a data format error in one field.. When corrected the upgrade ran to completion.. 2. The utility dd NOT process DOUBLE format... had to follow similar steps as for DATE fields... ie. Copy as text VARCHAR, run upgrade and copy back... 3. Confirm that query and sub form setting in content.xml fix was needed to allow for my queries and forms to work...
@Brent : the double conversion issue (or failure thereof) should have been resolved in bug 126268 for LO6302 *** This bug has been marked as a duplicate of bug 126268 ***
@Brent : if the double conversion/migration issue is indeed a problem, then bug 126268 would need to be reopened.
Hello Brent, I've just opened your file, it only contains 1 row in each table. Please attach the correct file, Even in HSQLDB
The data in the database is proprietary and will not be posted, open to the Internet... The database structure is as posted with one sample record... add whatever you need to test...