Latest Contributions by RichardCrucchiola

I absolutely had this same issue last September.  In our case our Server Admin Team is using Solarwinds Enterprise Management System.  One of its functions is to monitor HTTP and HTTPS traffic on remote servers.  It uses Microsoft WinRM to listen for that traffic, which others in this thread have described.  WinRM uses port 5985 for HTTP and port 5986 for HTTPS traffic.  I had a support case opened for this last fall and the Support Tech associated the case with these BUG reports BUG-000116597 and BUG000116596.  In my case, I was able to work with our Server Admin staff to direct Solarwinds to use an adjacent port (5987) to do it's work.  I did receive BUG resolution report for 00116596 on April 16th, they are planning to add this port to the Data Store installation documentation at ver 10.7.1.  I just checked and they have not yet added it in 10.7 online documentation  They have no current product plans to make accommodations for the fact that Microsoft is already using port 5986 in WinRM 2.0.  My hope is the documentation edit includes the reference to the conflict with WinRM.  For anyone else encountering this issue, here's the URL to the Microsoft documentation - https://docs.microsoft.com/en-us/windows/desktop/winrm/installation-and-configuration-for-windows-remote-management ... View more

Thomas Thanks for commenting on my idea.  My support case analyst suggested that I put this item into Ideas after she and I chatted about my experience and I pointed out that it wasn't mentioned in the installation guides.  I'm a newer GIS Sys Admin, with 30+ years of ESRI desktop/workstation experience.  So for some GIS Sys Admins the notion of putting the appropriate SQL client on the server is second nature, but for newer GIS Sys Admins, we're carefully looking at the documentation and installation guides.  So my fresh eyes on this caught what I believe is missing information in the installation guides.  Hope the Idea was helpful. ... View more

Having a bit of a unique problem with this code.  I used a bit of the code above to nest the ListFeatureClasses inside of the ListDatasets.  Under my ListFeatureClasses section I'm trying to use arcpy.Describe to extract the geometry storage type of the feature class.  I've hit a wall where if the feature class and the feature dataset have the exact same name my second for statement is closing out. import os, arcpy, time from time import clock, strftime, localtime try:     sdeConn = "Database Connections\\washsde_rlis_sde.sde"     arcpy.env.workspace = sdeConn     oFileHeaders = "FeatureDataset,FeatureClass,Geometry"     oListTime = time.asctime()     f = open("K:/Workgroups/GISITS/ADMIN_DBA_Projects/Binary2SQLGeometry/WashSDE_RLIS_fcGeom.csv", "w")     f.write("SDE Connection: " + sdeConn + "\n")     f.write("List Created On: " + oListTime + "\n")     datasets = arcpy.ListDatasets(feature_type='feature')     datasets = [''] + datasets if datasets is not None else []     print datasets     f.write('Datasets in geodatabase: ' + str(datasets) + "\n")     f.write(oFileHeaders + "\n")     for ds in datasets:         for fc in arcpy.ListFeatureClasses(feature_dataset=ds):             desc = arcpy.Describe(fc)             vFile = desc.file             vPath = desc.path             vGeometry = desc.geometryStorage             f.write(ds + "," + vFile + "," + vGeometry + "\n")             print (ds + "," + vFile + "," + vGeometry)     f.close() except:     print arcpy.GetMessage(1)     print arcpy.GetMessage(arcpy.GetMessageCount() - 1) I get a type 1 exception when its trying to deal with the RLIS.RLIS.boundary feature class in the similarly named RLIS.RLIS.BOUNDARY feature dataset.  The SDE instances is named RLIS and the database users is named RLIS. ... View more

We've used the following SQL Statement for a while.  Looks like your hitting the same elements.  I just checked it again in Microsoft SQL Server Management Studio for SQL Server 2012. select a.owner,a.table_name locked_table, a.registration_id, b.owner locked_by, b.nodename connect_source, b.start_time from sde.sde_table_registry a, sde.sde_process_information b, sde.sde_table_locks c where a.registration_id = c.registration_id and b.sde_id = c.sde_id ... View more