Bug 54838

Hi Colin,

please
1) Attach the odb-file.
2) List the single steps in details for "Creating a report using both design view and wizard".
3) Attach a screenshot of the failure report.

Moreover, which Java/jre version do you have?
Did you upgrade Java recently?
Did you try to rename your LO profile to force LO to detect again jre installed? (see http://wiki.documentfoundation.org/UserProfile)

Created attachment 67263 [details]
A libreoffice 3.6.1 Base file

Created attachment 67264 [details]
java error log

An error log like this is produced every time LO crashes when editing/creating a report

I have used both jre6 and jre7. I have recently upgraded to jre7.
Creating a report in design view based on query "Income". add fields Date, Supplier, value. "Edit/view report works. View/sorting and grouping selecting Date and moving Date into date group also works. Formatting by moving value control crashes LO.

Basicly the same results are seen when using the wizard.

I have noticed that the "Insert field dialog from the design method also appears in the wizard method

I have renamed the LO profile and a new one was created

Further to Base crashing on creating report:
I have found that saving the complete database after each edit I have been able to gradually build up the working report while working in design view.

With the wizard it crashes each time I press finish.

On pc Debian x86-64 with 3.6 branch updated today, I don't reproduce the problem.

The weird thing is you can still reproduce the problem with a brand new LO profile and most of this kind of problem doesn't appear with a brand new one.

Did you install any specific font?
Do you reproduce the problem with these steps:
- create a report by clicking "Use Wizard to create report"
- select all the columns with ">>"
- click finish
?
Do you reproduce on any odb file?

1) As i have had the same outcome with the new LO profile I have reverted to the original.
2) No extra fonts have been specifically installed
3) Older .odb files produce the same results.
4) This I find confusing, as I said before when I use the wizard the design view field enter dialogue opens also
  I have 2 reports which were created in an older version of LO using the wizard.
These still function perfectly.
  I did as you asked and using the wizard stopped at the enter fields state and clicked finish. This created a simple report.
  Now when I come to edit this it opens in design view with the page heading saying Libreoffice Base: Oracle report builder, exactly as if produced in design view
  When I go to edit one of the old "wizard" reports it opens in writer with the page title Libreoffice Base:Report Design

Does this give us another clue

Colin: Thank you for your feedback. So creating a report doesn't crash.
Could you give the exact steps to reproduce the problem once the report has been created?

Could you attach the old odb file with the 2 reports?

Created attachment 67467 [details]
LO base file

Shows difference in two reports

Hi Julien  intriguing no?

I assume you meant the report made with the wizard with just the fields added and finished and saved. I just right clicked the report and edit. It opens in design view.

I have included an attachment which is the same file but with a report added which works as expected

Let's focus on the crash for the moment.
Could you give the exact steps to reproduce the crash?

Rather than describe the steps, I have added an Impress file which shows these as screen shots of each step.

Colin: I received your email with the odb + odp explaining the problem.
You must know that there's a page to upload big files (see http://wiki.documentfoundation.org/QA/Bugzilla-Attachments quoted in http://wiki.documentfoundation.org/BugReport).
FYI, LO proposed me to repair your odp file, I did it. (Perhaps it's a email problem, I don't know).

On pc Debian x86-64, I made the test with 3.5, 3.6 and master branches, each time with a brand new LO profile, I didn't reproduce the pb.

