topic Re: Automated method to check if enterprise geodatabase is accepting connections? in Geodatabase Questions

Automated method to check if enterprise geodatabase is accepting connections?

Brownschuh — Mon, 13 Dec 2021 17:19:42 GMT

Our organization has a database maintenance script that runs nightly. Without going into too much detail of the script tasks, the first task is to stop any connections to the GDB and the last step is to open connections back to the GDB. While it is rare, once a blue moon the script will stop during a run and not allow for database connections. We usually find this out when the end users are prompted with an error message the next morning and we have to manually check the box to allow for connections. I should note we do have safeguards in place if the script runs into any geoprocessing errors; the script will send admin users an email message of the error that was encountered and reestablish database connections as a final step. However, there are the strange instances where the script will stop completely with no errors, thus not taking that final step to accept connections.

My questions is: is there a way using python to check if an enterprise geodatabase is accepting connections?

Ideally I would like to write a simple script that performs the following tasks:
1. Check if GDB is accepting connections
2. If yes, end script
3. If no, send an alert message to admins and accept connections

Re: Automated method to check if enterprise geodatabase is accepting connections?

George_Thompson — Mon, 13 Dec 2021 17:39:11 GMT

Take a look at this: https://pro.arcgis.com/en/pro-app/latest/arcpy/functions/acceptconnections.htm

Looks like it is what you are looking for.

Re: Automated method to check if enterprise geodatabase is accepting connections?

Brownschuh — Mon, 13 Dec 2021 17:49:26 GMT

Thank you for the reply. We already use the AcceptConnections function to block or accept connections in our database maintenance scripts. What I'm looking for is a way to check if connections are blocked/open.

Re: Automated method to check if enterprise geodatabase is accepting connections?

George_Thompson — Mon, 13 Dec 2021 18:15:35 GMT

Ah, you are correct. Sorry I did not fully gather that. I am not sure of a way, but have seen a thread mention it: https://gis.stackexchange.com/questions/14677/can-arcpy-test-for-availability-of-sde-connection-before-trying-to-use-it

You may also want to add something like a describe (https://pro.arcgis.com/en/pro-app/latest/arcpy/functions/featureclass-properties.htm) on a specific feature class in the DB to see if it works.

Re: Automated method to check if enterprise geodatabase is accepting connections?

VishApte — Mon, 13 Dec 2021 21:47:26 GMT

I cannot see arcpy function to test if geodatabase is accepting connections. Quick SQL trace tells me that ArcGIS checks it using following SQL statement

SELECT num_prop_value FROM DBNAME.sde.SDE_server_config WHERE prop_name = 'STATUS'

And if the value is 2, it is NOT accepting connections. Value 1 means it is.

Following python code may help.

import arcpy
import os
def is_accepting_connections(sde_conn_nonadmin):
    if (os.path.exists(sde_conn_nonadmin) == False):
        raise ValueError("Invalid SDE connection file '{}'".format(sde_conn_nonadmin))
    try:
        arcpy.env.workspace = sde_conn_nonadmin
        desc = arcpy.Describe(sde_conn_nonadmin)
        if (hasattr(desc, 'workspaceType')):
            return True
        else:
            return False
    except:
        raise

Re: Automated method to check if enterprise geodatabase is accepting connections?

Brownschuh — Tue, 14 Dec 2021 14:51:06 GMT

Bummer, I was hoping there would be an arcpy function to test if a GDB is accepting connections. Maybe ESRI can include that functionality in future releases?