BIRT designer exception for datawarehouse reports
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:
The complete exception trace looks like this:
Has anyone faced this problem earlier?
Thanks,
Vikas
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
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.
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.
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?
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?
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.
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.