It's all about the answers!

Ask a question

BIRT designer exception for datawarehouse reports


Vikas Setty (2162) | asked Mar 03 '09, 5:58 a.m.
JAZZ DEVELOPER
Hello,

I am using BIRT designer plugins v2.2.2 along with RTC (1.0.1).
Having specified Jazz DataSource as the driver, I am unable to create dataset for any of default snapshot tables.
The exception I see in the RCP when I try to map output columns of resultset:

Cannot open the connection for the driver: com.ibm.team.reports.generic.dataSource

Reason: A BIRT exception occurred

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.CannotOpenConnection

Error Message:Cannot open the connection for the driver: com.ibm.team.reports.generic.dataSource



The complete exception trace looks like this:

!ENTRY org.eclipse.birt.data 4 1001 2009-03-03 16:03:48.062

!MESSAGE A BIRT exception occurred.
!STACK 0
org.eclipse.birt.data.engine.core.DataException: Cannot open the connection for the driver: com.ibm.team.reports.generic.dataSource
at org.eclipse.birt.data.engine.odaconsumer.ConnectionManager.openConnection(ConnectionManager.java:157)
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:265)
at org.eclipse.birt.data.engine.impl.QueryExecutor.prepareExecution(QueryExecutor.java:210)
at org.eclipse.birt.data.engine.impl.PreparedQuery.doPrepare(PreparedQuery.java:500)
at org.eclipse.birt.data.engine.impl.PreparedDataSourceQuery.execute(PreparedDataSourceQuery.java:161)
at org.eclipse.birt.data.engine.impl.PreparedOdaDSQuery.execute(PreparedOdaDSQuery.java:142)
at org.eclipse.birt.data.engine.impl.PreparedDataSourceQuery.execute(PreparedDataSourceQuery.java:141)
at org.eclipse.birt.report.data.adapter.impl.QueryExecutionHelper.executeQuery(QueryExecutionHelper.java:113)
at org.eclipse.birt.report.data.adapter.impl.QueryExecutionHelper.executeQuery(QueryExecutionHelper.java:92)
at org.eclipse.birt.report.data.adapter.impl.DataSetMetaDataHelper.getRealMetaData(DataSetMetaDataHelper.java:147)
at org.eclipse.birt.report.data.adapter.impl.DataSetMetaDataHelper.getDataSetMetaData(DataSetMetaDataHelper.java:101)
at org.eclipse.birt.report.data.adapter.impl.DataRequestSessionImpl.getDataSetMetaData(DataRequestSessionImpl.java:168)
at org.eclipse.birt.report.designer.data.ui.util.DataSetProvider.populateAllOutputColumns(DataSetProvider.java:186)
at org.eclipse.birt.report.designer.data.ui.dataset.OutputColumnsPage.populateOutputColums(OutputColumnsPage.java:294)
at org.eclipse.birt.report.designer.data.ui.dataset.OutputColumnsPage.updateOutputColumns(OutputColumnsPage.java:275)
at org.eclipse.birt.report.designer.data.ui.dataset.OutputColumnsPage.pageActivated(OutputColumnsPage.java:189)
at org.eclipse.birt.report.designer.data.ui.property.AbstractPropertyDialog.showPage(AbstractPropertyDialog.java:570)
at org.eclipse.birt.report.designer.data.ui.property.AbstractPropertyDialog.showSelectionPage(AbstractPropertyDialog.java:467)
at org.eclipse.birt.report.designer.data.ui.dataset.DataSetEditor.showSelectionPage(DataSetEditor.java:820)
at org.eclipse.birt.report.designer.data.ui.property.AbstractPropertyDialog$3.run(AbstractPropertyDialog.java:425)
at org.eclipse.swt.custom.BusyIndicator.showWhile(BusyIndicator.java:67)
at org.eclipse.birt.report.designer.data.ui.property.AbstractPropertyDialog$2.selectionChanged(AbstractPropertyDialog.java:420)
at org.eclipse.jface.viewers.Viewer$2.run(Viewer.java:162)
at org.eclipse.core.runtime.SafeRunner.run(SafeRunner.java:37)
at org.eclipse.core.runtime.Platform.run(Platform.java:857)
at org.eclipse.ui.internal.JFaceUtil$1.run(JFaceUtil.java:46)
at org.eclipse.jface.util.SafeRunnable.run(SafeRunnable.java:199)
at org.eclipse.jface.viewers.Viewer.fireSelectionChanged(Viewer.java:160)
at org.eclipse.jface.viewers.StructuredViewer.updateSelection(StructuredViewer.java:2047)
at org.eclipse.jface.viewers.StructuredViewer.setSelection(StructuredViewer.java:1641)
at org.eclipse.jface.viewers.TreeViewer.setSelection(TreeViewer.java:1095)
at org.eclipse.jface.viewers.Viewer.setSelection(Viewer.java:392)
at org.eclipse.birt.report.designer.data.ui.property.AbstractPropertyDialog.initTreeSelection(AbstractPropertyDialog.java:396)
at org.eclipse.birt.report.designer.data.ui.property.AbstractPropertyDialog.createDialogArea(AbstractPropertyDialog.java:283)
at org.eclipse.jface.dialogs.Dialog.createContents(Dialog.java:754)
at org.eclipse.birt.report.designer.data.ui.dataset.DataSetEditor.createContents(DataSetEditor.java:514)
at org.eclipse.jface.window.Window.create(Window.java:426)
at org.eclipse.jface.dialogs.Dialog.create(Dialog.java:1083)
at org.eclipse.birt.report.designer.internal.ui.dialogs.BaseDialog.open(BaseDialog.java:99)
at org.eclipse.birt.report.designer.ui.actions.NewDataSetAction.editDataSet(NewDataSetAction.java:224)
at org.eclipse.birt.report.designer.ui.actions.NewDataSetAction.createNewDataSet(NewDataSetAction.java:161)
at org.eclipse.birt.report.designer.ui.actions.NewDataSetAction.run(NewDataSetAction.java:142)
at org.eclipse.jface.action.Action.runWithEvent(Action.java:498)
at org.eclipse.jface.action.ActionContributionItem.handleWidgetSelection(ActionContributionItem.java:546)
at org.eclipse.jface.action.ActionContributionItem.access$2(ActionContributionItem.java:490)
at org.eclipse.jface.action.ActionContributionItem$5.handleEvent(ActionContributionItem.java:402)
at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:66)
at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:938)
at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:3682)
at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3293)
at org.eclipse.ui.internal.Workbench.runEventLoop(Workbench.java:2389)
at org.eclipse.ui.internal.Workbench.runUI(Workbench.java:2353)
at org.eclipse.ui.internal.Workbench.access$4(Workbench.java:2219)
at org.eclipse.ui.internal.Workbench$4.run(Workbench.java:466)
at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:289)
at org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Workbench.java:461)
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:169)
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:363)
at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:176)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:79)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:618)
at org.eclipse.equinox.launcher.Main.invokeFramework(Main.java:508)
at org.eclipse.equinox.launcher.Main.basicRun(Main.java:447)
at org.eclipse.equinox.launcher.Main.run(Main.java:1173)
Caused by: org.eclipse.datatools.connectivity.oda.OdaException ;
java.lang.IllegalArgumentException: Data warehouse service must be specified
at com.ibm.team.reports.service.oda.internal.ServiceConnection.setAppContext(ServiceConnection.java:89)
at org.eclipse.datatools.connectivity.oda.consumer.helper.OdaConnection.setAppContext(OdaConnection.java:288)
at org.eclipse.datatools.connectivity.oda.consumer.helper.OdaConnection.open(OdaConnection.java:214)
at org.eclipse.birt.data.engine.odaconsumer.ConnectionManager.openConnection(ConnectionManager.java:145)
... 72 more
Caused by: java.lang.IllegalArgumentException: Data warehouse service must be specified
at com.ibm.team.reports.service.oda.internal.ServiceConnection.setAppContext(ServiceConnection.java:63)


