Home Dashboard Directory Help
Search

When Connecting Feedback Client to a Team Project I receive an Exception TF30040 by Hossein Aarabi


Status: 

Resolved
 as Won't Fix Help for as Won't Fix


1
0
Sign in
to vote
Type: Bug
ID: 772577
Opened: 11/28/2012 12:00:27 PM
Access Restriction: Public
0
Workaround(s)
view
0
User(s) can reproduce this bug

Description

I have just updated VS 2012 and TFS 2012 to Update 1. When I try to connect MS Feedback Client for TFS to a Team Project I receive the following error:

"Cannot connect to Team Foundation Server. Verify the network connection and try again. TF30040: The database is not correctly configured. Contact your Team Foundation Server administrator."

I am not sure if this was issue before upgrading VS 2012 to Update 1 or not.

I check the log on the TFS server. I found the following information...

In the database server log, I see the following warning:

Date        11/28/2012 11:49:29 AM
Log        Windows NT (Application)

Source        TFS Services
Category        (0)
Event        3007
Computer        XXXXX-TFS01

Message
The description for Event ID 3007 from source TFS Services cannot be found. Either the component that raises this event is not installed on your local computer or the installation is corrupted. You can install or repair the component on the local computer.

In the Event log I see the following warning:

Exception Message: TF30040: The database is not correctly configured. Contact your Team Foundation Server administrator. (type DatabaseConfigurationException)
Exception Stack Trace:    at Microsoft.TeamFoundation.Framework.Server.TeamFoundationSqlResourceComponent.TranslateException(Int32 errorNumber, SqlException sqlException, SqlError sqlError)
at Microsoft.TeamFoundation.Framework.Server.TeamFoundationSqlResourceComponent.TranslateException(SqlException sqlException)
at Microsoft.TeamFoundation.Framework.Server.TeamFoundationSqlResourceComponent.MapException(SqlException ex, QueryExecutionState queryState)
at Microsoft.TeamFoundation.Framework.Server.TeamFoundationSqlResourceComponent.HandleException(Exception exception)
at Microsoft.TeamFoundation.Framework.Server.TeamFoundationSqlResourceComponent.Execute(ExecuteType executeType, CommandBehavior behavior)
at Microsoft.TeamFoundation.TestManagement.Server.TestManagementDatabaseM37.CreateSession(Int32 projectId, Session session, Guid updatedBy)
at Microsoft.TeamFoundation.TestManagement.Server.Session.Create(TestManagementRequestContext context, TestSettings settings, String teamProjectName)
at Microsoft.TeamFoundation.TestManagement.Server.TestManagementWebService.CreateSession(Session session, TestSettings settings, String teamProjectName)

Inner Exception Details:

Exception Message: Procedure or function 'prc_CreateSession' expects parameter '@buildPlatform', which was not supplied. (type SqlException)
SQL Exception Class: 16
SQL Exception Number: 201
SQL Exception Procedure: prc_CreateSession
SQL Exception Line Number: 0
SQL Exception Server: XXXXX-TFS01
SQL Exception State: 4
SQL Error(s):

Exception Data Dictionary:
HelpLink.ProdName = Microsoft SQL Server
HelpLink.ProdVer = 11.00.2218
HelpLink.EvtSrc = MSSQLServer
HelpLink.EvtID = 201
HelpLink.BaseHelpUrl = http://go.microsoft.com/fwlink
HelpLink.LinkId = 20476


Exception Stack Trace:    at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()
at System.Data.SqlClient.SqlDataReader.get_MetaData()
at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior)
at Microsoft.TeamFoundation.Framework.Server.TeamFoundationSqlResourceComponent.Execute(ExecuteType executeType, CommandBehavior behavior)


Details
Sign in to post a comment.
Posted by Hossein Aarabi on 11/28/2012 at 2:42 PM
Resovled.

Eventhought the upgrade of TFS 2012 to Update 1 said that it was successful. Some how the DB schema upgrade was corrupted.

I fixed the issue by performing the following steps:

1. In cmd prompt, go to the following directory "C:\Program Files\Microsoft Team Foundation Server 11.0\Tools" run: TFSServiceController quiesce

2. In cmd prompt, run: net stop was

3. Open control panel, select uninstall a program, select Team Foundation Server 2012, select Change, Select Repair. (a restart is required)

4. Run: TFSServiceController unquiesce
5. Run: net start was
6. Check IIS, makes sure the IIS server and all the web sites and application pools are started.
7. Test to make sure you can connect to TFS, using MS Feedback Client for TFS.
Posted by Microsoft on 11/28/2012 at 12:52 PM
Thank you for your feedback, we are currently reviewing the issue you have submitted. If this issue is urgent, please contact support directly(http://support.microsoft.com)
Sign in to post a workaround.