Solution - Fiber Manager - Connection Manager Unhandled Exception: A column named 'BackPort_Num already belongs to this data table.

Version 4

    Behavior

     

    When attempting to open Connection Manager for a patch location feature, an error message similar to the following is received:

    already belongs to this data table.jpg

    (Unhandled Exception

    A column named 'BackPort_Num' already belongs to this DataTable.)

     

    The following error may be reported in the Miner Event Viewer log:

     

     

    2013-09-03 12:19:32,122 [1] ERROR Miner.Desktop.FiberManager.ConnectionManager [(null)] - System.Data.DuplicateNameException: A column named 'BackPort_Num' already belongs to this DataTable.

       at System.Data.DataColumnCollection.RegisterColumnName(String name, DataColumn column, DataTable table)

       at System.Data.DataColumnCollection.BaseAdd(DataColumn column)

       at System.Data.DataColumnCollection.AddAt(Int32 index, DataColumn column)

       at System.Data.DataColumnCollection.Add(DataColumn column)

       at Miner.Framework.FiberManager.UniversalConnectableDataTable.CreateColumnsFromRow(IRow row)

       at Miner.Framework.FiberManager.UniversalConnectableDataTable.DescendAndCreateColumnsNoQuery(IRow row, List`1 currentList)

       at Miner.Framework.FiberManager.UniversalConnectableDataTable.DescendAndCreateColumnsNoQuery(IRow row, List`1 currentList)

       at Miner.Framework.FiberManager.UniversalConnectableDataTable.DescendAndCreateColumnsNoQuery(IRow row, List`1 currentList)

       at Miner.Framework.FiberManager.UniversalConnectableDataTable.InitializeData()

       at Miner.Framework.FiberManager.FiberDataSetFactory.DescendTreeToCreateTables(IRow row, List`1 ancestors, List`1 currentList)

       at Miner.Framework.FiberManager.FiberDataSetFactory.DescendTreeToCreateTables(IRow row, List`1 ancestors, List`1 currentList)

       at Miner.Framework.FiberManager.FiberDataSetFactory.DescendTreeToCreateTables(IRow row, List`1 ancestors, List`1 currentList)

       at Miner.Framework.FiberManager.FiberDataSetFactory.CreateLocationDataSet(String displayFieldModelName, IFeature feature)

       at Miner.Desktop.FiberManager.ConnectionManager.ShowConnectionManager(IFeature feature)

       at Miner.Desktop.FiberManager.ConnectionManager.OnMouseDown(Int32 Button, Int32 Shift, Int32 X, Int32 Y)

    {log4net:HostName=PT-620093, LoggingAssemblyFileVersion=10.11.0.263}

     

    Cause

     

    This error will occur if the FIBERCONNECTIONDISPLAYFIELD and FIBERCONNECTIONDISPLAYSORTFIELD model names have both been assigned to the column named in the error.

     

    Solution

     

    The FIBERCONNECTIONDISPLAYFIELD and FIBERCONNECTIONDISPLAYSORTFIELD model names should not be assigned to the same column.
    Use the ArcFM Properties Manager in ArcCatalog to remove one of the model names from the field mentioned in the error.

     

    Visit the ArcFM Solution Resource Center for information about how to manage model names for feature and table classes.

    ArcFM Solution Resource Center