It's all about the answers!

Ask a question

Custom report in rtc. Empty tables in snapshot schemas


Qaiser Islam (31297074) | asked Dec 28 '09, 9:44 a.m.
hi,

i m trying to create the custom reports in rtc. but tables in the available snapshot schema (WORKITEM_SNAPSHOT, SCM_SNAPSHOT etc. ) dont contain any data.

I setup the rtc using db2 as database and i double checked the tables using DB2 Control Center and verify that all these tables are empty
how can i populate these tables???

Regards,
Qaiser

3 answers



permanent link
Rafik Jaouani (5.0k16) | answered Dec 28 '09, 12:12 p.m.
JAZZ DEVELOPER
The data warehouse data collection tasks run every midnight. You need to wait until the next day to see data in those tables.

The SCM_SNAPSHOT needs to be configured by selecting which streams to collect data for. This can be done through the reports Web UI. Click the link "Administer SCM Snapshot"

permanent link
Qaiser Islam (31297074) | answered Dec 29 '09, 5:54 a.m.
The data warehouse data collection tasks run every midnight. You need to wait until the next day to see data in those tables.

The SCM_SNAPSHOT needs to be configured by selecting which streams to collect data for. This can be done through the reports Web UI. Click the link "Administer SCM Snapshot"


is there any way to run these task manually??

permanent link
Qaiser Islam (31297074) | answered Dec 29 '09, 9:43 a.m.
The data warehouse data collection tasks run every midnight. You need to wait until the next day to see data in those tables.

The SCM_SNAPSHOT needs to be configured by selecting which streams to collect data for. This can be done through the reports Web UI. Click the link "Administer SCM Snapshot"


thanks, i found the link to update all snapshots from web ui. thanks again for help

Your answer


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