Duplicate Value Project Tab

Problem:

When clicking the Projects Tab within the Si5.5 Navigator the application crashes with the following error message.

Description: A duplicate value cannot be inserted into a unique index. [ Table name = ProjectFileInfo,Constraint name = IX_FMProjectFile ]

Email:

User Message:

Details: Error: SqlCeException HResult=-2147217873 (DTools.FileManager.ProjectService.syncLocalCache) (DTools.FileManager.ProjectService.GetProjectInfoList) (DTools.SystemIntegrator.Navigator.NavigatorShell.ApplyProjectFilter) (DTools.SystemIntegrator.Navigator.ProjectListControl.applyProjectListArchivedFilter) (DTools.SystemIntegrator.Navigator.ProjectListControl.UltraToolbarsManager1_ToolValueChanged) (Infragistics.Win.UltraWinToolbars.UltraToolbarsManager.OnToolValueChanged) (Infragistics.Win.UltraWinToolbars.UltraToolbarsManager.FireEvent) (Infragistics.Win.UltraWinToolbars.ComboBoxTool.ComboBoxToolExtraSharedProps.SetValue) (Infragistics.Win.UltraWinToolbars.ComboBoxTool.set_Value) (Infragistics.Win.UltraWinToolbars.ComboBoxTool.set_EditValue) (Infragistics.Win.UltraWinToolbars.ComboBoxTool.set_SelectedIndex) (Infragistics.Win.UltraWinToolbars.ComboBoxTool.set_SelectedItem) (DTools.SystemIntegrator.Navigator.ProjectListControl.navShell_ActiveViewChanged) (DTools.SystemIntegrator.Navigator.Common.INavigatorShell.ActiveViewChangedEventHandler.Invoke) (DTools.SystemIntegrator.Navigator.NavigatorShell.set_ActiveView) (DTools.SystemIntegrator.Navigator.NavigatorShell.OnShowProjectsListView) (DTools.SystemIntegrator.Navigator.CommandManagement.Command.Execute) (DTools.SystemIntegrator.Navigator.CommandManagement.UltraExplorerBarGroupCommandExecutor.explorerBar_GroupClick) (Infragistics.Win.UltraWinExplorerBar.UltraExplorerBar.OnGroupClick) (Infragistics.Win.UltraWinExplorerBar.UltraExplorerBar.FireEvent) (Infragistics.Win.UltraWinExplorerBar.UltraExplorerBarGroup.DoHeaderClick) (Infragistics.Win.UltraWinExplorerBar.UltraExplorerBarGroupHeaderUIElement.OnClick) (Infragistics.Win.ControlUIElementBase.ProcessMouseUpHelper) (Infragistics.Win.ControlUIElementBase.ProcessMouseUp) (Infragistics.Win.Utilities.ProcessEvent) (Infragistics.Win.UltraControlBase.OnMouseUp) (Infragistics.Win.UltraWinExplorerBar.UltraExplorerBar.OnMouseUp) V5.5.0.0

Errors=System.Data.SqlServerCe.SqlCeErrorCollection

HResult=-2147217873 (0x80040E2F)

NativeError=25016 (0x61B8)

Message=A duplicate value cannot be inserted into a unique index. [ Table name = ProjectFileInfo,Constraint name = IX_FMProjectFile ]

Data=System.Collections.ListDictionaryInternal

Solution:

The solution to this problem is quite simple.  You just need to rename the LocalFileManager.sdf file to OldLocalFileManager.sdf and have the file regenerated by our application.

1.      Navigate to the LocalFileManager.sdf file.  This file can be found at the following locations depending on your version of Windows:

XP: C:\Documents and Settings\{your username}\Application Data\D-Tools\SI 5\LocalFileManager.sdf

Vista/7:  C:\Users\{your username}\AppData\Roaming\D-Tools\SI5\LocalFileManager.sdf

2.      Rename the LocalFileManager.sdf file to OldLocalFileManager.sdf

3.      Restart Si5.5

Solution applies to System Integrator versions 5.5 and higher.

If you are still experiencing this issue after performing the above steps then please contact our support team by submitting an issue on our website.