Team Foundation Excel Add In hangs for 5 minutes to retrieve work items

Question

Hello experts:

I am experiencing this when retrieving work items using the Excel Add In (Office 2007, Visual Studio 2008, Windows Vista).

I enabled the Excel log functionality as explained here and here are the relevan log results:

[Verbose, PID 4624, TID 4596, 16:17:34.972] Middle tier URL:

http://dptc04tfscomputer1.dpt.ad.company.com:8080/WorkItemTracking/v1.0/ClientService.asmx
[Verbose, PID 4624, TID 4596, 16:17:34.972] Middle tier configurationUrl:

http://dptc04tfscomputer1.dpt.ad.company.com:8080/WorkItemTracking/v1.0/ConfigurationSettingsService.asmx
[Verbose, PID 4624, TID 4596, 16:17:34.972] Default cache directory: C:\Users\vsoto\AppData\Local\Microsoft\Team Foundation\2.0\Cache
[Verbose, PID 4624, TID 4596, 16:17:34.972] InstanceInfo Id: e4876485-33d6-4433-ad14-10e6a575ec52
[Verbose, PID 4624, TID 4596, 16:17:35.566] Middle tier URL:

http://dptc04tfscomputer1.dpt.ad.company.com:8080/WorkItemTracking/v1.0/ClientService.asmx
[Verbose, PID 4624, TID 4596, 16:17:35.566] Middle tier configurationUrl:

http://dptc04tfscomputer1.dpt.ad.company.com:8080/WorkItemTracking/v1.0/ConfigurationSettingsService.asmx
[Verbose, PID 4624, TID 4596, 16:17:35.566] Default cache directory: C:\Users\vsoto\AppData\Local\Microsoft\Team Foundation\2.0\Cache
[Verbose, PID 4624, TID 4596, 16:17:35.566] InstanceInfo Id: e4876485-33d6-4433-ad14-10e6a575ec52
[Verbose, PID 4624, TID 4596, 16:17:39.769] Entering WorkItem(PS.DatastoreItem psDSI, WorkItemStore store)
[Verbose, PID 4624, TID 4596, 16:17:39.785] Entering WorkItem.PartialOpen, id = 256
[Verbose, PID 4624, TID 4596, 16:21:59.663] Constructor Field(PS.Field psField, WorkItem item, int revision). Id=10018
[Verbose, PID 4624, TID 4596, 16:21:59.663] Entering Field.Value/Get. Id=10018
[Verbose, PID 4624, TID 4596, 16:21:59.663] Leaving Field.Value/Get. Id=10018, Value=No
[Verbose, PID 4624, TID 4596, 16:21:59.663] Constructor Field(PS.Field psField, WorkItem item, int revision). Id=10012
[Verbose, PID 4624, TID 4596, 16:21:59.678] Entering Field.Value/Get. Id=10012
[Verbose, PID 4624, TID 4596, 16:21:59.678] Entering Field.FieldDefinition/Get. Id=10012
[Verbose, PID 4624, TID 4596, 16:21:59.678] Leaving Field.Value/Get. Id=10012, Value=

As you can see, there is an almost 5 minute lag beteween those calls.

 

Any help will be very much appreciated.

 

Vini

Answer 1

Hi Vini,

Are you able to run queries that return the workitem you are retrieving in excel from team explorer? Are you able to double click and see the form for that workitem then (also from team explorer)? Does this repro all the time, or just occassionally?

Note : typically this log means that a call was made to the server to page in workitems, and the call did not return for a while.

Thanks.
Mareen.

Answer 2

Hey Mareen,

Yes. I can run the exact same query from Team Explorer (which returns in a timely fashion) and I can double click the item and see the form. The behavior repros all the time.

The issue doesn't repro on Office XP + Windows XP.

Cheers.

Answer 3

Hi,

Thanks for the clarification. I've asked one of our server developers to look at what might be happening here. I'll loop back with you when we have more data.

Thanks.
-Mareen.

Answer 4

Hi there

was wondering if anyone determined the cause - i am hitting this too - when refresh is clicked, the 'waiting to connect' dialog hangs out for minutes upon minutes.