One TFs error occurs (the error message returned when the row of the item set 'iterationparam' is missing)

From: http://huanlin.dyndns.org/cs/blogs/huan-lins_blog/archive/2006/06/12/330.aspx
During the processing period of the processing table, a processing interval occurs. (Rsprocessingaborted) Get the statement
The error message returned when the query result of the item set 'iterationparam' is invalid. (Rserrorexecutingcommand)
The team system cube does not exist or has not been processed.

In normal cases, this region should have a two-dimensional table to show the remaining jobs.

I used the keyword "" to ask Google to find two useful comment strings:

1. Warehouse troubleshooting guide
2. Warehouse cube won't process-b3refresh upgraded OK

I will explain the problem one by one according to the first article. However, the SQL commands in step 2 are correct. The following are the SQL commands I corrected:

Use cipher setting as [last cube processing] From _ warehouseconfig where id = 'authorization' -- total revisions in the relational warehouseuse tfswarehouseselect top 1 _ lastupdatedtime as [lastvcwhwrite] From DBO. [Code church N] With (nolock) order by _ lastupdatedtime descselect top 1 _ lastupdatedtime as [lastwitwhwrite] From DBO. [work item history] With (nolock) order by _ lastupdatedtime descuse tfswarehouseselect count (*) as [Wh revisions] from [DBO]. [work item history] With (nolock) Where [record count] <>-1use tfsworkitemtrackingselect count (*) as [wit revisions] from [DBO]. [workitemslatestandwere] With (nolock) Use tfswarehouseselect max ([Changeset id]) as [Wh Changeset] from [DBO]. changeset with (nolock) Where _ dimensionmemberactive = 1use tfsversioncontrolselect max (changesetid) as [VC Changeset] From tbl_changeset with (nolock) -- identitiesuse tfswarehouseselect property_value as [warehouse identity id] From _ propertybagwhere property_key = 'css identity sequence ID 'Use tfsintegrationselect max (sequence_id) as [integration identity id] From repository -- structureuse tfswarehouseselect property_value as [warehouse structure id] From _ propertybagwhere property_key = 'css structure sequence id' use tfsintegrationselect max (sequence_id) as [integration structure id] From tbl_nodes with (nolock)

At step 3, tfswarehouse was found to have no information, so it jumped to gathering error data. According to the gathering Error Data step, I downloaded the debugview tool of sysinternals to check that there are a lot of such errors:

The mdxscript (team system) (66, 1) end Scope statement does not conform to the start Scope statement.
The mdxscript (team system) (68, 46) '[STR]' function does not exist.

Go to Google to search again, and find the second comment. In accordance with the steps above, divide the cube, and the problem is completely solved!

Then, the command and result of step 2 in the second comment string are stored as fix_tfs.bat, then, you can merge this batch of shards:

C:
CD \ Program Files \ Microsoft Visual Studio 2005 team Foundation Server \ tools
Setupwarehouse-rebuild-mturl http: // localhost: 8080-C warehouseschema. XML-s localhost-D tfswarehouse-A vsts \ tfsservice-ra vsts \ tfsreports

(Token: My host name token is vsts)

The result of the rows:
Setupwarehouse: zookeeper is successfully updated.

After that, repeat step 3 of the first comment string in the record until the running arguments of the warehouse are changed from running adapters to idle. Then, the website will be connected to the team website, and the "remaining work" notice under the first line should be properly displayed.