topic Re: Disconnect SDE Connection in Pro in Data Management Questions

Disconnect SDE Connection in Pro

MichaelVolz — Mon, 23 Jul 2018 14:01:03 GMT

From my testing of various versions of Pro (1.4 through to 2.2), it appears that you cannot disconnect from SDE once you have connected to an SDE database. Currently the only way to truly disconnect from SDE connections in Pro is to close the ArcPro app altogether. Now this seems like it might be problematic when Pro is used for SDE administrative tasks where not being able to disconnect from SDE could cause SDE locks for admin SDE tools. Is this current architecture by design and will persist in future versions of Pro?

Re: Disconnect SDE Connection in Pro

ThomasColson — Mon, 23 Jul 2018 19:20:48 GMT

Related, ENH-000114150 [Enhancement] Provide DBMS connectivity error notification when drawing in ArcGIS Pro session after the connection has been terminated to underlying enterprise geodatabase. This arose out of some issue causing SDE to be disconnected while Pro is open (e.g network outage), which is a very common occurrence.

Re: Disconnect SDE Connection in Pro

ThomasColson — Mon, 23 Jul 2018 19:25:36 GMT

...However, in 2.2 you can "disconnect your self" by going into Connection properties and removing what you "think" is your connection (among many, in my case, I guessed right). There needs to be a very clear connect and disconnect feature.

Re: Disconnect SDE Connection in Pro

MichaelVolz — Tue, 24 Jul 2018 14:36:26 GMT

Thomas:

What user connection were you using when you were able to access the Connection properties of an SDE connection in Pro? Testing at my org that is an Oracle shop for GIS data shows that only the SDE (Database owner) connection can even access the Connections tab (The Locks tab appears to be available for all users).

Re: Disconnect SDE Connection in Pro

Asrujit_SenGupta — Tue, 24 Jul 2018 16:28:21 GMT

Thats expected.

Manage connections to Oracle—Manage geodatabases in Oracle | ArcGIS Desktop

You can connect to the geodatabase as the geodatabase administrator in ArcGIS Pro to view connections from within the Geodatabase Administration dialog box.

The geodatabase administrator in Oracle—Manage geodatabases in Oracle | ArcGIS Desktop

The same was the case with ArcGIS Desktop.

Re: Disconnect SDE Connection in Pro

MichaelVolz — Tue, 22 Jun 2021 08:42:53 GMT

Thanks for the helpful links.

As a person who is knowledgable about SDE geodatabases, you would agree that sorting in the Geodatabase Administration screen in Pro (as can be done in ArcMap) is an important feature for the SDE Administrator as per following GeoNet thread:

https://community.esri.com/ideas/15300

This task would be especially important if you are trying to disconnect a user from SDE using Pro, which is the topic of this thread.

Re: Disconnect SDE Connection in Pro

AJR — Mon, 18 May 2020 21:26:11 GMT

This issue still exists in Pro 2.5, will it ever be fixed? There should be an easy way to disconnect from an enterprise geodatabase.

Re: Disconnect SDE Connection in Pro

RandyKreuziger1 — Tue, 02 Jun 2020 23:38:10 GMT

It shows that the Idea is In Product Plan but that doesn't tell us in which version of Pro ERSI plans to make it available. That's a pet peeve of the Ideas labeling. something can be "In Product Plan" but take 2 or more years before it's available.

Sort Parameters in Geodatabase Administration Screen in Pro

Re: Disconnect SDE Connection in Pro

ChelseaRozek — Fri, 11 Sep 2020 13:31:48 GMT

agree, it seems like I need to have a separate admin aprx with my database owner connections because having my personal user connections are causing locks when in the same aprx and trying to do admin work. I wish I could just disconnect and get a red X on the connection again like in ArcCatalog

Re: Disconnect SDE Connection in Pro

Anonymous User — Thu, 24 Sep 2020 17:26:05 GMT

The ability to explicitly connect, re-connect and re-fresh SDE connections is absolutely needed in ArcGIS Pro as it was in ArcDeskop/Map/Catalog! I find this especially true in the age of working from home more often/all of the time. The variability and potential ways to get disconnected from your database server, even for a brief moment, are much more common (VPN, remote desktops, home WiFI, etc.). ArcMap handles this like a champ and seems to get hung up less often - if it does, the right-click connection tools work great. The ability to refresh the top-level Folder or DB folders is also missed.

