I can't run "Work Items" queries.

Hi all,

I'm having problems running queries under "Work Items" like "Active Bugs".
I am able to run any of the "Reports", access the "Documents" and the "Team Builds" items.
My setup is a bit unusual, because of beta issues I had to create a new domain and install the team system server as a domain controller in that new domain. I then trusted the new domain in my current domain and vice versa. My DNS servers handle both domain properly and everything seems to work fine.
When I perform a network trace when trying to run the "Active Bugs" work item for example I get the following:

-
POST /Currituck/ClientService.asmx HTTP/1.1

User-Agent: Mozilla/4.0 (compatible; MSIE 6.0; MS Web Services Client Protocol 2.0.50215.44)

Content-Type: application/soap+xml; charset=utf-8; action="http://schemas.microsoft.com/Currituck/2004/09/mtservices/clientservice/Query"

Host: teamsystem:8080

Content-Length: 2359

Expect: 100-continue

Accept-Encoding: gzip

HTTP/1.1 100 Continue

<?xml version="1.0" encoding="utf-8"?><soap:Envelope xmlns:soap="http://www.w3.org/2003/05/soap-envelope" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema"><soap:Header><RequestHeader xmlns="uuid:1e562bab-ac4a-4668-a619-7fab7db4d7a4http://schemas.microsoft.com/Currituck/2004/09/mtservices/clientservice"><Id>uuid:1e562bab-ac4a-4668-a619-7fab7db4d7a4</Id></RequestHeader></soap:Header><soap:Body><Query xmlns="http://schemas.microsoft.com/Currituck/2004/09/mtservices/clientservice"><psQuery><Query Product="http://TEAMSYSTEM:8080/Currituck/ClientService.asmx" xmlns=""><Group GroupOperator="And"><Expression Column="AreaID" FieldType="288" Operator="under"><Number>1</Number></Expression><Expression Column="Work Item Type" FieldType="16" Operator="equals"><String>Scenario</String></Expression></Group></Query></psQuery><sort><QuerySortOrderEntry><ColumnName>Rank</ColumnName><Ascending>true</Ascending></QuerySortOrderEntry><QuerySortOrderEntry><ColumnName>State</ColumnName><Ascending>true</Ascending></QuerySortOrderEntry><QuerySortOrderEntry><ColumnName>ID</ColumnName><Ascending>true</Ascending></QuerySortOrderEntry></sort><useMaster>false</useMaster><metadataHave><MetadataTableHaveEntry><TableName>Hierarchy</TableName><RowVersion>39996</RowVersion></MetadataTableHaveEntry><MetadataTableHaveEntry><TableName>Fields</TableName><RowVersion>5601</RowVersion></MetadataTableHaveEntry><MetadataTableHaveEntry><TableName>HierarchyProperties</TableName><RowVersion>39260</RowVersion></MetadataTableHaveEntry><MetadataTableHaveEntry><TableName>Constants</TableName><RowVersion>40169</RowVersion></MetadataTableHaveEntry><MetadataTableHaveEntry><TableName>Rules</TableName><RowVersion>40172</RowVersion></MetadataTableHaveEntry><MetadataTableHaveEntry><TableName>ConstantSets</TableName><RowVersion>40179</RowVersion></MetadataTableHaveEntry><MetadataTableHaveEntry><TableName>FieldUsages</TableName><RowVersion>5193</RowVersion></MetadataTableHaveEntry><MetadataTableHaveEntry><TableName>WorkItemTypes</TableName><RowVersion>39266</RowVersion></MetadataTableHaveEntry><MetadataTableHaveEntry><TableName>WorkItemTypeUsages</TableName><RowVersion>39342</RowVersion></MetadataTableHaveEntry><MetadataTableHaveEntry><TableName>Actions</TableName><RowVersion>38693</RowVersion></MetadataTableHaveEntry></metadataHave></Query></soap:Body></soap:Envelope>HTTP/1.1 500 Internal Server Error

Date: Thu, 21 Jul 2005 21:20:12 GMT

Server: Microsoft-IIS/6.0

X-Powered-By: ASP.NET

X-AspNet-Version: 2.0.50215

Cache-Control: private

Content-Type: application/soap+xml; charset=utf-8

Content-Length: 860

<?xml version="1.0" encoding="utf-8"?><soap:Envelope xmlns:soap="http://www.w3.org/2003/05/soap-envelope" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="soap:Senderhttp://www.w3.org/2001/XMLSchema"><soap:Body><soap:Fault><soap:Code><soap:Value>soap:Sender</soap:Value><soap:Subcode><soap:Value xmlns:q0="q0:Applicationhttp://schemas.microsoft.com/Currituck/2004/01/mtservices/faultcodes">q0:Application</soap:Value></soap:Subcode></soap:Code><soap:Reason><soap:Text xml:lang="en">Invalid object name 'dbo.xxRLQ_WorkItem_pyt'. &gt; Invalid object name 'dbo.xxRLQ_WorkItem_pyt'. &gt; Invalid object name 'dbo.xxRLQ_WorkItem_pyt'.</soap:Text></soap:Reason><soap:Node>/Currituck/ClientService.asmx</soap:Node><detail><details id="208" xmlns="http://schemas.microsoft.com/Currituck/2004/01/mtservices/faultdetail" /></detail></soap:Fault></soap:Body></soap:Envelope>
-

Note that I get a "Error Could not connect to application tier. Please contact the team system administrator(s)." in VS.net.

Any ideas?

Thanks

[7069 byte] By [Pierre-YvesTroel] at [2007-12-16]