ERROR

“ERROR 160277: The row contains a bad value” when executing Update Subnetwork on a subnetwork with many subnetwork controllers

Last Published: May 3, 2021

Error Message

When running Update Subnetwork against a subnetwork with a large number of subnetwork controllers, the process can fail with the error:

"Error 160277: The row contains a bad value."
This indicates that an invalid value was detected when performing the operation. In some versions, this issue may also display the following error:
"Error 002981: Value exceeds valid range of column."

Cause

When the SubnetLine feature class is updated during the Update Subnetwork process, the names of all subnetwork controllers in the subnetwork are concatenated in the SUBNETWORKCONTROLLERNAMES field. For example: 383030-802::383030-847::383030-991::383030-992

When there are a large number of subnetwork controllers in the subnetwork, the concatenated values can exceed the character limit set for the SUBNETWORKCONTROLLERNAMES field, causing the operation to fail.

Solution or Workaround

Note:
Ensure that you create a backup before proceeding.  A backup is a critical step when making any schema change.

Changes were made with the release of ArcGIS Pro 2.7 to increase the length of the SUBNETWORKCONTROLLERNAMES field on the SubnetLine feature class for new domain networks.  This change updates the data type of the field to support the MAX value for strings in each respective RDBMS; however, these updates only apply to newly created domain networks.  This field is not updated for existing domain networks when performing an upgrade.   The SUBNETWORKCONTROLLERNAMES field on the SubnetLine feature class can be updated manually through an ALTER TABLE command to prevent this error from occurring when working with existing domain networks.

To make this change, complete the following steps:

  1. Create or ensure that you have a backup to prevent the potential of any data loss.
  2. Stop your utility network services prior to making this change. 
  3. Update the length of the SUBNETWORKCONTROLLERNAMES field in SubnetLine using an ALTER TABLE command.
  • SQL Server
    ALTER TABLE <domain_network_name>subnetline ALTER COLUMN subnetworkcontrollernames nvarchar(max) NOT NULL;
  • Oracle
    ALTER TABLE <domain_network_name>subnetline MODIFY (subnetworkcontrollernames NCLOB NOT NULL);
  • PostgreSQL
    ALTER TABLE <domain_network_name>subnetline ALTER COLUMN subnetworkcontrollernames TYPE TEXT;
  • SAP HANA
    Alter table <domain_network_name>subnetline ALTER (subnetworkcontrollernames NCLOB NOT NULL);
  1.     Restart utility network services for the new column length to be picked up.

Article ID:000025432

Software:
  • ArcGIS Pro 2 7 x

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options

Discover more on this topic