VSTS Connector Admin Site Error (Unhandled Exception)

Aug 6, 2008 at 8:10 PM

Hello,
I have a Team foundation 2008 Server computer with the Project Server 2007 Connector installation component and the Team Foundation Server installation component on it.
I have SharePoint 2007/Project 2007 Server computer with the Project Server installation component on it.
SQL is on a different machine and I had to install the databases using the scripts provided as the install was success (it said) but no databases were created or logs of what might have gone wrong (not in any of the app logs)

The three components installed with success, I used the tfsservice account to install all three.
The tfsservice account is a farm admin on sharepoint, Project Server instance admin, as well as having FC of the PWA site. It is a local admin on all three computers and is a sysadmin on the SQL computer.
It is a member of the IIS_WPG group and has FC of the Temp ASP.net folder.

When I launch the Connector web site I get this:

Error

This operation could not be successfully performed. Please contact the administrator and refer to HandlingInstanceID: bf4504c2-b023-414d-aad0-d8a282fa229d


And these two items show in the Event Log:

Event Type: Warning
Event Source: ASP.NET 2.0.50727.0
Event Category: Web Event
Event ID: 1310
Date:  8/6/2008
Time:  12:53:56 PM
User:  N/A
Computer: QHRTEAMF
Description:
Event code: 3008
Event message: A configuration error has occurred.
Event time: 8/6/2008 12:53:56 PM
Event time (UTC): 8/6/2008 7:53:56 PM
Event ID: c448f08e8e064d6d87d56618a39e833f
Event sequence: 2
Event occurrence: 1
Event detail code: 0
 
Application information:
    Application domain: /LM/W3SVC/64549133/Root/Connector Web Service-1-128625260344311958
    Trust level: Full
    Application Virtual Path: /Connector Web Service
    Application Path: C:\Program Files\Microsoft Project Server 2007 Connector\Connector Web Service\
    Machine name: QHRTEAMF
 
Process information:
    Process ID: 6664
    Process name: w3wp.exe
    Account name: QUADRANTHR\tfsservice
 
Exception information:
    Exception type: ConfigurationErrorsException
    Exception message: The entry 'Formatted EventLog TraceListener' has already been added. (C:\Program Files\Microsoft Project Server 2007 Connector\Connector Web Service\web.config line 229)
 
Request information:
    Request URL: http://localhost:9090/Connector Web Service/PS2007ProviderAdministration.asmx
    Request path: /Connector Web Service/PS2007ProviderAdministration.asmx
    User host address: 127.0.0.1
    User: 
    Is authenticated: False
    Authentication Type: 
    Thread account name: QUADRANTHR\tfsservice
 
