System.ArgumentOutOfRangeException when comparing data (4270626)

Chat now with support

Return

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title

System.ArgumentOutOfRangeException when comparing data
Description

Getting the following error when performing data compare
**********************************************************************
Exception Information
**********************************************************************
Exception: System.ArgumentOutOfRangeException
Message : StartIndex cannot be less than zero.
Parameter name: startIndex
Stack Trace:
at System.Text.StringBuilder.Remove(Int32 startIndex, Int32 length)
at
Quest.DataCompare.PLMSSQL.MSSQLTable.generateScriptCreatePrimaryKeyIndex
(List`1 result, MSSQLIndex item)
at
Quest.DataCompare.PLMSSQL.MSSQLTable.ScriptCreatePrimaryKeyIndexes()
at Quest.DataCompare.PL.TAPLRoot.generateClosingOptionsScript(List`1
Cause

This can happen when a column in one of the tables being compared is a key column but that same column is used as an INCLUDED column in the other table.
Resolution

Issue fixed in version 5.5.
The latest version of Toad For SQL server can be downloaded at: http://support.quest.com/Search/SearchDownloads.aspx

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title