Bug 140285 - Reportbuilder - adding or removing fields in report causes Libreoffice to crash
Summary: Reportbuilder - adding or removing fields in report causes Libreoffice to crash
Status: RESOLVED INSUFFICIENTDATA
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Base (show other bugs)
Version:
(earliest affected)
7.1.0.3 release
Hardware: x86-64 (AMD64) Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2021-02-09 08:36 UTC by jorojmaqui
Modified: 2022-10-07 03:38 UTC (History)
4 users (show)

See Also:
Crash report or crash signature: https://crashreport.libreoffice.org/stats/crash_details/fdcdbbcf-69a7-4907-bc9a-a402c167288e


Attachments
salary problems when editing reports (7.28 MB, application/vnd.sun.xml.base)
2021-02-09 08:36 UTC, jorojmaqui
Details
information (132.12 KB, application/pdf)
2021-02-11 09:08 UTC, jorojmaqui
Details
report_sql_breaks (193.59 KB, application/pdf)
2022-02-28 13:01 UTC, jorojmaqui
Details

Note You need to log in before you can comment on or make changes to this bug.
Description jorojmaqui 2021-02-09 08:36:18 UTC
Created attachment 169603 [details]
salary problems when editing reports

when using want to work with create report in libreoffice base, it crashes and I completely exit the program
Comment 1 jorojmaqui 2021-02-11 09:08:28 UTC
Created attachment 169666 [details]
information
Comment 2 Alex Thurgood 2021-02-11 10:21:20 UTC
@jorojmaqui :

I am testing on :

Version: 7.0.4.4
Build ID: 841d27ff4cd6850c43bdd7333f8373cae686520d
CPU threads: 8; OS: Mac OS X 11.2; UI render: default; VCL: osx
Locale: fr-FR (fr_FR.UTF-8); Langue IHM : fr-FR
Calc: threaded


I notice that the test file contains macros.
If I activate the macros on loading the ODB, I get an error message :

Error #1 (An exception occurred : ) at line 1302 in OpenConnection

Is it possible to test the problem of editing a report without having activated the macro environment ?

Please provide detailed steps for testing, for example, which report are we supposed to be opening / editing ?
Comment 3 Alex Thurgood 2021-02-11 10:23:40 UTC
Trying to test with LO Vanilla from Collabora as provided via the Apple AppStore leads to the following error message :

firebird_sdbc error:
*lock manager error
*failed to create database /Users/alex/Library/Containers/com.collabora.libreoffice-free/Data/Library/Application Support/LibreOfficeVanilla/4/user/temp/lu17362qz8l.tmp/lu17362qz8u.tmp/firebird.fdb
*Exiting before completion due to errors
caused by
'isc_service_query'
Comment 4 Alex Thurgood 2021-02-11 10:26:12 UTC
Tested with:

Version: 7.1.0.1
Build ID: b585d7d90ab863bf29b2d110c174c0c2a98f3ee4
CPU threads: 8; OS: Mac OS X 10.16; UI render: default; VCL: osx
Locale: fr-FR (fr_FR.UTF-8); UI: en-US
Calc: threaded

1) Open ODB file.
2) Open Report named R3xSALARIOSxIRPF
3) No crash.
Comment 5 jorojmaqui 2021-02-12 21:16:45 UTC
so: windows 10.0 build 19041
libreoffice community 7.1.1 (x86)
cpu:4
vcl:win
IU:skia/rej
interface: ES


If you spend a while copying fields, attaching fields and deleting, the program breaks
disabling experimental functions also exits
Comment 6 QA Administrators 2021-02-13 04:05:13 UTC Comment hidden (obsolete)
Comment 7 jorojmaqui 2021-02-17 20:52:53 UTC
By placing a field in the report that breaks libreoffice
Comment 8 Alex Thurgood 2021-02-18 11:04:46 UTC
Sounds similar to bug 134195
Comment 9 Alex Thurgood 2021-02-18 11:06:16 UTC
FWIW, that bug report is also specific to behaviour reported on WinOS
Comment 10 Alex Thurgood 2021-03-12 10:08:37 UTC Comment hidden (obsolete)
Comment 11 Alex Thurgood 2021-03-12 10:09:44 UTC Comment hidden (obsolete)
Comment 12 jorojmaqui 2021-03-17 20:39:23 UTC
The program breaks again with Libreoffice 7.1.2.1 on Windows 10

