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]
master.sys.databases AS dtb
([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?
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.