topic Re: Invert where clause error on Select by attributes in Python Questions

Invert where clause error on Select by attributes

CassidyKillian — Tue, 07 Jul 2020 16:16:24 GMT

I am running a script that was exported directly from model builder in Pro. It runs this select by attributes statement and gives me an error.

# Process: Select Layer By Attribute (Select Layer By Attribute)
DBO_wHydrantInspection_Layer, Count = arcpy.SelectLayerByAttribute_management(in_layer_or_view=GISDefault_DBO_wHydrantInspection, selection_type="NEW_SELECTION", where_clause="REPAIR = 'Yes'", invert_where_clause="")

Does anyone know why the invert where cause is throwing an error?

Re: Invert where clause error on Select by attributes

JoshuaBixby — Tue, 07 Jul 2020 16:24:22 GMT

Are you using Pro? The parameter in question is only supported in Pro.

Re: Invert where clause error on Select by attributes

CassidyKillian — Tue, 07 Jul 2020 16:27:27 GMT

I built the model in pro and exported to a python script that I need to run as a scheduled task. When I tried to run the script in IDLE it gave me the error.

Re: Invert where clause error on Select by attributes

DanPatterson — Tue, 07 Jul 2020 16:30:34 GMT

The options for that parameter are

inert_where_clause

(Optional)

Specifies whether the result of the expression should be inverted.

NON_INVERT —The result of the query will be used as is. This is the default.
INVERT —The result of the query will be inverted. If the selection_type parameter is used, the inversion occurs before the selection is combined with existing selections.

not "". Leave it out altogether if NON_INVERT is what you want. You don't need to specify parameters if you are using named parameters and using defaults.

Re: Invert where clause error on Select by attributes

CassidyKillian — Tue, 07 Jul 2020 16:44:18 GMT

Dan,

I removed the invert clause statement so not it looks like this:

Now it gives me this error:

Traceback (most recent call last):
File "H:\Python\HydrantRepairPro.py", line 25, in <module>
Model()
File "H:\Python\HydrantRepairPro.py", line 16, in Model
DBO_wHydrantInspection_Layer, Count = arcpy.SelectLayerByAttribute_management(in_layer_or_view=GISDefault_DBO_wHydrantInspection, selection_type="NEW_SELECTION", where_clause="REPAIR = 'Yes'")
File "C:\Program Files (x86)\ArcGIS\Desktop10.7\ArcPy\arcpy\management.py", line 7737, in SelectLayerByAttribute
raise e
ExecuteError: Failed to execute. Parameters are not valid.
The value cannot be a feature class
ERROR 000840: The value is not a Raster Layer.
ERROR 000840: The value is not a Mosaic Layer.
Failed to execute (SelectLayerByAttribute).

Re: Invert where clause error on Select by attributes

JoeBorgione — Tue, 07 Jul 2020 16:46:38 GMT

I think you need to add a make feature layer step in there. This is a case where the model to python conversion isn't 100%.

This line in the error is the kicker:

The value cannot be a feature class‍

Re: Invert where clause error on Select by attributes

JoshuaBixby — Tue, 07 Jul 2020 18:35:40 GMT

As an FYI, the trackback is showing you are running the code from ArcGIS Desktop/ArcMap and not Pro, which is why your original code failed because of the parameter difference. Also, it could be why the code is failing now since Select Layer By Attribute handled data set inputs differently between ArcMap and Pro.

Run the original code from Python bundled with Pro.