Description: I have a LibreOffice Writer document with 2 mail merge fields which links to a Base file in the same folder. The Base file is fed from a spreadsheet in the same folder. Every time I open the Writer document and attempt to do a mail merge I get an exception: The connection to the data source "Constats Database" could not be established. the file (path to spreadsheet) could not be loaded../connectivity/source/commontools/dbexception.cxx:413 Steps to Reproduce: 1.Open the Writer document & Print (mail merge) 2.Error exception Actual Results: Base cannot find the spreadsheet Expected Results: The dialogue box should open to allow me to select the rows in the database I want to merge. Reproducible: Always User Profile Reset: No Additional Info: I have to try to establish a new database connection every time. The dialogue box show me all the previous database links that have been made but I can't connect to any of them, nor can I remove them. Every new link is incremented by 1.
(In reply to besancon4me from comment #0) > The Base file is fed from a spreadsheet in the same folder. It's always like that, Base file is created. > I have to try to establish a new database connection every time. You didn't explain in detail what you do. You may need to try Edit-Exchange database. Please try to recreate the problem using in-built Bibliography database, and attach ODT with those fields. > User Profile Reset: No Please do this, rename LO profile folder.
Created attachment 181182 [details] Error message - the connection could not be established
"It's always like that, Base file is created." I don't think you understand. I realise that when you FIRST create a mail merge document in Open Office you link it to a spreadsheet and that generates a datanbase file from the spreadsheet. That much is clear. The first mail merge worked fine. But a few days later I needed to do another mail merge using the same Open Office text file, the same spreadsheet and the same database, but this returned an error. The only way I could get the merge to work was to make an entirely new link. This surely cannot be expected behaviour? I am attaching screen shots of the error messages to this report. I am also attaching a screen shot of the log file, which seems to be indicating some kind of a problem with snaps. I don't know if this is related, but it happened when I tried to recreate the error, and the whole Open Office application froze.
Created attachment 181183 [details] Screenshot of error logs
Created attachment 181184 [details] second screen shot of error logs
Created attachment 181185 [details] Rather unhelpful error messages
So it's Linux. You should still follow suggestions from Comment 1 and maybe try to relocate ODS from that long path.
Sorry but I did not understand your 'suggestions" in Comment 1. Could you reword in pl
...could you reword in plain English, please?
[Automated Action] NeedInfo-To-Unconfirmed
First error message: Does the path file:///home/lorna/TEFL/aaa%20ILCF%20Chanb%C3A9ry/02%20SNCF%20constats%20tests/Constats/Constats/Calendar%20entries.ods really exist?
The path exists, but the folder names contain spaces which have been filled with the characters %20 and accented characters have been rendered as %C3A9. Is it possible that the code is unable to cope with a long path name? I know long file names can sometimes cause issues, and certain special characters such as question marks in a file or folder name can mess up backups etc.
Bug needs to be reproducible. To ask you to attach that ODS here is too early. You should try to solve yourself, but write what you tried. 1. We don't know how you re-register ODS, is it via Edit - Exchange database? 2. Move ODS to TEFL folder and re-register it. 3. Try to rename 'user' profile folder where LO is. 4. If you still have a problem, try to recreate the problem using in-built Bibliography database, create and attach ODT with those fields.
(In reply to besancon4me from comment #12) > > Is it possible that the code is unable to cope with a long path name? I know > long file names can sometimes cause issues, and certain special characters > such as question marks in a file or folder name can mess up backups etc. Have tested this with a path name like this: file:///home/robby/Dokumente/Datenbanken/Sportverein/Neuer%20Ordner/%C3%9Cber%20den%20Wolken/calc%20%3F%20noch%20mehr/Calc_Adress.ods There are spaces, one "Ü" and a "?" in the path. Path is a little bit longer than path, which doesn't work as reported. I have created a file for mail merge in this path. I could execute the mail merge without any problem. Data were found and set in Writer document. So I shut down LO, restart the whole system, restart LO and tried again. Again no problem while executing mail merge. Tested all with OpenSUSE 15.3 64bit rpm Linux. LibreOffice Version: 7.3.5.1 / LibreOffice Community Build ID: d56c1c78db15939340c3db8ee3b6667832313d23 CPU threads: 6; OS: Linux 5.3; UI render: default; VCL: kf5 (cairo+xcb) Locale: de-DE (de_DE.UTF-8); UI: de-DE Calc: threaded I couldn't find any buggy behavior here.
@besoncon4me : Could you tell us which kind of package version of LibreOffice you are using ? Are you using TDF packages, or Linux distrib provided packages, or Snap, Flatpak, etc ?
Dear besancon4me, This bug has been in NEEDINFO status with no change for at least 6 months. Please provide the requested information as soon as possible and mark the bug as UNCONFIRMED. Due to regular bug tracker maintenance, if the bug is still in NEEDINFO status with no change in 30 days the QA team will close the bug as INSUFFICIENTDATA due to lack of needed information. For more information about our NEEDINFO policy please read the wiki located here: https://wiki.documentfoundation.org/QA/Bugzilla/Fields/Status/NEEDINFO If you have already provided the requested information, please mark the bug as UNCONFIRMED so that the QA team knows that the bug is ready to be confirmed. Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-NeedInfo-Ping
Dear besancon4me, 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