topic Re: Cannot truncate UN feature classes in ArcGIS Utility Network Questions

Cannot truncate UN feature classes

JohnHu — Wed, 28 Aug 2024 17:52:59 GMT

I am working on an UN mobile geodatabase and use this for initial data loading from other existing feature class using FME form. One major problem is that I cannot truncate the existing UN feature class such as ElectricLine, ElectricJuntion etc using FME writer truncating option. I need this function to work so I can reload data into UN feature classes based on problems, incorrect data mapping, or simply to make attribute corrections using my FME workbench. Please help and let me know how I can resolve this issue and can truncate existing UN feature classes in order to do corrections for my data loading. My electric UN mobile geodatabase is based on UN 6 for ArcGIS Pro 3.2, and Enterprise 11.0, or Electric UN V2.2. Thanks.

Re: Cannot truncate UN feature classes

JoaquinMadrid1 — Wed, 28 Aug 2024 18:15:55 GMT

If your target is a UN... could deletion semantics be a reason for this failure to truncate?

Re: Cannot truncate UN feature classes

JohnHu — Wed, 28 Aug 2024 18:46:02 GMT

Yes, my target is UN and I am working on a copied version of UN mobile geoedatabase. I am still new to UN and cannot answer your question. For now, I just need to be able to truncate the FCs and reload in order to get data right for UN FCs.

Re: Cannot truncate UN feature classes

RobertKrisher — Wed, 28 Aug 2024 19:15:18 GMT

Instead of truncating the data, you can just delete the data using the Delete Rows tool. Another option you could consider is taking a backup of your database prior to loading the data that you can restore back to. Finally, if you make any schema or configuration changes you will likely want to drop and recreate the database.

Re: Cannot truncate UN feature classes

MikeMillerGIS — Wed, 28 Aug 2024 21:20:57 GMT

I also would suggest loading into an asset package and creating a new UN if you can. It might actually be faster.

Re: Cannot truncate UN feature classes

SillPaul — Wed, 22 Jan 2025 22:07:55 GMT

Was there ever a published process or geoprocessing tool to cleanly remove a Utility Network from an existing enterprise geodatabase? We are iterating through schema changes in our test environment, and have attempted to delete the UN. We weren't successful and have gone back to a restore point as a result.

From what little we've found on this scenario - it seems like an entirely new database (Oracle) and enterprise geodatabase may be the best option. This is especially true given that this is a test environment.