Issue 113250

Summary: Cannot stop database query when retreiving large data sets
Product: Base Reporter: osavill <osavill>
Component: codeAssignee: AOO issues mailing list <issues>
Status: UNCONFIRMED --- QA Contact:
Severity: Trivial    
Priority: P3 CC: issues, r4zoli
Version: OOO330m1Keywords: oooqa
Target Milestone: ---   
Hardware: All   
OS: All   
Issue Type: DEFECT Latest Confirmation in: ---
Developer Difficulty: ---

Description osavill 2010-07-19 15:34:43 UTC
The Stop button is ineffective when trying to run a database report. The only
way to stop it is to kill the application. 
Run the Report Wizard,
In the last step select Create Report Now and Finish,
A collecting data dialog appears with a Stop button.

The query takes a long time to run hence the attempt at stopping it. I cannot
run other query based reports (see my next issue report) so I don't know if this
is general for all query based reports.

When running a report I also get:
Run SQL Command Directlycom.sun.star.beans.UnknownPropertyException: FormatsSupplier
        at com.sun.star.bridges.jni_uno.JNI_proxy.dispatch_call(Native Method)
        at com.sun.star.bridges.jni_uno.JNI_proxy.invoke(JNI_proxy.java:175)
        at $Proxy6.setPropertyValue(Unknown Source)
        at
com.sun.star.wizards.common.NumberFormatter.setNumberFormat(NumberFormatter.java:204)
        at
com.sun.star.wizards.report.DBColumn.initializeNumberFormat(DBColumn.java:244)
        at
com.sun.star.wizards.report.ReportTextDocument.insertColumnstoRecordTable(ReportTextDocument.java:440)
        at
com.sun.star.wizards.report.ReportTextDocument.setupRecordSection(ReportTextDocument.java:325)
        at
com.sun.star.wizards.report.ReportTextImplementation.layout_setupRecordSection(ReportTextImplementation.java:546)
        at
com.sun.star.wizards.report.ReportLayouter.initialize(ReportLayouter.java:229)
        at com.sun.star.wizards.report.ReportWizard.leaveStep(ReportWizard.java:238)
        at com.sun.star.wizards.ui.WizardDialog.switchToStep(WizardDialog.java:363)
        at
com.sun.star.wizards.ui.WizardDialog.gotoNextAvailableStep(WizardDialog.java:681)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
        at java.lang.reflect.Method.invoke(Unknown Source)
        at
com.sun.star.wizards.ui.event.MethodInvocation.invoke(MethodInvocation.java:96)
        at
com.sun.star.wizards.ui.event.AbstractListener.invoke(AbstractListener.java:89)
        at
com.sun.star.wizards.ui.event.CommonListener.actionPerformed(CommonListener.java:49)
        at com.sun.star.bridges.jni_uno.JNI_proxy.dispatch_call(Native Method)
        at com.sun.star.bridges.jni_uno.JNI_proxy.invoke(JNI_proxy.java:175)
        at $Proxy89.execute(Unknown Source)
        at com.sun.star.wizards.ui.UnoDialog.executeDialog(UnoDialog.java:742)
        at
com.sun.star.wizards.report.ReportWizard.startReportWizard(ReportWizard.java:492)
        at
com.sun.star.wizards.report.CallReportWizard$ReportWizardImplementation.trigger(CallReportWizard.java:140)
com.sun.star.beans.UnknownPropertyException: FormatsSupplier
        at com.sun.star.bridges.jni_uno.JNI_proxy.dispatch_call(Native Method)
        at com.sun.star.bridges.jni_uno.JNI_proxy.invoke(JNI_proxy.java:175)
        at $Proxy6.setPropertyValue(Unknown Source)
        at
com.sun.star.wizards.common.NumberFormatter.setNumberFormat(NumberFormatter.java:204)
        at
com.sun.star.wizards.report.DBColumn.initializeNumberFormat(DBColumn.java:244)
        at
com.sun.star.wizards.report.ReportTextDocument.insertColumnstoRecordTable(ReportTextDocument.java:440)
        at
com.sun.star.wizards.report.ReportTextDocument.setupRecordSection(ReportTextDocument.java:325)
        at
com.sun.star.wizards.report.ReportTextImplementation.layout_setupRecordSection(ReportTextImplementation.java:546)
        at
com.sun.star.wizards.report.ReportLayouter.initialize(ReportLayouter.java:229)
        at com.sun.star.wizards.report.ReportWizard.leaveStep(ReportWizard.java:238)
        at com.sun.star.wizards.ui.WizardDialog.switchToStep(WizardDialog.java:363)
        at