Thread information:
    Thread ID: 1
    Thread account name: QUADRANTHR\tfsservice
    Is impersonating: False
    Stack trace:    at System.Configuration.BaseConfigurationRecord.EvaluateOne(String[] keys, SectionInput input, Boolean isTrusted, FactoryRecord factoryRecord, SectionRecord sectionRecord, Object parentResult)
   at System.Configuration.BaseConfigurationRecord.Evaluate(FactoryRecord factoryRecord, SectionRecord sectionRecord, Object parentResult, Boolean getLkg, Boolean getRuntimeObject, Object& result, Object& resultRuntimeObject)
   at System.Configuration.BaseConfigurationRecord.GetSectionRecursive(String configKey, Boolean getLkg, Boolean checkPermission, Boolean getRuntimeObject, Boolean requestIsHere, Object& result, Object& resultRuntimeObject)
   at System.Configuration.BaseConfigurationRecord.GetSection(String configKey, Boolean getLkg, Boolean checkPermission)
   at System.Configuration.BaseConfigurationRecord.GetSection(String configKey)
   at System.Web.Configuration.HttpConfigurationSystem.System.Configuration.Internal.IInternalConfigSystem.GetSection(String configKey)
   at System.Configuration.ConfigurationManager.GetSection(String sectionName)
   at Microsoft.Practices.EnterpriseLibrary.Common.Configuration.SystemConfigurationSourceImplementation.GetSection(String sectionName)
   at Microsoft.Practices.EnterpriseLibrary.Common.Configuration.SystemConfigurationSource.GetSection(String sectionName)
   at Microsoft.Practices.EnterpriseLibrary.Logging.Configuration.LoggingSettings.GetLoggingSettings(IConfigurationSource configurationSource)
   at Microsoft.Practices.EnterpriseLibrary.Logging.LogWriterStructureHolderCustomFactory.CreateObject(IBuilderContext context, String name, IConfigurationSource configurationSource, ConfigurationReflectionCache reflectionCache)
   at Microsoft.Practices.EnterpriseLibrary.Logging.LogWriterCustomFactory.CreateObject(IBuilderContext context, String name, IConfigurationSource configurationSource, ConfigurationReflectionCache reflectionCache)
   at Microsoft.Practices.EnterpriseLibrary.Common.Configuration.ObjectBuilder.ConfiguredObjectStrategy.BuildUp(IBuilderContext context, Type t, Object existing, String id)
   at Microsoft.Practices.ObjectBuilder.SingletonStrategy.BuildUp(IBuilderContext context, Type typeToBuild, Object existing, String idToBuild)
   at Microsoft.Practices.ObjectBuilder.BuilderStrategy.BuildUp(IBuilderContext context, Type typeToBuild, Object existing, String idToBuild)
   at Microsoft.Practices.EnterpriseLibrary.Common.Configuration.ObjectBuilder.ConfigurationNameMappingStrategy.BuildUp(IBuilderContext context, Type t, Object existing, String id)
   at Microsoft.Practices.EnterpriseLibrary.ExceptionHandling.Logging.Configuration.LoggingExceptionHandlerAssembler.Assemble(IBuilderContext context, ExceptionHandlerData objectConfiguration, IConfigurationSource configurationSource, ConfigurationReflectionCache reflectionCache)
   at Microsoft.Practices.EnterpriseLibrary.Common.Configuration.ObjectBuilder.AssemblerBasedObjectFactory`2.Create(IBuilderContext context, TConfiguration objectConfiguration, IConfigurationSource configurationSource, ConfigurationReflectionCache reflectionCache)
   at Microsoft.Practices.EnterpriseLibrary.ExceptionHandling.ExceptionPolicyEntryCustomFactory.Create(IBuilderContext context, ExceptionTypeData objectConfiguration, IConfigurationSource configurationSource, ConfigurationReflectionCache reflectionCache)
   at Microsoft.Practices.EnterpriseLibrary.ExceptionHandling.ExceptionPolicyCustomFactory.CreateObject(IBuilderContext context, String name, IConfigurationSource configurationSource, ConfigurationReflectionCache reflectionCache)
   at Microsoft.Practices.EnterpriseLibrary.Common.Configuration.ObjectBuilder.ConfiguredObjectStrategy.BuildUp(IBuilderContext context, Type t, Object existing, String id)
   at Microsoft.Practices.ObjectBuilder.SingletonStrategy.BuildUp(IBuilderContext context, Type typeToBuild, Object existing, String idToBuild)
   at Microsoft.Practices.ObjectBuilder.BuilderStrategy.BuildUp(IBuilderContext context, Type typeToBuild, Object existing, String idToBuild)
   at Microsoft.Practices.EnterpriseLibrary.Common.Configuration.ObjectBuilder.ConfigurationNameMappingStrategy.BuildUp(IBuilderContext context, Type t, Object existing, String id)
   at Microsoft.Practices.ObjectBuilder.BuilderBase`1.DoBuildUp(IReadWriteLocator locator, Type typeToBuild, String idToBuild, Object existing, PolicyList[] transientPolicies)
   at Microsoft.Practices.ObjectBuilder.BuilderBase`1.BuildUp(IReadWriteLocator locator, Type typeToBuild, String idToBuild, Object existing, PolicyList[] transientPolicies)
   at Microsoft.Practices.ObjectBuilder.BuilderBase`1.BuildUp[TTypeToBuild](IReadWriteLocator locator, String idToBuild, Object existing, PolicyList[] transientPolicies)
   at Microsoft.Practices.EnterpriseLibrary.Common.Configuration.ObjectBuilder.EnterpriseLibraryFactory.BuildUp[T](IReadWriteLocator locator, String id, IConfigurationSource configurationSource)
   at Microsoft.Practices.EnterpriseLibrary.Common.Configuration.ObjectBuilder.LocatorNameTypeFactoryBase`1.Create(String name)
   at Microsoft.Practices.EnterpriseLibrary.ExceptionHandling.ExceptionPolicy.GetExceptionPolicy(Exception exception, String policyName, ExceptionPolicyFactory factory)
   at Microsoft.Practices.EnterpriseLibrary.ExceptionHandling.ExceptionPolicy.HandleException(Exception exceptionToHandle, String policyName)
   at Microsoft.Vsts.Ranger.Connector.WebServices.ExceptionHandling.ExceptionHandler.HandleException(Exception exception)
   at Microsoft.Vsts.Ranger.Connector.WebServices.ConfigurationUtility.get_TFSResourceServiceAgent()
   at Microsoft.Vsts.Ranger.Connector.WebServices.Global.Application_Start(Object sender, EventArgs e)
 
 
Custom event details:

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.


and this:

Event Type: Warning
Event Source: ASP.NET 2.0.50727.0
Event Category: Web Event
Event ID: 1309
Date:  8/6/2008
Time:  12:53:56 PM
User:  N/A
Computer: QHRTEAMF
Description:
Event code: 3005
Event message: An unhandled exception has occurred.
Event time: 8/6/2008 12:53:56 PM
Event time (UTC): 8/6/2008 7:53:56 PM
Event ID: 2c363e7acc76466d8b8fb6decfd48a71
Event sequence: 4
Event occurrence: 1
Event detail code: 0
 
Application information:
    Application domain: /LM/W3SVC/64549133/Root-1-128625260322081766
    Trust level: Full
    Application Virtual Path: /
    Application Path: C:\Program Files\Microsoft Project Server 2007 Connector\Connector Web Site\
    Machine name: QHRTEAMF
 
Process information:
    Process ID: 2064
    Process name: w3wp.exe
    Account name: NT AUTHORITY\NETWORK SERVICE
 
Exception information:
    Exception type: HttpUnhandledException
    Exception message: Exception of type 'System.Web.HttpUnhandledException' was thrown.
 
Request information:
    Request URL: http://qhrteamf:9090/default.aspx
    Request path: /default.aspx
    User host address: 10.197.0.90
    User: 
    Is authenticated: False
    Authentication Type: 
    Thread account name: NT AUTHORITY\NETWORK SERVICE
 
Thread information:
    Thread ID: 1
    Thread account name: NT AUTHORITY\NETWORK SERVICE
    Is impersonating: False
    Stack trace:    at System.Web.UI.Page.HandleError(Exception e)
   at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
   at System.Web.UI.Page.ProcessRequest(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
   at System.Web.UI.Page.ProcessRequest()
   at System.Web.UI.Page.ProcessRequestWithNoAssert(HttpContext context)
   at System.Web.UI.Page.ProcessRequest(HttpContext context)
   at ASP._project_list_aspx.ProcessRequest(HttpContext context) in c:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\root\c4c3607e\8e9e542c\App_Web_o8a9n1uc.3.cs:line 0
   at System.Web.HttpServerUtility.ExecuteInternal(IHttpHandler handler, TextWriter writer, Boolean preserveForm, Boolean setPreviousPage, VirtualPath path, VirtualPath filePath, String physPath, Exception error, String queryStringOverride)
 
 
Custom event details:

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.


Can you help me?

Thanks!
Nov 3, 2008 at 6:42 PM
I wondered if anyone can point me in the right direction?
I would be grateful for the help!
Jan 12, 2009 at 3:25 PM
Hi.
Did you solved it? I have the same problem...
Jan 12, 2009 at 3:32 PM
No, it seems that the Project Connector has some inherent issues (particularly with a setup like ours, with a database back end, a VM application server, and a separate machine running SharePoint 2007 Server) with connections, as well as issues once you get it working.

I have stopped troubleshooting this--because if the developers started using it if I did get it working and then I ran into problems, there is no support (as it is a codeplex offering) and I can't take that chance. I am testing Project Party (recommended to me by our Microsoft Partner contacts), an offering from a company in Israel (Orantech). Haven't got too far in the testing process, but it does indeed allow bidirectional data movement between Project 2007 and Team Foundation 2008.
Jan 28, 2009 at 12:05 PM

Hey Hi
           I have installed a TFS 2005 on one machine and also installed MS Project server 2007 on other machine. I want a connector which create communication between these both software. So I got the connector from you site (Linkgiven Here: http://www.codeplex.com/pstfsconnector/Wiki/View.aspx?title=Setup%20Guide). I got the all installation guide line from this link. I have some problem in this communication. First of all When I installed the connector, I had given all perfect information during connector installation. But during the installation I have some questions related to following steps.

TFS Service account, which was created during installation of Visual Studio Team Suite. This account should have administrative privileges on the machine hosting Microsoft Project Server 2007 – Connector.
TFS Service account should be mapped with dbo user, default database as master and it should have sysadmin privileges in SQL Server 2005.
TFS Service account should also be the member of IIS_WPG and Administrator group on local machine and it should have full permissions in %windir%\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files
Execute the following command in visual studio command prompt
aspnet_regiis -i –enable
As you have said in first step we will use the TFS Service account. Here I want to clarify that when we installed TFS 2005 we create 3 domain account for TFS i.e. are TFSSETUP, TFSSERVICES and TFSReport. I always use TFSSETUP account for machine login. So right now I am also using this account for using TFS server and explorer in that machine. Will you tell me what do you mean by TFSService account. Can we connect the machine with TFSService account and use TFS with this account. While the TFSSETUP account have full administrative privileges.
I have installed SQLServer 2005 on TFS machine. I have installed it with TFSSETUP account on TFS machine. I also add the TFSSERVICE account in SQL server 2005 connector db user. and TFSSERVICE has full administrative rights. So let me know how we will remove this confusion. Because we are using TFSSETUP user account and you are telling us about TFSSERVICE use account. So please let us know, if you have any guideline document about it.
How can I verify that TFSSERVICE use account or TFSSETUP account is a members of IIS_WPG. How can verify this service in my machine. secondly as you have mentioned about ASP.Net files. When I check it in my machine, I have found there following folder in this hierarchy (\Program Files\Microsoft.NET\ADOMD.NET and \Program Files\Microsoft.NET\Primary Interop Assemblies). So let me know how can I verify it and after which software installation this folder create in given hierarchy. Please if you have any guideline about it too please send me.
In the last as you have given some command  about ASP.NET registration. But this command is not executable. Let me know about it too.
If you have further guideline then please let me know ASAP. 

Jan 28, 2009 at 2:30 PM
mwaseemalvi,

As these questions are not Project Connector questions but Team Foundation Server setup questions, you may get an answer to your questions faster if you post to either the MSDN Team Foundation General Forum:
http://social.msdn.microsoft.com/forums/en-US/tfsgeneral/threads/
or
the Team Foundation setup forum:
http://social.msdn.microsoft.com/Forums/en-US/tfssetup/threads/

Plus, I have set up both Team Foundation 2005 and Team Foundation 2008.
2008 was a lot easier to get working.

Why not use the latest version, rather than TFS 2005?
Feb 19, 2009 at 10:06 AM
 Dear Sir
            I have installed TFS server 2005 at one machine and I have MS Project Server 2007 another machine. Now I want to connect Project server with TFS. I got the one link (http://www.codeplex.com/pstfsconnector/Wiki/View.aspx?title=Setup%20Guide), here I got the VSTS connector for MS Project Server 2007 and TFS 2005 integration. TFS2005 software is working very well before this connectore installation. When I installed the connector by following the proper guideline which are present at given link. After complete installation, When I start the TFS Server and open the TFS Explorer then I got following error.

"TFS31001: Team Foundation cannot retrieve the list of team projects from Team Foundation Server ss01-cpu-118. The TEam Foundation Server returned the following error: The request failed with HTTP status 404:."

I was installing this connector on TFS Machine as per guideline which are given on website(http://www.codeplex.com/pstfsconnector/Wiki/View.aspx?title=Setup%20Guide). I was login with TFSSETUP on TFS machine. Although I have installed TFS server 2005 with this Login. While on installation I used the TFSSERVICE account for TFS installation.

Please if any one have any solution about this problem. Please let me know ASAP.


Thanks

Best Regards

Muhammad Waseem Alvi