Create Migration Workspace error

[Brian_Laws]

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!!  

[MikeMillerGIS]

If you can package up a repo case(schema only), I can look a look.  Reviewing the source, it has something to do with the source to target mapping and subtypes.  It should be looking at the subtype name.  Do you have subtypes who description is a number?

[Brian_Laws]

Hi Mike,

No, we don't have any subtypes in our geometric network data.  How do I package up a repo case for you to look at?

[MikeMillerGIS]

I would need the source and target database in a fgdb.  Do not need the Geometric network.  Also the data mapping spreadsheet.

[Brian_Laws]

Thanks Mike.  I'll follow up via email with those files.

[Brian_Laws · Accepted solution]

To close out this question, Mike discovered what my issue was.  In the Simple Data Mapping spreadsheet I was attempting to create new Asset Types that were only numbers:

Even setting the column as text would still result in them being seen as numbers by the GP tool.  So I added some text in there in addition to the numbers and was able to run the Create Migration Workspace tool successfully.