Some Eclipse Foundation services are deprecated, or will be soon. Please ensure you've read this important communication.

Bug 218495

Summary: Data source is not used during report generation.
Product: [Tools] Data Tools Reporter: Paul Slauenwhite <paulslau>
Component: Enablement:ODAAssignee: 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 Flags
Sample project.
none
Expected report screen capture none

Description Paul Slauenwhite CLA 2008-02-11 08:40:40 EST
Created attachment 89395 [details]
Sample project.

Data source is not used during report generation.

Using the TPTP 4.4.1-200802061217 build with the M-R1-2.2.2RC1-200801311210 build, generating a BIRT Test report with a valid data source, the resulting BIRT report does not contain anything from the data source.  The data source is:

<testSuites startTime="1202702400725" endTime="1202731242725" totalError="1" totalFail="1" totalInconclusive="1" totalPass="1" totalTests="4" verdictValue="0" ><verdictProperty name="Inconclusive" value="1" /><verdictProperty name="Pass" value="1" /><verdictProperty name="Fail" value="1" /><verdictProperty name="Error" value="1" /><testExecutionResults verdictValue="3" name="mantest" id="ED5ED6181346D364B65D3CD0D89611DC" version="null" type="TPTP Manual Test" timestamp="1202730295256" totalError="1" totalFail="1" totalInconclusive="1" totalPass="1" totalTests="4" ></testExecutionResults></testSuites>

The report template is:

http://dev.eclipse.org/viewcvs/index.cgi/test/org.eclipse.tptp.test.report.birt/templates/TabularReport.rptdesign?revision=1.14&root=TPTP_Project

There are no errors appearing in the UI or the .log file.

Note, running TPTP 4.4.1-200802061217 build with JRE 1.4.2, BIRT 2.1.3, DTP
0.9.1 and GEF 3.2.2, the reports work as designed.  

Verified that it is not the same issue as
https://bugs.eclipse.org/bugs/show_bug.cgi?id=202331 by self-hosting an
instance of TPTP using both the BIRT and DTP constants:

org.eclipse.birt.report.data.oda.xml.inputStream
org.eclipse.birt.report.data.oda.xml.closeInputStream

org.eclipse.datatools.enablement.oda.xml.inputStream
org.eclipse.datatools.enablement.oda.xml.closeInputStream

This defect can be reproduced by using the following steps:

1) Download TPTP (http://www.eclipse.org/tptp/home/downloads/?buildId=TPTP-4.4.1-200802061217), EMF/BIRT/GMF/DTP.

2) Import the enclosed sample project.

3) Open the Test Perspective and right-click the genproj\mantest.testsuite file.

4) Select Report, select HTML Tabular Test Report (BIRT), and specify a report window from Feb10 - today (see http://help.eclipse.org/help33/topic/org.eclipse.tptp.test.report.birt.doc.user/tasks/treporttest.xhtml).

5) Click Finish and note the missing content (see https://bugs.eclipse.org/bugs/attachment.cgi?id=89311).  The report should contain the enclosed content.
Comment 1 Paul Slauenwhite CLA 2008-02-11 08:42:49 EST
Created attachment 89396 [details]
Expected report screen capture
Comment 2 Mingxia Wu CLA 2008-02-12 22:48:18 EST
This is a regression bug of 215948.Fix it now.
Comment 3 Paul Slauenwhite CLA 2008-02-13 06:31:48 EST
Thanks Mingxia.  What 1.6 build will this first appear?
Comment 4 Mingxia Wu CLA 2008-02-14 04:07:45 EST
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

 
Comment 5 Linda Chan CLA 2008-02-15 00:19:42 EST
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.
Comment 6 Mingxia Wu CLA 2008-02-15 00:43:16 EST
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. 
Comment 7 Wenfeng Li CLA 2008-02-15 17:04:32 EST
Has this patch being included in the latest BIRT 2.2.2RC build?
Comment 8 Mingxia Wu CLA 2008-02-17 21:41:13 EST
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?

Comment 9 Xiaoying Gu CLA 2008-02-17 21:45:26 EST
It will be in 2.2.2 nightly build 20080218.
Comment 10 Paul Slauenwhite CLA 2008-02-19 12:57:41 EST
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
Comment 11 Paul Slauenwhite CLA 2008-02-19 13:13:03 EST
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
Comment 12 Linda Chan CLA 2008-02-19 18:17:29 EST
(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.

Comment 13 Lin Zhu CLA 2008-02-19 21:59:04 EST
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

Comment 14 Lin Zhu CLA 2008-02-19 22:00:22 EST
For #12, 218922 has been reported and fixed. So the current BIRT 2.2.2 already include fixing to the problem.
Comment 15 Paul Slauenwhite CLA 2008-02-21 07:41:17 EST
(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.
Comment 16 Paul Slauenwhite CLA 2008-02-21 07:41:40 EST
Closing.