AnsweredAssumed Answered

Multiple connections from one machine to a single database

Question asked by Cep86 on Jun 21, 2016
Latest reply on Jul 8, 2016 by bnayak-esristaff

Like • Show 0 Likes0
Comment • 5

I have been having an issue where I'll notice that I have multiple connections open to a single geodatabase. Right now I am showing that I have 5 connections, one of which is greyed out for the current connection. Each computer here has its own name associated with it, so I can tell that all of the connections I am seeing are from my machine.

What causes this?

Is it a problem?
How do I fix it if so?

System Information:
ArcGIS for Desktop 10.3.1

Windows 7 Machine

Microsoft SQL Geodatabase

SDE Connection

Thanks!

No one else has this question

Outcomes

5 Replies

asengupta-esristaff Jun 21, 2016 3:56 PM
Mark Correct
Correct Answer
First of All: I clicked the option "Assume Answered" by mistake and don't see any option to revert back. Sorry for that.

To answer your question:
Each connection that you make to that geodatabase -- from ArcMap, ArcCatalog, ArcGIS Server Services...will create a new connection to the geodatabase.
Even in the same ArcCatalog interface, if you connect to the same gdb with two different connection files, that will create separate connections and thus show in that list.

New GUI for Geodatabase Administration | ArcGIS Blog
Like • Show 0 Likes0
Actions
- rastrauch @ asengupta-esristaff on Jun 21, 2016 3:49 PM
  Mark Correct
  Correct Answer
  And although not officially supported, I saw your post on an older thread https://community.esri.com/thread/82285#comment-402241 and was able to get the GDBT 10.0 (toolset) working with 10.3.1 the other day....so happy to have that look and feel back again for versioned databases. !!
  Like • Show 1 Like1
  Actions
- Cep86 @ asengupta-esristaff on Jun 22, 2016 9:27 AM
  Mark Correct
  Correct Answer
  Asrujit, that makes sense, but in my particular example, I am referring to accessing the database through a single source, and still seeing upwards of 5 or more connections. For instance, I had everyone log off last night a little early so I could make some changes to some fields that we have in our feature classes, and I had 5 connections that were time stamped at various times throughout the day. Instances that I was no longer using or even had open. At that moment that I was looking, the only thing that I had open was ArcCatalog, and I was only accessing the database through a single connection file.
  
  All in all it doesn't really create a problem for me, as I can simply break the locks to ensure that my current instance is the only connection, but I really just want to be sure that there isn't some underlying problem that we are having, or if by breaking those locks I may be harming something that took place earlier in the day.
  Like • Show 0 Likes0
  Actions
  - asengupta-esristaff @ Cep86 on Jun 22, 2016 12:34 PM
    Mark Correct
    Correct Answer
    You should surely take a look as to why so many connections are getting generated.
    
    Are you using any ArcGIS Server Services (Map Service, Feature Service, ...)?
    
    If possible, please discuss the Case with Esri Tech Support so that they can take a closer look at your environment and suggest accordingly.
    Like • Show 0 Likes0
    Actions
bnayak-esristaff Jul 8, 2016 10:53 AM
Mark Correct
Correct Answer
After closing/stopping all client application accessing geodatabase, if you still find connections are present in process_information table of sde schema then those are orphan connections. You can just truncate the table to clear it.
If you find these orphan connections very often then you need to monitor your ArcGIS workflow or any network drop.

- Biraja
2 people found this helpful
Like • Show 0 Likes0
Actions

GeoNet

The Esri Community

Multiple connections from one machine to a single database

Outcomes

Related Content

Recommended Content