nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

MakeQueryLayer doesn't return results in a python script

IngRF

Hi,

I have an issue using the MakeQueryLayer Geoprocessing tool in a python script. I'm querying a Oracle Spatial DB (Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production).

When I use the geoprocessing tool from the Data Management Tools (MakeQueryLayer_1.JPG) I get a result. I then "Send to Python Window " to get the python command (MakeQueryLayer_2).JPG). Once again I get a result.

But when I create a python script using the same previous code to run from a ArcGIS Toolbox, the query returns no values. I tried to troubleshoot with a DBA and the conclusion is that when the Query comes from the Python Script, it doesn't reach the database.

What's even weirder is that it only happens when I query a POLYLINE dataset. When I query POINTS or POLYGONS, it works fine.

Any help would be greatly appreciated

Thanks

MakeQueryLayer_1.JPG

MakeQueryLayer_2.JPG

MakeQueryLayer_3.JPG

Najděte více příspěvků označených jako

Accepted answers

IngRF

I have identified the problem.

The data I'm querying has M-Values and the arcpy.management.MakeQueryLayer within a script doesn't support it.

As a workaround I convert my geom to 2D (SDO_CS.MAKE_2D(c1.GEOM) AS GEOM) since I do not need the M values in my geoprocessing.

Could it be a bug ?

All comments

IngRF

I have identified the problem.

The data I'm querying has M-Values and the arcpy.management.MakeQueryLayer within a script doesn't support it.

As a workaround I convert my geom to 2D (SDO_CS.MAKE_2D(c1.GEOM) AS GEOM) since I do not need the M values in my geoprocessing.

Could it be a bug ?

IngRF

Hi Robert,

Yes the connection file and location are valid. It's the same connection that was used in the MakeQueryLayer Tool and Python Console and in both cases a result was obtained.

Also, the Python Script works when querying POLYGON or POINT tables while using the same connection.

LINESTRING/MULTILINESTRING geometries seem to be the issue. But I don't understand is that they work when using Add Data/Query Layer, MakeQueryLayer Tool but not inside a python script.

Thanks

Robert LeClair

So one question I have based upon your 3rd image is the *.sde connection file. Is the correct *.sde connection file and location? It could be "blank" so it's therefore not seeing your eGDB.

Připojte se k diskusi

Přihlášení členové mohou přispívat, sledovat aktualizace a další. Jste tu noví? Zaregistrujte si bezplatný účet.

Rychlé odkazy

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.