I have a script that runs regularly to update a Feature layer on our Enterprise server. I have started to get the following error when I am calling
arcpy.management.DeleteRows(in_rows="url to feature layer")
ExecuteError: ERROR 160117: The value type is incompatible with the field type.
Failed to execute (DeleteRows)
The workflow is that I have a grid polygon which I join to a spreadsheet and symbolise on a 'status' attribute of the table, then I update the existing Feature layer (which is used in a Dashboard) by deleting the rows in the existing Feature layer & then calling arcpy.management.Append() . I am doing this for two other grids sizes without issue.
Any suggestions for why I am suddenly getting this error? I have tired overwriting the web layer from within ArcPro and then trying again with no luck. Full script below.
I am also happy to receive any suggestions to improve my workflow as I am not sure this is the best way to do it in the first place....
# Set your workspace
arcpy.env.workspace = r"path to gdb on server.gdb"
def stripwhitespaces(table_name):
"""function for stripping whitespace from all string columns in a table, table name passed as input"""
fieldlist=[i.name for i in arcpy.ListFields(table_name) if i.type=='String']
with arcpy.da.UpdateCursor(table_name,fieldlist) as cursor:
for row in cursor:
row=[i.strip() if i is not None else None for i in row]
cursor.updateRow(row)
def delete_rows(table, clause):
"""Deleted rows from specified table or feature class where conditions in where clause are TRUE"""
arcpy.management.SelectLayerByAttribute(
in_layer_or_view=table,
selection_type="NEW_SELECTION",
where_clause=clause,
invert_where_clause=None
)
arcpy.management.DeleteRows(
in_rows=table
)
# Step 1: Read the spreadsheet
spreadsheet_path = r"path to spreadsheet on server.xlsx"
spreadsheet_layer = "Work Order Tracker"
output_table = "worktracker"
arcpy.ExcelToTable_conversion(spreadsheet_path, output_table, spreadsheet_layer, field_names_row=2)
stripwhitespaces("worktracker")
# create & format the Band 3 table ready to join
input_table = "worktracker"
output_table = "band3table"
# Specify the fields you want to keep
selected_fields = ["name", "progress", "a", "b", "c"]
# Create a NumPy array for the selected fields
table_array = arcpy.da.TableToNumPyArray(input_table, selected_fields)
# Convert empty strings to None
table_array = np.where(table_array == '', None, table_array)
# Create a new file geodatabase table
arcpy.CreateTable_management(arcpy.env.workspace, output_table)
# Add fields to the new table based on the selected fields
for field in selected_fields:
arcpy.AddField_management(output_table, field, 'TEXT') # Assuming all fields are text, adjust if needed
# Create an InsertCursor to insert rows into the new table
with arcpy.da.InsertCursor(output_table, selected_fields) as cursor:
for row in table_array:
cursor.insertRow(row)
# delete blank rows from table
arcpy.management.SelectLayerByAttribute(
in_layer_or_view="band3table",
selection_type="NEW_SELECTION",
where_clause="name NOT LIKE 'GB%'",
invert_where_clause=None
)
arcpy.management.DeleteRows(
in_rows="band3table"
)
# copy the grid schema shapefile before joining to keep a clean original.
arcpy.management.CopyFeatures('grid saved in .gdb name', 'band3')
# join to spreadsheet values
arcpy.JoinField_management("band3", "Name", "band3table", "name")
#deleting all cells from the feature class where the progress is Null
arcpy.management.SelectLayerByAttribute(
in_layer_or_view="band3",
selection_type="NEW_SELECTION",
where_clause="progress IS NULL",
invert_where_clause=None
)
arcpy.management.DeleteRows(
in_rows="band3"
)
#delete columns that are not needed post join
arcpy.DeleteField_management("band3",
["id", "name"])
#apply symbology
arcpy.management.ApplySymbologyFromLayer(
in_layer="band3",
in_symbology_layer=r"path to layer file on server.lyrx",
symbology_fields="VALUE_FIELD progress progress",
update_symbology="MAINTAIN"
)
arcpy.management.DeleteRows(
in_rows="url to Feature layer on Enterprise server"
)
#append rows
arcpy.management.Append(
inputs=r"path to band3 in geodatabase on server",
target="url to Feature layer on Enterprise server",
schema_type="TEST",
field_mapping=None,
subtype="",
expression="",
match_fields=None,
update_geometry="NOT_UPDATE_GEOMETRY"
)
