WORKITEMS_SNAPSHOT is not showing any table list from Birt Plugin
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
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
Accepted answer
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
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
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