Submit My Question - Recent Questions - Recent Answer

Msdn Tech >> Visual Studio Team System >> Team Foundation Server - General

Areas and Iterations defined for project not listed in work item drop downs

1) July CTP of TFS
2) I've read through the existing threads regarding onchange latency and 10 minute cache refreshing
3) I've waited over-night and shutdown and restarted TFS Explorer
4) I am a TFS Administator on this server

In light of the above, I've added additional areas at the first child level and also added iterations (2 at first child, with another as a child of a child). I can see the areas and iterations I've added in the Areas/Iterations of the project (right-click, etc...). However, I don't see that these are even being inserted into the database -all I see in the TreeNodes table are the original areas and iterations.

Am I missing the purpose of the Areas/Iterations definition UI in the IDE? Should it be inserting these, or are these purely local?
Thanks,

Cory

[819 byte] By [CoryDixon] at [2007-12-16]

«« .NET Bug : global variables and xsl:import
»» Urgent help regd reducing the size and backing up of SQL Server Transaction log file

# 1

Additional investigation information:
It appears that it is trying to find a parent that, in the database (Currituck.dbo.TreeNodes), DOES exist, but is the top level node of a project that failed to be created properly (due to security settings). The id of the item in question is "fa504723-757e-4eab-add4-9b6ed0fba43a", which is the ParentId mentioned in the error message below. In TreeNodes the fNewDeleted is true for this row. The Project, in BisDB.dbo.tbl_projects has the same guid as the project_id and a status of "Deleting"

As an fyi, this project failed to be fully created due to improper security between the app tier WSS and the data tier STS_Config. Once that was resolved, I tried to recreate the same project, which inserted into tbl_projects and TreeNodes, etc, but errored out since the project name was the same. I now have 2 projects of the same name with status of "Deleting"

In the event log of the app tier, the following error is repeated when I am editing Areas/Iterations from the Client.

Microsoft.TeamFoundation.WorkItemTracking.Server.ValidationException: SyncBisTree: ParentId does not exist : fa504723-757e-4eab-add4-9b6ed0fba43a,

Transaction count after EXECUTE indicates that a COMMIT or ROLLBACK TRANSACTION statement is missing. Previous count = 1, current count = 0. > System.Data.SqlClient.SqlException: SyncBisTree: ParentId does not exist : fa504723-757e-4eab-add4-9b6ed0fba43a,

Transaction count after EXECUTE indicates that a COMMIT or ROLLBACK TRANSACTION statement is missing. Previous count = 1, current count = 0.

at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)

at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)

at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)

at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)

at System.Data.SqlClient.SqlDataReader.ConsumeMetaData()

at System.Data.SqlClient.SqlDataReader.get_MetaData()

at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)

at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)

at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)

at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)

at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)

at System.Data.SqlClient.SqlCommand.ExecuteReader()

at Microsoft.TeamFoundation.WorkItemTracking.Server.SqlAccess.ExecuteBatchPayload(IRequestContext context, String sqlBatch, ArrayList parameterList, Boolean& errorOnBulkUpdate)

End of inner exception stack trace

at Microsoft.TeamFoundation.WorkItemTracking.Server.SqlAccess.ExecuteBatchPayload(IRequestContext context, String sqlBatch, ArrayList parameterList, Boolean& errorOnBulkUpdate)

at Microsoft.TeamFoundation.WorkItemTracking.Server.SqlBatchBuilder.ExecuteBatchInternal(IRequestContext context)

at Microsoft.TeamFoundation.WorkItemTracking.Server.ProcessStructureEventMessage.ExecuteBatch()

at Microsoft.TeamFoundation.WorkItemTracking.Server.ProcessStructureEventMessage.Process()

at Microsoft.TeamFoundation.WorkItemTracking.Server.StructureEventMessage.Process()

at Microsoft.TeamFoundation.WorkItemTracking.Server.EventMessageQueue.ProcessEventMessage(IEventMessage eventMessage)

at Microsoft.TeamFoundation.WorkItemTracking.Server.EventMessageQueue.Process(Object state)

CoryDixon at 2007-9-9 >

top of Msdn Tech,Visual Studio Team System,Team Foundation Server - General...

# 2

Finally forced a resolution - lots of reversing out db relationships. The root problem was caused by the original project(s) not being fully created. The DeleteTeamProject /force did not clean up or successfully finish - died during Report removal (even with the /force switch).

Areas and Iterations are now replicating to Currituck from BisDB and showing up in the IDE.
In case anyone has a similar problem, caused by the same issue:

In BisDB db (obviously oid_hash and project_name are specific)
-

begin transaction

delete from tbl_security_permission_cache where oid_hash = '317623476'

delete from tbl_security_membership_cache where container in (select sid from tbl_gss_groups inner join tbl_projects on project_uri like '%' + convert(varchar(40), project_id) where project_name like 'Test%')

