topic Re: ArcGIS Pro 2.6.3 Definition Query in ArcGIS Pro Questions

ArcGIS Pro 2.6.3 Definition Query

Jurogin — Thu, 26 Nov 2020 14:33:13 GMT

Hi All,

I'm trying to make one basic Definition Query like "OBJECTID = 1" using one layer from one enterprise geodatabase (Oracle) and i'm receiving one error message "There was an error with the expression", but if I make the same query using the "Select By Attributes" the selection is done without problems.

So someone have ideas to solve my problem?

PS: Using the previous versions of ArcGIS Pro I was able to make query on the same layers.

Thanks,

Vítor Carvalho

Re: ArcGIS Pro 2.6.3 Definition Query

Robert_LeClair — Mon, 30 Nov 2020 21:59:15 GMT

Is the error occurring in the Layer Properties->Definition Query? If so, click the SQL slider in the Layer Properties->Definition Query and type OBJECTID=1 without the quotes. Click Apply followed by OK. Does it process correctly?

Re: ArcGIS Pro 2.6.3 Definition Query

KatharinaWerner1 — Mon, 28 Dec 2020 15:26:48 GMT

Hello, we've have the same problem.

We get this errormessage, when we use the SQL option. When we use the not-SQL option ArcGIS Pro crashes. But after some tries with not-SQL-option ArcGIS Pro crashes also. There isn't any systemic errorbehavior. I've created a case at Esri Support Germany. But we couldn't find the cause of the crash nor couldn't resolve the problem. I guess there's a bug in ArcGIS Pro. We'll see in the case, if there is a solution.

Happy new year,

Kathi

Re: ArcGIS Pro 2.6.3 Definition Query

Robert_LeClair — Mon, 28 Dec 2020 15:42:02 GMT

Kathi - interesting - thx for the response. I wonder - have you upgraded to ArcGIS Pro 2.7 and attempt the same workflow again? Not sure if it's a bug in ArcGIS Pro or not, but there were a lot of bugs resolved in the latest update.

Re: ArcGIS Pro 2.6.3 Definition Query

KatharinaWerner1 — Tue, 29 Dec 2020 07:11:58 GMT

Hello Robert,

thanks for your answer. No we haven't already upgrated ArcGIS Pro. I'll try
the same workflow, when 2.7.x is released and let you know, if the problem
has resolved or not.

Re: ArcGIS Pro 2.6.3 Definition Query

Robert_LeClair — Tue, 29 Dec 2020 14:41:09 GMT

Good morning - good news! ArcGIS Pro 2.7 was released a little more than a week ago. You can upgrade at any time and test the workflow again.

Re: ArcGIS Pro 2.6.3 Definition Query

KatharinaWerner1 — Wed, 30 Dec 2020 10:27:32 GMT

Hello Vitor and Robert, I could try the workflow with a newer Oracle-version (18c) in ArcGIS Pro. And Definition query works fine. So I guess, for me the problem is solved: newer version works fine. Probably Esri should check, if ArcGIS Pro 2.6.3 still supports Oracle-versions lower 12 (https://desktop.arcgis.com/de/system-requirements/latest/database-requirements-oracle.htm)

Thanks for your help,

Kathi

Re: ArcGIS Pro 2.6.3 Definition Query

Robert_LeClair — Wed, 30 Dec 2020 15:01:47 GMT

Kathi - based upon your attachment and the ArcGIS Pro Supported DBMS's (2.5, 2.6, 2.7), the only Oracle release lower than Oracle 12x is Oracle 11g R2 (64-bit) 11.2.0.4

In reviewing the details, Oracle 11g R2 (64-bit) 11.2.0.4 support goes all the way back to ArcGIS Pro 2.1

Anything other Oracle release is not supported and may be the culprit here.