I have begun the process of migrating our Water Distribution network from the geometric network to the utility network. I've created the Simple Mapping spreadsheet and have it filled out and now I am attempting to run the Create Migration Workspace tool but I get the following error:
Create Migration Workspace
=====================
Tool Path
V:\GIS\Development\PublicWorks\Water\Water Distribution Utility Network Foundation V2_2 Expanded\Toolboxes\UtilityDataManagementSupport.atbx\CreateMigrationWorkspace
=====================
Parameters
Source Dataset C:\Users\blaws\AppData\Roaming\Esri\ArcGISPro\Favorites\ForAppTesting GIS DEFAULT nwkgisdb.sde\ForAppTesting.GIS.WaterDistribution
Asset Package V:\GIS\Development\PublicWorks\Water\Water Distribution Utility Network Foundation V2_2 Expanded\Data Model\Newark_WaterExpanded_AssetPackage.gdb
Data Mapping Spreadsheet V:\GIS\Development\PublicWorks\Water\Water Distribution Utility Network Foundation V2_2 Expanded\Migration Workspace\SimpleDataMapping_01\DataMapping.xlsx
Service Territory Polygon V:\GIS\Development\PublicWorks\Water\Water Distribution Utility Network Foundation V2_2 Expanded\Water Utility Network Expanded.gdb\UNServiceBoundary
Output Location V:\GIS\Development\PublicWorks\Water\Water Distribution Utility Network Foundation V2_2 Expanded\Migration Workspace
Output Folder Name CON_Water_Migration_01
Data Loading Mapping Table in_memory\record_set1
Copy Fields COPY_FIELDS
Extended Asset Package \\
Data Loading Workspace \\
Predictive Field Matching Options MATCH_FIELDS;MATCH_VALUES
Calculate Row Count Statistics NO_STATS
Create Matches by Subtype DONT_MATCH
=====================
Messages
Start Time: Wednesday, October 29, 2025 9:39:40 AM
ArcGIS Pro 3.4.3.55405
udms 3.3.3
Executing from ArcGIS Pro, 2 map(s), activeMap = False
Loading Workbook
Validating data mappings
Calculating new asset types
8 new asset types in mapping spreadsheet
Traceback (most recent call last):
File "V:\GIS\Development\PublicWorks\Water\Water Distribution Utility Network Foundation V2_2 Expanded\Toolboxes\UtilityDataManagementSupport.atbx\CreateMigrationWorkspace.tool\tool.script.execute.py", line 26, in <module>
File "V:\GIS\Development\PublicWorks\Water\Water Distribution Utility Network Foundation V2_2 Expanded\Toolboxes\UtilityDataManagementSupport.atbx\udms\esri.py", line 547, in wrapper
File "V:\GIS\Development\PublicWorks\Water\Water Distribution Utility Network Foundation V2_2 Expanded\Toolboxes\UtilityDataManagementSupport.atbx\udms\logic\__init__.py", line 1113, in create_simple_mapping
File "V:\GIS\Development\PublicWorks\Water\Water Distribution Utility Network Foundation V2_2 Expanded\Toolboxes\UtilityDataManagementSupport.atbx\udms\sumt\SchemaBuilder.py", line 751, in main
File "V:\GIS\Development\PublicWorks\Water\Water Distribution Utility Network Foundation V2_2 Expanded\Toolboxes\UtilityDataManagementSupport.atbx\udms\sumt\SchemaBuilder.py", line 126, in create_final_data_mapping
File "C:\Users\blaws\AppData\Local\ESRI\conda\envs\arcgispro-py3-UtilityNetwork\Lib\site-packages\pandas\core\frame.py", line 9423, in apply
return op.apply().__finalize__(self, method="apply")
^^^^^^^^^^
File "C:\Users\blaws\AppData\Local\ESRI\conda\envs\arcgispro-py3-UtilityNetwork\Lib\site-packages\pandas\core\apply.py", line 678, in apply
return self.apply_standard()
^^^^^^^^^^^^^^^^^^^^^
File "C:\Users\blaws\AppData\Local\ESRI\conda\envs\arcgispro-py3-UtilityNetwork\Lib\site-packages\pandas\core\apply.py", line 798, in apply_standard
results, res_index = self.apply_series_generator()
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "C:\Users\blaws\AppData\Local\ESRI\conda\envs\arcgispro-py3-UtilityNetwork\Lib\site-packages\pandas\core\apply.py", line 814, in apply_series_generator
results[i] = self.f(v)
^^^^^^^^^
File "V:\GIS\Development\PublicWorks\Water\Water Distribution Utility Network Foundation V2_2 Expanded\Toolboxes\UtilityDataManagementSupport.atbx\udms\sumt\SchemaBuilder.py", line 134, in <lambda>
AttributeError: 'float' object has no attribute 'casefold'
Failed script Create Migration Workspace...
Failed to execute (CreateMigrationWorkspace).
Failed at Wednesday, October 29, 2025 9:47:08 AM (Elapsed Time: 7 minutes 28 seconds)
I've run the tool many times but it gets almost all the way finished but just fails right at the end with the same error every time. Any help would be appreciated!!
