topic Re: Error code 400 when I publish a feature with a Definition query in ArcGIS Pro Questions

Error code 400 when I publish a feature with a Definition query

wilcow — Mon, 14 Dec 2020 21:32:06 GMT

I have a feature class in Enterprise GIS that has a related table (simple relationship, 1:M).

I have a definition query on the features based on a field in the related table:

FacilityID_INT IN (SELECT FID_INT FROM SS_Spills WHERE Spill_Overflow IS NOT NULL)

and when I attempt to publish to AGO, it fails with this error in the log: "StatusMessage: Server Response: ERROR: code:400, Invalid URL, Invalid URL, Bad syntax in request."

When I remove the DQ, the feature publishes fine.

I would simply filter the feature layer on AGO after I publish but there's no way that I can see to use subsets or SQL in AGO

Any thoughts on what could be fouled up in that definition query?

Re: Error code 400 when I publish a feature with a Definition query

Robert_LeClair — Wed, 16 Dec 2020 21:09:18 GMT

This is a known issue. One workaround is to export the feature class out to a new feature class based upon the DQ and publish the new layer to ArcGIS Online. Then you don't have to worry about an ArcGIS Online filter for subsets.

Re: Error code 400 when I publish a feature with a Definition query

wilcow — Wed, 16 Dec 2020 21:15:16 GMT

Well, thanks for the response.

I was able to publish the FL to Portal with the definition query, but ran into other (separate) issues with that.

Eventually I settled on only publishing the related table to AGO (as a web feature) so I could create a Survey123 form against that.

May still have to resort to a separate feature class as you describe ...

Thanks again!