Created attachment 95787 [details] Firebird_Base_more_10_rows 1. Create ODS file with more than 10 rows 2. Create Firebird database 3. Import ODS Sheet into database tables by dragging ODS sheet into Base tables. 4. If the table has more than 10 rows opening fails if less, Base opens table. See attachment. Using HSQLDB everything seems to be ok.
If more then 10 rows, one can get an error: firebird_sdbc error: *Dynamic SQL Error *SQL error code = -804 *Incorrect values within SQLDA structure caused by 'isc_dsql_fetch'
Can not confirm that it is the number of rows which is the problem on my Linux master 4.3 build with a test Calc sheet imported into an empty Firebird ODB containing 20 or more rows. The problem is more likely to lie in the field definition or the character strings of your varchar fields. Can you post your ODS file so we can test ? Alex
Any relation to bug 74019 ? Alex
Alex, ODS is uploaded ... with two tables one which contains 10 rows and one which more than 10 rows ... Brgds, Piotr
Could be the duplicate of https://bugs.freedesktop.org/show_bug.cgi?id=74019
Sorry I made a mistake ... my bad! Not rows but columns! More than 10 columns make and error ...
wabik: Following this comment https://bugs.freedesktop.org/show_bug.cgi?id=74019#c7, could you give a try to 4.2.5 or 4.2 daily build (see http://dev-builds.libreoffice.org/daily/libreoffice-4-2/) ?
Tested on LO 4.2.5.1 ... still not working :( Table is imported but cannot be opened. Error: Kod błędu: 1 firebird_sdbc error: *Dynamic SQL Error *SQL error code = -804 *Incorrect values within SQLDA structure caused by 'isc_dsql_fetch'
On pc Debian x86-64 with 4.2.4 LO version, I can reproduce this. I don't reproduce this with 4.2 sources updated some days ago. Wabik: for the test, could you give a try to the daily 4.2 build (future 4.2.6)?
Version: 4.2.6.0.0+ Build ID: 743bcdebef21deeb73f0111b4e6e047c88fd7b8f TinderBox: Win-x86@42, Branch:libreoffice-4-2, Time: 2014-06-04_14:23:07 The same error: Error code: 1 firebird_sdbc error: *Dynamic SQL Error *SQL error code = -804 *Incorrect values within SQLDA structure caused by 'isc_dsql_fetch'
Thank you for your feedback, no idea then :-(.
Confirming also on OSX with LO 4242, changing OS to all
Wabik/Alex: Following the fix of fdo#74019, would you have some time to give a try to a recent (less than 3 weeks ago) 4.2 daily build?
Seems that git push for fdo#74019 fixes this bug also I have tested with a sheet > 20 rows as described above and no crashes libo Version: 4.4.0 So this can be closed
Thank you for the feedback. So let's put this as FIXED Wabik/Alex: Don't hesitate to reopen this tracker, if you can still reproduce this.
Thanks for closing it also i have tested with more than 10 columns and seems to be stable: nocrashes :)