TFS security model in configuration database

by XDK 20. December 2013 06:42

 

Following is the sample query to get the user details associated with the team projects

SELECT TOP (10) PERCENT 
    login.display_name  AS user_name, 
    proj.scope_name     AS project, 
    login_grp.display_name AS user_group

FROM dbo.tbl_security_membership_cache AS membership INNER JOIN
  dbo.tbl_security_identity_cache AS login ON membership.member_id = login.tf_id INNER JOIN
  dbo.tbl_security_projects AS proj INNER JOIN
     dbo.tbl_security_domain AS domain INNER JOIN
       dbo.tbl_security_domain_groups AS grp ON domain.domain_number = grp.domain_number 
       ON proj.domain_number = domain.domain_number
     ON membership.container_id = grp.group_id INNER JOIN
  dbo.tbl_security_identity_cache AS login_grp ON grp.group_id = login_grp.tf_id

ORDER BY user_name, project

 

Tags:

Azure DevOps on-premises | SQL Server

TFS 2012 and VS 2012 featured with new workspace concept called “local” workspaces

by XDK 19. December 2013 19:19

Explanation:

TFS 2012 and VS 2012 featured with new workspace concept called “local” workspaces.The workspace concept which was available from VS/TFS 2005 - 2010 is called as “server” workspaces. “server” workspaces is the default option while creating a new workspace in VS 2012.

When a local workspace is created, the required data structures will be moved from the TFS server onto the TFS Client. The data structures are local to local machine instead of being hosted on the TFS server. Moving the data structures to local machine gives VS 2012 the ability to perform a number of source control operations without TFS web service calls or active connection to TFS server. The following operations continue to work when the local machine is disconnected from the TFS server.

  • Opening a source-controlled solution
  • Checking out a file for edit
  • adding a new file or folder for add
  • Delete on an existing file or folder
  • Rename on an existing file or folder
  • Monitor pending changes in the workspace
  • Undoing pending changes
  • Diffing your copy of a file with the version of the file your change is pended against
  • The local workspace will not carry read only bit during get source.
  • “Promoting” the candidate adds and/or deletes
  • The local workspace will be invisible to VS 2010 and earlier versions
  • No enforcement of PendChange permission or checkout locks
  • The local workspace can be converted to Server workspace and reverse the same

Drawback on Local workspaces.

Local workspaces have scalability limitations due to their use of the local workspace scanner which checks for edited items.If the workspace has more than 50,000 items, There may be performance problems or "TF400030 errors as operations exceed 45 seconds in duration." may occur

Steps to create a local workspace.

  

 

Tags:

TFS 2012 | Visual Studio 2012

"TF400030: The local data store is currently in use by another operation. Please wait and then try your operation again. If this error persists, restart the application.”

by XDK 19. December 2013 08:36

Exception:

"TF400030: The local data store is currently in use by another operation. Please wait and then try your operation again. If this error persists, restart the application.”

Explanation:

The error occur when using local workspaces in Visual Studio 2012 or later

TFS 2012 and VS 2012 featured with new workspace concept called “local” workspaces.The workspace concept which was available from VS/TFS 2005 - 2010 is called as “server” workspaces 

When a local workspace is created, The required data structures will be moved from the TFS server onto the TFS Client. The data structures are local to local machine instead of being hosted on the TFS server. Moving the data structures to local machine gives VS 2012 the ability to perform a number of source control operations without TFS web service calls. The following operations continue to work when the local machine is disconnected from the TFS server.

  • Opening a source-controlled solution
  • Checking out a file for edit
  • adding a new file or folder for add
  • Delete on an existing file or folder
  • Rename on an existing file or folder
  • Monitor pending changes in the workspace
  • Undoing pending changes
  • Diffing your copy of a file with the version of the file your change is pended against
  • The local workspace will not carry read only bit during get source.
  • “Promoting” the candidate adds and/or deletes
  • The local workspace will be invisible to VS 2010 and earlier versions
  • No enforcement of PendChange permission or checkout locks
  • The local workspace can be converted to Server workspace and reverse the same

Local workspaces have scalability limitations due to their use of the local workspace scanner which checks for edited items.If the workspace has more than 50,000 items, There may be performance problems or "TF400030 errors as operations exceed 45 seconds in duration." may occur

Reconciled operation on the server or deadlock between two operations may also trigger the error.

In Local workspace architecture, only a single operation (thread) can use this local data at a time. If two pieces of system want to use the data store simultaneously – perhaps the Solution Explorer and the Source Control Explorer both want to refresh after an Undo operation was performed – then these two components have to take turns to use the local data store. One will wait for the other to finish, and who gets to go first is arbitrary.

The ‘loser’ of the race has to wait before proceeding, but will only wait for about 45 seconds. If he ends up waiting for that full amount of time, but still doesn’t get the chance to use the local data store (because some other component of the system is still using it), then this error will be raised.

Workaround:

  • keep the size of the local workspace from growing too large, files and folders less than 50,000 items
  • Avoid working with extremely large sets of pending changes (10,000+) for a long time without checking in. This helps to keep ‘reconcile’ costs low
  • Install Visual Studio 2012 Update 2 or later to get protected from the deadlock scenarios
  • Convert the local workspace to server workspace

Tags:

Azure DevOps on-premises | TFS 2012 | Visual Studio 2012

How to switch a workspace from source to target workspace mappings without affecting the folders and files in the target workspace.

by XDK 19. December 2013 08:02

Explanation:

A regular get operation will deleted each item in the target workspace folder and re-downloaded the folders and files from the server to target workspace folder.

Solution:

Use remap switch with tf get command

"tf get /remap"

Note: /remap switch does increase the load on server to process your request

Tags:

TFS 2010 | Visual Studio 2010 | Visual Studio 2012 | Visual Studio 2013

Can I lock folders and files in a shelveset?

by XDK 19. December 2013 07:43

Explanation

A lock cannot exist in a shelveset, When you try to lock an item and shelve it, your lock will be removed as part of the shelve operation.

Tags:

Visual Studio 2010 | Visual Studio 2012 | Visual Studio 2013

About the author

My name is Xavier Dilip Kumar Jayaraj having 16+ years of IT experience which includes solid experience and depth Knowledge in Application Life Cycle Management, Configuration Management, Implementation and Support using TFS on-premises and Azure DevOps. I have invested in gaining DevOps knowledege to expertise with Cloud Computing providers namely Microsoft Azure and Amazon Web Services in recent years. I am very positive to learn and adapt emerging technologies to client’s environment.

Microsoft Certified: Azure Administrator Associate

Microsoft Certified: Azure DevOps Engineer Expert

DevOps Engineer Certificate Program | Transcript 

OTP-AWSD5: AWS IoT: Developing and Deploying an Internet of Things

[PCEP-30-01] PCEP – Certified Entry-Level Python Programmer

Quotes I Like

"Failure will never overtake me if my determination to succeed is strong enough."  - Dr. APJ. Abdul Kalam

"Always be yourself, express yourself, have faith in yourself, do not go out and look for a successful personality and duplicate it." - Bruce Lee

"Technology is just a tool. In terms of getting the kids working together and motivating them, the teacher is the most important." - Bill Gates

"Innovation distinguishes between a leader and a follower." - Steve Jobs

CategoryList

Disclaimer

The information provided here is based on my expreriences, troubleshooting and online/offline findings. It can be used as is on your own risk without any warranties and I impose no rights.