Jul 18, 2011 at 9:44 AM
Edited Jul 18, 2011 at 10:10 AM
I am getting error 'The database doesn't have necessary data to run the report' while running Blocking and Wait Statistics/Bottleneck Analysis Reports. I also folled the below solution but still the error is coming. Please tell me where i am missing. I checked
the collation in database.
When I tried to run these 2 reports I get an error that 'The database doesn't have necessary data to run the report'. I later discovered that this is due to the fact that the collation set of the server I loaded the sqldiag data
on was case sensitive. When I loaded this data onto a server where the server collation set was case insensitive, these reports started working flawlessly.
I also tried the below Sol but the tables below are missing in the database
tbl_Requests tbl_blocking_chains tbl_notableActiveQueries
Unable to view the Blocking and Wait Statistics OR Bottleneck Analysis reports or getting the error “Database doesn't have the necessary data to run this report”.
The data for the above report is based on the SQL Server 2005/2008 Perf Stats script output depending on the version of the SQL instance that you are collecting data from. The file that normally has the data for the above reports to be generated
will have the following naming convention: <ServerName>__SQL_2005_Perf_Stats_Startup.OUT or
<ServerName>__SQL_2008_Perf_Stats_Startup.OUT. Ensure that this file has collected at least two snapshots of the outputs of the T-SQL queries present in the SQL Server 2005/2008 PerfStats script. The check that is done to report this error is
to check if data is present in the following tables in the Nexus database: