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

DW Empty after Data Collection Jobs Run

Questions
Tags
Users
Badges
Alastair Beadle
(194●1●12●18) Aug 14 '13, 12:01 p.m.
Hi,
I have a Websphere/DB2/RRDI setup recently installed but it looks like the Data Warehouse is remaining empty even after the data collection jobs have run - a Query Studio query on Requirement Area/Requirement/Name always returns 'No Data Available' and looking at the Requirement table in the DW database in DB2 I can see no entries.
There is data in a single RM project and the etl_user is a member of that project and has the data collection license allocated. The data collection jobs are running with no errors shown and the jts-etl.log does not seem to contain any errors
Any thoughts on what might be going wrong? Is the jts-etl.log the only place data collection errors would be reported? (There is no rm-etl.log - I assume the requirement data collection logs to jts-etl.log?).
Ali

0 votes

Comments
Francesco Chiossi
Aug 15 '13, 12:52 p.m.
Hello Ali, you are right on the jts-etl.log, as the RM data collection is handled by JTS. About the settings for the etl_user, the only ther thing that I would verify is that it has JazzAdmin repository permissions. Do you get data for any other object in the data warehouse, like projects, requests or test cases, or is it completely empty? Best Regards Francesco

Erica Tran
JAZZ DEVELOPER Aug 16 '13, 3:51 p.m.
Hello, If you're not seeing any errors and it appears to be completing successfully, maybe additional logging may help.  In the ..\server\conf\jts\log4j.properties file there is an ETL section.  There are a line for detailed RM debug info that is commented out.  Remove the comment save and restart the server for the logging change to take effect then try to run the ETL jobs again. log4j.logger.com.ibm.team.datawarehouse.service.rrc=DEBUG, etl Hopefully additional messages will be logged helping you identify the problem.

Andal Prassan
JAZZ DEVELOPER Aug 20 '13, 1:55 p.m.
can you check if there status is 1 for the jobs run in CONFIG.ETL_INFO table ? could you please check if jobs were successful from the data collection status page ?

2 answers
7,355 views
0 votes

2 answers

Permanent link
Philip Johnson
(30●9●10) Aug 27 '13, 10:18 a.m.
 Hi Ali,

Have you tested RRDI to confirm that it is successfully connecting to the RIDW?

Thanks,
Phil

0 votes

Permanent link
Alastair Beadle
(194●1●12●18) Aug 20 '14, 11:41 a.m.
OK, to close this one down: it appears that a configuration error during set-up meant that the DW data was being written into the RM database. I think this occurred by me entering the RM database name into the con figuration wizard when it was asking for the DW database.
The system has been taken down and rebuild (without a DW or RRDI at the moment as the complexities of the installation currently outweigh our desire fro their capabilities) and is running OK.

0 votes

Comments
Francesco Chiossi
Aug 20 '14, 12:10 p.m.
Thanks a lot for sharing the cause of the problem and the solution, Ali!

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
× 403
× 51

Question asked: Aug 14 '13, 12:01 p.m.

Question was seen: 7,355 times

Last updated: Aug 20 '14, 12:10 p.m.

Confirmation Cancel Confirm