MDW Disk Usage for Database Report Error – A data source has not been supplied for the data source D

Hello,

On the MDW Disk Usage Collection Set report, I get the following error when I click on a database hyperlink.

A data source has not been supplied for the data source DS_TraceEvents

SQL profiler shows the following SQL statements are executed (I’ve replaced the database name with databaseX)

1. exec sp_executesql N’SELECT
dtb.name AS [Name]
FROM
master.sys.databases AS dtb
WHERE
([email protected]_msparam_0)’,N’@_msparam_0 nvarchar(4000)’,@_msparam_0=N’databaseX’

this returns zero rows as databaseX does not exist on my MDW central server, but is a database on a target server (i.e. one that is being monitored and uploaded into the MDW central server).

2. USE [datatbaseX]

this produces the following error:

Msg 911, Level 16, State 1, Line 1
Database ‘databaseX’ does not exist. Make sure that the name is entered correctly.

why is the report looking for the database on my server?

thanks

Jag

Environment: MDW (Management Data Warehouse) on SQL 2008 R2

 

This definitely seems like a bug.If you click  on the msdb database  it shows  the data  and log file sizes for my server, not the msdb stats uploaded  from the target  server.This is totally un-helpful!/

Hi Jag, Based on my test, while this database  is offline, we will encounter this issue. This is because that while we click  the certain database in “Disk Usage Collection

Hello,The database  doesn’t exist  on my MDW central  server, it is one of the databases  from a target server  that is being monitored. The data  collector on the target  server uploads the data into some tables on my MDW database.Shouldn’t clicking the database read from these MDW tables instead of looking for the database on my server?thanksJagBTW – Thank you for your time.