Index (zero based) must be greater than or equal to zero

markbewlay

Have recently applied the patch to version 1.0.4.1 and some issues have certainly been resolved.

However, I have one linked database that after performing a 'Get Latest' and sync successfully I am unable to go any futher. Attempting a 'Get Latest' or 'Commit Changes' results in:

'Index (zero based) must be greater than or equal to zero and less than the size of the argument list.'

with a complete error message of:

System.FormatException: Index (zero based) must be greater than or equal to zero and less than the size of the argument list.
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)

Any ideas on what may be causing this?

Regards

Mark

peter.peart

Hi there,

Thanks fgor your post. Is this reproducible using the release version of SQL Source Control, or do you only get this error when using the patched version?

Also, since I believe this is reproducible with the patched version, are you able to submit the exception when prompted and also include your e-mail address? If you can let me know when you have done this by e-mailing support(at)red-gate.com quoting reference number F0037534 that would be great.

Many thanks!

Pete