topic Re: Error attempting to edit query layer in ArcGIS Pro Questions

Error attempting to edit query layer

EricIsaak — Wed, 09 Sep 2020 21:51:47 GMT

After successfully editing the SQL query in a query layer multiple times (~10), the next edit attempt generates a "Name is empty" error after pressing Validate. The only way to recover seems to be to create a new query layer and redo all the configuration. Has anybody experienced this behavior?

Re: Error attempting to edit query layer

MikeNelsonOP — Wed, 24 Mar 2021 20:08:26 GMT

I am experiencing the same problem and had to do the same workaround as you. I don't know of another way around this.

Re: Error attempting to edit query layer

kshahmmp — Thu, 15 Apr 2021 15:56:39 GMT

I have the same issue too

Re: Error attempting to edit query layer

LaurentP — Thu, 27 May 2021 00:37:24 GMT

I have the same issue as well

Re: Error attempting to edit query layer

JayantaPoddar — Thu, 27 May 2021 00:46:57 GMT

A known bug. BUG-000134052

Currently, there is no other documented workaround than to create a new query layer.

Re: Error attempting to edit query layer

TristanMcHardie — Mon, 29 Nov 2021 21:45:59 GMT

For me, this seems to have stemmed from the layer's "Alias" (see Layer Properties > Source > Alias) being appended with _1, then _1_2, then _1_2_3, etc. until it reached 68 characters.

My workaround was to export the layer as a Layer File (.lyrx), edit the file using a text editor to remove the _1_2_3 suffix, and then replace the layer from the layer file. This way, you don't have to re-apply any symbology, labelling, scale ranges etc. which you would if you recreate the query layer from scratch.

This workaround might also be achieved using arcpy by modifying the layer's CIM, but I haven't tested this myself.

If anyone knows what the purpose of the alias is in query layers I'd be pleased for an explanation, particularly the % sign and suffixes that get inserted/appended.