Data Collecton Jobs - Failed
Ketan Divecha (26●1●8●12)
| asked Aug 07 '13, 9:47 a.m.
retagged Aug 08 '13, 5:18 p.m. by Laura W. Hinson (161●2●6) Hi,
I recently installed RRDI and connected to Jazz Data Warehouse, however I am unable to run reports (I get no data available message). So I decided to look at status of data collection jobs, and they are all failing. I have tried few things already but havent been able to resolve this, see screenshot. I have attached data warehouse connection roperties page. If anyone has any suggestions, please let me know. What I was wondering is if I have to set up OAuth consumer for DW connection, or is jazz ADMIN user fine.
|
3 answers
To troubleshoot this issue, you need to find the <app>-etl.log files.
Assuming you're using Tomcat, they are located in <JazzServer>/server/logs In case of WAS: <WebSphere install dir>/AppServer/profiles/<profile name>/logs There you will find the reason for the failures. I see that it has never worked for you, so as the first step I would make sure your DW collection user (usually called dw_user) has the Data Collector license assigned, and is in the JazzAdmins role. |
Agreed with Piotr's answer above. From your first screenshot, the user being used to run the ETLs is 'ADMIN'. If you use LDAP, this user has to be a valid LDAP user as well. Alternatively, you can create a consumer key and secret to be used here. (ref: http://www-01.ibm.com/support/docview.wss?uid=swg21591743) |
|
thanks guys, I just dropped DW and reran the JTS setup in order to create DW tables. I belive the DW tables did not get created properly when I migrated from Derby to SQL server. Its all good now.
|
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.