Jazz Forum Welcome to the Jazz Community Forum Connect and collaborate with IBM Engineering experts and users

WORKITEMS_SNAPSHOT is not showing any table list from Birt Plugin

Questions
Tags
Users
Badges
Kabir Ahmed
(26●3) edited
Jun 25 '15, 10:18 a.m.
Hello ,

I am trying to follow tutorials available on the internet about creating custom reports with BIRT - However I am not able to see any tables when I select WORKITEMS_SNAPSHOT as my data source and try to create data set from it. Other Snapshots e.g. Live Snapshot gives me back result . Any idea / help about why WORKITEMS_SNAPSHOT is not returning tables information will be greatly appreciated. My Configurations as follows

BIRT

  BIRT Chart Framework    2.6.2.r262_v20101008
  BIRT Chart OSGi Runtime Feature    2.6.2.r262_v20101025
  BIRT Chart OSGi Runtime SDK Feature    2.6.2.r262_v20101025
  BIRT Example Source Feature    2.6.2.r262_v20101008
  BIRT Framework    2.6.2.r262_v20101008

Eclipse :
Version: Helios Release
Build id: 20100617-1415

RTC

Rational Team Concert
Version: 4.0.0.1
Build id: RTC-I20120911-1740

 

Thanks in advance
kabir

1 vote

Comments
Donald Nong
Jul 01 '15, 3:29 a.m.
If you check the .metadata/.log file, can you see any errors?

Ralph Schoon
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER Jul 01 '15, 4:55 a.m.
The other thing to mention is that there needs to be data there. The data collection jobs need to be running, have to have already run once successfully, and there need to be work items that actually contribute. Thank you for providing all the environment details in your question!

Ralph Schoon
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER Jul 01 '15, 5:01 a.m.
Can you check if the WORKITEMS_SNAPSHOT is run in the report section? Do you have a production server - that runs the whole time? The data collection job in 4.x is run once a night. Does it maybe collide with the nightly reboot time? If it is a test system, can you run the collection job manually?

Kabir Ahmed
Jul 03 '15, 5:15 a.m.
@Donald : There is nothing in the log file. just to make sure i deleted the content and kept file empty . Create Data Set which did not returned any table in the UI and there was no entry appeared in the log as well. @Ralph : Sure Data is there , we are running reports from web UI - I think this not related to data ( i may be wrong though) but i am not seeing Table name under Fact Information Window of data set creation wizard. about your question Can you check if the WORKITEMS_SNAPSHOT is run in the report section?: Not sure how to do that can you guide me a bit to do this ? Much appreciated your response, is there any work around creating custom reports  ? We are really in need of doing this and I want to get rid of excel export and fiddling with data in excel to generate charts and reports

Donald Nong
Jul 03 '15, 5:28 a.m.
The WORKITEMS_SNAPSHOT corresponds to the data collection job "Work Items". So make sure this job has been run successfully. https://jazz.net/wiki/bin/view/Main/DataWarehouseSnapshotSchemas20

Kabir Ahmed
Jul 03 '15, 6:30 a.m.
Hi Donal, Thanks for responding. I have glanced through the link you provided. It does explain what a snapshot is however I am not sure how to run the data collection job. I dont have administrator access to server . is that what only can be done by administrator ? any pointer are much appreciated. 

Donald Nong
Jul 03 '15, 6:31 a.m.
You do need someone with the "JazzAdmins" role to perform this. http://www-01.ibm.com/support/knowledgecenter/SSYMRC_4.0.0/com.ibm.rational.reporting.admin.doc/topics/t_running_the_data_collection_jobs.html

showing 5 of 7 show 2 more comments
1 answer
5,130 views
1 vote

Accepted answer

Permanent link
Kabir Ahmed
(26●3) Jul 09 '15, 8:57 a.m.
Hello Donald and Ralph

Thank you for your input - The issue has been resolved for me at least. I discovered that our Server Version was 5.0.2 but the client i was using was Version: 4.0.0.1 - This morning i installed client for 5.0.2 from IBM installation manager and Bingo - I could see the tables coming in for Work item snapshot.

Thanks again for pointing me to some useful resources.

Best regards
kabir

Ralph Schoon selected this answer as the correct answer

0 votes

Your answer

Register or log in 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.

Ask a question
Guidelines
FAQ
Search context
Follow this question

By Email: 

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers
Answers and Comments
Question details
× 14

Question asked: Jun 25 '15, 5:04 a.m.

Question was seen: 5,130 times

Last updated: Jul 09 '15, 8:57 a.m.

Confirmation Cancel Confirm