Reporting Tab - "No data available for this period"

[Michael Drawbridge]

All.

I have an issue with DPM 2006 (not servicepacked yet). It has just started
without any changes that I can pinpoint. When trying to view the Disk
Utilization or Shadow Copy reports for last month (or this month for that
matter) it says "no data available for this period'. The other reports work
fine.
I have created some sql code below to produce the data I was after at the
time - and it generates results that look very realistic and, more
importantly, up to date.

--summarised data
select max(enddatetime) as 'Sample Date',
max(diskspacecapacity)/1073741824 as 'Total Disk Capacity (GB)',
max(diskspaceallocated)/1073741824 as 'Disk Allocated (GB)',
max(diskspaceallocated)*100/max(diskspacecapacity) as '% Allocated',
max(diskspaceused)/1073741824 as 'Disk Space Used (GB)',
max(diskspaceused)*100/max(diskspaceallocated) as '% Used'
from tbl_sm_statistics s inner join
tbl_sm_total_disk_trend tdt on tdt.smstatsid = s.smstatsid
group by year(enddatetime), month(enddatetime)
order by max(enddatetime) desc

Anyone come across this and/or know the solution???

Thanks,
Mike

[Kapil Malhotra [MSFT]]

Michael,

Can you take a SQL backup of the DPM DB database and send it over for us to
look at? The DB will be of reasonable size so I request you to send me mail
on Kapil dot Malhotra AT microsoft dot com, so that I can create an FTP
share for you.

A few questions on the issue:
- Does the entire report say 'No data' or is the problem specific
to any specific graph (latest disk usage or graph used to show historical
info)

- Does it only come for Monthly report or for weekly/yearly reports
as well ?

- What is the number of PGs created and if you deleted any PG
recently ?

--
Thanks,

Kapil
This posting is provided "AS IS" with no warranties, and confers no rights.

"Michael Drawbridge" <MichaelD...@discussions.microsoft.com> wrote in
message news:BE3025D4-3701-4A4F...@microsoft.com...

[Michael Drawbridge]

Hi Kapil

Many thanks for your reply. I will answer your questions here for the
benefit of any other readers, but will email you afterwards to setup an ftp
share for the DB upload.

> Does the entire report say 'No data' or is the problem specific
> to any specific graph (latest disk usage or graph used to show historical
> info)

The answer below ties into this. I cannot even run montly reports for 'this
month' or 'last 1 month'. The interface where you select date range and
grouping just says 'no data available for this period' and wont let me
proceed. if I select a larger date range, say last 3 months, then the report
runs, but I would only have data for the third month back, not the most
recent 2.

> Does it only come for Monthly report or for weekly/yearly reports
> as well ?

I didn't think to try this. The monthly and yearly ones don't work
properly, but the weekly ones do. 4 weeks ago we added another 1TB raid
volume to the storage pool (99% sure it was already not working before we did
this) - but if I do a report for say the last 2 years, the '2007' graphs do
not reflect the additional storage capacity, so it is evidently not using the
most recent data the weekly reports are using. The weekly graphs do show
this change as expectected and contain data right to the current day. I made
an error when I said it was limited to disk utilization and shadow copy
reports - the same problem applies to all report options when using the
'monthly' setting. So maybe it is a problem with monthly-summarised data for
all reporting areas?

> What is the number of PGs created and if you deleted any PG
> recently ?

We have 8 protection groups and this hasn't changed since implementation

Thanks,
Michael