Bug#875688: libreoffice-report-builder: Design view missing from libre office base. Existing reports won't run.

[Giuseppe Barichello]

On Sun, 17 Sep 2017 19:43:05 +0200 Giuseppe Barichello 
 wrote:

> On Fri, 15 Sep 2017 14:19:07 +0200 Francesco  wrote:
>
> I'm having the same problem as Guido and you. My reports were built 
in 2015.

> Creating a new report works without issues for me too.
>

Just tried to open the same base file with a previous version (5.2.7.2) 
on another machine: reports open without problems.


I also removed and reinstalled LO (5.4.1.2 debian package) on my pc, to 
no avail.

Bug#875688: libreoffice-report-builder: Design view missing from libre office base. Existing reports won't run.

[Giuseppe Barichello]

On Fri, 15 Sep 2017 14:19:07 +0200 Francesco  wrote:

> I was considering it an extension 'cause I have the same error of Guido;
> so could be interesting to see what's the missing extension or if now 
for some
> reports is considered like an extension. I don't think my report 
could be

> older than 2013, but it's possible.
>

I'm having the same problem as Guido and you. My reports were built in 2015.
Creating a new report works without issues for me too.

TIA

Bug#875688: libreoffice-report-builder: Design view missing from libre office base. Existing reports won't run.

[Francesco]

In data venerdì 15 settembre 2017 07:37:52 CEST, Rene Engelhard ha scritto:
> On Fri, Sep 15, 2017 at 01:44:30AM +0200, Francesco wrote:
> > I think there is something missing in the package: I saw in
> 
> No, I got confused at first too because I misremembered, but...
> 
> > mysql-connector extension there is a path that looks like
> > /usr/lib/libreoffice/share/extensions/mysql-connector-ooo/, so
> > I expet to find something similar in report-builder or in
> > report-builder-bin package but nothing pointing to
> > .../share/extensions/...
> 
> ... the report builder is not a extension anymore since a long time (2013):
> It was converted to a proper "internal code":
> 
> https://cgit.freedesktop.org/libreoffice/core/commit/?id=90a326c7028d5af132c
> 62edfaef77c53627e4c0e

I was considering it an extension 'cause I have the same error of 
Guido; 
so could be interesting to see what's the missing extension or if now for some 
reports is considered like an extension. I don't think my report could be 
older than 2013, but it's possible.


-- 
Non pretendo che comprendiate il significato di quello che ho scritto senza 
averlo riletto un certo numero di volte. Personalmente, vi riterrei degli 
stupidi se lo faceste. Io l'ho letto sei volte ed ancora non l'ho capito.

Bug#875688: libreoffice-report-builder: Design view missing from libre office base. Existing reports won't run.

[Rene Engelhard]

On Fri, Sep 15, 2017 at 01:44:30AM +0200, Francesco wrote:
> I think there is something missing in the package: I saw in 

No, I got confused at first too because I misremembered, but...

> mysql-connector extension there is a path that looks like 
> /usr/lib/libreoffice/share/extensions/mysql-connector-ooo/, so 
> I expet to find something similar in report-builder or in
> report-builder-bin package but nothing pointing to 
> .../share/extensions/... 

... the report builder is not a extension anymore since a long time (2013):
It was converted to a proper "internal code":

https://cgit.freedesktop.org/libreoffice/core/commit/?id=90a326c7028d5af132c62edfaef77c53627e4c0e

Regards,

Rene

Bug#875688: libreoffice-report-builder: Design view missing from libre office base. Existing reports won't run.

[Francesco]

Package: libreoffice-report-builder
Version: 1:5.4.1-1
Followup-For: Bug #875688

Dear Maintainer,


I think there is something missing in the package: I saw in 
mysql-connector extension there is a path that looks like 
/usr/lib/libreoffice/share/extensions/mysql-connector-ooo/, so 
I expet to find something similar in report-builder or in
report-builder-bin package but nothing pointing to 
.../share/extensions/... 