com.sun.star.wizards.ui.WizardDialog.gotoNextAvailableStep(WizardDialog.java:681)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
        at java.lang.reflect.Method.invoke(Unknown Source)
        at
com.sun.star.wizards.ui.event.MethodInvocation.invoke(MethodInvocation.java:96)
        at
com.sun.star.wizards.ui.event.AbstractListener.invoke(AbstractListener.java:89)
        at
com.sun.star.wizards.ui.event.CommonListener.actionPerformed(CommonListener.java:49)
        at com.sun.star.bridges.jni_uno.JNI_proxy.dispatch_call(Native Method)
        at com.sun.star.bridges.jni_uno.JNI_proxy.invoke(JNI_proxy.java:175)
        at $Proxy89.execute(Unknown Source)
        at com.sun.star.wizards.ui.UnoDialog.executeDialog(UnoDialog.java:742)
        at
com.sun.star.wizards.report.ReportWizard.startReportWizard(ReportWizard.java:492)
        at
com.sun.star.wizards.report.CallReportWizard$ReportWizardImplementation.trigger(CallReportWizard.java:140)
com.sun.star.beans.UnknownPropertyException: FormatsSupplier
        at com.sun.star.bridges.jni_uno.JNI_proxy.dispatch_call(Native Method)
        at com.sun.star.bridges.jni_uno.JNI_proxy.invoke(JNI_proxy.java:175)
        at $Proxy6.setPropertyValue(Unknown Source)
        at
com.sun.star.wizards.common.NumberFormatter.setNumberFormat(NumberFormatter.java:204)
        at
com.sun.star.wizards.report.DBColumn.initializeNumberFormat(DBColumn.java:244)
        at
com.sun.star.wizards.report.ReportTextDocument.insertColumnstoRecordTable(ReportTextDocument.java:440)
        at
com.sun.star.wizards.report.ReportTextDocument.setupRecordSection(ReportTextDocument.java:325)
        at
com.sun.star.wizards.report.ReportTextImplementation.layout_setupRecordSection(ReportTextImplementation.java:546)
        at
com.sun.star.wizards.report.ReportLayouter.initialize(ReportLayouter.java:229)
        at com.sun.star.wizards.report.ReportWizard.leaveStep(ReportWizard.java:238)
        at com.sun.star.wizards.ui.WizardDialog.switchToStep(WizardDialog.java:363)
        at
com.sun.star.wizards.ui.WizardDialog.gotoNextAvailableStep(WizardDialog.java:681)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
        at java.lang.reflect.Method.invoke(Unknown Source)
        at
com.sun.star.wizards.ui.event.MethodInvocation.invoke(MethodInvocation.java:96)
        at
com.sun.star.wizards.ui.event.AbstractListener.invoke(AbstractListener.java:89)
        at
com.sun.star.wizards.ui.event.CommonListener.actionPerformed(CommonListener.java:49)
        at com.sun.star.bridges.jni_uno.JNI_proxy.dispatch_call(Native Method)
        at com.sun.star.bridges.jni_uno.JNI_proxy.invoke(JNI_proxy.java:175)
        at $Proxy89.execute(Unknown Source)
        at com.sun.star.wizards.ui.UnoDialog.executeDialog(UnoDialog.java:742)
        at
com.sun.star.wizards.report.ReportWizard.startReportWizard(ReportWizard.java:492)
        at
com.sun.star.wizards.report.CallReportWizard$ReportWizardImplementation.trigger(CallReportWizard.java:140)
com.sun.star.beans.UnknownPropertyException: FormatsSupplier
        at com.sun.star.bridges.jni_uno.JNI_proxy.dispatch_call(Native Method)
        at com.sun.star.bridges.jni_uno.JNI_proxy.invoke(JNI_proxy.java:175)
        at $Proxy6.setPropertyValue(Unknown Source)
        at
com.sun.star.wizards.common.NumberFormatter.setNumberFormat(NumberFormatter.java:204)
        at
com.sun.star.wizards.report.DBColumn.initializeNumberFormat(DBColumn.java:244)
        at
com.sun.star.wizards.report.ReportTextDocument.insertColumnstoRecordTable(ReportTextDocument.java:440)
        at
com.sun.star.wizards.report.ReportTextDocument.setupRecordSection(ReportTextDocument.java:325)
        at
com.sun.star.wizards.report.ReportTextImplementation.layout_setupRecordSection(ReportTextImplementation.java:546)
        at
com.sun.star.wizards.report.ReportLayouter.initialize(ReportLayouter.java:229)
        at com.sun.star.wizards.report.ReportWizard.leaveStep(ReportWizard.java:238)
        at com.sun.star.wizards.ui.WizardDialog.switchToStep(WizardDialog.java:363)
        at