Has anyone faced this problem earlier?

Thanks,
Vikas

7 answers



permanent link
Benjamin Chodroff (8985231) | answered Apr 02 '09, 10:30 a.m.
Great :) How do I fix it?
What specific server plugin do I need to remove from my client? Thanks for the help!

permanent link
Rafik Jaouani (5.0k16) | answered Mar 03 '09, 7:10 a.m.
JAZZ DEVELOPER
Make sure you RTC client has a connection to a jazz server and you data source is using that connection.

permanent link
Rafik Jaouani (5.0k16) | answered Mar 03 '09, 2:29 p.m.
JAZZ DEVELOPER
Problem was caused by the fact that the client contained server plugins.
The Jazz Data Source driver has two different implementations. One for the client and one for the server. Both are contributed through extension points. When both impls are present, the server one is picked. The server driver does not work on the client.

permanent link
Rafik Jaouani (5.0k16) | answered Apr 02 '09, 9:22 p.m.
JAZZ DEVELOPER
I need to know your setup.

1) If you are trying to create a report design file from your host RTC client which is connected to a Jazz Server, then you do not need to do anything. As the RTC client does not contain any server plugins.

2) Now, if you launched RTC as a runtime evironment using the Jazz SDK, then I guess you are doing that because your are trying to extrend RTC. In that case, please ask the question in the Extending Team Concert forum since this forum is for users of the product and asking and answering questions about the SDK in this forum could confuse the normal users.

So under which case do you fall 1 or 2?

permanent link
Matt Heinrich (11) | answered Apr 03 '09, 12:53 p.m.
I fall under #1. I'm getting the error when trying to open the data_set after being created in RTC, report perspective.

permanent link
Matt Heinrich (11) | answered Apr 03 '09, 1:00 p.m.
After reading my reply, I may not have made myself clear.

I am receiving this error in my RTC client. I can reproduce many ways, but here is the most clear.

Take an exiting template (from RTC install on hard drive) and copy and rename. Place in my workspace and attempt to modify the template. Change data-source to point to my jazz server. Attempt to edit any data-set and get the error.

I can reproduce this error using any of my newly created templates also. With a new report, I can create the data-source, create and edit the data-set, create chart, then at some point after previewing the chart, the data-set becomes uneditable due to receiving the error. For the past week, I've been deleting my data-set and recreating, but getting tired of this approach. The "fact information" section is what I am trying to edit. After the error message, I can click "ok", however, the "fact information" section is missing from the opened frame.

permanent link
Rafik Jaouani (5.0k16) | answered Apr 03 '09, 7:05 p.m.
JAZZ DEVELOPER
Please check and see if this solves your problem. Make sure your data source is also pointing to a logged in team repository.

Here is the topic:
https://jazz.net/forums/viewtopic.php?t=3977

Your answer


Register or to post your answer.


Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.