For the opener of the bug: are you sure the mysql-connector
extension is used for report-builder? Isn't it's used for
you to connect to yor db? For me db works fine but not the
reporting tool, with the stock libreoffice and without the link
are you able to read your data?

For further information I tried to generate a new report and
it works fine, so I tink it's a form of incompatibility with older ones
whith same errors as reported by Guido.
Maybe we should investigate and find a way to migrate to a newer
format without recreating.



-- System Information:
Debian Release: buster/sid
  APT prefers testing
  APT policy: (500, 'testing'), (1, 'experimental')
Architecture: amd64 (x86_64)
Foreign Architectures: i386

Kernel: Linux 4.12.0-1-amd64 (SMP w/4 CPU cores)
Locale: LANG=it_IT.UTF-8, LC_CTYPE=it_IT.UTF-8 (charmap=UTF-8), LANGUAGE= 
(charmap=UTF-8)
Shell: /bin/sh linked to /bin/dash
Init: systemd (via /run/systemd/system)

Versions of packages libreoffice-report-builder depends on:
ii  libbase-java   1.1.6-2
ii  libcommons-logging-java1.2-1
ii  libflute-java  1:1.1.6-3
ii  libfonts-java  1.1.6.dfsg-3
ii  libformula-java1.1.7.dfsg-2
ii  liblayout-java 0.2.10-2
ii  libloader-java 1.1.6.dfsg-4
ii  libpentaho-reporting-flow-engine-java  0.9.4-4
ii  libreoffice-common 1:5.4.1-1
ii  libreoffice-core   1:5.4.1-1
ii  libreoffice-java-common1:5.4.1-1
ii  libreoffice-report-builder-bin 1:5.4.1-1
ii  librepository-java 1.1.6-3
ii  libsac-java1.3+dfsg-2
ii  libserializer-java 1.1.6-4
ii  libxml-java1.1.6.dfsg-3

libreoffice-report-builder recommends no packages.

libreoffice-report-builder suggests no packages.

Versions of packages libreoffice-base depends on:
ii  libc6 2.24-17
ii  libgcc1   1:7.2.0-4
ii  libreoffice-base-core 1:5.4.1-1
ii  libreoffice-base-drivers  1:5.4.1-1
ii  libreoffice-core  1:5.4.1-1
ii  libstdc++67.2.0-4
ii  uno-libs3 5.4.1-1
ii  ure   5.4.1-1

Versions of packages libreoffice-base recommends:
ii  default-jre [java6-runtime]2:1.8-59
ii  libreoffice-java-common1:5.4.1-1
ii  libreoffice-writer 1:5.4.1-1
ii  openjdk-8-jre [java6-runtime]  8u144-b01-1

Versions of packages libreoffice-base suggests:
ii  unixodbc  2.3.4-1

-- no debconf information

Bug#875688: libreoffice-report-builder: Design view missing from libre office base. Existing reports won't run.

[MAG4 Piemonte]

Package: libreoffice-report-builder
Version: 1:5.4.1-1

Dear Maintainer,
we confirm the problem upgrading LibreOffice to version 5.4.1.
Opening every report we have the message
SQL State: S1000
Unable to open the document "...". 
Stato SQL: S1000
The report "..." request the function Oracle Report Builder.
The extension is not installed.
with no message on the terminal.
Downgrading to version 5.4.0 workaroud the problem ...
Regards!

Guido

--- System information. ---
Architecture: 
Kernel:   Linux 4.12.0-1-amd64

Debian Release: buster/sid
  500 testing ftp.it.debian.org 
  500 stable  download.webmin.com 