Currently I am using ArcGIS Pro 2.5 and manage/interact with a wide variety of SDE Oracle, Postgres and FGDB connections for basic data displaying/reading in addition to higher level SDE-admin tasks. I find once a connection is interrupted while Pro is opened, it throws a fit and reports a general connection error/exception while showing a red "! " next to the name in the Catalog pane. The only way to re-establish the connection is to close and re-open the Project, if it doesn't freeze up all together mandating a force-quite/end-task.

If there are workarounds or parallel solutions to the above that I am missing in ArcGIS Pro please let me know. My transition to Pro is decent overall and I like some aspects of it... but every week it seems I find a new, wonky bug (feature?) affecting core functionality.

Re: Disconnect SDE Connection in Pro

WilliamRice — Tue, 28 Sep 2021 19:37:12 GMT

With Database Connections using ArcCatalog, one can right-click on the connection and select "Disconnect". As a Geodatabase Administrator, having the ability to explicitly disconnect the connection is useful when some type of action is needed to perform a refresh of the underlying database connection. Such as when new feature classes have been added to the geodatabase and one needs to now be able to view those new additions in the existing database connection.

The "Disconnect" operation has been in the ArcGIS Desktop software for years. A similar "Disconnect" operation is needed with Catalog in ArcGIS Pro. Currently, to refresh an existing database connection in ArcGIS Pro, one has to exit the ArcGIS Pro project and then reopen the project.

Re: Disconnect SDE Connection in Pro

MKF62 — Fri, 21 Jan 2022 16:30:28 GMT

2022 and still no way to do this??

Re: Disconnect SDE Connection in Pro

AJR — Fri, 21 Jan 2022 16:32:18 GMT

not as of AGP 2.9 😞

Re: Disconnect SDE Connection in Pro

MKF62 — Fri, 21 Jan 2022 16:40:46 GMT

I have a feeling they're never going to do it at this point. I don't understand that. I shouldn't have to close AGP to disconnect from a database. You can remove the connection completely, but that defeats the point of having an eGDB in your favorites. Closing connections and removing locks is really not appropriate or efficient...

Re: Disconnect SDE Connection in Pro

ctalleygreenville — Tue, 08 Feb 2022 20:11:55 GMT

This is a real handicap in switching from old ArcCatalog (desktop ArcGIS) compared with trying to set up a similar admin environment in PRO. I have various connections in desktop Catalog to the same DB but as different users. I am constantly using the right click on DB connection and choosing "disconnect" during admin tasks that require different user logins.

What ARE people doing to switch from ArcCatalog to Catalog in Pro for Admin? I keep finding myself "just giving up and opening in ArcCatalog" to do some tasks. I have pretty much totally switch ArcMap tasks to Pro but my DB admin tasks in Catalog -- I haven't determined how to make the switch.

Re: Disconnect SDE Connection in Pro

AxelLévy — Mon, 14 Mar 2022 14:59:45 GMT

Still nothing in 2022 ? "Error DBMS..."

The only way to refresh the connection is to restart Arcgis PRO...

Re: Disconnect SDE Connection in Pro

fkhan242 — Wed, 06 Apr 2022 15:23:31 GMT

I think there should be a "disconnect" option in Pro as well. This option in ArcCatalog was very useful.

Re: Disconnect SDE Connection in Pro

George_Thompson — Wed, 06 Apr 2022 16:26:59 GMT

I used the disconnect in Pro 2.9.2 yesterday and it worked as expected.

Re: Disconnect SDE Connection in Pro

fkhan242 — Wed, 06 Apr 2022 16:31:28 GMT

I'm running on 2.9.2, but not seeing the Disconnect option when right-clicking on the database in Catalog.

Re: Disconnect SDE Connection in Pro

George_Thompson — Wed, 06 Apr 2022 19:21:18 GMT

What RDBMS are you using for the Enterprise Geodatabase?

You may have to grant some additional privileges' to the SDE (Geodatabase Administrator) user. The SDE user is the one that could potentially disconnect users:

SQL Server - https://pro.arcgis.com/en/pro-app/latest/help/data/geodatabases/manage-sql-server/manage-connections-sqlserver.htm

PostgreSQL - https://pro.arcgis.com/en/pro-app/latest/help/data/geodatabases/manage-postgresql/manage-connections-postgresql.htm

Oracle - https://pro.arcgis.com/en/pro-app/latest/help/data/geodatabases/manage-oracle/manage-connections-oracle.htm

Hope that helps!