G'day,

I have encountered strange problem.

We are using the code presented below to retrieve Everyone application group with members.

IGroupSecurityService _groupSecurityService = _server.GetService(typeof(IGroupSecurityService)) as IGroupSecurityService;

Identity everyoneGroup = _groupSecurityService.ReadIdentity(SearchFactor.EveryoneApplicationGroup, null, QueryMembership.Expanded);

The code works as expected on all but one installation of TFS. In the exceptional set up the exception "TF30290: There was a problem accessing the database on the server. See the Team Foundation Server event log for details." is thrown. The event log says that "SQLException: The statement has terminated. The maximum recursion 100 has been exhausted before statement completion" and the SQL exception procedure is prc_security_read_identity. The TFS version used is RTM and setup seems to be fairly typical.

I am quite at loss how to continue from that point; the code appears quite kosher and works at other installations.

We would be very obliged for any insights from MS people.

Yours truly, Eugene

The short answer is that's a bug, but I don't know if this is a known issue. It may be due to trying to expand groups. It will probably work if you don't ask for the expanded group membership.

I'll send email to the relevant person for follow up.

Buck

Buck,

Thank you for your reply. It does not matter much if retrieving everyone group will work without Expanded option specify, as we were using it in order to get all valid users for Team Server.

Could you advise of some other technique that allows to obtain all valid users for TFS?

Yours truly, Eugene

This is a known problem. What is happening is that the Valid Users group contains a group that is nested more than 100 levels deep, or there is a circular group membership in an AD group. If you can eliminate the deep nesting or circular group membership, everything will start working again. Otherwise you will need to contact CSS and ask that a case be opened. If you do open a case with CSS, have them reference dogfood bug #74665.

Matt Hoover
Visual Studio Team Foundation
Software Design Engineer