-
Title
Enterprise reports in Spotlight 11.7.1 giving error "A data source instance has not been supplied for the data source Enterprise" -
Description
All of the Enterprise reports (e.g. Enterprise SQL Server Inventory) in 11.7.1 are throwing the following error:
"A data source instance has not been supplied for the data source Enterprise..."
-
Resolution
All of the Enterprise reports (like Enterprise SQL Server Inventory report) should have been deprecated after 11.7.0 and replaced with the SQL Server reports. For example the Enterprise SQL Server Inventory should become SQL Server Inventory Report in 11.7.1.
Please use the SQL Server reports. Below is the list of deprecated reports and its equivalent replacement:
Deadlock List.rdl => Deadlock List Report.rdlEnterprise SQL Server Connection Report.rdl => SQL Server Connection Report.rdlEnterprise SQL Server Database Space.rdl => SQL Server Database Space Report.rdlEnterprise SQL Server Inventory.rdl => SQL Server Inventory Report.rdlEnterprise SQL Server Job Report.rdl => SQL Server Job Report.rdlEnterprise SQL Server Performance Summary.rdl => SQL Server Performance Summary Report.rdlEnterprise Windows Disk Space.rdl => Windows Disk Space Report.rdlEnterprise Windows Inventory.rdl => Windows Inventory Report.rdlEnterprise Windows Performance Summary.rdl => Windows Performance Summary Report.rdlEnterprise Windows Virtualization Summary.rdl => Windows Virtualization Summary Report.rdlSQL Server Transaction Daily Range Summary.rdl => SQL Server Transaction Daily Range Summary Report.rdlSQL Server Transaction Monthly Summary.rdl => SQL Server Transaction Monthly Summary Report.rdlServer Alarm Report.rdl => Server Alarms by Time Report.rdlSQL Analysis Workload => No equivalent because the entire SQL Analysis feature has been deprecatedThe depreciated Enterprise reports should have been removed after upgrade. If that is not the case, they can be removed from the following path and you will need to restart the Diagnostic Server after removing them.
C:\Program Files (x86)\Dell\Spotlight on SQL Server\Plug-ins\Trending\Reports
Or you can uninstall the Spotlight 11.7.1 client and delete "C:\Program Files (x86)\Dell\Spotlight on SQL Server" before re-installing the Spotlight 11.7.1 client.