--- Package information. ---
Depends  (Version) | Installed
==-+-=
libreoffice-core   | 1:5.4.1-1
libreoffice-java-common| 1:5.4.1-1
libreoffice-report-builder-bin(>= 1:5.4.1) | 1:5.4.1-1
libreoffice-common   (= 1:5.4.1-1) | 1:5.4.1-1
libbase-java   | 1.1.6-2
libsac-java| 1.3+dfsg-2
libxml-java (>= 1.1.6) | 1.1.6.dfsg-3
libflute-java   (>= 1.1.6) | 1:1.1.6-3
libpentaho-reporting-flow-engine-java   (>= 0.9.4) | 0.9.4-4
liblayout-java (>= 0.2.10) | 0.2.10-2
libloader-java  (>= 1.1.6) | 1.1.6.dfsg-4
libformula-java (>= 1.1.7) | 1.1.7.dfsg-2
librepository-java  (>= 1.1.6) | 1.1.6-3
libfonts-java   (>= 1.1.6) | 1.1.6.dfsg-3
libserializer-java  (>= 1.1.6) | 1.1.6-4
libcommons-logging-java| 1.2-1
libreoffice-base-core(= 1:5.4.1-1) | 1:5.4.1-1
libreoffice-base-drivers (= 1:5.4.1-1) | 1:5.4.1-1
libreoffice-core (= 1:5.4.1-1) | 1:5.4.1-1
libc6(>= 2.14) | 2.24-17
libgcc1 (>= 1:3.0) | 1:7.2.0-4
libstdc++6  (>= 5) | 7.2.0-4
uno-libs3 (>= 5.1.0~alpha) | 5.4.1-1
ure| 5.4.1-1


Recommends  (Version) | Installed
=-+-==
libreoffice-writer| 1:5.4.1-1
libreoffice-java-common (>= 1:5.4.1~) | 1:5.4.1-1
default-jre   | 2:1.8-59
 OR sun-java6-jre | 
 OR java6-runtime | 
 OR jre   | 


Suggests(Version) | Installed
=-+-===
libreoffice-report-builder| 1:5.4.1-1
unixodbc  | 

Bug#875688: libreoffice-report-builder: Design view missing from libre office base. Existing reports won't run.

[Rene Engelhard]