Crash report again
Comment 13 jorojmaqui 2021-03-30 13:30:12 UTC
The program breaks again with Libreoffice 7.1.2.2 on Windows 10

Crash report again
Comment 14 jorojmaqui 2021-04-30 11:00:09 UTC
Libreoffice 7.1.3.2 Crash report
Comment 16 Alex Thurgood 2021-05-03 08:01:07 UTC
@joro : according to the crash report, you have set a listener somewhere in your report, and switching from that listener to another (or releasing it), is causing a crash in the rptuilo library.

Is there any basic code execution associated with your report creation ?

Looking at the crash report detail :
comphelper::OInterfaceContainerHelper2::forEach<com::sun::star::view::XSelectionChangeListener,<lambda_d58ac2fab180795b2081e04b15f6c6f1>

So, which selection change (XSelectionChangeListener, presumably made with the mouse) is causing this to happen ?

Seems linked to the header identified in : 
\comphelper\interfacecontainer2.hxx at line 266

Not much else I can say, I'm afraid.
Comment 17 jorojmaqui 2021-05-03 08:18:43 UTC
thank you
Comment 18 jorojmaqui 2021-07-01 09:08:59 UTC
Mi pregunta es: en sistema linux este error no existe?
Si es así podría seguir con mi programa en linux hasta que este error esté resulto en Windows

My question is: in linux system this error does not exist?
 If so, I could continue with my program in linux until this error is resolved in Windows
Comment 19 Robert Großkopf 2021-07-01 13:56:32 UTC
(In reply to jorojmaqui from comment #18)
> 
> My question is: in linux system this error does not exist?
>  If so, I could continue with my program in linux until this error is
> resolved in Windows

Sometimes Report Builder crashes under Linux, but without possibility to get a real reason for it. So I prefer the following method:
After some Minutes of working with ReportBuilder I will save the report and save the *.odb-file. So the changed content won't be lost.

Creating a report is unstable, but executing a report, which has already been created, will work well.
Comment 20 jorojmaqui 2021-07-12 20:40:28 UTC
I have installed libreoffice 7.1.4.2 on Ubuntu and it gives me the same problem with the reports of this database, except that the error that occurs can be sent. 

crash
Comment 21 picopa88 2021-07-13 04:05:55 UTC Comment hidden (spam)
Comment 22 jorojmaqui 2022-01-18 11:52:56 UTC
Hello
When will this problem be fixed?
Comment 23 jorojmaqui 2022-02-28 13:01:39 UTC
Created attachment 178576 [details]
report_sql_breaks
Comment 24 Alex Thurgood 2022-03-01 12:08:37 UTC
(In reply to jorojmaqui from comment #23)
> Created attachment 178576 [details]
> report_sql_breaks

This last report is different to what you reported in comment 5 (copying/adding/removing fields).

This last report relates to a crash caused by entering and exiting the SQL list dialog after having edited the query.

As we do not know what the complete query is (we can't see it in the report), we can't tell whether the new issue is due to the query itself, or some other problem with the use of the SQL list functionality. 

Please open a separate bug report for this.

The current issue that you initially reported can not be fixed because no one has managed to reproduce it, mainly because you didn't provide any instructions on what exactly to do in order to see the behaviour you were reporting.


General instability of the report builder is known, as Robert has pointed out in comment 19. The problem is to identify which particular behaviour causes any given crash.
Comment 25 Xisco Faulí 2022-03-09 11:38:35 UTC
Thank you for reporting the bug.
Could you please try to reproduce it with the latest version of LibreOffice from https://www.libreoffice.org/download/libreoffice-fresh/ ?
I have set the bug's status to 'NEEDINFO'. Please change it back to 'UNCONFIRMED' if the bug is still present in the latest version.
Comment 26 QA Administrators 2022-09-06 03:53:38 UTC Comment hidden (obsolete)
Comment 27 QA Administrators 2022-10-07 03:38:39 UTC
Dear jorojmaqui,

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