.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

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

Posted By:      Posted Date: August 28, 2010    Points: 0   Category :Sql Server
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 (dtb.name=@_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  

View Complete Post

More Related Resource Links

The report cannot be opened because the data source associated with it is not a report model.


i tried to open a report i created in sql business intelligence development studio in the report builder in wss3 and it gave me this error:

Microsoft.ReportingServices.ReportBuilder.ReportModel.Report: The report 'http://servername:port#/Reports/report.rdl' cannot be opened because the data source 'http://servername:port#/DataSource Library/datasource.rsds' associated with it is not a report model.

This report was not created in Report Builder. Try opening this report in Report Designer instead.

can i fix this so i can open my reports in report builder?


Data Source View Gives incorrect Error--Different Data Type

Hi, I'm creating a report model (2008 R2).  I am trying to create a relationship between two tables.  One FKs to another--same name and type (tinyint) columns.  But the Data Source View editor doesn't allow this, giving the message "...source and destination column have different data types".  But the columns are the same types.  I ahd this once before  acouple of years ago and don't remember how I got around it. Does anyong have ideas?  

Excel Data Source SSIS AcquireConnection failed 0x80004005 unspecified error

Nuances of using Excel data sources with SSIS Your Development Machine Setup Needs Jet Drivers, available along with the default Office install so if you have Excel working fine locally, this is enough. Installing the "Office Data Connectivity Components" (download file name AccessDatabaseEngine.exe) as well as having Office installed corrupts the Jet Driver stack so that SSIS in VS 2008 cannot create the object to read the XLS file. You will see the title error "Unspecified Error" and "80004005" code. Resolution: Uninstall the Jet Engine pack on your development XP machine if you have Office. It will be listed as something like "Microsoft Access Database Engine (2010)". Run Office 200x setup with the Repair option and reboot. Try configuring the task in SSIS and it should be able to read the Sheet names again and columns.  Live Server (32-bit and 64-bit) Deploying your SSIS package to a server without Office 200x means it will not have the Jet Engine drivers to read XLS, XLSX files. You must install the 32-bit Office Data Connectivity Components - Jet Drivers mentioned above found here  (http://www.microsoft.com/downloads/details.aspx?familyid=7554f536-8c28-4598-9b72-ef94e038c891&displaylang=en). There are no 64-bit drivers; therefore regardless of 32 or 64-bit live environments, this step is the same. You shoul

I need to create a script in SSIS which creates a data source that connects to an Access database.

I need to create a script in SSIS which creates a data source that connects to an Access database. The Access database file name needs to be set as a variable as it will change from month to month. I have no idea what I am doing can anybody give me some tips? Mr Shaw

SSIS 2005 - XML Source no data loading to sql server database destination

Hello I am trying to load data from xml source to sql server destination, but the task executes with no data loaded to destination. i really appreciate any guidance in working and troubleshooting xml sources. Regards Harris

Sharepoint list as Report Data Source

My current environment is Sharepoint 2007 with SSRS 2008 in Sharepoint Integrated Mode. SSRS 2008 uses trusted authentication to communicate to Sharepoint 2007. Sharepoint 2007 is configured to use NTLM authentication (configured with a domain account). My settings within Central Admin are Authentication Type: Windows IIS authentication settings: Integrated windows authentication with NTLM. My question is: Do I need to configure Sharepoint to use kerberos to use Sharepoint Lists as a Report Data Source?  

Setting Local Report Data Source

I am a college professor and am updating my undergraduate database course to use Reporting Services as the reporting tool.  The student labs cannot run IIS so I assume that using server-based reports is out and am looking at using local reports and the VB ReportViewer control. For several reasons (waaayyy too long to list here) I do not wish to use the drag-and-drop datasets that seem to be the core of the ADO.Net 2005 architecture.  Instead I prefer to create connections, commands, and datasets in code and to set data binding and manage data updates in code.  All command objects map to SQL Server stored procedures. I need to be able to do the same thing with reporting services local reports but have run into a brick wall in getting the report and/or report viewer to recognize a dataset table created in code. I would like to do the following (which worked very well in VB 2003 using Crystal Reports): 1. Design report--I am willing to accept the requirement to manually set the Value property of controls since I don't want to set data sources to .xsd files. 2. Instantiate a report object at run time and set it's data source to a dataset table.  The underlying query that fills the table would have to contain all columns needed by the report's controls. 3. Set the report object to be the LocalReport for a ReportViewer control. Can anyone point me to a tutorial or walk-through tha

A data source instance has not been supplied for the data source 'DataSet_ApplicationCV'


i have an webapplication and i have 2 reports first report give me list with all application i have in my database table when i click on one id of this list it shuld rediract me to the second report that take 2 parameter from first report

inside the first report i set the navigation and send parameter value

when i run my page that have first report it is ok run but when i click on the any id to go to next report that have detailes it give me this error

  • A data source instance has not been supplied for the data source 'DataSet_ApplicationCV'
  • i understand that  the datasource for second report not set in report viewer but how can i set both dataset and wht if i have subreports inside the second report

    code for report viewer:

    <%@ Page Title="" Language="C#" MasterPageFile="~/Site1.Master" AutoEventWireup="true" CodeBehind="ApplicationReport.aspx.cs" Inherits="Webis.admin.ApplicationReport" %>
    <%@ Register Assembly="Microsoft.ReportViewer.WebForms, Version=, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"
        Namespace="Microsoft.Reporting.WebForms" TagPrefix="rsweb" %>
    <asp:Content ID="Cont

    Using CROSS APPLY in a data source query causes ARITHABORT error


    I have an issue where the following query as an OLEDB data source throws the following error:

    SELECT XmlNode.value('SomeValue[1]', 'varchar(10)') as SomeValue

    FROM (SELECT CAST('<TestXML><SomeValue>123</SomeValue></TestXML>' AS XML

    SQL Server 2008 R2 Disk Usage report showing incorrect data file


    When I go to ANY database (System, AdventureWorks*, user) in Managemant Studio, I right-click on the db, select Reports, select Standard Reports, and select Disk Usage.  The disk usage report shows the correct db on top, but always only shows AdventureWorks_Data.mdf when I expand Disk Space Used by Data Files section.  This happens to any db I try.  When I look at Database Properties/Files for that database, the logical and physical file names are correct.

    Since the correct files appear in Database Properties/Files, I'm hoping it's just a bug in the report.  Same thing happens if I run a Disk Usage by Table report for ANY database,  The tables for AdventureWorks always only appear,

    Thanks,  Mike

    Status of Accessing Nested Objects in Data Source of Local Report Does Not Function


    We recently upgraded out platform to .NET 4.  We are also using Microsoft Reporting dlls.  Unfortunately, we found that the upgrade broke all of our reports.  Researching the cause, we found this article:


    It seems that this issue has been open for some time now and I have not seen a good workaround (except for the shim class which is not really feasible for us).  Can I please get a status update for this?  Is there some other type of resolution?

    Thank you,

    Benjamin Strum 

    Ben Strum

    SSIS: Error in the package when the data in the flat file source is modified


    Hi All,

    I have a package which loads data from a flat file source to an OLEDB destination, which is executed successfully and data is loaded perfectly.

    But later when the data in the flat file source is modified i.e. if an extra column gets added to the text file, the package is throwing an error because it is unable to detect the extra added column.

    How can i avoid this error??? I need my package to execute successfully ignoring the changes(added columns) happened in the flat file source.

    Please provide me wth your suggestions and solutions....

    Thanks in Advance!!

    error when testing query during configuring sql data source for gridview


    I got the following error message:

    There was an error executing the query. Please check the syntax of hte the command and if present, the types and values of the parameters and ensure they are correct.  Failed to enable constraints.  One or more rows contain values violating non-null, unique, or foreign-key constraints.

    But when I run the query through Management Studio, I can get the result. 

    There are no parameters for this query either. 

    Can anybody give me a glue what to check?


    How can you debug a report data source that is an XML web service?


    I have a report that is using an XML web service as it's datasource.  I would like to know what parameter 

    values the report is passing to the web service. 

    I tried the following debugging process but it did not work.

    1.  Set the Reporting Services Project as the Starting Project.

    2.  Set the report as the startitem in the project's startitem property.

    3.  Set a breakpoint in the web service.

    4.  I started the debugging which opened the report.  I put in a parameter value and ran the report.

    But the debugger did not stop at the breakpoint.  What am I doing wrong?

    How can I know what parameter values are being passed to the web service?





    Unit Testing Error - The unit test adapter failed to connect to the data source or to read the data


    I'm using VSTS 2K8 and I've set up a Unit Test Project. In it, I have a test class with a method that does a simple assertion. I'm using an Excel 2007 spreadsheet as my data source.

    My test method looks like this:

    "Dsn=Excel Files;dbq=|DataDirectory|\\MyTestData.xlsx;defaultdir=C:\\TestData;driverid=1046;maxbuffersize=2048;pagetimeout=5",
    public void State_Value_Is_Set()

    Copy and modify Data Source crashes SPD 2010 - List Threshold error


    When I try to copy and modify a data source, I get a server error that the operation is prohibited because it exceeds the list view threshold, but I only have 10 items in my list, well below the default threshold.  I get the same error if I try to create a new page from master.  Anybody run across this one?

    Confirmed the threshold with my administrator and even upped it to 10,000 but that did not help.

    XML web service showing error in Data Source Library when I clicked on "Show Data".


    Hi ,

    I am working on share point 2007.
    I have added a XML Web service in Data source in Share Point designer 2007. This web service is custom web service which get data from 3 different type of list and creates XML and return that xml.

    I have installed this web service as instructed in msdn. I checked it is working properly.
    First time when I create a data source from XML web service in Share Point Designer 2007, It shows all records when I clicked on “Show Data ”. But after a few minutes it shows en error” The server returned a non-specific error when trying to get data from the data source. Check the format and content of your query and try again. If the problem persists, contact the server administrator. ”.

    Gaurav Goyal
    ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
    Sql Server  SharePoint  Silverlight  Others  All   

    Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend