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."
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.
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: