It's all about the answers!

Ask a question

How to connect to "Jazz Data set" to Create new RT


Prasad Rachuri (1632) | asked Feb 03 '10, 9:26 a.m.
I want to create a new report template using "Jazz Data set" as described in this link https://jazz.net/wiki/bin/view/Main/ReportsCreatingANewReport20.
My question is how to connect to this data set? so that I can create new report templates as per my client requests. If some one already created new reports and documented the procedure can you send me the document.

Thanks in advance,
Prasad R Rachuri

9 answers



permanent link
Eric Wood (211) | answered May 18 '11, 11:01 a.m.
I have tried to follow the steps in https://jazz.net/wiki/bin/view/Main/ReportsCreatingANewReport20.

I am able to specify a Jazz data source and can select a snapshot and project area in the fields on the Snapshot Information page. However the "Next" button remains ghosted and when I press Test Connection, I get the following error


org.eclipse.datatools.connectivity.oda.OdaException: Snapshot must be specified...

Any assistance is appreciated.


Turns out this may be a minor issue with the SpringSource distro or Eclipse on MAC I am using. In the New Jazz Data Source dialog, I have to type in the text (or edit the text) for the URL, snapshot, and project area. If I just use the dropdown, it doesn't pick up the selection.

permanent link
James Moody (3.3k24) | answered Feb 03 '10, 2:53 p.m.
JAZZ DEVELOPER
On 2/3/2010 9:38 AM, prasad.rachuri wrote:
I want to create a new report template using "Jazz Data set"
as described in this link
https://jazz.net/wiki/bin/view/Main/ReportsCreatingANewReport20.
My question is how to connect to this data set? so that I can create
new report templates as per my client requests. If some one already
created new reports and documented the procedure can you send me the
document.

Thanks in advance,
Prasad R Rachuri


Hi Prasad,

I'm not sure what you're asking. Generally, when creating a BIRT report,
the first step is to create a data source, and then to create a data set
from that data source. Then, you use that data set in your report -
often by presenting the information in the form of a table or graph. For
a graph, you just create a "Chart" from the BIRT palette, and then in
the "Select Data" page, select your data set and tell the graph where to
get the data for the X and Y axes. To make a table, you can just drag
the data set onto the canvas and a table will be created automatically.

Hope this helps.

james
RTC Reports Team Lead

permanent link
Prasad Rachuri (1632) | answered Feb 04 '10, 1:30 a.m.
On 2/3/2010 9:38 AM, prasad.rachuri wrote:
I want to create a new report template using "Jazz Data set"
as described in this link
https://jazz.net/wiki/bin/view/Main/ReportsCreatingANewReport20.
My question is how to connect to this data set? so that I can create
new report templates as per my client requests. If some one already
created new reports and documented the procedure can you send me the
document.

Thanks in advance,
Prasad R Rachuri


Hi Prasad,

I'm not sure what you're asking. Generally, when creating a BIRT report,
the first step is to create a data source, and then to create a data set
from that data source. Then, you use that data set in your report -
often by presenting the information in the form of a table or graph. For
a graph, you just create a "Chart" from the BIRT palette, and then in
the "Select Data" page, select your data set and tell the graph where to
get the data for the X and Y axes. To make a table, you can just drag
the data set onto the canvas and a table will be created automatically.

Hope this helps.

james
RTC Reports Team Lead

Hello James,
I see below two steps in the Reports creation document. Here it says select "Jazz Data Source". But I don't see this instead I see "Sample Database", "Flar file data source", "JDBC Data Source", "Scripted Data Source", "Web Service Data Source" and ,"XML Data Source".

How can I connect to "Jazz Data Source" as it is not coming by default.
3 Next, we need some data to report on. Select the Data Explorer view. Right-click on the Data Sources node, and select New Data Source. Select "Jazz Data Source", and enter "Work Items" as the data source name. Click Next. Select your repository from the drop-down list, and select WORKITEMS_SNAPSHOT as the snapshot. Press Finish.
4 Right-click on the Data Sets node, and select New Data Set. Enter "Open Work Items" as the data set name. Select the Data Source you just created, and ensure "Jazz Data Set" is selected as the data set type. Select Next.

permanent link
Tommie Haag (6) | answered Aug 13 '10, 3:08 a.m.
I'm having the same problem. I installed the BIRT Report Designer, but when choosing 'new data source' I don't get to choose anything jazz-related at all.

How come?

Do I need to configure BIRT Report Designer to find the jazz repository somehow?

permanent link
Sergey Tupchienko (11131) | answered Sep 24 '10, 4:57 a.m.
Dear colleagues, now I have the same problem. I have just performed all steps in https://jazz.net/wiki/bin/view/Main/ReportsCreatingANewReport20 and now I don't see "Jazz Data Set" in list of evailable data sets.

Please help me to solve the problem.

Many thanks in advance!

permanent link
James Moody (3.3k24) | answered Oct 07 '10, 1:59 p.m.
JAZZ DEVELOPER
On 9/24/2010 5:08 AM, stupchienko wrote:
Dear colleagues, now I have the same problem. I have just performed
all steps in
https://jazz.net/wiki/bin/view/Main/ReportsCreatingANewReport20 and
now I don't see "Jazz Data Set" in list of evailable data
sets.

Please help me to solve the problem.

Many thanks in advance!


