Latest Contributions by BlakeTerhune

I have a Python script running on a 64-bit Windows Server 2012r2 machine with ArcGIS Server 10.2.2. The script has a list of twelve services (stored as a Python dictionary) that it stops and starts. 90% of the time all services in the list stop and start successfully. The other ten percent: not so much. The JSON error message returned says Could not undeploy services from one or more machines. 'com.esri.arcgis.discovery.admin.AdminException'. The log message in ArcGIS Server Manager shows up as Severe level and says pretty much the same thing. I haven't been able to notice a pattern in how often or which service it fails on. Sometimes (like this most recent time) it failed to stop a service in the middle of the list, then continued on to successfully stop the rest of the services. Later on in the script the same services are started and all started successfully. So I know the script works but it's just sometimes that it fails. My script does the following: Copy feature classes from SDE to staging file geodatabase on server Compact staging geodatabase Stop related services Delete production geodatabase Copy staging gdb to production gdb Start services The code I use to stop and start services is based on this work from Kevin Hibma: ArcGIS Server Administration Toolkit - 10.1+ AdministeringArcGISServerwithPython_DS2014‌ Here are the Python functions I came up with: getToken() def getToken(adminUser, adminPass, server, port, expiration):     # Build URL     url = "http://{}:{}/arcgis/admin/generateToken?f=json".format(server, port)     # Encode the query string     query_dict = {         'username': adminUser,         'password': adminPass,         'expiration': str(expiration),  ## Token timeout in minutes; default is 60 minutes.         'client': 'requestip'     }     query_string = urllib.urlencode(query_dict)     try:         # Request the token         with contextlib.closing(urllib2.urlopen(url, query_string)) as jsonResponse:             getTokenResult = json.loads(jsonResponse.read())             ## Validate result             if "token" not in getTokenResult or getTokenResult == None:                 raise Exception("Failed to get token: {}".format(getTokenResult['messages']))             else:                 return getTokenResult['token']     except urllib2.URLError, e:         raise Exception("Could not connect to machine {} on port {}\n{}".format(server, port, e)) serviceStartStop() def serviceStartStop(server, port, svc, action, token):     # Build URL     url = "http://{}:{}/arcgis/admin".format(server, port)     requestURL = url + "/services/{}/{}".format(svc, action)     # Encode the query string     query_dict = {         "token": token,         "f": "json"     }     query_string = urllib.urlencode(query_dict)     # Send the server request and return the JSON response     with contextlib.closing(urllib.urlopen(requestURL, query_string)) as jsonResponse:         return json.loads(jsonResponse.read()) I get the token once at the beginning of the main script and call the serviceStartStop() function repeatedly in a for loop iterating through a list of services. ... View more

I have a mosaic dataset with tiled imagery that has an infrared band. How can I publish an image service on ArcGIS Server 10.2.2 so the published image uses the correct bands to display it as infrared instead of just regular RGB? Previously we published it as a map service but I'd like to do it as an image service if possible. ... View more

