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

Birt Report. STATES table empty

I'm developing a report and I need to show the state names, but the STATE table is empty. In RTC 3.0.1 it worked correctly, but since 3.0.1.2 and so far (4.0), it's doesn't work. The STATE table doesn't have any records. Well the table has only one record:
STATE STATE_NAME PROJECT_AREAID
Unassigned Info not available

Does anybody know if something is changed when you create a new Project Area?
Is there a new table with the STATE names?

Datasource: WORKITEMS_SNAPSHOT
Dataset:
table: STATE
Columns: STATE, STATE_NAME, STATE_GROUP

Best regards
Boris

0 votes



2 answers

Permanent link
Hi boris,
Reason could be that the snapshot tables have not got updated. This updation happens through jobs run periodically. Just check on the job settings, run it once (via JTS admin page) and check if its reflecting latest data.

If you have data in the project, then it should reflect in the report as well. Just make sure there is data.

0 votes


Permanent link
Hi Valli
Following your suggestions I got this link which explains how to run a data collection job.

http://pic.dhe.ibm.com/infocenter/clmhelp/v3r0m1/index.jsp?topic=%2Fcom.ibm.rational.rcpr.help.doc%2Ftopics%2Ft_running_the_data_collection_jobs.html

Thank you very much, now the STATE table does contain all states of all Project Areas.

Best regards
Boris

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.

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
× 10,940

Question asked: May 30 '12, 7:42 a.m.

Question was seen: 5,703 times

Last updated: May 30 '12, 7:42 a.m.

Confirmation Cancel Confirm