Reports not showing work items

Hi Lauren,

The "Work Items by Owner" and "Work Items by Team Area" are "live"
reports that present data from the repository, which would be why they
are the only two that have data.

1. Is there any indication in your server error log why the snapshot
might have failed to run?
2. Was the server actually up all night? If it's down around midnight
the snapshot might not run.
3. What happens if you try to run the snapshot manually? You can do this
as any user with admin privileges (specifically you need the
JazzDWAdmins repository permission) - go to the Reports web UI and click
on Administer Data Warehouse, then select Update All Snapshots.

To answer your questions, this isn't common, it doesn't sound like
you're making a mistake, and the reports do not need a full 24 hours
worth of data - whatever work item data is available when the snapshot
runs will be fine.

james
Jazz Reports Team Lead

ljhaywar wrote:

Hi,
I'm working on trying out the Reports feature in the web ui so we can
utilize it in a class. Yesterday evening, I created a project area,
a team area, 2 iterations, and an iteration plan with work items in
both iterations. I tried to view the reports, but the snapshot from
the previous evening didn't show any work items so the reports were
all blank. I tried to view the reports again this morning, and the
only reports with data in them were the Work Items by Owner and Work
Items by team area. The other reports in the plans section indicate
that are no open work items, even though the Iteration Plan pages in
the web ui clearly indicate there are open work items. Is this
common? Am I making a typical mistake when creating the work items?
Do the reports need a full 24 hours worth of data?
Any help is appreciated!
Lauren

Hi James,
Thanks for the fast response! I started manually run the snapshot around 10:45 last night as I really wanted to see those reports. :) I viewed the active services and they were running. Is it possible my manual snapshot run conflicted with the scheduled snapshot run? I just went back to view Active Services and there is still a service currently running that I started. It seems like they should be done by now? The server should have been running all night.
-Lauren

Hi Lauren,

The "Work Items by Owner" and "Work Items by Team Area" are "live"
reports that present data from the repository, which would be why they
are the only two that have data.

1. Is there any indication in your server error log why the snapshot
might have failed to run?
2. Was the server actually up all night? If it's down around midnight
the snapshot might not run.
3. What happens if you try to run the snapshot manually? You can do this
as any user with admin privileges (specifically you need the
JazzDWAdmins repository permission) - go to the Reports web UI and click
on Administer Data Warehouse, then select Update All Snapshots.

To answer your questions, this isn't common, it doesn't sound like
you're making a mistake, and the reports do not need a full 24 hours
worth of data - whatever work item data is available when the snapshot
runs will be fine.

james
Jazz Reports Team Lead

ljhaywar wrote:

Hi,
I'm working on trying out the Reports feature in the web ui so we can
utilize it in a class. Yesterday evening, I created a project area,
a team area, 2 iterations, and an iteration plan with work items in
both iterations. I tried to view the reports, but the snapshot from
the previous evening didn't show any work items so the reports were
all blank. I tried to view the reports again this morning, and the
only reports with data in them were the Work Items by Owner and Work
Items by team area. The other reports in the plans section indicate
that are no open work items, even though the Iteration Plan pages in
the web ui clearly indicate there are open work items. Is this
common? Am I making a typical mistake when creating the work items?
Do the reports need a full 24 hours worth of data?
Any help is appreciated!
Lauren

Not sure if this will add any insight, but I just tried to open the chart page in the Iteration Plan and it gave me the following error:

Display Chart
Reason: Report descriptor not found for: workitems.OpenWorkItemsByType
Report descriptor not found for: workitems.OpenWorkItemsByType

I had another friend look over the empty reports, and we figured out part of the problem. Apparently, you need to check the specific parameter boxes (the generic defaults don't seem to work). So I was able to get information in most of the charts. But that doesn't explain the Display Chart error.

Hi Lauren,

I'll reply to each of your posts in order...

It should not conflict if you have a manual job running when the
scheduled task kicks in - we have mutex code so that two snapshots can't
actually run at the same time. The length of time required depends
greatly on the amount of data you have. On our production server, if I
recall correctly, our snapshot takes about 1.5 hours to run.

james

ljhaywar wrote:

Hi James,
Thanks for the fast response! I started manually run the snapshot
around 10:45 last night as I really wanted to see those reports. :)
I viewed the active services and they were running. Is it possible
my manual snapshot run conflicted with the scheduled snapshot run? I
just went back to view Active Services and there is still a service
currently running that I started. It seems like they should be done
by now? The server should have been running all night.
-Lauren


jmoodywrote:
Hi Lauren,
The "Work Items by Owner" and "Work Items by Team
Area" are "live"
reports that present data from the repository, which would be why
they
are the only two that have data.

1. Is there any indication in your server error log why the snapshot