On Wed, Sep 13, 2017 at 04:40:12PM -0500, william l-k wrote:
>Sorry, I have another message I'm composing. I did try the following:
>/usr/lib/jvm/jdk-8-oracle-x64/jre
>/usr/lib/jvm/java-8-openjdk-amd64/jre
>/usr/lib/jvm/java-8-openjdk-amd64/jre
>The problem still occurs with any of them.
Hmm. As said, works for me (in sid, though, shouldn't matter, though, none
of the dependencies of the report builder broke and got fixed, so  that wouldn't
explain breakage in testing, besides that the versions are identical, except
maybe for libsac-java but that difference was there before the last updates.

Where you claimed it worked before, so that can't be it either.

I am afraid *you* have to give more info, it's not reproducible here, as
already said.

Regards,
 
Rene

Bug#875688: libreoffice-report-builder: Design view missing from libre office base. Existing reports won't run.

[Rene Engelhard]

On Wed, Sep 13, 2017 at 11:15:35AM -0500, william l-k wrote:
> libreoffice-report-builder will not run in base. Critical reports built using 
>   
> this tool cannot now be run. This occurred after the most recent upgrade to 
> the 
> debian testing branch.

Please define "would not run". Crash? Not start? Any message? Any message
on the terminal? More info is helpful.

> I tried reconfiguring the extension in dpkg. I also tried downloading the

Which of course wouldn't do anything given the package just drops files
into LOs extension directory and only does tell LO to reread stuff by a simple
touch to go sure (via libreoffice-commons triggers)...

> extension for report builder available from open office - which had a java
> incompatibility issue. I checked advanced tab options, and the oracle report
> builder is listed there. I'm currently seeking a work around, but libreoffice

Huh? What? That is the *JVM* (aka the Oracle JDK), not the report builder.

The report builder would be shows in Tools -> Extensions.

> Versions of packages libreoffice-base recommends:
> ii  default-jre [java6-runtime]   2:1.8-59
> ii  libreoffice-java-common   1:5.4.1-1
> ii  libreoffice-writer1:5.4.1-1
> ii  openjdk-7-jre [java6-runtime] 7u151-2.6.11-1
> ii  openjdk-8-jre [java6-runtime] 8u144-b01-1
> ii  oracle-java8-jdk [java6-runtime]  8u65

So what is configured for LO? Oracle? Just out of curiosity, what happens
if you changed to OpenJDK? If if you configured Java 7 switched to Java 8?
Maybe something implicitely changed somewhere? (Maybe not even in LO but in
Java stuff LO depends on.)

Regards,

Rene

Bug#875688: libreoffice-report-builder: Design view missing from libre office base. Existing reports won't run.

[william l-k]

Package: libreoffice-report-builder
Version: 1:5.4.1-1
Severity: grave
Justification: renders package unusable

Dear Maintainer,

libreoffice-report-builder will not run in base. Critical reports built using
this tool cannot now be run. This occurred after the most recent upgrade to the
debian testing branch.

I tried reconfiguring the extension in dpkg. I also tried downloading the
extension for report builder available from open office - which had a java
incompatibility issue. I checked advanced tab options, and the oracle report
builder is listed there. I'm currently seeking a work around, but libreoffice
base is rendered useless for our purposes without those painstakingly
constructed reports.



-- System Information:
Debian Release: buster/sid
  APT prefers testing
  APT policy: (800, 'testing'), (700, 'unstable'), (600, 'experimental'), (500, 
'stable')
Architecture: amd64 (x86_64)

Kernel: Linux 4.12.0-1-amd64 (SMP w/4 CPU cores)
Locale: LANG=en_US.UTF-8, LC_CTYPE=en_US.UTF-8 (charmap=UTF-8), 
LANGUAGE=en_US.UTF-8 (charmap=UTF-8)
Shell: /bin/sh linked to /bin/dash
Init: systemd (via /run/systemd/system)

Versions of packages libreoffice-report-builder depends on:
ii  libbase-java   1.1.6-2
ii  libcommons-logging-java1.2-1
ii  libflute-java  1:1.1.6-3
ii  libfonts-java  1.1.6.dfsg-3
ii  libformula-java1.1.7.dfsg-2
ii  liblayout-java 0.2.10-2
ii  libloader-java 1.1.6.dfsg-4
ii  libpentaho-reporting-flow-engine-java  0.9.4-4
ii  libreoffice-common 1:5.4.1-1
ii  libreoffice-core   1:5.4.1-1
ii  libreoffice-java-common1:5.4.1-1
ii  libreoffice-report-builder-bin 1:5.4.1-1
ii  librepository-java 1.1.6-3
ii  libsac-java1.3+dfsg-2
ii  libserializer-java 1.1.6-4
ii  libxml-java1.1.6.dfsg-3

libreoffice-report-builder recommends no packages.

libreoffice-report-builder suggests no packages.

Versions of packages libreoffice-base depends on:
ii  libc6 2.24-17
ii  libgcc1   1:7.2.0-4
ii  libreoffice-base-core 1:5.4.1-1
ii  libreoffice-base-drivers  1:5.4.1-1
ii  libreoffice-core  1:5.4.1-1
ii  libstdc++67.2.0-4
ii  uno-libs3 5.4.1-1
ii  ure   5.4.1-1

Versions of packages libreoffice-base recommends:
ii  default-jre [java6-runtime]   2:1.8-59
ii  libreoffice-java-common   1:5.4.1-1
ii  libreoffice-writer1:5.4.1-1
ii  openjdk-7-jre [java6-runtime] 7u151-2.6.11-1
ii  openjdk-8-jre [java6-runtime] 8u144-b01-1
ii  oracle-java8-jdk [java6-runtime]  8u65

Versions of packages libreoffice-base suggests:
pn  unixodbc  

-- no debconf information