Error: Input string was not in a correct format
josefortuna
Posts: 4
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
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
Comments
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)
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
Stephanie M. Herr :-)
Product Manager Database DevOps
Thanks for your help.
Jose