Latest Contributions by 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!!   ... View more

I believe I have successfully set up a Sanitary Utility Network in a file geodatabase and I am attempting to migrate it to our Enterprise geodatabase following the help on configuring a multiuser environment from the Foundation help page.  I copy the Utility Network feature dataset from the FGDB and paste it into the Enterprise Database connection that has been set up for the user I wish to be the Utility Network owner in the Catalog pane in ArcGIS Pro (version 3.4.3).  It goes through the copy process for a few minutes and then stops with the following error: I did modify some other database sequences for some of the Generate ID attribute rules, but I never touched this sequence.  I thought maybe I deleted this one by mistake, so then I try to recreate it and I get the error that the sequence already exists.  I also checked the attribute rule that it references to make sure the spelling of the sequence name never changed and it is still named the same. Any help regarding fixing this error or working around it would be much appreciated! ... View more

I am attempting to set up subnetworks in our Sewer Utility Network in a file geodatabase and I am trying to use the Directional Manhole Channels as the subnetwork controllers for our Sewershed subnetwork.  They are set up just like the regular Manhole Channels, with the Pipe Connections at the end of the Gravity Mains and those Pipe Connections are associated with the Manhole Channel (and all in containment of the Manhole Sewer/Storm Vault).  I change the Manhole Channel to a Directional Manhole Channel and then Modify the Subnetwork Controller to give it a name and define what subnetwork it controls.  But when I go to Modify the Terminal Connections I cannot select the line features for the Upstream and Downstream terminals.  I found that if I connect the mains directly to the Directional Manhole Channel I can select the mains and define the terminals, and I seem to be able to validate and get no errors and run the Update Subnetwork GP tool to propagate the subnetwork name upstream. I see in the Naperville data that the Directional Manhole Channels aren't directly connected to the main, they have the Pipe Connections just like the regular Manhole Channels, and it seems to be the subnetwork controller for the sewershed. So my question is there something I'm missing in order to set terminal connections on the Directional Manhole Channel subnetwork controller with mains using Pipe Connections?  Or do the mains have to be directly connected to the Directional Manhole Channels in order for them to be used as subnetwork controllers? ... View more

I am just beginning the migration of our Sanitary Sewer network to the Utility Network using the Sewer Utility Network Expanded Foundation solution V2.2.  I have created my Simple Data Mapping spreadsheet (Data Mapping.xlsx) and have filled out most of it.  I have completed the Data Mapping, Associations, and Exclude Copy Fields sheets, but am having a hard time understanding the Mapping Table sheet.  I've read the Info sheet regarding the Mapping Table but cant really make heads or tails of what I'm supposed to do in there.  I've seen a couple of tutorials on filling out this Data Mapping spreadsheet and none of them have any examples of what to do on this sheet.  Are there any examples of how to fill this sheet out that I haven't found? ... View more