Bug 138241 - running report on deleted table gives impolite message
Summary: running report on deleted table gives impolite message
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Base (show other bugs)
Version:
(earliest affected)
7.1.0.0.alpha1+
Hardware: All Linux (All)
: medium minor
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: bibisected, bisected, regression
Depends on:
Blocks:
 
Reported: 2020-11-15 18:03 UTC by Terrence Enger
Modified: 2024-11-08 07:23 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments
screenshot of error message (226.32 KB, image/png)
2020-11-15 18:03 UTC, Terrence Enger
Details
broken database (6.02 KB, application/vnd.oasis.opendocument.database)
2020-11-15 18:05 UTC, Terrence Enger
Details
message (121.29 KB, image/png)
2021-03-23 15:48 UTC, mkrajnak
Details
Shows different error messages for failing report since LO 6.4.7.2 (93.51 KB, application/pdf)
2022-11-07 14:52 UTC, Robert Großkopf
Details
tail of bibisect output in repo linux-64-7.2 (2.95 KB, text/plain)
2022-11-08 19:53 UTC, Terrence Enger
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Terrence Enger 2020-11-15 18:03:14 UTC
Created attachment 167314 [details]
screenshot of error message

STR

( 0) Optionally download soon-to-be-attached
     embedded_fb_missing_table.odb and skip to step (8).

( 1) Create a new embedded Firebird database.

( 2) Create a table.

( 3) Create a report based on the table.

( 4) Save as embedded_fb_missing_table.odb.

( 5) Close and reopen embedded_fb_missing_table.odb.

( 6) Delete the table.

( 7) Save and close the .odb.

( 8) Open embedded_fb_missing_table.odb.

( 9) In pane Database, click <Reports>.

(10) In lower pane Reports, click <Table1>.

     Expected : a polite error message

     Observed : as per attached screenshot, a dialog box with two java
                backtraces before the dialog runs off the bottom of my
                screen

This observations is from a local build of commit 38b1497d
(2020-11-04), built and running on debian-buster.

Aside:  this report arises from poking into bug 138201.
Comment 1 Terrence Enger 2020-11-15 18:05:50 UTC
Created attachment 167315 [details]
broken database
Comment 2 Telesto 2020-11-15 22:41:20 UTC
@Off-topic
Expected some kind of "IDIOT" warning message based on they title. As variant to 'b0rked' :-). But they dialog info doesn't seem useful/helpful, I admit that [based on screenshot; didn't test]
Comment 3 Robert Großkopf 2020-11-16 19:53:22 UTC
Tested this one. The first paragraph of the message is the same you get in LO 7.0.3.1 - says there doesn't exist a table named "Table1". This part is also translated in the language you choose.
And this is the same I get with LO 7.1.0.0Alpha1+ from 2020-11-06 and 2020-11-13

So I couldn't confirm the behavior on OpenSUSE 15.1 64bit rpm Linux
Comment 4 mkrajnak 2021-03-23 15:48:26 UTC
Created attachment 170663 [details]
message

I was able to reproduce this with libreoffice-base-7.1.0.3-3.el9.x86_64

1. Create new empty database
2. Add just 4 simple VARCHAR fields, no data
3. Save and run report wizard
4. In Report Wizzard add all fields, click Finish

The similiar ugly message. The same reproducer works without errors in libreoffice-base:6.4.7.2-5
Comment 5 Jorge Teixeira 2022-11-07 13:36:38 UTC
Bug still present in LO 7.4.2.3 with the "broken database.odb" reproducer.

Version: 7.4.2.3 (x64) / LibreOffice Community
Build ID: 382eef1f22670f7f4118c8c2dd222ec7ad009daf
CPU threads: 8; OS: Windows 10.0 Build 19044; UI render: Skia/Raster; VCL: win
Locale: pt-PT (pt_PT); UI: en-US
Calc: threaded

I suggest renaming this bug to:
"Opening a Report referencing a deleted Table results in a verbose error message (callstack trace) that is not user-friendly".
Comment 6 Robert Großkopf 2022-11-07 14:52:59 UTC
Created attachment 183448 [details]
Shows different error messages for failing report since LO 6.4.7.2

Tested with OpenSUSE 15.3. Have installed different version of LO here.
Up to LO 6.4.7.2 the error-message is, as it should be.
LO 7.0.0.3 give an uncomplete message, which is been shown later in LO 7.0 as it appears for many messages in databases: Something with ./home/buildslave…

Since LO 7.2.0.3 there has been added all the stuff about the report builder.
Comment 7 Robert Großkopf 2022-11-07 14:57:56 UTC
Must be a regression. So I set the keyword, but I can't set the right version for this bug. Bug appears here first in LO 7.2.0.3, but is also detected by others here with earlier versions. Hope everybody did test it with LO directly from LibreOffice, not with a special build of a Linux-version.
Comment 8 Terrence Enger 2022-11-08 19:53:18 UTC
Created attachment 183480 [details]
tail of bibisect output in repo linux-64-7.2

Working on debian-buster in bibisect repository linux-64-7.2, and
taking the display of java callstacks as "bad", I see

    state  commit    s-h       date
    -----  --------  --------  -------------------
    good   be461b0d  ff673ce8  2021-05-03 10:02:18
    bad    9f0f3be6  ed33d1d4  2021-05-03 10:33:33

leading to

    commit ed33d1d4928dc9886eaace62d3c62ea4305efdac
    Author:     Noel Grandin <noel.grandin@collabora.co.uk>
    AuthorDate: Mon May 3 09:59:08 2021 +0200
    Commit:     Noel Grandin <noel.grandin@collabora.co.uk>
    CommitDate: Mon May 3 12:33:33 2021 +0200

        clean up some Java warnings
    
        Change-Id: Id54e8fd6803c3a6c0d924338d1781679ed0b1bfd
        Reviewed-on: https://gerrit.libreoffice.org/c/core/+/115025
        Tested-by: Jenkins
        Reviewed-by: Noel Grandin <noel.grandin@collabora.co.uk>

I am removing keyword bibisect request and adding bibisected and
bisected.
Comment 9 Terrence Enger 2022-11-08 19:53:57 UTC
(In reply to mkrajnak from comment #4)

I do not see the problem in the Report Wizzard in bibisect repository
linux-64-7.5 s-h cfc8a8f5.
Comment 10 QA Administrators 2024-11-08 03:15:04 UTC Comment hidden (obsolete)
Comment 11 Robert Großkopf 2024-11-08 07:23:53 UTC
Tested with
Version: 24.8.3.1 (X86_64) / LibreOffice Community
Build ID: 65412f067af443213e726c93f137ccc85c9a1e06
CPU threads: 6; OS: Linux 6.4; UI render: default; VCL: kf5 (cairo+xcb)
Locale: de-DE (de_DE.UTF-8); UI: de-DE
Calc: threaded

Bug still exists.

Error message gives detailed information about report job.

"Document "Table1" couldn't be opened.
org.libreoffice.report.ReportExecutionException: Doen't exist "Table1"."

This would be enough for the user. Second row is repeated with many details.