Can you confirm that you added the BIRT, DTP, EMF, GEF and WTP plug-ins
to an existing RTC client installation? (i.e. don't simply use the BIRT
all-in-one zip).

james
RTC Reports Team Lead

permanent link
Eric Wood (211) | answered May 17 '11, 3:28 p.m.
I have tried to follow the steps in https://jazz.net/wiki/bin/view/Main/ReportsCreatingANewReport20.

I am able to specify a Jazz data source and can select a snapshot and project area in the fields on the Snapshot Information page. However the "Next" button remains ghosted and when I press Test Connection, I get the following error


org.eclipse.datatools.connectivity.oda.OdaException: Snapshot must be specified
at com.ibm.team.reports.common.oda.generic.GenericConnection.open(GenericConnection.java:44)
at com.ibm.team.reports.client.oda.internal.ClientConnection.open(ClientConnection.java:40)
at org.eclipse.datatools.connectivity.oda.consumer.helper.OdaConnection.open(OdaConnection.java:239)
at org.eclipse.datatools.connectivity.oda.profile.OdaConnectionWrapper.open(OdaConnectionWrapper.java:209)
at org.eclipse.datatools.connectivity.oda.profile.OdaConnectionWrapper.<init>(OdaConnectionWrapper.java:59)
at org.eclipse.datatools.connectivity.oda.profile.OdaConnectionFactory.createConnection(OdaConnectionFactory.java:26)
at org.eclipse.datatools.connectivity.internal.ConnectionFactoryProvider.createConnection(ConnectionFactoryProvider.java:83)
at org.eclipse.datatools.connectivity.internal.ConnectionProfile.createConnection(ConnectionProfile.java:355)
at org.eclipse.datatools.connectivity.ui.PingJob.createTestConnection(PingJob.java:76)
at org.eclipse.datatools.connectivity.oda.design.internal.ui.DataSourceWizardPageCore$1.run(DataSourceWizardPageCore.java:244)
at org.eclipse.swt.custom.BusyIndicator.showWhile(BusyIndicator.java:70)
at org.eclipse.datatools.connectivity.ui.wizards.ConnectionProfileDetailsPage.testConnection(ConnectionProfileDetailsPage.java:194)
at org.eclipse.datatools.connectivity.ui.wizards.ConnectionProfileDetailsPage$2.widgetSelected(ConnectionProfileDetailsPage.java:131)
at org.eclipse.swt.widgets.TypedListener.handleEvent(TypedListener.java:228)
at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:84)
at org.eclipse.swt.widgets.Display.sendEvent(Display.java:3543)
at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1250)
at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1273)
at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1258)
at org.eclipse.swt.widgets.Widget.notifyListeners(Widget.java:1079)
at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:3441)
at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3100)
at org.eclipse.jface.window.Window.runEventLoop(Window.java:825)
at org.eclipse.jface.window.Window.open(Window.java:801)
at org.eclipse.birt.report.designer.data.ui.actions.NewDataSourceAction.run(NewDataSourceAction.java:126)
at org.eclipse.jface.action.Action.runWithEvent(Action.java:498)
at org.eclipse.jface.action.ActionContributionItem.handleWidgetSelection(ActionContributionItem.java:584)
at org.eclipse.jface.action.ActionContributionItem.access$2(ActionContributionItem.java:501)
at org.eclipse.jface.action.ActionContributionItem$5.handleEvent(ActionContributionItem.java:411)
at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:84)
at org.eclipse.swt.widgets.Display.sendEvent(Display.java:3543)
at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1250)
at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1273)
at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1258)
at org.eclipse.swt.widgets.Widget.notifyListeners(Widget.java:1079)
at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:3441)
at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3100)
at org.eclipse.ui.internal.Workbench.runEventLoop(Workbench.java:2405)
at org.eclipse.ui.internal.Workbench.runUI(Workbench.java:2369)
at org.eclipse.ui.internal.Workbench.access$4(Workbench.java:2221)
at org.eclipse.ui.internal.Workbench$5.run(Workbench.java:500)
at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:332)
at org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Workbench.java:493)
at org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.java:149)
at org.eclipse.ui.internal.ide.application.IDEApplication.start(IDEApplication.java:113)
at org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:194)
at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(EclipseAppLauncher.java:110)
at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(EclipseAppLauncher.java:79)
at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:368)
at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:179)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.eclipse.equinox.launcher.Main.invokeFramework(Main.java:559)
at org.eclipse.equinox.launcher.Main.basicRun(Main.java:514)
at org.eclipse.equinox.launcher.Main.run(Main.java:1311)

Any assistance is appreciated.

permanent link
Manik K (10133) | answered Sep 12 '11, 11:53 a.m.
I may be worng, but I think you all are trying to access Jazz data source withought a connection to the Jazz database/repository; that is, you have installed BIRT by downloading the BIRT installer or and Eclipse IDE with Framework (BIRT report).

Well, if that is the case, you may not be able to make a connection. The process should be, on top of an existing/installed RTC environment, you'll have to import/dump the BIRT related plugins into the RTC plugins folder.

That is how I did and if there are other ways, I have not tried those. But this way you are in the RTC, you make a connection to the team projects, acces the Report Design module from RTC and create Jazz Data Source.

permanent link
David Cox (1111) | answered Mar 06 '12, 7:04 p.m.
Any updates on this? I have an RTC eclipse client and the downloaded eclispse with Birt, but niether of them have the JAZZ Data source.

Your answer


Register or to post your answer.