Error: Input string was not in a correct format

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: Input string was not in a correct format

Postby josefortuna » Wed Aug 11, 2010 11:22 am

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
 
Posts: 3
Joined: Wed Aug 11, 2010 11:10 am
Location: London

Stack trace

Postby josefortuna » Wed Aug 11, 2010 11:50 am

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)
josefortuna
 
Posts: 3
Joined: Wed Aug 11, 2010 11:10 am
Location: London

Input string was not in the correct format

Postby sherr » Thu Aug 12, 2010 12:07 pm

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
Thank you!
Stephanie M. Herr :-)
Delivery Product Manager
sherr
 
Posts: 126
Joined: Thu Mar 19, 2009 12:45 pm
Location: Cambridge

Postby josefortuna » Thu Aug 12, 2010 12:09 pm

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

Thanks for your help.

Jose
josefortuna
 
Posts: 3
Joined: Wed Aug 11, 2010 11:10 am
Location: London


Return to SQL Source Control 1

Who is online

Users browsing this forum: No registered users and 1 guest