Latest Contributions by Arne_Gelfert

When using a derivative of the template map service publishing examples given in many places throughout ESRI documentation, I have the following working (I've stripped this down significantly)...  # set up a number of parameter for SD Draft generation # shortened for illustration sharing_draft = m.getWebLayerSharingDraft("FEDERATED_SERVER", "MAP_IMAGE", service) sharing_draft.federatedServerUrl = <federatedServerUrl> ... # Create SD Draft files sharing_draft.exportToSDDraft(sddraft_output_filename) .. arcpy.StageService_server(sddraft_output_filename, sd_output_filename) ... # set up a number of parameter for SD Draft # shortened for illustration inSdFile = sd_output_filename inServer = <serverUrl> inServiceName = <service name> ... arcpy.UploadServiceDefinition_server(inSdFile, inServer, inServiceName, ...)‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍ What exactly is the difference - if any - between  what I am referring to here as >federatedServerUrl. and <serverUrl>? And what exactly is the format of the URL expected here? I have it working in one environment and am using the exact same string (URL) for both variables. In another environment, the same code fails with ... ExecuteError: ERROR 999999: Something unexpected caused the tool to fail. Please refer to the error help for potential solutions, or contact Esri Technical Support http://esriurl.com/support. Failed to execute (StageService). ‍‍‍‍‍‍‍‍‍ The only difference is that I'm using a different URL but the same one in both places. It's a valid URL that mimics the first environment's URL and includes the webadaptor name. It successfully created the SD Draft file. So the URL seems to work fine for that steps. Very frustrating. I have used this a bunch of times in both environments and now it fails. ... View more

So I'm using a search widget to search across multiple similar (same schema)  map services and have set things up to where I get suggestions. Upon selection of a suggestion "result", I've got some event handlers doing what I need them to do and it all works. But I just don't like how the suggestions are displayed. They are grouped by service/source including a header referencing that source something like this: service1 : searchfield1, searchfield 2 record 1 record 2 record 3 service2 : searchfield1, searchfield 2 record 4 record 5 record 6 service3 : searchfield1, searchfield 2 record 7 record 8 record 9 I want all those records but without any references to what service they came from. My Search widget looks like this: this.superSearch = new Search({ sources: list_of_services, map: this.map, popupEnabled: false, autoSelect: false, enableSourcesMenu: false, enableSuggestions: true, maxSuggestions: 5, allPlaceholder: "Example: John Smith", // I'm searching for names autoNavigate: false }, "superSearch");‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍ Is there a way to format this, i.e. drop the "category" header identifying the feature services I'm calling? Thanks. ... View more

Needing some help with ArcSDE Compress over Easter Weekend.   Until every recently, I've had a Python script doing SDE maintenance every night - a reconcile/post on all versions, followed by a compress. The database in question houses a number versioned feature classes that are manually edited throughout the day. No huge volumes, but constant change. Also, I have a variety of scheduled FME processes writing to versioned feature classes. This was all working. Then, suddenly I was seeing errors from the FME end about conflicts in reconciling and things started "escalating" from there. What I found was some "bad" data that was stuck delta tables - either as a result of some root cause or maybe the cause of it all ?   As remedy, I temporarily disabled some nightly ETL and my scheduled maintenance. Next, and I removed the unwanted records with: exec dbo.set_current_version 'DBO.AdminWork'; exec dbo.edit_version 'DBO.AdminWork',1; DELETE FROM ... WHERE.... exec dbo.edit_version 'DBO.AdminWork',2; ‍‍‍‍‍‍‍ Then I disconnected users, set the Allow-Connections to 'False', reconciled all versions, and ran a compress. I've tried this a couple of times ( keeping that infamous definition of insanity in mind), both through ArcCatalog as admin and using arcpy. Each time, I end up with something like this: All my versions point to the same state ABCDEFG.  States are down to '0' and 'ABCDEFG' as a child of '0'. This state is associated with a number deletes in one D-table. But someone I seem to be unable to reconcile-post-compress them away. I've used some queries for locks and related processes from this excellent topic. But I have found no locks, and by not allowing any processes to connect, I have to connections by the time I execute the compress. So my question is: What could make those "deletes" persist and keep my versions from all getting back to state 0? (Now, I should note that I realize that usually not getting all versions to compress back to 0 is no reason to panic. But this all started when I was getting errors about conflicts during reconcile. Otherwise, I wouldn't have been poking around.) - Thanks for any clues! Happy Easter.  ... View more

Is there any way that a 'named user' Pro license that is being consumed by a service account has to be released so that the same account can "check out" this license on another machine? I know there is no real check in/out for named users. But I'm running into an issue where I want to have the same account running the same script on different machines but it will only complete on the first machine. I can schedule it to run on either machine over night and it runs fine. As soon as I want to run it on both machines, it will fail on the second one. I've wrapped my import into try/except to make sure that's really where it's failing: try: import arcpy except Exception: with open(r'C:\temp\arcpyIssue.log','w') as failurelog: failurelog.write("Unable to get arcpy license") ‍‍‍‍‍‍ and that appears to indicate the arcpy import is the issue? Any thoughts? Shouldn't I be able to run as many instances of Pro or Pro licensed Python under the same account as I want? I seem to have no issues having instances of Pro open on multiple machines using my own account. ... View more

