Red Gate forums :: View topic - Error: Input string was not in a correct format
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Source Control 1
SQL Source Control 1 forum

Error: Input string was not in a correct format

Search in SQL Source Control 1 forum
Post new topic   Reply to topic
Jump to:  
Author Message
josefortuna



Joined: 11 Aug 2010
Posts: 3
Location: London

PostPosted: Wed Aug 11, 2010 11:22 am    Post subject: Error: Input string was not in a correct format Reply with quote

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
Back to top
View user's profile Send private message
josefortuna



Joined: 11 Aug 2010
Posts: 3
Location: London

PostPosted: Wed Aug 11, 2010 11:50 am    Post subject: Stack trace Reply with quote

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)
Back to top
View user's profile Send private message
sherr



Joined: 19 Mar 2009
Posts: 125
Location: Cambridge

PostPosted: Thu Aug 12, 2010 12:07 pm    Post subject: Input string was not in the correct format Reply with quote

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 Smile
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 Smile
Delivery Product Manager
Back to top
View user's profile Send private message
josefortuna



Joined: 11 Aug 2010
Posts: 3
Location: London

PostPosted: Thu Aug 12, 2010 12:09 pm    Post subject: Reply with quote

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

Thanks for your help.

Jose
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group