Bug 132713 - FILEOPEN Old base file (*.dbf) created in LO fails to open in 6.4.2.2
Summary: FILEOPEN Old base file (*.dbf) created in LO fails to open in 6.4.2.2
Status: RESOLVED INSUFFICIENTDATA
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Base (show other bugs)
Version:
(earliest affected)
6.4.2.2 release
Hardware: x86-64 (AMD64) All
: high major
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: bibisectRequest, regression
Depends on:
Blocks:
 
Reported: 2020-05-05 12:03 UTC by Jacques
Modified: 2022-11-06 03:40 UTC (History)
6 users (show)

See Also:
Crash report or crash signature:


Attachments
DBF file does not open in LO 6.4 (175.92 KB, application/x-dbf)
2020-05-05 12:05 UTC, Jacques
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Jacques 2020-05-05 12:03:53 UTC
Description:
I used to maintain an address list of about 900 names in LO Base, but did not use it for about 3 or so years.I wanted to now use it again.
I tried opening as Spreadsheet as well as Writer - same error message.
I tried using various Character set selections, none works.
The *.dbt and *.adx files opened.

Error message:
General Error.
General input/output error.

Steps to Reproduce:
I attach the file

Actual Results:
Cannot open file

Expected Results:
File should open - especially as it was created in LO


Reproducible: Always


User Profile Reset: No



Additional Info:
None
Comment 1 Jacques 2020-05-05 12:05:28 UTC
Created attachment 160376 [details]
DBF file does not open in LO 6.4
Comment 2 Robert Großkopf 2020-05-05 12:55:02 UTC
I have tested this with the attached file. No problem here to open the *.dbf with LO 6.4.4.1 on OpenSUSE 15.1 64bit rpm Linux.

You are using Ubuntu. Do you use the packages of Ubuntu or do you use the packages from LO directly?

One hint for the attachment: Everybody in the whole world could read it. It isn't a good idea to attach personal data here. I will try to delete the attachment. Don't know if I'm allowed to.
Comment 3 Robert Großkopf 2020-05-05 12:57:05 UTC Comment hidden (obsolete)
Comment 4 Jacques 2020-05-05 13:03:54 UTC
Thanks for your trouble
Also thanks for deleting the DBF
weird...

Did you ope without selecting character set?

So an Ubuntu problem?
I've seen some Windows users having a similar problem and they had to install some Java runtime update.
Would that be a solution?