delete from tbl_security_membership_cache where member in ( select sid from tbl_security_identity_cache where domain in (

select domain from tbl_security_identity_cache

inner join tbl_projects on domain like '%' + convert(varchar(40), project_id)

where project_name like 'Test%'))

delete from tbl_security_ismember_cache where [group] in (select sid from tbl_gss_groups inner join tbl_projects on project_uri like '%' + convert(varchar(40), project_id) where project_name like 'Test%')

delete from tbl_security_identity_cache where domain in (

select domain from tbl_security_identity_cache

inner join tbl_projects on domain like '%' + convert(varchar(40), project_id)

where project_name like 'Test%')

delete from tbl_security_acls where oid in (select oid from tbl_security_objects where pid in (1,2))

delete from tbl_security_objects where pid in (1,2)

delete from tbl_security_projects where pid in (1,2)

delete from tbl_gss_group_membership where parent_group_sid in (select sid from tbl_gss_groups inner join tbl_projects on project_uri like '%' + convert(varchar(40), project_id) where project_name like 'Test%')

delete from tbl_gss_groups where sid in (select sid from tbl_gss_groups inner join tbl_projects on project_uri like '%' + convert(varchar(40), project_id) where project_name like 'Test%')

delete from tbl_node_ancestors where ancestor in (select id from tbl_nodes where project_context in (select project_id from tbl_projects where project_name like 'Test%'))

delete from tbl_nodes where project_context in (select project_id from tbl_projects where project_name like 'Test%')

delete from tbl_project_properties where project_id in (select project_id from tbl_projects where project_name like 'Test%')

delete from tbl_projects where project_name like 'Test%'

commit
In Currituck DB (more specific items pid, etc)

begin transaction

delete from sets where constid in (select constid from constants where domainpart in ('fa504723-757e-4eab-add4-9b6ed0fba43a','23f83ebb-6a80-422b-8505-cd6d7cfbd177'))

delete from ruleusages where ruleid in (select id from rules where projectid in (1,7))

delete from rules where projectid in (1,7)

delete from storedqueries where projectid in (1,7)

delete from actions where fdeleted = 1

delete from workitemsare where areaid in (1,7)

delete from workitemtypeusages where workitemtypeid in (select workitemtypeid from workitemtypes where projectid in (1,7))

delete from workitemtypes where projectid in (1,7)

delete from persons where projectid in (1,7)

delete from xxtree where id in (select belowid from treeidpairs where aboveid in ( select id from treenodes where typeid = -42 and name like 'Test%'))

delete from treeproperties where areaid in (1,7)

delete from treenodes where id in ( select belowid from treeidpairs where aboveid in ( select id from treenodes where typeid = -42 and name like 'Test%'))

delete from treeidpairs where aboveid in (1,7) or belowid in (1,7)

delete from adobjectmemberships where memberobjectsid in (select objectsid from adobjects where domainname in ('fa504723-757e-4eab-add4-9b6ed0fba43a','23f83ebb-6a80-422b-8505-cd6d7cfbd177'))

delete from adobjects where domainname in ('fa504723-757e-4eab-add4-9b6ed0fba43a','23f83ebb-6a80-422b-8505-cd6d7cfbd177')

delete from addomains where domainname in ('fa504723-757e-4eab-add4-9b6ed0fba43a','23f83ebb-6a80-422b-8505-cd6d7cfbd177')

delete from constants where domainpart in ('fa504723-757e-4eab-add4-9b6ed0fba43a','23f83ebb-6a80-422b-8505-cd6d7cfbd177')

commit

CoryDixon at 2007-9-9 >

# 3

I will confirm we handle this situation in Beta3 and log a bug if we don't.

thx

BryanMacFarlaneMSFT at 2007-9-9 >

# 4

This is a known issue and is fixed in Beta3

Thanks
-Sundar

Sundar at 2007-9-9 >

# 5

I had an issue creating a project (in Beta3) and /force is not working. Actually when I run the util the error is that the item acn not be found. If I try to create a project with that name, I receive and error that says that the proejct must have a unique name.

Ideas?

Javierdc at 2007-9-9 >

# 6

same here - with beta3r - where is this delete tool you're talking about?

TilfriedWeissenberger at 2007-9-9 >

# 7

Hi,

We have TFS SP1 installed and since few time the system refreshes the drop down with areas and iterations only if we restart it.

We have read carefully all the information you posted about this subject and there is a difference in our case: there is no related error in the application log.

Indeed we have also a project that failed to be created due to user (a new user) rights, but we are not sure if this is the reason because we don't find an event similar with yours.

Please advise,

Thank you,

Eugen

EugenD at 2007-9-9 >

Visual Studio Team System

Team Foundation Server - General

Visual Studio Team System Hot Topic

Visual Studio Team System New Topic

Visual Studio Team System

Java / MSDN / Linux Tech / PHP Tech / MSDN DotNet / MSDN TECH / Health Library / Programmers Tech / visual basic Tech / Developer Tech / Ipod faqs / Msdn China Tech