Error when trying to commit changes

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

Moderators: Chris Auckland, David Atkinson, sherr, PhilScrace

Error when trying to commit changes

Postby atalbot » Wed Mar 30, 2011 11:43 pm

When I click on the tab to Commit Changes the wait wheel get to "Calculating Changes" and then errors out with the following error:


System.Data.SqlClient.SqlException: Line 31: Incorrect syntax near '.'.
Line 58: Incorrect syntax near '('.
Line 62: Incorrect syntax near ','.
Incorrect syntax near the keyword 'AND'.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at #pSe.#wEc.#4Zc(SqlConnection )
at #qEc.#jEc.get_ServerConnection()
at #pSe.#mEc.#DIc()
at #pSe.#wEc..ctor(DatabaseConnection , Boolean )
at #oEc.#VXM.#t.#WXM.#xFV()
at #oEc.#VXM.#t.#WXM.#aQU(ICollection`1 , DatabaseObjectIdDictionary`1 , SourceControlOperation )
at #oEc.#VXM.#t.#XXM.#L8c(SourceControlOperation )
at #oEc.#VXM.#t.#XXM.#zYM(ToCommitChangeSet& toCommitChangeSet)
at #oEc.#VXM.#mYM[#eTb](Func`2 , ICancellableOperationStatus , IReadOnlySourceControlServerCallBacks )
at #oEc.#VXM.#jYM(ICancellableOperationStatus , IReadOnlySourceControlServerCallBacks )
at #oEc.#4Ec.#7Jc(ICancellableOperationStatus , IReadOnlySourceControlServerCallBacks )
at #oEc.#4Ec.#t.#u3.#ofA(ICancellableOperationStatus )
at #eEc.#iEc.#t.#D3.#i5f()
at RedGate.SQLSourceControl.Engine.Cancellables.CancellableOperationBase.InvokeWithTracker(Action action)
at #eEc.#iEc.Invoke()
at #eEc.#Qlg.Invoke()
at #JLc.#PLc.#t.#Jfb.#EJf()
at RedGate.SQLSourceControl.Engine.SmartAssembly.ExceptionReporting.ErrorReporterBase.Do(Action , Predicate`1 , Boolean )
at RedGate.SQLSourceControl.Engine.SmartAssembly.ExceptionReporting.ErrorReporterBase.DoWithObviousExceptionsRethrowAll(Action action)
at RedGate.SQLSourceControl.CommonUI.Forms.ErrorDialog.DoWithObviousExceptionsRethrowAll(Action action)
at #JLc.#PLc.#CTc(ICancellableOperation`1 , Object )
atalbot
 
Posts: 6
Joined: Mon Nov 08, 2010 11:27 pm

Postby james.billings » Fri Apr 01, 2011 12:40 pm

This looks like a problem parsing one of your objects' definitions on first glance.

Does it say which file triggered the problem in the error message?
james.billings
 
Posts: 1144
Joined: Wed Jun 16, 2010 11:10 am
Location: My desk.

Postby atalbot » Fri Apr 01, 2011 3:12 pm

It didn't say which file but after shutting down and restarting SSMS a couple of times, it started working.
atalbot
 
Posts: 6
Joined: Mon Nov 08, 2010 11:27 pm

Postby james.billings » Fri Apr 01, 2011 3:13 pm

That's pretty strange. Keep an eye on it, and if the problem persists please feel free to email support directly so we can investigate further.
james.billings
 
Posts: 1144
Joined: Wed Jun 16, 2010 11:10 am
Location: My desk.


Return to SQL Source Control 2

Who is online

Users browsing this forum: No registered users and 0 guests