| Summary: | Data source is not used during report generation. | ||||||||
|---|---|---|---|---|---|---|---|---|---|
| Product: | [Tools] Data Tools | Reporter: | Paul Slauenwhite <paulslau> | ||||||
| Component: | Enablement:ODA | Assignee: | Mingxia Wu <mwu> | ||||||
| Status: | CLOSED FIXED | QA Contact: | |||||||
| Severity: | blocker | ||||||||
| Priority: | P2 | CC: | bluesoldier, clin, jcayne, lchan, lzhu, wenfeng.fwd, xxue | ||||||
| Version: | 1.6 | ||||||||
| Target Milestone: | 1.6M6 | ||||||||
| Hardware: | All | ||||||||
| OS: | All | ||||||||
| Whiteboard: | |||||||||
| Bug Depends on: | |||||||||
| Bug Blocks: | 218382 | ||||||||
| Attachments: |
|
||||||||
|
Description
Paul Slauenwhite
Created attachment 89396 [details]
Expected report screen capture
This is a regression bug of 215948.Fix it now. Thanks Mingxia. What 1.6 build will this first appear? Hi paul, This issue has been fixed in R1.6M4, see https://bugs.eclipse.org/bugs/show_bug.cgi?id=210968. The birt build M-R1-2.2.2RC1-200801311210 you used is using DTP R1.5.2 version, which do not include this fix. Now I've backport this fix in R1.5.2. Please try the birt2.2.2 build with DTP R1.5.2 or the birt2.3 build with latest DTP1.6M5 to verify this issue. Thanks Mingxia DTP 1.6M5 has already been released last week. The additional fix made in the HEAD branch (backported to 1.5.2) will appear in 1.6M6. The fix in 1.6M6 is related with the new regression issue of bug 215948, which maybe cause the preview failure.Meanwhile, a fix similar with bug 210968 in M4 has been backported into 1.5.2. Has this patch being included in the latest BIRT 2.2.2RC build? Yes, BIRT2.2.2RC build will include the latest DTP's 1.5.2 fix. The build team said it will be upload on website on 2008/02/19(China time). (In reply to comment #7) > Has this patch being included in the latest BIRT 2.2.2RC build? It will be in 2.2.2 nightly build 20080218. Using the below configuration, the following error is generated when attempting the report template with the sample XML data source (see Description): A BIRT exception occurred. Plug-in Provider:Eclipse.org Plug-in Name:BIRT Data Engine Plug-in ID:org.eclipse.birt.data Version:2.2.2.r22x_v20071212 Error Code:odaconsumer.CannotExecuteStatement Error Message:Cannot execute the statement. unknown protocol: d Configuration: GEF-runtime-M200801291704.zip birt-dtp-integration-2_2_2-N20080218.zip birt-report-framework-2_2_2-N20080218.zip tptp.runtime.allInOne.win32.win32.x86-TPTP-4.4.1-200802121409.zip BIRT 2.3/DTP 1.6: Using the below configuration, the following error is generated when attempting the report template with the sample XML data source (see Description): A BIRT exception occurred. Plug-in Provider:Eclipse.org Plug-in Name:BIRT Data Engine Plug-in ID:org.eclipse.birt.data Version:2.3.0.v20080215 Error Code:odaconsumer.CannotOpenConnection Error Message:Cannot open the connection for the driver: org.eclipse.datatools.enablement.oda.xml Configuration: sdo-runtime-2.4.0M5.zip GEF-runtime-3.4.0M5.zip birt-dtp-integration-2_3_0-S20080219.zip birt-report-framework-2_3_0-S20080219.zip org.eclipse.tptp.test.report.birt-TPTP-4.5.0M5.zip tptp.runtime.allInOne.win32.win32.x86-TPTP-4.5.0M5.zip (In reply to comment #10) Moved issue in DTP 1.5.2, described in comment #10 to a separate bug 219519, for the DTP 1.5.2 build process. Hi Paul, For #10, in our test everything simple works fine (using your given environment). At current stage the only way to reproduce the problem reported in #10 is that, make data source definition in the report template invalid (D:\xx.xml). Can you ensure that when you do the test the file (D:\xx.xml) exists? For BIRT 2.3 + Dtp 1.6, please use Dtp 1.6 M6 nightly build for this bug is targeting 1.6M6. Thanks. Lin For #12, 218922 has been reported and fixed. So the current BIRT 2.2.2 already include fixing to the problem. (In reply to comment #13) > Hi Paul, > > For #10, in our test everything simple works fine (using your given > environment). At current stage the only way to reproduce the problem reported > in #10 is that, make data source definition in the report template invalid > (D:\xx.xml). Can you ensure that when you do the test the file (D:\xx.xml) > exists? I set the XML Data Set in the Edit Data Set dialog for each of the Data Sets in the Data Explorer before selecting Preview in the *.rptdesign editor. However, the one Data Sources was incorrect. Using the below configuration, the TPTP BIRT Test Reports work as designed: GEF-runtime-M200801291704.zip birt-dtp-integration-2_2_2-N20080218.zip birt-report-framework-2_2_2-N20080218.zip tptp.runtime.allInOne.win32.win32.x86-TPTP-4.4.1-200802121409.zip > For BIRT 2.3 + Dtp 1.6, please use Dtp 1.6 M6 nightly build for this bug is > targeting 1.6M6. However, using the below configuration, a sample report can be previewed (set the XML Data Set in the Edit Data Set dialog for each of the Data Sets in the Data Explorer before selecting Preview in the *.rptdesign editor) but generating TPTP BIRT Test Reports fails with the following exception: + An exception occurred during processing. Please see the following message for details: Cannot open the connection for the driver: org.eclipse.datatools.enablement.oda.xml An exception occurred during processing. Please see the following message for details:Cannot open the connection for the driver: org.eclipse.datatools.enablement.oda.xml ( 1 time(s) ) detail : org.eclipse.birt.report.engine.api.EngineException: An exception occurred during processing. Please see the following message for details:Cannot open the connection for the driver: org.eclipse.datatools.enablement.oda.xml at org.eclipse.birt.report.engine.executor.ExecutionContext.addException(ExecutionContext.java:1084) at org.eclipse.birt.report.engine.executor.ExecutionContext.addException(ExecutionContext.java:1048) at org.eclipse.birt.report.engine.executor.QueryItemExecutor.executeQuery(QueryItemExecutor.java:88) at org.eclipse.birt.report.engine.executor.GridItemExecutor.execute(GridItemExecutor.java:64) at org.eclipse.birt.report.engine.internal.executor.dup.SuppressDuplicateItemExecutor.execute(SuppressDuplicateItemExecutor.java:42) at org.eclipse.birt.report.engine.internal.executor.wrap.WrappedReportItemExecutor.execute(WrappedReportItemExecutor.java:45) at org.eclipse.birt.report.engine.internal.executor.l18n.LocalizedReportItemExecutor.execute(LocalizedReportItemExecutor.java:33) at org.eclipse.birt.report.engine.layout.html.HTMLBlockStackingLM.layoutNodes(HTMLBlockStackingLM.java:63) at org.eclipse.birt.report.engine.layout.html.HTMLStackingLM.layoutChildren(HTMLStackingLM.java:27) at org.eclipse.birt.report.engine.layout.html.HTMLAbstractLM.layout(HTMLAbstractLM.java:133) at org.eclipse.birt.report.engine.layout.html.HTMLInlineStackingLM.resumeLayout(HTMLInlineStackingLM.java:104) at org.eclipse.birt.report.engine.layout.html.HTMLInlineStackingLM.layoutNodes(HTMLInlineStackingLM.java:153) at org.eclipse.birt.report.engine.layout.html.HTMLStackingLM.layoutChildren(HTMLStackingLM.java:27) at org.eclipse.birt.report.engine.layout.html.HTMLAbstractLM.layout(HTMLAbstractLM.java:133) at org.eclipse.birt.report.engine.layout.html.HTMLBlockStackingLM.layoutNodes(HTMLBlockStackingLM.java:68) at org.eclipse.birt.report.engine.layout.html.HTMLStackingLM.layoutChildren(HTMLStackingLM.java:27) at org.eclipse.birt.report.engine.layout.html.HTMLTableLM.layoutChildren(HTMLTableLM.java:76) at org.eclipse.birt.report.engine.layout.html.HTMLAbstractLM.layout(HTMLAbstractLM.java:133) at org.eclipse.birt.report.engine.layout.html.HTMLBlockStackingLM.layoutNodes(HTMLBlockStackingLM.java:68) at org.eclipse.birt.report.engine.layout.html.HTMLPageLM.layout(HTMLPageLM.java:85) at org.eclipse.birt.report.engine.layout.html.HTMLReportLayoutEngine.layout(HTMLReportLayoutEngine.java:106) at org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.doRun(RunAndRenderTask.java:139) at org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.run(RunAndRenderTask.java:66) at org.eclipse.tptp.platform.report.birt.core.provisional.BIRTReportGenerator.generateHTMLReportFragment(BIRTReportGenerator.java:293) at org.eclipse.tptp.platform.report.birt.core.provisional.BIRTReportGenerator.generateHTMLReport(BIRTReportGenerator.java:190) at org.eclipse.tptp.test.report.birt.internal.elements.TabularTPFTestSuiteReportElement.generate(TabularTPFTestSuiteReportElement.java:223) at org.eclipse.tptp.platform.report.birt.ui.internal.BIRTReportsWizard.generate(BIRTReportsWizard.java:60) at org.eclipse.hyades.test.ui.internal.wizard.ReportWizard$FinishOperation.execute(ReportWizard.java:193) at org.eclipse.ui.actions.WorkspaceModifyOperation$1.run(WorkspaceModifyOperation.java:104) at org.eclipse.core.internal.resources.Workspace.run(Workspace.java:1800) at org.eclipse.ui.actions.WorkspaceModifyOperation.run(WorkspaceModifyOperation.java:116) at org.eclipse.jface.operation.ModalContext.runInCurrentThread(ModalContext.java:407) at org.eclipse.jface.operation.ModalContext.run(ModalContext.java:347) at org.eclipse.jface.wizard.WizardDialog.run(WizardDialog.java:934) at org.eclipse.hyades.test.ui.internal.wizard.ReportWizard.performFinish(ReportWizard.java:148) at org.eclipse.jface.wizard.WizardDialog.finishPressed(WizardDialog.java:746) at org.eclipse.jface.wizard.WizardDialog.buttonPressed(WizardDialog.java:373) at org.eclipse.jface.dialogs.Dialog$2.widgetSelected(Dialog.java:623) at org.eclipse.swt.widgets.TypedListener.handleEvent(TypedListener.java:227) at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:84) at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:982) at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:3760) at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3371) at org.eclipse.jface.window.Window.runEventLoop(Window.java:825) at org.eclipse.jface.window.Window.open(Window.java:801) at org.eclipse.hyades.test.ui.internal.navigator.action.OpenReportAction.run(OpenReportAction.java:48) at org.eclipse.jface.action.Action.runWithEvent(Action.java:498) at org.eclipse.jface.action.ActionContributionItem.handleWidgetSelection(ActionContributionItem.java:582) at org.eclipse.jface.action.ActionContributionItem.access$2(ActionContributionItem.java:499) at org.eclipse.jface.action.ActionContributionItem$5.handleEvent(ActionContributionItem.java:410) at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:84) at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:982) at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:3760) at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3371) at org.eclipse.ui.internal.Workbench.runEventLoop(Workbench.java:2392) at org.eclipse.ui.internal.Workbench.runUI(Workbench.java:2356) at org.eclipse.ui.internal.Workbench.access$4(Workbench.java:2222) at org.eclipse.ui.internal.Workbench$4.run(Workbench.java:474) at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:288) at org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Workbench.java:469) at org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.java:149) at org.eclipse.ui.internal.ide.application.IDEApplication.start(IDEApplication.java:106) at org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:193) at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(EclipseAppLauncher.java:106) at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(EclipseAppLauncher.java:76) at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:362) at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:175) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:64) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:615) at org.eclipse.equinox.launcher.Main.invokeFramework(Main.java:564) at org.eclipse.equinox.launcher.Main.basicRun(Main.java:504) at org.eclipse.equinox.launcher.Main.run(Main.java:1251)Caused by: org.eclipse.birt.report.data.adapter.api.AdapterException: An exception occurred during processing. Please see the following message for details:Cannot open the connection for the driver: org.eclipse.datatools.enablement.oda.xml at org.eclipse.birt.report.data.adapter.impl.DataRequestSessionImpl.execute(DataRequestSessionImpl.java:466) at org.eclipse.birt.report.engine.data.dte.DteDataEngine.doExecuteQuery(DteDataEngine.java:112) at org.eclipse.birt.report.engine.data.dte.AbstractDataEngine.execute(AbstractDataEngine.java:247) at org.eclipse.birt.report.engine.executor.ExecutionContext.executeQuery(ExecutionContext.java:1618) at org.eclipse.birt.report.engine.executor.QueryItemExecutor.executeQuery(QueryItemExecutor.java:77) ... 71 moreCaused by: org.eclipse.birt.data.engine.core.DataException: Cannot open the connection for the driver: org.eclipse.datatools.enablement.oda.xml at org.eclipse.birt.data.engine.odaconsumer.ConnectionManager.openConnection(ConnectionManager.java:169) at org.eclipse.birt.data.engine.executor.DataSource.newConnection(DataSource.java:134) at org.eclipse.birt.data.engine.executor.DataSource.open(DataSource.java:121) at org.eclipse.birt.data.engine.impl.DataSourceRuntime.openOdiDataSource(DataSourceRuntime.java:214) at org.eclipse.birt.data.engine.impl.QueryExecutor.openDataSource(QueryExecutor.java:279) at org.eclipse.birt.data.engine.impl.QueryExecutor.prepareExecution(QueryExecutor.java:224) at org.eclipse.birt.data.engine.impl.PreparedQuery.doPrepare(PreparedQuery.java:508) at org.eclipse.birt.data.engine.impl.PreparedDataSourceQuery.produceQueryResults(PreparedDataSourceQuery.java:195) at org.eclipse.birt.data.engine.impl.PreparedDataSourceQuery.execute(PreparedDataSourceQuery.java:172) at org.eclipse.birt.data.engine.impl.PreparedOdaDSQuery.execute(PreparedOdaDSQuery.java:143) at org.eclipse.birt.report.data.adapter.impl.DataRequestSessionImpl.execute(DataRequestSessionImpl.java:455) ... 75 moreCaused by: org.eclipse.datatools.connectivity.oda.OdaException ; java.net.MalformedURLException: unknown protocol: d at org.eclipse.datatools.enablement.oda.xml.impl.Connection.open(Connection.java:76) at org.eclipse.datatools.connectivity.oda.consumer.helper.OdaConnection.open(OdaConnection.java:235) at org.eclipse.birt.data.engine.odaconsumer.ConnectionManager.openConnection(ConnectionManager.java:157) ... 85 moreCaused by: java.net.MalformedURLException: unknown protocol: d at java.net.URL.<init>(URL.java:608) at java.net.URL.<init>(URL.java:498) at java.net.URL.<init>(URL.java:447) at org.eclipse.datatools.enablement.oda.xml.impl.Connection.open(Connection.java:72) ... 87 more Configuration: GEF-runtime-3.4.0M5.zip birt-dtp-integration-2.3M5.zip birt-report-framework-2.3M5.zip org.eclipse.tptp.test.report.birt-TPTP-4.5.0M5.zip tptp.runtime.allInOne.win32.win32.x86-TPTP-4.5.0M5.zip Since the original symptom is now fixed in BIRT 2.2.2 and DTP 1.5.2, resolving as fixed. The new exception when using BIRT 2.3 and DTP 1.6 will be tracked under defect https://bugs.eclipse.org/bugs/show_bug.cgi?id=218578. Closing. |