Subquery returned more than 1 value.

Question

Users ([Project]\Contributors) can not add/edit/view WorkItems.

Detailed Message: Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.
Exception Message: Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression. (type SqlException)
SQL Exception Class: 16
SQL Exception Number: 512
SQL Exception Procedure: LookupRule
SQL Exception Line Number: 225
SQL Exception Server: TFSSERVER
SQL Exception State: 1
SQL Error(s):

Exception Data Dictionary:
HelpLink.ProdName = Microsoft SQL Server
HelpLink.ProdVer = 09.00.3042
HelpLink.EvtSrc = MSSQLServer
HelpLink.EvtID = 512
HelpLink.BaseHelpUrl = http://go.microsoft.com/fwlink
HelpLink.LinkId = 20476


Exception Stack Trace:    at Microsoft.TeamFoundation.WorkItemTracking.Server.SqlAccess.HandleDalError(Exception e)
   at Microsoft.TeamFoundation.WorkItemTracking.Server.SqlAccess.ExecuteBatchPayloadImpl(IRequestContext context, String sqlBatch, List`1 parameterList, Boolean& errorOnBulkUpdate, String connectionString)
   at Microsoft.TeamFoundation.WorkItemTracking.Server.AdoDbBase.ExecuteBatchQuery(IRequestContext context, String sqlBatch, List`1 parameterList)
   at Microsoft.TeamFoundation.WorkItemTracking.Server.SqlBatchBuilder.ExecuteBatchInternal(IRequestContext context, Boolean passInConnectionInfo, String server, String database)
   at Microsoft.TeamFoundation.WorkItemTracking.Server.DataAccessLayerImpl.UpdateImpl(String serverName, String databaseName, String attachmentServer, String attachmentDatabase, XmlElement updateElement, MetadataTable[] tablesRequested, Int64[] rowVersions, Payload metadataPayload, Boolean bisNotification, String& dbStamp, Boolean bulkUpdate, Boolean& bulkUpdateSuccess, String userSid)
   at Microsoft.TeamFoundation.WorkItemTracking.Server.DataAccessLayerImpl.Update(String serverName, String databaseName, String attachmentServer, String attachmentDatabase, XmlElement updateElement, MetadataTable[] tablesRequested, Int64[] rowVersions, Payload metadataPayload, Boolean bisNotification, String& dbStamp, String userSid)
   at Microsoft.TeamFoundation.WorkItemTracking.Server.ProcessSecurityEventMessage.ExecuteBatch(String updateXml)
   at Microsoft.TeamFoundation.WorkItemTracking.Server.ProcessSecurityEventMessage.Process()
   at Microsoft.TeamFoundation.WorkItemTracking.Server.SecurityEventMessage.Process()
   at Microsoft.TeamFoundation.WorkItemTracking.Server.EventMessageHandler.ProcessSecurity(Int32 seqId)
   at Microsoft.TeamFoundation.WorkItemTracking.Server.EventMessageHandler.ProcessSecurityEvent()

Answer 1

Which version of Team Foundation Server are you using?

 

Answer 2

TFS 2008

Answer 3

What does this SQL query return?

 

select addeddate, removeddate, sid, domainpart, namepart, displaypart

from TfsWorkItemTracking.dbo.Constants

where [SID] IN

(

select [SID]

from TfsWorkItemTracking.dbo.Constants

where [SID] IS NOT NULL

group by [SID]

having count(*) > 1

)

order by AddedDate asc

 

If you consider this sensitve information, please contact me via email.

 

Answer 4

addeddate               removeddate             sid                                                domainpart   namepart   displaypart
----------------------- ----------------------- -------------------------------------------------- ------------ ---------- -----------
2007-12-21 18:24:16.870 2008-04-08 14:00:00.810 S-1-5-21-1363088145-1207452480-XXXXXXXXXX-YYYY     DOM1         user1     User 1
2008-04-10 06:35:09.263 2008-04-14 07:15:59.197 S-1-5-21-3007044144-2014576845-ZZZZZZZZZZ-QQQQ     DOM2         user2     User 2
2008-04-11 09:45:29.403 2008-04-14 07:15:59.773 S-1-5-21-1363088145-1207452480-XXXXXXXXXX-YYYY     DOM2         user1     User 1
2008-04-14 08:41:12.050 2008-04-15 10:53:41.353 S-1-5-21-3007044144-2014576845-ZZZZZZZZZZ-QQQQ     DOM2         user2     user2