When I run the OOTB reports from the shared reports, most do not work for me.
4 answers
It sounds like the data collection jobs are not running on your server. Many of the shared reports (e.g., Open vs Closed Work Items) pull their data from the data warehouse. Make sure that the jobs are running successfully (you may need to ask your server administrator). Also, if you've only recently created your timelines, work items, etc., then they won't show up in the reports until the next time the data collection jobs run (usually once a day).
The Work Items by Owner report does pull live data from the repository, which would explain why it's working when the other reports aren't.
Thanks for your response. I have admin access and have validated the collection jobs are running and I have also had another team member with admin access check and the jobs are running at 11pm everyday. There has been data in the project area for several weeks, like I said some reports work but others do not. The one thing we have noticed is that when you edit a report it doesn't list the timeline we are using. It shows the main timeline, but not the timeline we created or the iterations underneath it. Maybe there is something wrong with how we setup the timeline.
Like I said earlier, Open vs Closed Work Items doesn't work, but Work Items by Owner the report runs and shows "Work items by type" and "Open vs closed work items" in a graph and successffully.
Comments
Hmm, that's strange. Just to confirm - did you check that the jobs were running successfully in both the JTS and CCM? (I forgot to ask - are you using DCC or the built-in jobs? What version of RTC is this?)
Re: not seeing your timeline show up - again, this could be caused by the jobs not running correctly. Another possible reason is that, in most reports, it will only show parameter values for which there are assigned work items - e.g., if there's a parameter called "Iteration", it will only allow you to choose from iterations that have some assigned work items, not all iterations that are defined in the project area.
Comments
When she say that she can run a query to get her data - do you mean she's running an SQL query on the actual data warehouse? Or is she creating a work item query? The reason I ask is that it would be useful to verify whether or not the expected data is in the data warehouse (if it's not, then there's probably an issue with the data collection jobs; if the data is in the warehouse, but not showing in a report, then it could be a problem with the report configuration).
At this point, I think we've checked all the obvious causes for this problem - your best bet might be to log a ticket with IBM support so that they can help troubleshoot this in more detail.