Apache OpenOffice (AOO) Bugzilla – Issue 113250
Cannot stop database query when retreiving large data sets
Last modified: 2013-01-29 21:59:07 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)
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.
> 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
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.