topic Re: Utilities Abandon Features Tool Not Working with Enterprise Geodatabase? in State & Local Government Questions

Utilities Abandon Features Tool Not Working with Enterprise Geodatabase?

AlanToms — Sat, 11 Dec 2021 23:01:33 GMT

Hello,

I am having an issue with the Abandon Features script from the Water Utility Network Editing tools.

I am trying to abandon a feature from the wMain feature class. If the the abandon features are set to go to the wAbandonedLine feature class on my enterprise geodatabase it will fail with the below message. If I set it to the wAbandonedLine in the file geodatabase that came with the tools it works fine. It is a 10.1 SP1 environment. The enterprise geodatabase is using the SQL geometry spatail type. Any ideas?

Executing: AbandonFeatures 'Water Mains' "Water Abandoned Lines" "Water Abandoned Points" true LINETYPE POINTTYPE "Record Set"
Start Time: Fri May 10 09:05:12 2013
Running script AbandonFeatures...
Starting Abandon Selected Features Script
Processing Parameters
Abandoning Selected Features in GISData.GISADMIN.wMain
Water Mains is a Polyline with 1 selected
Traceback (most recent call last):
  File "C:\IS_Support\UtilityNetworkEditingfor10.1\Application\Abandon Tools\AbandonSelectedFeatures.py", line 204, in <module>
    newRow.setValue(fieldName, row.getValue(fieldName))
  File "c:\program files (x86)\arcgis\desktop10.1\arcpy\arcpy\arcobjects\arcobjects.py", line 1040, in setValue
    return convertArcObjectToPythonObject(self._arc_object.SetValue(*gp_fixargs(args)))
RuntimeError: ERROR 999999: Error executing function.
Field is not editable.
ERROR 999999: Error executing function.
Field is not editable.
Script Complete
Completed script AbandonFeatures...
Failed to execute (AbandonFeatures).
Failed at Fri May 10 09:05:13 2013 (Elapsed Time: 1.00 seconds)

Re: Utilities Abandon Features Tool Not Working with Enterprise Geodatabase?

MikeMillerGIS — Thu, 13 Jun 2013 15:44:05 GMT

Alan,
Are both the water layers and the abandon layers editable?

Re: Utilities Abandon Features Tool Not Working with Enterprise Geodatabase?

AlanToms — Thu, 13 Jun 2013 15:50:37 GMT

Alan,
Are both the water layers and the abandon layers editable?

Yes, I can edit the feature classes.

Re: Utilities Abandon Features Tool Not Working with Enterprise Geodatabase?

AlanToms — Thu, 13 Jun 2013 15:52:53 GMT

I do have a few additional fields in the wMain feature class that are not part of the local gov schema, but I don't think that is the issue because the tool works when it outputs to the file geodatabase. /shrug

Re: Utilities Abandon Features Tool Not Working with Enterprise Geodatabase?

MikeMillerGIS — Thu, 13 Jun 2013 15:53:57 GMT

Are you in an edit session and you can edit both layers when you run the tools?

Re: Utilities Abandon Features Tool Not Working with Enterprise Geodatabase?

MikeMillerGIS — Thu, 13 Jun 2013 15:59:44 GMT

Alan,
I just tested the tools using a SQL Server based GDB and they work. Both the Abandon and the Network layers need to be editable and an active edit session needs to be started. This was using the sample data provided.

If you can repro the issue with your instance, can you log a tech support call? It could be something with the additional fields. Did you add fields to the abandon layers? If so, it trys to loop through them and if it finds them in the network layers, it trys to copy them.

Re: Utilities Abandon Features Tool Not Working with Enterprise Geodatabase?

AlanToms — Thu, 13 Jun 2013 16:00:55 GMT

Are you in an edit session and you can edit both layers when you run the tools?

Yes I have been in an edit session and verified I could edit when I attempted to run the tool. The tool still does fails when selecting the abandoned features on the enterprise database.

Re: Utilities Abandon Features Tool Not Working with Enterprise Geodatabase?

LanceCole — Sat, 11 Dec 2021 23:01:35 GMT

I just ran into this on the newest version (2/2017) as well, on both GBD and SDE enterprise databases. After looking into the issue further found the python scripts AbandonFeatures.py and UnAbandonAssets.py were trying to modify the GlobalID fields which are not editable. If your database is not utilizing Global id's the script works great. To correct this three lines of code need to be modified to exclude modifying the GlobalID values. In AbandonFeatures.py lines 203 and 244 by appending code to exclude GlobalID.

202 for fieldName in fieldListLines:
203    if fldInfo.findFieldByName(fieldName) >= 0 and fieldName != "GlobalID":
204       arcpy.AddMessage("fieldName: " + fieldName)
205       newRow.setValue(fieldName, row.getValue(fieldName))

...

243 for fieldName in fieldListPoints:
244    if fldInfo.findFieldByName(fieldName) >= 0 and fieldName != "GlobalID":
245       newRow.setValue(fieldName, row.getValue(fieldName))
‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

