Hi All, I have three different levels of database connection in ArcCatalog on my PC which I use to connect to our Enterprise GDB for various reasons. I have my user level connection for data editing. I have one called GISADMIN which is the Data Owner. And another with is called SDE which is the Geodatabase Admin User. I have no access to the Database Admin User, this is managed by our in house I.T Dept. I am trying to use the arcpy.DisconnectUser function in a python script, but no matter which of the connections mentioned above I use, I get the following error: >> > arcpy . DisconnectUser ( r 'Database Connections\SDE@SDE_Spatial@SDE-DB.sde' , 123494 ) Runtime error Traceback ( most recent call last ) : File " " , line 1 , in module > File "c:\program files (x86)\arcgis\desktop10.3\arcpy\arcpy\__init__.py" , line 1086 , in DisconnectUser return gp . disconnectUser ( sde_workspace , users ) File "c:\program files (x86)\arcgis\desktop10.3\arcpy\arcpy\geoprocessing\_base.py" , line 504 , in lambda > return lambda * args : val ( * gp_fixargs ( args , True ) ) RuntimeError : Unable to disconnect : The connection ID provided is for the current administrator connection >> > I have confirmed this by trying to use all three connections, also trying to disconnect several different connections from my Enterprise GDB. Something strange is that if I put a completely random session ID in my python snippet, the exact same error is returned.... I am perplexed as to why this is happening to me, and I am unable to track down why this seems to have started happening all of a sudden. Anyone have any troubleshooting ideas for me? Nathan Duncan Cheers -Ben

nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

arcpy.DisconnectUser is throwing this error - RuntimeError: Unable to disconnect: The connection ID provided is for the current administrator connection

BenVan_Kesteren1

Hi All,

I have three different levels of database connection in ArcCatalog on my PC which I use to connect to our Enterprise GDB for various reasons.

I have my user level connection for data editing.

I have one called GISADMIN which is the Data Owner.

And another with is called SDE which is the Geodatabase Admin User.

I have no access to the Database Admin User, this is managed by our in house I.T Dept.

I am trying to use the arcpy.DisconnectUser function in a python script, but no matter which of the connections mentioned above I use, I get the following error:

<SPAN class="operator token">>></SPAN><SPAN class="operator token">></SPAN> arcpy<SPAN class="punctuation token">.</SPAN>DisconnectUser<SPAN class="punctuation token">(</SPAN>r<SPAN class="string token">'Database Connections\SDE@SDE_Spatial@SDE-DB.sde'</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="number token">123494</SPAN><SPAN class="punctuation token">)</SPAN>
Runtime error 
Traceback <SPAN class="punctuation token">(</SPAN>most recent call last<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp; File <SPAN class="string token">"<string>"</SPAN><SPAN class="punctuation token">,</SPAN> line <SPAN class="number token">1</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="keyword token">in</SPAN> <SPAN class="operator token"><</SPAN>module<SPAN class="operator token">></SPAN>
&nbsp; File <SPAN class="string token">"c:\program files (x86)\arcgis\desktop10.3\arcpy\arcpy\__init__.py"</SPAN><SPAN class="punctuation token">,</SPAN> line <SPAN class="number token">1086</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="keyword token">in</SPAN> DisconnectUser
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">return</SPAN> gp<SPAN class="punctuation token">.</SPAN>disconnectUser<SPAN class="punctuation token">(</SPAN>sde_workspace<SPAN class="punctuation token">,</SPAN> users<SPAN class="punctuation token">)</SPAN>
&nbsp; File <SPAN class="string token">"c:\program files (x86)\arcgis\desktop10.3\arcpy\arcpy\geoprocessing\_base.py"</SPAN><SPAN class="punctuation token">,</SPAN> line <SPAN class="number token">504</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="keyword token">in</SPAN> <SPAN class="operator token"><</SPAN><SPAN class="keyword token">lambda</SPAN><SPAN class="operator token">></SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">return</SPAN> <SPAN class="keyword token">lambda</SPAN> <SPAN class="operator token">*</SPAN>args<SPAN class="punctuation token">:</SPAN> val<SPAN class="punctuation token">(</SPAN><SPAN class="operator token">*</SPAN>gp_fixargs<SPAN class="punctuation token">(</SPAN>args<SPAN class="punctuation token">,</SPAN> <SPAN class="token boolean">True</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN>
RuntimeError<SPAN class="punctuation token">:</SPAN> Unable to disconnect<SPAN class="punctuation token">:</SPAN> The connection ID provided <SPAN class="keyword token">is</SPAN> <SPAN class="keyword token">for</SPAN> the current administrator connection
<SPAN class="operator token">>></SPAN><SPAN class="operator token">></SPAN> ‍‍‍‍‍‍‍‍‍‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

I have confirmed this by trying to use all three connections, also trying to disconnect several different connections from my Enterprise GDB.

Something strange is that if I put a completely random session ID in my python snippet, the exact same error is returned....

I am perplexed as to why this is happening to me, and I am unable to track down why this seems to have started happening all of a sudden.

Anyone have any troubleshooting ideas for me?

Nathan Duncan‌

Cheers

-Ben

Find more posts tagged with

Accepted answers

BenVan_Kesteren1

Just to close off my own question, it turns out that for some reason the permissions had changed on my Geodatabase Admin (SDE) User and this was causing the problem.

I had to elevate to my in house IT Dept to resolve.

All comments

BenVan_Kesteren1

Just to close off my own question, it turns out that for some reason the permissions had changed on my Geodatabase Admin (SDE) User and this was causing the problem.

I had to elevate to my in house IT Dept to resolve.

DonnaRiebe

This same thing happened to me. I suspect the solution will be the same.

BenVan_Kesteren1

I believe what happened is that our IT team audited the SQL Server permissions and noticed our SDE account had quite high privileges, and as I am not located 'within' the IT team this is against business rules, so they revoked my access as SDE Admin, which in turn caused this error to rear its head.

Once my IT team restored previous permissions all was good again.

Cheers

LDreyfuss

I know this was quite some time ago now, but any idea what permissions were restored to the SDE user? I'm getting the same error using the arcpy.DisconnectUser, only this time on a 10.9.1 geodatabase.

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.