idea ArcGIS Pro_Remove connection in ArcGIS Pro Ideas

ArcGIS Pro_Remove connection

HaythamSuleiman — Mon, 07 Jan 2019 08:07:27 GMT

Hello everyone,

My problem in ArcGIS Pro:

If a connection to a table that has a definition query is deleted, then no more features of that layer will be displayed.

(DE: Wenn eine Verbindung zu einer Tabelle gelöscht wird auf die eine Definitionsabfrage besteht, dann werden keine Feature des betreffenden Layers mehr angezeigt.)

Re: ArcGIS Pro_Remove connection

KoryKramer — Mon, 07 Jan 2019 15:23:46 GMT

Hi Haytham Suleiman‌

Can you provide some clarification on the issue here?

You have a layer with a definition query.

What is the source of the layer? Feature class/standalone table (from file gdb, enterprise gdb, ...), shapefile/standalone table in folder...

What connection are you removing? Project connection to a database? Project connection to a folder?

Is the behavior specific to having a definition query applied to the layer?

I just added a layer to a map in Pro (from a file gdb through a folder connection), applied a definition query to the layer, then removed the folder connection - the layer remains in the map.

Please provide more details, maybe with some screenshots so that we can understand the issue.

Thanks

Re: ArcGIS Pro_Remove connection

HaythamSuleiman — Tue, 08 Jan 2019 15:21:35 GMT

Hi Kory Kramer ,

* The source of the layer ist from gdb, connected to sql database.

Attribute table:

After Removing the connection to sql datebase:

and the Attribute table is empty and error message appears:

The behavior happens, when a difinition query is applied to the layer.

Re: ArcGIS Pro_Remove connection

KoryKramer — Tue, 08 Jan 2019 15:45:31 GMT

Thank you for the details. Is that a built-in geoprocessing tool? Can you send me the link to the tool's web help?

Thanks

Re: ArcGIS Pro_Remove connection

MichaelVolz — Tue, 08 Jan 2019 16:08:42 GMT

Are you removing the connection to the SQL database in the Pro project?

Re: ArcGIS Pro_Remove connection

HaythamSuleiman — Tue, 08 Jan 2019 16:13:14 GMT

No it's not a built-in geoprocessing tool. I don't know what u mean with "the link to the tool's web help?"

sorry

Re: ArcGIS Pro_Remove connection

HaythamSuleiman — Tue, 08 Jan 2019 16:14:02 GMT

Yes exactly...

Re: ArcGIS Pro_Remove connection

MichaelVolz — Tue, 08 Jan 2019 16:16:02 GMT

Does the same phenomenon occur if you do not have a definition query applied to this layer? Can you try this test?

Re: ArcGIS Pro_Remove connection

HaythamSuleiman — Tue, 08 Jan 2019 16:25:07 GMT

the phenomen occurs when a definition query is applied to this level.

Re: ArcGIS Pro_Remove connection

KoryKramer — Tue, 08 Jan 2019 16:51:25 GMT

I think it would be good to investigate this further through a Support case.

I added the Fires layer from a SQL database and then applied a definition query to the layer.

Then I removed the connection to the database in the Catalog Pane and the layer doesn't disappear:

It seems like for now, this would have been more appropriate for the ArcGIS Pro‌ or Geodatabase‌ spaces rather than Ideas.

Re: ArcGIS Pro_Remove connection - Status changed to: Closed

KoryKramer — Fri, 18 Dec 2020 21:31:43 GMT