On which distribution are you?
How did you install LO? From distribution packages?
Could you give a try to final 3.6.1?
Finally could you retrieve an useful backtrace? (see http://wiki.documentfoundation.org/BugReport#How_to_get_backtrace_.28on_Linux.29)

BTW, your odp explains how to get a crash during creation of a report not during an edition.
So when do happen your crashes, during creation, editing, both?

I am running ubuntu 12.04 on a 32bit system.
The LO distribution is 3.6.1.2 build id e29a214
This was down loaded and installed from the libreoffice site. I previously used the ubuntu version but changed because of the problem with Base.
I am unable to install libreoffice-dbg to produce a backtrace because of a dependancy issue which implies I do not have libreoffice installed.

Editing, provided I do it with incremental saves, now seems to work but creation always crashes

It's anormal you can't install libreoffice-dbg.
Could you quote the details of dependency problem?

Then could you try this?
- remove your LO version
- add ppa Libreoffice (sudo add-apt-repository ppa:libreoffice/ppa)
- rename your LO directory profile (see http://wiki.documentfoundation.org/UserProfile)
- uninstall lo-menubar if installed
- install LO from ppa + libreoffice-dbg
- try again

Could you also give java version?
Type this on console:
java -version

Suggestions have been followed and the results are attached.

I am now back using same LO version

Created attachment 67659 [details]
dependencies for libreoffice-dbg

It's quite a mess here, libreoffice-dbg should be installable. Perhaps I'm wrong but it seems version of libreoffice-dbg and libreoffice-core don't correspond.

Could you remove all LibreOffice packages with:
apt-get remove --purge <package> 
?

Then if you installed some things with dpkg, uninstall it too with dpkg.

Finally, could you attach the complete list of your repositories?
(in Debian it's here /etc/apt/sources.list)
Perhaps there's something wrong in it.

I have attempted to remove libreoffice packages as listed in the dependencies problems. with the stated result that none of them are installed, which I can confirm by searching, except for the 3.6.1 version which installs into a diferent folder.

I have included the attachment showing my sources list.

Now this is getting rather complicated and I am thinking maybe I should wait a couple of weeks for Ubuntu 12,10.
However there appears to be some doubt as to whether LO base will be included.

I also note that the latest version of Linux Mint does not include LO base, Is there an unresolved problem there also?

Created attachment 67703 [details]
Sources list

Since you got Precise, could you comment this line:
deb http://archive.canonical.com/ubuntu natty partner 

Then launch these:
apt-get update
apt-get autoremove --purge
apt-get clean
apt-get check

After that try this:
apt-get libreoffice libreoffice-dbg

Did as requested;

apt-get libreoffice libreoffice-dbg  = invalid instruction

apt-get install libreoffice-dbg gave exactly the same unmet dependency list as before

(In reply to comment #25)
> Did as requested;
> 
> apt-get libreoffice libreoffice-dbg  = invalid instruction
> 
> apt-get install libreoffice-dbg gave exactly the same unmet dependency list
> as before

Sorry for the "install" :-(

Except reinstall Linux, no more idea now. I still think there's something wrong with your repos but I don't know what.

Rene: Any idea about the dependency problem? (since you maintain LO packages for Debian and  Ubuntu is derived from Debian)

Should this be considered regarding dependency problems.

When installing LO using the .tar.gz files from the LO site. LO is installed into /opt folder whereas ubuntu installs LO into /usr/share, all of which have been un- installed thro' Synaptic

I could not confirm any crash of the report-builder while editing a report with the wizard or directly in design-view.
My System: OpenSUSE 12.1 64bit rpm, OpenJDK 1.6, LO 3.6.2.1

Colin, does your report contain a calculated field by any chance ?


Alex

The reason I ask is because in the Java log you posted I see a reference to Fraction in rptuilo and calculated fields in reports were known to crash LO until a fix went into master, but this fix will only be available in 3.6.2 or 3.6.3 as I understand it.


Alex

(In reply to comment #31)
> The reason I ask is because in the Java log you posted I see a reference to
> Fraction in rptuilo and calculated fields in reports were known to crash LO

sorry, that should be "calculated fields in SQL statements", but if your report relies on a calculated SQL statement, then it might fall victim to the same problem.


Alex

Alex
There is a calculated field in the query the report is basesd on 

SELECT "SUPPLIER", SUM( "VALUE" ) FROM "Income" GROUP BY "SUPPLIER"

Also: I am un able to use the  Accumulation function (or maximum or minimum) when trying to produce a total by supplier for instance in the footer.

The java-error-log is made from JRE version: 7.0_07-b30. Could you please test it with a JRE 6? There are many problems with JRE 7 - not only with Windows, Linux could have the same problems. You could see another report with JRE-7-problems here:
https://bugs.freedesktop.org/show_bug.cgi?id=55482

@Colin : try a recent daily build from 13/09/2012 or later.


Alex

Alex:.

All fixed ... Report Wizard now works fine, including the Accumulation function

Iinstalled LO 3.6.2 rc2 (28/9/12)

WOW

(In reply to comment #36)
> All fixed ... Report Wizard now works fine, including the Accumulation
> function
> 
> Iinstalled LO 3.6.2 rc2 (28/9/12)
Colin: Thanks for your feedback, so putting to WFM.

Alex: thank you for your help on this tracker