Commit problem with TFS

A SQL Server Management Studio add-in to source control your database in Subversion or Team Foundation Server.

Commit problem with TFS

Postby mmJPM » Tue Dec 06, 2011 9:32 pm

I'm having a problem setting up Source Control v2.2 with Team Foundation Server 2010. After linking a database, when I try to commit the changes for the first time, I get an error that the underlying connection was closed. If I try to commit a small number of changes (3 - 5 files), it works fine.

Here is the Event Viewer output:
Event Type: Error
Event Source: SQL Source Control 2
Event Category: None
Event ID: 32
Date: 12/6/2011
Time: 9:28:41 AM
User: N/A
ProgressTask:Not reporting error
Microsoft.TeamFoundation.VersionControl.Client.VersionControlException: C:\\Documents and Settings\\user\\Local Settings\\Application Data\\Red Gate\\SQL Source Control 2\\WorkingBases\\rapm2klt.pyq\\Functions\\contacts.ufn_Implode_PrimaryAddress.sql: The underlying connection was closed: A connection that was expected to be kept alive was closed by the server. ---> System.Net.WebException: The underlying connection was closed: A connection that was expected to be kept alive was closed by the server.
at System.Net.HttpWebRequest.GetResponse()
at Microsoft.TeamFoundation.VersionControl.Client.FileUploader.UploadChunk(FileStream fileContentStream, Int64 end)
--- End of inner exception stack trace ---
at Microsoft.TeamFoundation.VersionControl.Client.Workspace.UploadChanges(IEnumerable`1 changes, OnProcessingChangeDelegate onPendingMethod)
at Microsoft.TeamFoundation.VersionControl.Client.Workspace.CheckInInternal(WorkspaceCheckInParameters parameters)
at Microsoft.TeamFoundation.VersionControl.Client.Workspace.CheckIn(WorkspaceCheckInParameters checkinParameters)
at Microsoft.TeamFoundation.VersionControl.Client.Workspace.CheckIn(PendingChange[] changes, String comment, CheckinNote checkinNote, WorkItemCheckinInfo[] workItemChanges, PolicyOverrideInfo policyOverride)
at #oLi.#L8x.#t.#EMd.#t.#O3c.#bQv()
at #oLi.#fqi.#GHi(Action , VersionControlServer )
at #oLi.#fqi.#t.#A2.#gqi()
at #oLi.#uRi.#LBf(#ovB , Action )
at #oLi.#uRi.#LBf(VersionControlServer , Action )
at #oLi.#fqi.#Ipg(ICancellableOperationStatus , IReadOnlySourceControlServerCallBacks , Action , TfsLocation , ICredentialsStore , #Fqi , VersionControlServer , Object )
at #oLi.#L8x.#Ipg(ICancellableOperationStatus , IReadOnlySourceControlServerCallBacks , Action )
at #oLi.#L8x.#t.#EMd.#aQv(ICancellableOperationStatus )
at RedGate.SQLSourceControl.Engine.Cancellables.CancellableOperation.#i5f()
at RedGate.SQLSourceControl.Engine.Cancellables.CancellableOperationBase.InvokeWithTracker(Action action)
at RedGate.SQLSourceControl.Engine.Cancellables.CancellableOperation.Invoke()
at RedGate.SQLSourceControl.Engine.SmartAssembly.ExceptionReporting.ErrorReporterBase.Do(Action , Predicate`1 , Boolean )

For more information, see Help and Support Center at
Posts: 4
Joined: Tue Dec 06, 2011 9:23 pm

Postby james.billings » Thu Dec 08, 2011 7:53 pm

Hi, thanks for posting, and sorry you're having trouble.

This error is coming from the underlying TFS layer rather than SQL Source Control itself, however a quick google led me to this. Do you use Norton? If so, one user got around this type of error by disabling it by the looks of it.
Posts: 1122
Joined: Wed Jun 16, 2010 10:10 am
Location: Red Gate

Return to SQL Source Control Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests