Error: Input string was not in a correct format

josefortuna

Hi,

We are trying to setup an instance of SQL Source Control on a second PC. This PC uses SQL Management Studio to connect to the same database (Shared Database Development Scenario).

When linking the database to SVN we get the above error! Any ideas of what the problem might be?

Thanks

Jose

josefortuna

As a test, I have unlinked the database on the working PC and tried to re-link again and now get the same error. Stack trace is below:

Note that we have successfully linked another database from 2 PCs without any problems!

System.FormatException: Input string was not in a correct format.
at System.Text.StringBuilder.FormatError()
at System.Text.StringBuilder.AppendFormat(IFormatProvider provider, String format, Object[] args)
at System.String.Format(IFormatProvider provider, String format, Object[] args)
at System.String.Format(String format, Object[] args)
at #QEc.#REc.Trace(String message, Object[] args)
at RedGate.SQLSourceControl.Engine.ToRetrieveChangeSet.#Mgk(IDifference difference)
at RedGate.SQLSourceControl.Engine.ToRetrieveChangeSet.#Mgk(IEnumerable`1 differences)
at RedGate.SQLSourceControl.Engine.ToRetrieveChangeSet.#s1f(Differences headToLiveDifferences)
at RedGate.SQLSourceControl.Engine.ToRetrieveChangeSet..ctor(IDisposable[] toDisposeOf, #sEc runIgnoringDefaultTrace, IObjectExplorerStateService objectExplorerStateService, DatabaseConnection liveDatabaseConnection, Differences differences, IPersistentWorkspace workspace, Options options, Int64 revision, String headRootPath, ScriptDatabaseInformation folderOptions, List`1 changes, Differences differencesHeadToLive)
at RedGate.SQLSourceControl.Engine.ToRetrieveChangeSet..ctor(IDisposable[] toDisposeOf, #sEc runIgnoringDefaultTrace, DatabaseConnection liveDatabaseConnection, Differences differences, IPersistentWorkspace workspace, Options options, Int64 revision, String headRootPath, ScriptDatabaseInformation folderOptions, List`1 changes, Differences differencesHeadToLive)
at #oEc.#h7c..ctor(IDisposable[] toDisposeOf, DatabaseConnection liveDatabaseConnection, Differences differencesLiveToWorkingBase, Differences differencesHeadToWorkingBase, Differences differencesHeadToLive, IPersistentWorkspace workspace, Options options, ScriptDatabaseInformation folderOptions, #sEc databasePollingManager, Int64 revision, String headRegisterRootPath, Pair`2 changes)
at #oEc.#i7c.#t.#9Jf.#SSi()
at #oEc.#7Jf.#t.#9Jf.#uKf()
at #oEc.#7Jf.#hKf(ICancellableOperationStatus status, ICancellable database, Action action)
at #oEc.#7Jf.#lKf[T](ICancellableOperationStatus status, ICancellable database, Func`1 function)
at #oEc.#i7c.#QSi[TDiffType](ICancellableOperationStatus status, IReadOnlySourceControlServerCallBacks sourceControlUserCallBacks)
at #oEc.#i7c.#t.#z2.#hOi()
at #oEc.#i7c.#bOi[TDiffType](ICancellableOperationStatus status, Func`1 innerBuild)
at #oEc.#i7c.#q1f(ICancellableOperationStatus status, IReadOnlySourceControlServerCallBacks sourceControlUserCallBacks)
at #oEc.#4Ec.#z7c(ICancellableOperationStatus status, IReadOnlySourceControlServerCallBacks sourceControlUserCallBacks)
at #oEc.#4Ec.#8Jc(ICancellableOperationStatus status, IReadOnlySourceControlServerCallBacks sourceControlUserCallBacks)
at #oEc.#4Ec.#t.#B3.#qfA(ICancellableOperationStatus status)
at #eEc.#iEc.#t.#u3.#k5f()
at RedGate.SQLSourceControl.Engine.Cancellables.CancellableOperationBase.InvokeWithTracker(Action action)
at #eEc.#iEc.Invoke()
at #JLc.#Qlg.Invoke()
at #JLc.#PLc.#t.#Jfb.#EJf()
at RedGate.SQLSourceControl.Engine.SmartAssembly.ExceptionReporting.ErrorReporterBase.Do(Action toDo, Predicate`1 shouldReportPredicate, Boolean rethrow)
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 operation, Object token)

StephanieHerr

Hi Jose,

Did you send an exception report from within SQL Source Control?

I think this is issue SOC-1369, which occurs if you link a non empty db to an existing repo and the SQL contains curly braces {}. We are looking into a fix for this.

Thanks again for sending the information in. It's very helpful to diagnose problems.

Thank you!
Stephanie M. Herr :-)
Red Gate Software
Project Manager
UK: 01223-438676
US: 1-866-997-0397 (toll free)
SQL Source Control - http://www.red-gate.com/products/SQL_Source_Control
Free! SQL Search - http://www.red-gate.com/products/SQL_Search

josefortuna

Yes, thats it. Removing the curly braces (which were not needed anyway) resolved the problem.

Thanks for your help.

Jose