TF80071 connecting MPP to Team project
Hi,
I'm trying to connect MPP with my Team Server. When I click "choose team project" I get the dialog that list the projects. I select one (no matter which ) and get error TF80071 "team foundation encountered an error while acessing the work items database..."
I followed every advice in the other thread regarding this error, including changing the mapping and turning off the connection to the office server (which I don't use). i still get the same error.
Any idea what's wrong?
Thank you,
Ken
Hi Ken,
Can you create a config file (WinProj.exe.config in the folder where WinProj.exe resides - typically this will be C:\Program Files\Microsoft Office\OFFICE11) with the following contents. After creating this config file, launch Project and repeat the steps you stated above, then open c:\TextWriterOutput.log and look for Microsoft.TeamFoundation.WorkItemTracking.Client.ClientException. If you find such an exception can you post that exception info to this thread
<configuration>
<system.diagnostics>
<trace autoflush="false" indentsize="4">
<listeners>
<add name="myListener" type="System.Diagnostics.TextWriterTraceListener" initializeData="c:\TextWriterOutput.log" />
<remove name="Default" />
</listeners>
</trace>
</system.diagnostics>
</configuration>
Swamy
Include the xml declaration as well
<?xml version="1.0"?>
<configuration>
<system.diagnostics>
<trace autoflush="false" indentsize="4">
<listeners>
<add name="myListener" type="System.Diagnostics.TextWriterTraceListener" initializeData="c:\TextWriterOutput.log" />
<remove name="Default" />
</listeners>
</trace>
</system.diagnostics>
</configuration>
Thank you Swamy. Here is the content of the log file:
Middle tier URL: http://coderepository:8080/WorkItemTracking/v1.0/ClientService.asmx
Middle tier configurationUrl: http://coderepository:8080/WorkItemTracking/v1.0/ConfigurationSettingsService.asmx
Default cache directory: C:\Documents and Settings\DKT\Local Settings\Application Data\Microsoft\Team Foundation\1.0\Cache
InstanceInfo Id: ca06f961-359b-4c1b-8cac-a3321123a8fe
Got error in WorkItemTracking OM:
Unspecified error
(Windows)
Unmapped Currituck Exception, error code: -2147467259. Backend Exception: . PSOM Error:
Unspecified error
(Windows). An UnexpectedErrorException will be returned and usually is an indication of a bug in client or server code. If it is a proper exception that has to be mapped, pls raise a bug to map it.
Thank you,
Ken
Hi Ken,
Most likely there will be a corresponding error in the TFS AT event log (Source - TFS WorkItem Tracking) - can you post that as well
Thanks
Swamy
Hi Swamy,
I'm sorry, but the only items I see on the server event viewer are regarding the TFS various components (TFS workitem Tracking, TFS services, TFS warehouse, TFS version control) starting and stopping. In fact, it seems to me that these components are starting every 30 minutes or so and then, 30 minutes later, stopping only to start again 30 min after that and so on. Is that a normal behaviour? Could this be the cause of the problem I 'm having?
Thanks,
Ken
These start/stop messages will be logged when ASP .NET worker process is recycled. Can you check the AppPool settings for TFSAppPool using inetmgr. Look for the values set for
1) Recycle worker process (in mins) - under Recycling tab
2) Shutdown worker processes after being idle for (time in minutes) - under performance tab
Also check whether any ASP .NET error/warnings are logged in eventviewer (under System, Source:W3SVC)
Will let you know once we determine what could be the problem using the client log you posted earlier
Thanks
Swamy
Hi Swamy,
I've included below the answers to your questions.
These start/stop messages will be logged when ASP .NET worker process is recycled. Can you check the AppPool settings for TFSAppPool using inetmgr. Look for the values set for
1) Recycle worker process (in mins) - under Recycling tab - 1740 min.
2) Shutdown worker processes after being idle for (time in minutes) - under performance tab - 20 min.
Also check whether any ASP .NET error/warnings are logged in eventviewer (under System, Source:W3SVC)
I found only two warnings which is kind of old (4/12) but might be helpful so:
The identity of application pool, 'TFS AppPool' is invalid. If it remains invalid when the first request for the application pool is processed, the application pool will be disabled. The data field contains the error number.
And:
A process serving application pool 'TFS AppPool' suffered a fatal communication error with the World Wide Web Publishing Service. The process id was '2336'. The data field contains the error number.
Looking forward to hear about my client problem.
Thanks
Ken
Sorry for the late response. If there no errors/warnings in the TFS AT eventlog then I don't see any issue with the start/stop messages. I am guessing that it stops because of the idle timeout (20 mins) and start msg will be logged when there is a subsequent request (say from the TFS clients, TFS Warehouse adapters etc)
Regarding your client problem, we are not able to determine the exact reason for your problem as we are not able to repro this
Are you able to connect to TFS team projects and execute workitem queries from Team Explorer or Excel TFS addin (as MS Project is just another TFS client)? Also which version of MS Project and TFS are you using?
Swamy
Apart from Swamy's questions, pls let us know if you can create a repro for us to try here and that would help much. If you run dbgview (from sysinternals), you might get some additional diagnositic information and pls send any such info.
Thanks
Hi Naren and Swammy,
Thank you for you help so far. Answer to your questions:
1. Excel works fine. No problem connecting. So does my team explorer.
2. Office project professional 2003 (11.2.2005.180.1.15) SP2.
3. TFS is beta 3 refresh.
4. I'm sorry, but I'm not familiar with sysinternals. I'll be happy to send the needed information once you'll guide me how to get it.
Thanks,
Ken