Previously, I had created a Python script that used ArcSDESQLExecute to query the SDE.PROCESS_INFORMATION table to get detailed connection information. Something like SELECT UPPER(NODENAME) AS COMPUTER, COUNT(NODENAME) AS CONNECTIONS FROM SDE.PROCESS_INFORMATION GROUP BY NODENAME ORDER BY CONNECTIONS DESC, NODENAME and SELECT UPPER(NODENAME) AS COMPUTER, OWNER AS USERNAME, COUNT(OWNER) AS USERCONNS FROM SDE.PROCESS_INFORMATION GROUP BY NODENAME, OWNER ORDER BY NODENAME, USERCONNS DESC, OWNER Between the two, I was able to get the total number of connections for each computer, which users that computer was connecting with, and how many connections of each user were open. Since then, I stumbled across ListUsers and thought maybe I should be using it instead of the SQL. On a mission to conquer ListUsers and get the same SDE connections "report" I came up with this: import arcpy from operator import itemgetter #Get all connections and print the total GPRO_Connections = arcpy.ListUsers("Database Connections/SDE@GPRO.sde") print "{} total connections:".format(len(GPRO_Connections)) #Get and count unique computer connections and sort by number of connections AllClients = [conn.ClientName for conn in GPRO_Connections] ##Use list comprehension to get all ClientName values Clients = [(client, AllClients.count(client)) for client in set(AllClients)] ##Use list comprehension to get unique tuples of ClientName and number of connections #Get and count unique user connections for each computer and print results for c in sorted(Clients, key=itemgetter(1), reverse=True): ##Sort the unique computers by descending connections and print results     print "{} ({})".format(c[0], c[1])     ## Get and count unique user connections for the computer     AllClientUsers = [user.Name for user in GPRO_Connections if user.ClientName == c[0]] ##Use list comprehension to get all users on the computer     ClientUsers = [(usr, AllClientUsers.count(usr)) for usr in set(AllClientUsers)] ## Use list comprehension to get unique tuples of users on the computer and number of connections     ## Sort the computer's users by descending connections and print results     for u in sorted(set(ClientUsers), key=itemgetter(1), reverse=True):         print "\t{} ({})".format(u[0], u[1]) # Cleanup del GPRO_Connections arcpy.ClearWorkspaceCache_management() The ouput looks something like this 43 total connections: CC1WA125 (9)   SDE (4)   JTX (2)   GBATASKS (2)   GBAVIEWER (1) 8GK69Y1 (3)   GBAVIEWER (1)   WARRENW (1)   KURTHO (1) 8GZ59Y1 (3)   GISVIEWER (1)   RANDYE (1)   GBATASKS (1) 1HTX8Y1 (3)   GBAVIEWER (1)   GISVIEWER (1)   KURTHO (1) 8H269Y1 (2)   JESSEF (1)   GISVIEWER (1) 1HSZ8Y1 (2)   GBAVIEWER (1)   GISVIEWER (1) 1NGY8Y1 (2)   GISVIEWER (1)   SDE (1) 6IKSA69716 (2)   WS (2) D2P3JF1 (2)   CHRISSI (1)   GBATASKS (1) 1HWZ8Y1 (2)   JASONT (1)   GBATASKS (1) 1K1Z8Y1 (2)   GBAVIEWER (1)   KRISTYN (1) 1MRX8Y1 (2)   GBAVIEWER (1)   GISVIEWER (1) HGL7XL1 (1)   WS (1) 75L7XL1 (1)   WS (1) 8JKSB95938 (1)   WS (1) 6JKSA78574 (1)   WS (1) 2M068Y1 (1)   SDE (1) VM1WA91 (1)   GISVIEWER (1) 8GS49Y1 (1)   GISVIEWER (1) 1K1X8Y1 (1)   ERIKS (1) 46L27W1 (1)   WS (1) I've been learning Python from scratch over the past couple months and I'm pretty proud of how far I've come. However, I know there are a lot of nifty ways to do things and thought maybe the Python wizards here could offer some insight on the problem and my solution. At the very least, maybe someone else can get some use out of this code. ... View more

We are in the midst of trying to upgrade everyone in our organization from ArcGIS 10.0 to ArcGIS 10.2.2. We have several ArcPy scripts that copy and merge feature classes from our 10.0 SDE and output to a file geodatabases. As we recode some of the older scripts to work with our new ArcGIS 10.2.2 setup, I've found that the feature class outputs from the scripts running from 10.2.2 are not readable by ArcGIS 10.0. The geodatabase was created in 10.0. ArcCatalog 10.0 can open the geodatabase, view properties of the geodatabase and feature class, but it can't preview it; ArcCatalog straight-up crashes. Even stranger is that existing feature classes in the same geodatabase that weren't updated by the script will preview fine. Unfortunately, we aren't quite ready to retire these scripts. Any ideas on how to make this all play nice together? ... View more