3
Vote

The value for column 'IsXmlIndex' in table 'Index' is DBNull.

description

Receive the following error when clicking on 'Tables' in the 'Diff' area of two compared databases.

Message: The value for column 'IsXmlIndex' in table 'Index' is DBNull.
Source: DbDiff.Common
Stacktrace: at DbDiff.Common.DataAccess.DbObjectsDs.IndexRow.get_IsXmlIndex() in d:\work\DbDiff_Codeplex\DbDiffCommon\DataAccess\DbObjectsDs.cs:line 14170
at DbDiff.Common.Scripting.CreateIndex.IndexType() in d:\work\DbDiff_Codeplex\DbDiffCommon\Scripting\CreateIndex.cs:line 180
at DbDiff.Common.Scripting.CreatePrimaryKey.RowScript() in d:\work\DbDiff_Codeplex\DbDiffCommon\Scripting\CreatePrimaryKey.cs:line 63
at DbDiff.Common.Scripting.CreateBase.ToString() in d:\work\DbDiff_Codeplex\DbDiffCommon\Scripting\CreateBase.cs:line 108
at DbDiff.Common.Scripting.SqlScripting.ScriptTable(String schema, String name) in d:\work\DbDiff_Codeplex\DbDiffCommon\Scripting\SqlScripting.cs:line 290
at DbDiff.WinClient.Forms.DbItems.UcTableDiffInfo.GetTableScript() in d:\work\DbDiff_Codeplex\DbDiffWinClient\Forms\DbItems\ucTableDiffInfo.cs:line 572
at DbDiff.WinClient.Forms.DbItems.UcTableDiffInfo.Init(DataRow itemInfoRow, Databases databases, Boolean windowButton) in d:\work\DbDiff_Codeplex\DbDiffWinClient\Forms\DbItems\ucTableDiffInfo.cs:line 516
at DbDiff.WinClient.Forms.DbItems.UcTableDiffInfo..ctor(DataRow itemInfoRow, Databases databases, Boolean windowButton) in d:\work\DbDiff_Codeplex\DbDiffWinClient\Forms\DbItems\ucTableDiffInfo.cs:line 133
at DbDiff.WinClient.Forms.DbItems.UcTableDiff.UpdateDetailsFormData() in d:\work\DbDiff_Codeplex\DbDiffWinClient\Forms\DbItems\ucTableDiff.cs:line 129
at DbDiff.WinClient.Forms.DbItems.UcDbItemDiffListDetails.OnRowSelect(Object sender, RowClickEventArgs e) in d:\work\DbDiff_Codeplex\DbDiffWinClient\Forms\DbItems\ucDbItemDiffListDetails.cs:line 309
at DbDiff.WinClient.Forms.DbItems.UcDbListBase.FireRowSelectEvent(Object sender, RowClickEventArgs e) in d:\work\DbDiff_Codeplex\DbDiffWinClient\Forms\DbItems\ucDbListBase.cs:line 265
at DbDiff.WinClient.Forms.DbItems.UcDbDiffList.ShowSelectedItem(Int32 rowPosition) in d:\work\DbDiff_Codeplex\DbDiffWinClient\Forms\DbItems\ucDbDiffList.cs:line 132
at DbDiff.WinClient.Forms.DbItems.UcDbDiffList.SetData(DataTable data, String filterExpression, DatabaseObjectTypes itemTypeInfo) in d:\work\DbDiff_Codeplex\DbDiffWinClient\Forms\DbItems\ucDbDiffList.cs:line 273
at DbDiff.WinClient.Forms.DbItems.UcTableDiff.UpdateFormData() in d:\work\DbDiff_Codeplex\DbDiffWinClient\Forms\DbItems\ucTableDiff.cs:line 149
at DbDiff.WinClient.Forms.DbItems.UcDbItemBase.ShowView() in d:\work\DbDiff_Codeplex\DbDiffWinClient\Forms\DbItems\ucDbItemBase.cs:line 137
at DbDiff.WinClient.Forms.FrmMain.DiffTreeView_AfterSelect(Object sender, TreeViewEventArgs e) in d:\work\DbDiff_Codeplex\DbDiffWinClient\Forms\frmMain.cs:line 1349
Message: Specified cast is not valid.
Source: DbDiff.Common
Stacktrace: at DbDiff.Common.DataAccess.DbObjectsDs.IndexRow.get_IsXmlIndex() in d:\work\DbDiff_Codeplex\DbDiffCommon\DataAccess\DbObjectsDs.cs:line 14166

comments