might have failed to run?
2. Was the server actually up all night? If it's down around
midnight
the snapshot might not run.
3. What happens if you try to run the snapshot manually? You can do
this
as any user with admin privileges (specifically you need the
JazzDWAdmins repository permission) - go to the Reports web UI and
click
on Administer Data Warehouse, then select Update All Snapshots.

To answer your questions, this isn't common, it doesn't sound like
you're making a mistake, and the reports do not need a full 24 hours

worth of data - whatever work item data is available when the
snapshot
runs will be fine.

james
Jazz Reports Team Lead

ljhaywar wrote:
Hi,
I'm working on trying out the Reports feature in the web ui so we
can
utilize it in a class. Yesterday evening, I created a project
area,
a team area, 2 iterations, and an iteration plan with work items in
both iterations. I tried to view the reports, but the snapshot
from
the previous evening didn't show any work items so the reports were
all blank. I tried to view the reports again this morning, and the
only reports with data in them were the Work Items by Owner and
Work
Items by team area. The other reports in the plans section
indicate
that are no open work items, even though the Iteration Plan pages
in
the web ui clearly indicate there are open work items. Is this
common? Am I making a typical mistake when creating the work
items?
Do the reports need a full 24 hours worth of data?
Any help is appreciated!
Lauren

ljhaywar wrote:

Not sure if this will add any insight, but I just tried to open the
chart page in the Iteration Plan and it gave me the following error:

Display Chart
Reason: Report descriptor not found for:
workitems.OpenWorkItemsByType
Report descriptor not found for: workitems.OpenWorkItemsByType

Interesting, it looks like you're missing one or more reports. Can you
open the rich client, open the Team Artifacts view, expand the project
area that you're working with, and expand Report Templates? Look for
"Open Work Items by Type" - if it's there, select Properties on it and
see if an ID is specified (it should be "workitems.OpenWorkItemsByType").

james

ljhaywar wrote:

I had another friend look over the empty reports, and we figured out
part of the problem. Apparently, you need to check the specific
parameter boxes (the generic defaults don't seem to work). So I was
able to get information in most of the charts. But that doesn't
explain the Display Chart error.

That's good... it means the data warehouse is correctly collecting data.

The problem could come from the fact that most of our reports, by
default, use "Current Iteration" and "My Team Areas" as default
parameter values. We did this so that people would be more likely to get
reports that are relevant to *them* without any further action on their
part.

However, this could be problematic for you if:
1. "You" (your user specifically) aren't a member of the team or teams
that you'd like the report on, or
2. The "Current Iteration" flagged in your project area's process isn't
the one that you'd like the report on.

Fortunately, it's easy to change the parameter values, and you can
select "Save" once you specify the right values, so that other people
viewing the report will get the right chart.

I've addressed the Display Chart error in another message.

Hope this helps.

james
Jazz Reports Team Lead

I have a similar issue with the Blocking Work Items report. I'm using the Scrum template and I have blocking stories in all of my iterations, but no fiddling with the report parameters can I get any data to show. All of my other reports seem to load ok with the expected data.

Is there a way to see what items the report is actually querying? Like Lauren suggested, maybe it's related to the way we're creating stories and tasks?

baronlam wrote:

I have a similar issue with the Blocking Work Items report. I'm using
the Scrum template and I have blocking stories in all of my
iterations, but no fiddling with the report parameters can I get any
data to show. All of my other reports seem to load ok with the
expected data.

Is there a way to see what items the report is actually querying? Like
Lauren suggested, maybe it's related to the way we're creating stories
and tasks?

Hi Baron,

There's no easy way to see what items the report is querying... but to
come close, I'd recommend creating a fresh work items query. Then add
each of the parameters exactly as you've specified it in the report
(Team Area, Category, Iteration) paying particular attention to any
special parameters that are specified in the report (such as "My Team
Areas" and "Current Iteration"). See what the work items query returns.

There's nothing special about Story work items from this report's
perspective - it treats all work item types the same.

Could you open a work item in the Reports component so we can track this
issue, including any relevant information you think might help?
Additionally, if this is an internal server that I could have access to,
can you please email me the connection information?

Thanks,

james
Jazz Reports Team Lead

I opened the properties and the id was correct. When I double clicked the report, it gave me some weird error (that I didn't write down so I can't remember) but I can't seem to reproduce it. Very strange.

ljhaywar wrote:

Not sure if this will add any insight, but I just tried to open the
chart page in the Iteration Plan and it gave me the following error:

Display Chart
Reason: Report descriptor not found for:
workitems.OpenWorkItemsByType
Report descriptor not found for: workitems.OpenWorkItemsByType

Interesting, it looks like you're missing one or more reports. Can you
open the rich client, open the Team Artifacts view, expand the project
area that you're working with, and expand Report Templates? Look for
"Open Work Items by Type" - if it's there, select Properties on it and
see if an ID is specified (it should be "workitems.OpenWorkItemsByType").

james