Select to view content in your preferred language

Issue with maintaining an SDE connection

170
1
3 weeks ago
MRJ1
by
Emerging Contributor

Hello,

For my ArcGIS Pro SDK customizations I have been working with an enterprise geodatabase via SDE connection. I have noticed that after short periods of inactivity (typically 15-20 minutes) of not interacting with the enterprise data on the map, the connection appears to drop. I believe it is a lost connection because I receive errors when I go to perform simple actions like refresh the map view (an 'Underlying DBMS error' notification when the layers attempt to draw) or if I try to open an attribute table ('A database level I/O error occurred').

I am trying to figure out the root cause of this and if this can be managed from the database side with a timeout setting, or if there is something else going on, perhaps the corporate firewall automatically closing inactive connections for security reasons? Has anyone else encountered this issue? The connection is to an Oracle instance using TNS names.

Thank you!

0 Kudos
1 Reply
VinceAngelo
Esri Esteemed Contributor

That sounds like a firewall, VPN, or other port manager issue. It's possible there's an Oracle switch for this, but there's no place in the geodatabase API to set a timeout, and I've had Oracle connections up over weekends.

- V

0 Kudos