topic Re: python Error 999999 in duplicate append script. in Python Questions

python Error 999999 in duplicate append script.

Laura_m_Conner — Tue, 27 Jun 2023 17:15:22 GMT

All,
Recently we have finished innovatory of curbed streets. The curbed streets were appended into a new feature class in batches as an area was finished. Now I am checking to make sure no street segment got appended twice. I have written/modified it the script from Delete the older records of duplicate features after using the Append tool in ArcGIS Pro, for our data.

I am encountering Error 999999. None of the advice from 999999: Something unexpected caused the tool to fail seems applicable. There is no output file, only the original input file is being modified. There is no geometry network. The used fields do not have any null values. Given where it fails in the script, size should not be an issue. Also, there are only about 9,600 records in the table currently. For testing the script, I am running this on a copy of the data set exported from the enterprise geodatabase to the project database. once the script works, it will be run on the enterprise geodatabase copy. I am unable to test it in administrator mode, but I don't see a reason why this should be an issue.

How do I get the script working, or at least get past this error? Any insight is appreciated.
Script:

import arcpy fc = "StormCurbedStr_ExportFeature" feilds = ["FULLNAME","curb","Shape"] cursor = arcpy.UpdateCursor(fc, feilds) keepList = list() for row in cursor: row_val_0 = row.getValue(feilds[0]) row_val_1 = row.getValue(feilds[1]) row_val_2 = row.getValue(feilds[2]) row_val = row_val_0 + row_val_1 + str(row_val_2) if row_val not in keepList: keepList.append(row_val) elif row_val in keepList: cursor.deleteRow(row) else: pass print("done")

error:

