Hello, I often use the data compare feature to compare outputs between two versions of a SQL script. It occasionally produces an error message.
Index (zero based) must be greater than or equal to zero and less than the size of the argument list.
I’ve tried reformatting my dataset and using different columns and data types, but I’m not sure what could be causing this error.
Any ideas on what could be producing this error? Even a workaround would be great. Thanks!
Output from the DataCompareAndSync.log file below.
12/19/2025 2:27:08 PM; Info; Querying record count.
12/19/2025 2:27:08 PM; Info; Comparision started.
12/19/2025 2:27:08 PM; Error; ----------------------------------------------- Exception -----------------------------------------------
12/19/2025 2:27:08 PM; Error; System.FormatException
12/19/2025 2:27:08 PM; Error; Index (zero based) must be greater than or equal to zero and less than the size of the argument list.
12/19/2025 2:27:08 PM; Error; StackTrace : at System.Text.StringBuilder.AppendFormatHelper(IFormatProvider provider, String format, ParamsArray args)
at System.String.FormatHelper(IFormatProvider provider, String format, ParamsArray args)
at Quest.DataCompare.PL.ComparisonEngine.CreateQueryTexts(ObjectWithColumns tableSource, ObjectWithColumns tableTarget, String& querySource, String& queryTarget, Boolean extractDataOnly, Int32 rowLimit)
at Quest.DataCompare.PL.ComparisonEngine.CompareData(SaveFlags saveFlags, ComparisionOptions cmpOptions, String dataStoragePath, Guid sessionId, ICommandProgress overallProgress, ICommandProgress detailProgress, ConfirmRetryHandler retryHandler, Func3 setValueLength, Boolean extractDataOnly, Int32 rowLimit) at Quest.DataCompare.PL.ObjectWithColumnsPair.DoCompare(CompareTypesOptions CompareOptions, ComparisionOptions ComparisionSettings, String dataStoragePath, Guid sessionId, ICommandProgress overallProgress, ICommandProgress detailedProgress, ConfirmRetryHandler retryHandler, Func3 setValueLength, Boolean extractDataOnly, Int32 rowLimit)
at Quest.DataCompare.PL.PLFasade.DoCompare(CompareTypesOptions cs, ComparisionOptions co, String tempFolder, Guid sessionId, ArrayList ErrorList, ICommandProgress overallProgress, ICommandProgress detailProgress, ConfirmRetryHandler confirmHandler, Func`3 setValueLength, Boolean extractDataOnly, Int32 rowLimit)
12/19/2025 2:27:08 PM; Error; ---------------------------------------------------------------------------------------------------------
12/19/2025 2:27:08 PM; Info; Comparision completed.