com.sun.star.wizards.ui.WizardDialog.gotoNextAvailableStep(WizardDialog.java:681)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
        at java.lang.reflect.Method.invoke(Unknown Source)
        at
com.sun.star.wizards.ui.event.MethodInvocation.invoke(MethodInvocation.java:96)
        at
com.sun.star.wizards.ui.event.AbstractListener.invoke(AbstractListener.java:89)
        at
com.sun.star.wizards.ui.event.CommonListener.actionPerformed(CommonListener.java:49)
        at com.sun.star.bridges.jni_uno.JNI_proxy.dispatch_call(Native Method)
        at com.sun.star.bridges.jni_uno.JNI_proxy.invoke(JNI_proxy.java:175)
        at $Proxy89.execute(Unknown Source)
        at com.sun.star.wizards.ui.UnoDialog.executeDialog(UnoDialog.java:742)
        at
com.sun.star.wizards.report.ReportWizard.startReportWizard(ReportWizard.java:492)
        at
com.sun.star.wizards.report.CallReportWizard$ReportWizardImplementation.trigger(CallReportWizard.java:140)
com.sun.star.beans.UnknownPropertyException: FormatsSupplier
        at com.sun.star.bridges.jni_uno.JNI_proxy.dispatch_call(Native Method)
        at com.sun.star.bridges.jni_uno.JNI_proxy.invoke(JNI_proxy.java:175)
        at $Proxy6.setPropertyValue(Unknown Source)
        at
com.sun.star.wizards.common.NumberFormatter.setNumberFormat(NumberFormatter.java:204)
        at
com.sun.star.wizards.report.DBColumn.initializeNumberFormat(DBColumn.java:244)
        at
com.sun.star.wizards.report.ReportTextDocument.insertColumnstoRecordTable(ReportTextDocument.java:440)
        at
com.sun.star.wizards.report.ReportTextDocument.setupRecordSection(ReportTextDocument.java:325)
        at
com.sun.star.wizards.report.ReportTextImplementation.layout_setupRecordSection(ReportTextImplementation.java:546)
        at
com.sun.star.wizards.report.ReportLayouter.initialize(ReportLayouter.java:229)
        at com.sun.star.wizards.report.ReportWizard.leaveStep(ReportWizard.java:238)
        at com.sun.star.wizards.ui.WizardDialog.switchToStep(WizardDialog.java:363)
        at
com.sun.star.wizards.ui.WizardDialog.gotoNextAvailableStep(WizardDialog.java:681)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
        at java.lang.reflect.Method.invoke(Unknown Source)
        at
com.sun.star.wizards.ui.event.MethodInvocation.invoke(MethodInvocation.java:96)
        at
com.sun.star.wizards.ui.event.AbstractListener.invoke(AbstractListener.java:89)
        at
com.sun.star.wizards.ui.event.CommonListener.actionPerformed(CommonListener.java:49)
        at com.sun.star.bridges.jni_uno.JNI_proxy.dispatch_call(Native Method)
        at com.sun.star.bridges.jni_uno.JNI_proxy.invoke(JNI_proxy.java:175)
        at $Proxy89.execute(Unknown Source)
        at com.sun.star.wizards.ui.UnoDialog.executeDialog(UnoDialog.java:742)
        at
com.sun.star.wizards.report.ReportWizard.startReportWizard(ReportWizard.java:492)
        at
com.sun.star.wizards.report.CallReportWizard$ReportWizardImplementation.trigger(CallReportWizard.java:140)
Comment 1 r4zoli 2010-07-21 12:25:19 UTC
Can you add a database where we can check this?

What you means under "large data set"?
For large data sets needs more time to collect data for reports, during the
process OOo seems hanged, but the data processing happens in that time.
 
How many times needs to run report, sometimes it takes minutes to finish it.
Comment 2 osavill 2010-07-21 13:23:51 UTC
> Can you add a database where we can check this?
Sadly not, it's an internal SQL Server customer database.

> What you means under "large data set"?
about 300,000 records so not huge.

> For large data sets needs more time to collect data for reports, during the
> process OOo seems hanged, but the data processing happens in that time.
> How many times needs to run report, sometimes it takes minutes to finish it.
Agreed, but the user should not be prevented from cancelling the operation. Even
if the JDBC component is the issue it shouldn't just hang OOo
Comment 3 r4zoli 2010-07-21 14:22:12 UTC
The "old" type or report wizard, not updated long time.
In the future will be replaced by report builder, developed as extensions:
http://extensions.services.openoffice.org/en/project/reportdesign

This has more advanced settings, but can be slow on big data sets, too.