RuntimeError Traceback (most recent call last) In [5]: Line 7: cursor = arcpy.UpdateCursor(fc, feilds) File C:\Program Files\ArcGIS\Pro\Resources\ArcPy\arcpy\__init__.py, in UpdateCursor: Line 1234: return gp.updateCursor(dataset, where_clause, spatial_reference, fields, sort_fields) File C:\Program Files\ArcGIS\Pro\Resources\ArcPy\arcpy\geoprocessing\_base.py, in updateCursor: Line 374: self._gp.UpdateCursor(*gp_fixargs(args, True))) RuntimeError: ERROR 999999: Something unexpected caused the tool to fail. Contact Esri Technical Support (http://esriurl.com/support) to Report a Bug, and refer to the error help for potential solutions or workarounds

notes:

Arcpro 3.1.0

OS: Mircrosoft windows 10 pro for workstations

Thank You.

Laura

Re: python Error 999999 in duplicate append script.

AlfredBaldenweck — Tue, 27 Jun 2023 17:19:49 GMT

Typically cursors are done with a "with"

Not sure if this would actually change anything, but maybe give it a shot?

import arcpy fc = "StormCurbedStr_ExportFeature" feilds = ["FULLNAME","curb","Shape"] keepList = list() with arcpy.UpdateCursor(fc, feilds) as cursor: for row in cursor: row_val_0 = row.getValue(feilds[0]) row_val_1 = row.getValue(feilds[1]) row_val_2 = row.getValue(feilds[2]) row_val = row_val_0 + row_val_1 + str(row_val_2) if row_val not in keepList: keepList.append(row_val) elif row_val in keepList: cursor.deleteRow(row) else: pass print("done")

Re: python Error 999999 in duplicate append script.

Laura_m_Conner — Tue, 27 Jun 2023 18:25:15 GMT

thanks for the reply

I have tried it and got the same error.

Re: python Error 999999 in duplicate append script.

AlfredBaldenweck — Tue, 27 Jun 2023 18:30:48 GMT

Well, it was worth a shot.

The other thing that isn't clear from your code sample is if you're actually inputting the feature class or just its name.

Like, is your fc variable r"Documents\Projects\Example.gdb\StormCurbedStr_ExportFeature", or is it r"StormCurbedStr_ExportFeature" and you just censored it to share?

Re: python Error 999999 in duplicate append script.

Laura_m_Conner — Tue, 27 Jun 2023 18:37:34 GMT

to clarify I am running the script inside the arc pro in a notebook. what i put in the post is verbatim what I have.

Re: python Error 999999 in duplicate append script.

AlfredBaldenweck — Tue, 27 Jun 2023 18:40:07 GMT

Okay yeah, you need to actually give it the full name of whatever feature class you have.

Currently you're giving it just the name of the feature class without the full path, which is like telling someone to find "John". John who?

Re: python Error 999999 in duplicate append script.

Laura_m_Conner — Tue, 27 Jun 2023 18:59:14 GMT

well it fisxed that error but gave me another one. right now the script is

import arcpy fc = r"N:\laura\edit_map4\edit_map4.gdb\StormCurbedStr_ExportFeature" feilds = ["FULLNAME","curb","Shape"] keepList = list() with arcpy.UpdateCursor(fc, feilds) as cursor: for row in cursor: row_val_0 = row.getValue(feilds[0]) row_val_1 = row.getValue(feilds[1]) row_val_2 = row.getValue(feilds[2]) row_val = row_val_0 + row_val_1 + str(row_val_2) if row_val not in keepList: keepList.append(row_val) elif row_val in keepList: cursor.deleteRow(row) else: pass print("done")

the current error:

AttributeError Traceback (most recent call last) In [10]: Line 7: with arcpy.UpdateCursor(fc, feilds) as cursor: AttributeError: __enter__

Re: python Error 999999 in duplicate append script.

AlfredBaldenweck — Tue, 27 Jun 2023 19:12:12 GMT

Not sure if this will fix this error, but:

You are using the old UpdateCursor, whose parameters must be put in the following order:

UpdateCursor (dataset, {where_clause}, {spatial_reference}, {fields}, {sort_fields})

Try arcpy.UpdateCursor(fc, fields= feilds) to call the fields parameter out of order.

Alternatively, if you want to keep it as you've already written, change to the new arcpy.da.UpdateCursor() , which uses the parameter order you're currently using

arcpy.da.UpdateCursor (in_table, field_names, {where_clause}, {spatial_reference}, {explode_to_points}, {sql_clause}, {datum_transformation}, {explicit})

Re: python Error 999999 in duplicate append script.

Laura_m_Conner — Tue, 27 Jun 2023 19:39:07 GMT

ok i have updated the updatecursor function to and ran the script. the next error is...

AttributeError Traceback (most recent call last) In [13]: Line 10: row_val_0 = row.getValue(feilds[0]) AttributeError: 'list' object has no attribute 'getValue'

Re: python Error 999999 in duplicate append script.

AlfredBaldenweck — Tue, 27 Jun 2023 19:47:39 GMT

If you switched to arcpy.da.UpdateCursor(), it changed the object that it's delivering to you from a row type to a tuple. Each row is (Fullname, curb, Shape)

Just call: row_value_0 = row[0] , etc.

Actually, you could probably shorten it to:

import arcpy fc = r"N:\laura\edit_map4\edit_map4.gdb\StormCurbedStr_ExportFeature" feilds = ["FULLNAME","curb","Shape"] keepList = list() with arcpy.UpdateCursor(fc, feilds) as cursor: for row in cursor: row_val = row[0] + row[1] + str(row[2]) if row_val not in keepList: keepList.append(row_val) elif row_val in keepList: cursor.deleteRow(row) else: pass print("done")

Alternatively, you could try appending the entire row to keep list, rather than doing any sort of processing on it.

import arcpy fc = r"N:\laura\edit_map4\edit_map4.gdb\StormCurbedStr_ExportFeature" feilds = ["FULLNAME","curb","Shape"] keepList = list() with arcpy.UpdateCursor(fc, feilds) as cursor: for row in cursor: if row not in keepList: keepList.append(row) elif row in keepList: cursor.deleteRow(row) else: pass print("done")

Re: python Error 999999 in duplicate append script.

RhettZufelt — Tue, 27 Jun 2023 23:28:24 GMT

@AlfredBaldenweck this looks like in your first example above you meant to change to da.UpdateCursor since you are using the row[i] method instead of the getValue.

@Laura_m_Conner , this would be a good time to use the arcpy.da.UpdateCursor as it is has more power, much, much faster, and, at least for me, is easier to keep straight which field values are what.

Also, I don't see anywhere in the old arcpy.UpdateCursor documentation about how to grab the ("Shape" field).

With the arcpy.da.UpdateCursor, the field would be "SHAPE@" to grab the geometry object. Suspect this might be part of the issue.

Re: python Error 999999 in duplicate append script.

Laura_m_Conner — Wed, 28 Jun 2023 17:51:25 GMT

thank you. the script works and dose the job i need it to...for some reason it not checking all the duplicates. there is a handful left. now i need to work on figuring that out.

do you know of any good resources I can use in the future?

Re: python Error 999999 in duplicate append script.

RhettZufelt — Wed, 28 Jun 2023 18:01:05 GMT

I would start with the Find Identical GP tool and/or the Delete Identical GP tool.