I installed from LibreOffice Download site - https://www.libreoffice.org/download/download/
Comment 5 Robert Großkopf 2020-05-05 15:13:01 UTC
(In reply to Jacques from comment #4)
> Thanks for your trouble
> Also thanks for deleting the DBF

Isn't deleted yet. I can't delete it. I have only set it to "obsolete" ...

> Did you ope without selecting character set?

I have only put the file in a folder with other *.dbf-files. I opened the database connecting to this folder. The table could be opened without any problem.

Selecting character set is only available when you open the file with Calc, not with Base - but it will work the same way here.
> 
> So an Ubuntu problem?
> I've seen some Windows users having a similar problem and they had to
> install some Java runtime update.

Isn't there a jre on your system? Base needs this jre for many functions. So have a look at Tools > Options > LibreOffice > Advanced and activate the jre your system installed.
> 
> I installed from LibreOffice Download site -
> https://www.libreoffice.org/download/download/

So it's the original and we should have the same versions here.
Comment 6 Alex Thurgood 2020-05-06 07:51:54 UTC
Confirming that file doesn't load, irrespective of codepage choice, in:

Version : 6.4.3.5
Build ID : 4db9852e73d9e9d662fc8a2783bace79addf1805
Threads CPU : 8; OS : Mac OS X 10.15.4; UI Render : par défaut; VCL: osx; 
Locale : fr-FR (fr_FR.UTF-8); Langue IHM : fr-FR
Calc: threaded
Comment 7 Alex Thurgood 2020-05-06 07:53:45 UTC
Error message is :

Erreur de lecture.
Impossible d'établir un lien avec le fichier

roughly translated as :

Read error.
Impossible to establish link to file.
Comment 8 Alex Thurgood 2020-05-06 07:56:10 UTC
The file loads correctly in Calc with

Version: 5.4.7.2
Build ID: c838ef25c16710f8838b1faec480ebba495259d0
Threads CPU : 8; OS : Mac OS X 10.15.4; UI Render : par défaut; 
Locale : fr-FR (fr_FR.UTF-8); Calc: group

==> regression
Comment 9 Alex Thurgood 2020-05-06 08:00:05 UTC
The file also loads correctly in Calc LO6282 macOS 10.15
Comment 10 Alex Thurgood 2020-05-06 08:01:57 UTC
Also loads correctly in

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

so this is a relatively recent bug introduced in the 6.4.x line
Comment 11 Alex Thurgood 2020-05-06 08:05:24 UTC
I can also get the file to load in LO6432...but LO6435
Comment 12 Alex Thurgood 2020-05-06 08:05:39 UTC
Not LO6435
Comment 13 Jacques 2020-05-06 09:35:40 UTC
Thanks everyone
As things were too hectic to try and solve this, I opened the file in an old Windows box.

I also tried to open other *.dbf files - nothing works.

There must be a clash with operating on Ubuntu 18.04.4 LTS
Comment 14 Alex Thurgood 2020-05-06 10:26:38 UTC
(In reply to Jacques from comment #13)


> There must be a clash with operating on Ubuntu 18.04.4 LTS

No, it isn't just Ubuntu, my tests were done on macOS, and it fails to open for me in LO6435, per comment 6.
Comment 15 Robert Großkopf 2020-05-06 12:46:37 UTC
I have tested it again with different versions and now opening it in Calc. I have no problems to open the file in LO 6.3.0.3, 6.4.0.3, 6.4.3.2 and 6.4.4.1 So I couldn't confirm any buggy behavior.

Could it be a special problem of *.deb-packages and Mac?

Tested with OpenSUSE 15.1 64bit rpm Linux.
Comment 16 Xisco Faulí 2020-05-14 08:07:03 UTC
I can't reproduce it in

Version: 7.0.0.0.alpha1+
Build ID: 86bc13248c1d9f63b10aac304bdf0361d1dcc47f
CPU threads: 4; OS: Linux 4.19; UI render: default; VCL: gtk3; 
Locale: en-US (en_US.UTF-8); UI: en-US
Calc: threaded

nor in

Versão: 6.4.3.2 (x64)
ID da versão: 747b5d0ebf89f41c860ec2a39efd7cb15b54f2d8
Processos do CPU: 1; SO: Windows 6.1 Service Pack 1 Build 7601; Gestão da interface: padrão; VCL: win; 
Configuração regional: es-ES (es_ES); Idioma da interface: pt-PT
Calc: threaded

@Jacques, @Alex, You are testing with attachment 160376 [details], right ? why the document is set as obsolete?
Both of you use french locale, isn't it ? might it be the reason why you are having this issue ?
Comment 17 Jacques 2020-05-14 08:21:26 UTC
Xisco Faulí
* Used in UK English setup.
* All the "problematic" files seem to be problems only on Ubuntu 18.04.4 LTS box.
Problem happens with any of my old LO files, as well as *.DBF files created in other applications.

BTW: it is the same box I used previously for earlier versions of LO.

So I cannot but conclude that somehow a bug slipped into later releases of LO.
Comment 18 Robert Großkopf 2020-05-14 09:49:56 UTC Comment hidden (obsolete)
Comment 19 Xisco Faulí 2020-05-14 09:51:37 UTC
(In reply to Robert Großkopf from comment #18)
> (In reply to Xisco Faulí from comment #16)
> 
> > why the document is set as obsolete?
> 
> I have set it to "obsolete", because I can't delete it. Personal data as an
> attachment for a public bugtracker isn't a good idea.

I can delete it but it would be good to have another annomalyzed reproduced first
Comment 20 Julien Nabet 2020-05-14 10:36:57 UTC
On pc Debian x86-64 with master sources updated today, I got a popup message to select encoding.
I use by default one (Western Europe (DOS/OS2-850/International)), no pb.

I noticed these traces on console:
warn:svx.dialog:48910:48910:svx/source/dialog/txencbox.cxx:243: SvxTextEncodingTreeView::InsertTextEncoding: no resource string for text encoding: 91
warn:svx.dialog:48910:48910:svx/source/dialog/txencbox.cxx:243: SvxTextEncodingTreeView::InsertTextEncoding: no resource string for text encoding: 92

According to https://opengrok.libreoffice.org/xref/core/include/rtl/textenc.h?r=189abcf0#128
these encodings correspond to:
#define RTL_TEXTENCODING_ADOBE_STANDARD         (RTL_TEXTENC_CAST( 91 ))
#define RTL_TEXTENCODING_ADOBE_SYMBOL           (RTL_TEXTENC_CAST( 92 ))
Comment 21 Jacques 2020-05-14 14:25:03 UTC
 Julien Nabet 
I tested again with DOS/OS2-850/International after seeing your message, still no luck.
I have tried many of the character-set options - as reported in earlier notice.
Comment 22 Buovjaga 2020-06-10 18:54:24 UTC
No problem for me on Arch Linux or Windows 10. I also tried with French UI and locale.
Comment 23 raal 2021-04-07 17:56:17 UTC
Works for me in Version: 7.2.0.0.alpha0+ / LibreOffice Community
Build ID: c47ad11f8c2e917adebbd5d7b3a3ef6cc4b3e670
CPU threads: 4; OS: Linux 5.8; UI render: default; VCL: gtk3
Locale: cs-CZ (cs_CZ.UTF-8); UI: en-US
Calc: threaded
Ubuntu 20.10
Comment 24 Timur 2022-03-10 14:38:57 UTC
This bug is of no use as is, because it's not reproducible, also for me in Ubuntu 18.04, it opens in Calc with any LO. 
I set Needinfo for reporter to test again with current LO, or with User Profile Reset or to check Java as indicated.
Comment 25 Jean-Baptiste Faure 2022-04-05 13:15:13 UTC
No problem to open the file with Version: 7.4.0.0.alpha0+ / LibreOffice Community
Build ID: be7d84a3fbd47bf9a078ac7e6854bc4927e84933
CPU threads: 8; OS: Linux 5.13; UI render: default; VCL: gtk3
Locale: fr-FR (fr_FR.UTF-8); UI: en-US
Ubuntu_20.04_x86-64
Calc: threaded

It opens in Calc.

Best regards.
JBF
Comment 26 Jean-Baptiste Faure 2022-04-05 13:17:48 UTC
No problem to open the file in Version: 7.3.3.0.0+ / LibreOffice Community
Build ID: 0a34ac386187c5ca328aebc27851c2a2ff38f293
CPU threads: 8; OS: Linux 5.13; UI render: default; VCL: gtk3
Locale: fr-FR (fr_FR.UTF-8); UI: fr-FR
Ubuntu_20.04_x86-64
Calc: threaded

@Jacques, please could you try with the current version 7.3?

Best regards.
JBF
Comment 27 QA Administrators 2022-10-06 04:11:19 UTC Comment hidden (obsolete)
Comment 28 QA Administrators 2022-11-06 03:40:15 UTC
Dear Jacques,

Please read this message in its entirety before proceeding.

Your bug report is being closed as INSUFFICIENTDATA due to inactivity and
a lack of information which is needed in order to accurately
reproduce and confirm the problem. We encourage you to retest
your bug against the latest release. If the issue is still
present in the latest stable release, we need the following
information (please ignore any that you've already provided):

a) Provide details of your system including your operating
   system and the latest version of LibreOffice that you have
   confirmed the bug to be present

b) Provide easy to reproduce steps – the simpler the better

c) Provide any test case(s) which will help us confirm the problem

d) Provide screenshots of the problem if you think it might help

e) Read all comments and provide any requested information

Once all of this is done, please set the bug back to UNCONFIRMED
and we will attempt to reproduce the issue. Please do not:

a) respond via email 

b) update the version field in the bug or any of the other details
   on the top section of our bug tracker

Warm Regards,
QA Team

MassPing-NeedInfo-FollowUp