What exactly is the difference between manifest.json and manifest.xml. I mean both are a format for a service manifest but I thought JSON had replaced XML. Under what circumstances should I still be seeing XML when publishing map services to ArcGIS Server?  I'm using something like this to find data sources behind services and it bombed for any XML: manifestPath = os.path.join(folder, "extracted/manifest.json" ) if os.path.exists(manifestPath): with open(manifestPath,'r') as f: text = f.read() else: print(folder, "XML only") pass manifestJSON = json.loads(text)‍‍‍‍‍‍‍‍ Of course, if you use the ArcGIS Python API, you can do something like: from arcgis import gis mygis = gis.GIS('https://..../portal/home/', username='arcgis_python') servers = mygis.admin.servers.list() server = gistest.admin.servers.list()[0] services = server.services ‍‍‍‍‍‍‍ Then, once you have a reference to a specific service, this works: service._service_manifest()‍‍ I was really just wondering where the XML comes from. Wasn't expecting to see that and I see it in a very few cases. ... View more

Just when you think you've read every thread about arcpy/Pro to get your script to run and feel confident to have mastered this ridiculous convoluted world, you're back to square zero. I mean I have literally spent hours reading about installation/configuration of Python 3.x/conda with ArcGIS Pro. I've replied to a number of threads feeling knowledgeable enough to chime in. But I don't know what's going on here.   I have an SDE maintenance script running on one server under a service (domain) account, and it works beautifully. I had to: Install Pro (this is 2.3). Create a Portal user for the service account (for licensing) and make it admin. Open Pro on server once and connect to correct portal. Upgrade to latest version of arcgis package. No other changes to conda env. Only: C:\Program Files\ArcGIS\Pro\bin\Python\envs\arcgispro-py3 Write my script. Set up a Windows Scheduled task to use service account and run script with highest privileges Grant service account logon-as-service/RDP access Cross my fingers, and .. Boom everything worked.   Now, on server 2, where I did the exact same thing, same script, same tasks, same service account, nothing happens. Can't run Python as service account. That gives me an Application Error 0xs0000022.   The application was unable to start correctly (0xc0000022). Click OK to close the application. Inside Pro (running as srv account), I can open Python window but when I import arcpy, I get: PermissionError: [Errno 13] Permission denied: 'C:\\Program Files\\ArcGIS\\Pro\\bin\\Python\\ envs\\arcgispro-py3\\Lib\\site-packages\\mkl_fft\\__init__.py' What am I doing wrong, what step did I skip or screw up on ? Thanks. ... View more

Trying to take a subset of available layers in the map of an ArcGIS Pro project (aprx) and make sure they are in the right order. (I'm trying to dump the arranged layers into a PDF).  Originally I started out just hiding (setting layer.visible = False) for any layers I don't want. But while there were no errors, it didn't yield the expected results. The resulting layer order in the aprx is not the same as in Pro. So I thought about removing all layers and adding back in those that I need. While I can do this: while map.listLayers(): map.removeLayer(map.listLayers()[0])‍‍‍‍ ...to get rid of all layers, I can't do something more refined like: layerNames = ['layer 1', 'layer 2', 'layer 3' .... ] for layerName in layerNames: map.removeLayer(map.listLayers(layerName)[0])‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍ That blows up even though my layer names... for layerName in layerNames: ----> 6 map.removeLayer(map.listLayers(layerName)[0]) IndexError: list index out of range‍‍‍‍‍‍‍‍‍‍‍‍ ... are all included in the list that is ... [l.name for l in map.listLayers()]‍‍ So I can't figure out what's going on. I've tried individual layers and have found a few that worked. But I can't tell what's different about them. Depending on what type of layer it is, it's also hard to compare values for all the attributes.. 'brightness', 'connectionProperties', 'contrast', 'dataSource', 'definitionQuery', 'extrusion', 'getSelectionSet', 'is3DLayer', 'isBasemapLayer', 'isBroken', 'isFeatureLayer', 'isGroupLayer', 'isNetworkAnalystLayer', 'isNetworkDatasetLayer', 'isRasterLayer', 'isWebLayer', 'listLabelClasses', 'listLayers', 'longName', 'maxThreshold', 'minThreshold', 'name', 'saveACopy', 'setSelectionSet', 'showLabels', 'supports', 'symbology', 'transparency', 'updateConnectionProperties', 'updateLayerFromJSON', 'visible'‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍ So if I go the route of removing all layers... map = aprx.listMaps()[0] layers= [l for l in map.listLayers()] while map.listLayers(): map.removeLayer(map.listLayers()[0])‍‍‍‍‍‍‍‍‍‍ and then try to add one back... map.addLayer(layers[0],'TOP')‍‍ I get this error: C:\Program Files\ArcGIS\Pro\Resources\ArcPy\arcpy\utils.py in fn_(*a, **k) 189 "Invalid value for %s: %r (choices are: %r)" % 190 (key, val, list(cls.__args__[key].values()))) --> 191 return fn(*args, **kw) 192 # Add the old argspec to __doc__ 193 doc_addendum = "%s%s" % (fn.__name__, C:\Program Files\ArcGIS\Pro\Resources\ArcPy\arcpy\_mp.py in addLayer(self, add_layer_or_layerfile, add_position) 1135 1136 * TOP: Places the layer or layers at the top of the TOC layer stack.""" -> 1137 return convertArcObjectToPythonObject(self._arc_object.addLayer(*gp_fixargs((add_layer_or_layerfile, add_position), True))) 1138 1139 @constants.maskargs ValueError: <MappingLayerObject object at 0x0000012704F6B570>‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍ Anyone have any idea what's going on here or what I should do instead? ... View more