And in line 205 of UnAbandonAssets.py the same.

204 for fieldName in fieldList:
205    if targetFldInfo.findFieldByName(fieldName) >= 0 and fieldName != "GlobalID":
206       newRow.setValue(fieldName, row.getValue(fieldName))‍‍‍‍‍‍‍‍‍

Re: Utilities Abandon Features Tool Not Working with Enterprise Geodatabase?

PaulLeBlanc1 — Wed, 03 May 2017 16:45:10 GMT

Lance,

We recently released a preview version of the abandon/unabandon tools that fixes the issue of non-editable fields + a host of others. You can find it here.

Re: Utilities Abandon Features Tool Not Working with Enterprise Geodatabase?

LanceCole — Wed, 03 May 2017 21:01:58 GMT

Paul,

Thanks for the updated tools, they appear to be working. I did find one

other sudo glitch.

When you unabandon Water Hydrant Valves or Water System Valves they do not

initially show. The “HYDRFLAG” comes back in as NULL and will not display

because of the Definition Query on these two layers. I reset one layer to

include “OR HYDRFLAG IS NULL” so it will at least display.

Re: Utilities Abandon Features Tool Not Working with Enterprise Geodatabase?

AllysonReynolds2 — Wed, 08 Nov 2017 21:51:39 GMT

Paul,

This link appears to be dead. Is there a new version of the tools that includes this fix?

Thanks

Re: Utilities Abandon Features Tool Not Working with Enterprise Geodatabase?

LanceCole — Thu, 09 Nov 2017 00:52:51 GMT

Allyson,

The most recent version is available at Esri/local-government-desktop-addins

Re: Utilities Abandon Features Tool Not Working with Enterprise Geodatabase?

AlexBryan — Thu, 15 Feb 2018 16:00:25 GMT

I'm experiencing a problem with the most recent version of the tool. In this instance, I'm attempting to abandon features in two feature classes: water mains and fittings. All feature classes are editable and exist in the same SDE database. When I execute the Abandon Features tool, I receive this result:

Executing: AbandonFeatures 'Water Network\Watermain';'Water Network\Fitting' "Water Network\Abandoned\ABD Line" "Water Network\Abandoned\ABD Point" false LAYER_NAME LAYER_NAME "Record Set"
Start Time: Thu Feb 15 10:55:36 2018
Running script AbandonFeatures...
error on line: line 266
error in file name: <string>
with error message: IOError: "\watd.DBO.WaterAbandonedFeatures\watd.DBO.ABDPoint" does not exist
Completed script AbandonFeatures...
Failed to execute (AbandonFeatures).
Failed at Thu Feb 15 10:55:38 2018 (Elapsed Time: 2.56 seconds)

Any help would be greatly appreciated. Thanks!

Re: Utilities Abandon Features Tool Not Working with Enterprise Geodatabase?

LanceCole — Thu, 15 Feb 2018 16:40:24 GMT

Alex,

Does the tools work when you have just a single water main or a single fitting selected to be abandoned?

Re: Utilities Abandon Features Tool Not Working with Enterprise Geodatabase?

AlexBryan — Wed, 28 Feb 2018 19:45:59 GMT

It does not. The tool works fine if I move the abandon layers to a file geodatabase.

Re: Utilities Abandon Features Tool Not Working with Enterprise Geodatabase?

LanceCole — Wed, 28 Feb 2018 21:10:14 GMT

A few more questions/suggestions:

Do you get the same error for linear features that references the appropriate abandon feature class, ie lines for lines?

From the MXD you are using to abandon the features to the SDE connection:

enter an edit session to the SDE database.
select a single linear feature, a water line segment for example.
from the edit menu select cut, then select paste
in the paste dialog select the water abandoned lines layer as the target and click OK. You may need to zoom into the a level the abandoned features are visible, for it to display in the dialog drop down

Did this paste into the abandoned FC? If not, you have a permissions issue with the DB.

Try the same for a point feature and the abandon point layer

When you are using the abandoned feature tool, try dragging the abandoned line layer and abandoned point layer from your TOC to the appropriate drop down on the tool and drop them. Then try and abandon a single feature. The path name in the error message you provided does not look correct for an SDE connection. I am working on a production system at the moment so I cannot experiment to get a error message for comparison.

Re: Utilities Abandon Features Tool Not Working with Enterprise Geodatabase?

AlexBryan — Thu, 01 Mar 2018 16:43:40 GMT

We've been able to troubleshoot the issue. The features I'm attempting to abandon are in a geometric network and therefore in a feature dataset. The ABDPoint and ABDLine FCs are also contained in this feature dataset. The tool is failing to recognize the catalog path to the feature dataset. The tool will work if the features being abandoned and the ABD FCs are all outisde of a feature dataset.

This makes this tool unusable for anyone attempting to abandon any features in a feature dataset or geometric network?