Query execution failed for data set 'WorkItemTypeParam'

Question

I have just finised performing a restoration-based move of a TFS 2008 machine to a new machine (new hardware and new name). For this process I used the following documentation:

 

http://msdn2.microsoft.com/en-us/library/ms404869.aspx

 

Everything went fine but now when I try to run a report like "Bugs found without corresponding tests"  I get the following error message:

 

An error has occurred during report processing. (rsProcessingAborted) Get Online Help
Query execution failed for data set 'WorkItemTypeParam'. (rsErrorExecutingCommand) Get Online Help
Query (19, 3) The ALLMEMBERS function expects a hierarchy expression for the argument. A member expression was used.

 

There are no entries in the Event log.

 

For some reports like the "Exit Criteria" I get:

 

An error has occurred during report processing.
Query execution failed for data set 'dsCurrentWorkItem'.
Query (4, 9) The member '[Work Item Url]' was not found in the cube when the string, [Measures].[Work Item Url], was parsed

 

Several reports like the "Quality Indicators" do work so I don't get these errors with all the reports.

 

Any ideas on how to fix this?

 

Answer 1

I apologize for bumping this thread but we are really stuck here. So ideas on where to look?

 

Answer 2

 

Are there any errors in the event log?  It looks like cube processing might not have worked.

Answer 3

 

Gabriel,

 

How did you accomplish your HW based move within TFS?

 

I have worked with downed TFS old servers and I have faced the problem with renamedt command.

It is a big issue on TFS 2008 (I know there is no such an issue on TFS 2005).

 

In regard to your problem, please run the following statement on the TFSIntegration Database and check if this returns a URL like this http://<OldServer>/ReportServer/ReportService.asmx

exec dbo.prc_get_service_interface

@registry_entry_type=N'Reports',@service_interface_name=N'ReportsService'

 

Et voila, I could suppose What does it mean.

 

Regards,

Dragan

 

Answer 4

Hello. Well it has been a while ago but the problem I had was that on the new machine I had to modify the web.config files so that the old name of the TFS was there instead of the new name. Because i had the new name in the configs the rename operation was not successful.

 

Answer 5

 

This is well known bug in msdn documentation you mentioned (There is your comment on msdn)

 

But, you didn't face with the same problem as I did, because your old TFS maschine was probably started.

Imagine, what is happens in case of some kind of disater (your old TFS could be stolen, burned or system crashed). You couldn’t recover your TFS based on msdn document ( http://msdn2.microsoft.com/en-us/library/ms404869.aspx )

 

Rgds,

Dragan

 

Answer 6

Dragan Jankovic wrote:

This is well known bug in msdn documentation you mentioned (There is your comment on msdn)   But, you didn't face with the same problem as I did, because your old TFS maschine was probably started. Imagine, what is happens in case of some kind of disater (your old TFS could be stolen, burned or system crashed). You couldn’t recover your TFS based on msdn document ( http://msdn2.microsoft.com/en-us/library/ms404869.aspx )   Rgds, Dragan

 

Hello Dragan

 

It should work because in our situation the old machine was shutdown during the restoration based move. You need to change the connection strings in the config because the rename utility will perform a string-based search.

 

Regards

 

Gabriel

Answer 7

Hi,

 

I am also getting the same error.

 

An error has occurred during report processing. (rsProcessingAborted)

Query execution failed for dataset 'WorkItemTypeParam'. (rsErrorExecutingCommand)