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
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
2 answers
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.
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.
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
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