The data source connection information has been deleted.

Question

I was trying to fix my TFS sharepoint search capability and have now messed up my reporting services.  Sharepoint works like a champ but I can't run any preexisting TFS reports, like Remaing Work.  I get this error: "

Answer 1

Hi topoli

 

I got 2 questions:

1. Do you see this error message for every reports or just one report?
2. Have you changed account for the application pools used by reporting service and team foundation server?

Answer 2

1. I see this error for all the errors.

2. Yes, I changed all the accounts to tfsservice in the application pool to be consistent, But found out this was a mistake ...

Thanx,

Answer 3

topoli

 

To change account used by TFS web services and Reporting Service, you can use TFSAdminUtil.exe. This command can assign the required permission to the new service account.  Please try this command with ChangeAccount switch to change to the new service account. After this, you can run this command with ActivateAt switch to start TFS web services.

Answer 4

Hello topoli,

 

  In addition to Bill's,

 

    Please check the shared data source at the Report Service Site.

 

  Here are brief steps,

 

          1. Open the http://<ReportServer>/Reports

 

          2. Please check if there are two shared data sources

 

                    a. TfsReportDS

                    b. TfsOlapReportDS

 

                  More in  Data Sources for Team Foundation Reporting

 

           3. If there is no such data sources, try to create them

 

                   a. Click 'New data sources' button.

                  

           4. Here are some properties of the TfsReportDS and TfsOlapReportDS data source

 

 

                  TfsReportDS :

                          Connection string : Data source=<Data-Tier Name>;initial catalog=TfsWarehouse

                          Connection type: Microsoft SQL Sever.

 

                  TfsOlapReportDS :

 

                          Connection string : Data source=<Data-Tier Name>;initial catalog=TfsWarehouse

                          Connection type: Microsoft SQL Server Analysis Services.

           

                   Please make sure Connect using : the  Credentials stored securely in the report server setting.

 

                   And the credential is the TFSREPORTS account used during the TFS Setup.

 

           If you have any question please let me know.

 

          Good luck.

 

Answer 5

Thank you for your help.  Here is what I did:

• Tried to bring up a report and it gave me this error:\
  • The report server cannot process the report. The data source connection information has been deleted. (rsInvalidDataSourceReference)
• I then, went into Properties -> DataSource
• And saw this next to the Shared DataSource: The shared data source reference is no longer valid
• I then browsed and selected TfsReportDS and TfsOlapReportDS at the root
• And the reports work.
• I did this for all my reports and everything is back to normal
• But I am not sure why ? and if changing of the users in one of the IIS application pool is going to haunt me in the future ... Eventhough things look to be normal now

 

Thanx.

 

Answer 6

In case you have the message "The shared data source reference is no longer valid"
you can use the script below to recreate the data source reference. Success

DECLARE
  @Link uniqueidentifier

SELECT @Link = ItemID FROM dbo.Catalog
 WHERE Type = 6 -- Select the correct Datasource

BEGIN TRAN

  UPDATE dbo.DataSource
  SET Link = @Link
  WHERE ItemID IN
    (SELECT c.ItemID FROM dbo.Catalog c
     INNER JOIN dbo.DataSource ds ON ds.ItemID = c.ItemID
  WHERE c.type = 2 -- reports
  AND   ds.link is null
    )

COMMIT TRAN