Error adding fields to multiple classes with AddField_management

EdwardBlair — Mon, 09 Apr 2018 19:45:08 GMT

Hi -

Am trying to add a field to multiple classes in a File Geodatabase in ArcCatalog with a python script (below.) The script periodically errors on AddField_management returning a "General Function Failure". After the error I can't open the class and receive a "Can't edit object(s)" message box.

I've made sure that all classes are OK (can be opened and inspected) prior to running the script. So, I'm pretty sure there is something about the script that is causing a problem.

At first I though it might be the number of items in the class name list -- it seemed to fail on processing the 20th item. But now I'm not so sure.

Any insights on this would be greatly appreciated.

Thanks,

import arcpy

#Set the connection information

arcpy.env.workspace = "C:\Projects\Pilot_Test.gdb"

def FieldExist(featureclass, fieldname😞

fieldList = arcpy.ListFields(featureclass, fieldname)

fieldCount = len(fieldList)

if (fieldCount == 1😞

return True

else:

return False

try:

########################################################################

# Field properties for all new fields

########################################################################

fieldName = "FACILITYID"

aliasName = "Facility ID"

fieldType = "TEXT"

fieldLength = 20

########################################################################

# Iterate over classes

########################################################################

print("Add FACILITYID to classes")

classNames = ["cwFieldRestraint", "cwFitting", "cwPipe","AbandonedCurbBox","AbandonedWaterFitting",\

"AbandonedWaterMain","AbandonedWaterService",\

"AbandonedUGSecondary","AnchorGuy","BusBar","FaultCurrentZoneLimit",\

"FixedConsService","XY","PriOHElectricLineSegment","SecOHElectricLineSegment",\

"SecUGElectricLineSegment","ServicePoint","SpanGuy","Streetlight","Substation",\

"Transformer","TransmissionLine",\

"wCasing","wFitting","wCurbBox","wFieldRestraint","wMainTap","wMaintenanceTap",\

"wOffset","wPumpOut","wRawCasing","wRawFitting","wRawMain","wServicePoint",\

"wSludgeCasing","wSludgeFitting","wSludgeMain","wMain","wMeter","wService"]

for c in classNames:

if (not FieldExist(c, fieldName)):

arcpy.AddField_management(c, fieldName, fieldType, "", "", fieldLength, aliasName, "NULLABLE")

else:

print "Field " + fieldName + " already exists in class " + c

print("Fields added successfully")

print("Process completed")

except:

#If an error occurs when running Addfield, print out the error message.

print(arcpy.GetMessages())

Re: Error adding fields to multiple classes with AddField_management

DanPatterson_Retired — Mon, 09 Apr 2018 20:15:59 GMT

get rid of the \ in your list, there is no need for continuation as for strings, just hit enter after a comma to get a list to continue on to the next line... probably not related, but it could be an escape issue

Re: Error adding fields to multiple classes with AddField_management

JoshuaBixby — Mon, 09 Apr 2018 22:48:13 GMT

Sharing with https://community.esri.com/community/developers/gis-developers/python?sr=search&searchId=1259f14d-211d-4d62-a847-20ab2549ede3&searchIndex=0‌ space for more visibility.

Re: Error adding fields to multiple classes with AddField_management

EdwardBlair — Tue, 10 Apr 2018 00:22:46 GMT

Whaddya know...

Removed the \ from the list and that seems to have resolved my problem.

Thank you so much!

Re: Error adding fields to multiple classes with AddField_management

DanPatterson_Retired — Tue, 10 Apr 2018 00:26:20 GMT

Glad it worked Edward

You should mark it closed with the answer that solved the problem so others know what the solution was.

topic Re: Error adding fields to multiple classes with AddField_management in ArcGIS API for Python Questions

Error adding fields to multiple classes with AddField_management

Re: Error adding fields to multiple classes with AddField_management

Re: Error adding fields to multiple classes with AddField_management

Re: Error adding fields to multiple classes with AddField_management

Re: Error adding fields to multiple classes with AddField_management