Latest Contributions by DavidColey

Hi Glen, thanks.  Yeah we have arcpy code to disconnect users from sde so like you we are ok there.  From what I can read in the auth package the EsriSession.close() method works off something called the EsriSession.adapters property, but I have no idea how to get to that and so I don't know what that dictionary would even list.   @Clubdebambos  ... View more

Hi @Katie_Clark and @Clubdebambos - this is great, thank you both for posting.  We adopted Named User model this week and as such I just began looking into usage reports and this will help greatly. I was wondering however if either of you have come across anything that can force a session close.   I began looking into the api here https://developers.arcgis.com/python/latest/api-reference/arcgis.auth.html#arcgis.auth.api.EsriSession.close but so far have not come across anything to loop through open pro sessions and close them down as way to make certain we don't have any users connected to SDE and/or network directory locations while in pro that may produce locks on file gdb layers.  Not quite sure where to initiate an EsriSEssion.close(). If I come across anything I'll post a new question, and reference you guys and this post....Otherwise, if you come across anything that would be great. ... View more

Ok Kevin, like I said I ". . . extract our MSSQL features (including some UN network features) to file gdb.  Those layers are shared to portal using the ArcPy sharing module from Pro.  Each week I then overwrite the service definition file, un-pause the sync and then re-sync the layers. " All I am doing here is using ArcPy to ExportFeatures from SDE to a file gdb. If the layer exists in the file gdb, it is deleted first.  I then use the file gdb sourced layers to publish either a hosted feature layer or a feature layer collection from Pro to Portal and then share the layers with the Open Data groups. Once the hosted feature layer is in place in portal, I use the arcpy sharing module to overwrite the service definition file as a 3-step process:  create sd draft, stage sd and overwrite sd: def stageSDDraft(mp,lyrName,summary,lyrList,descript,folder,tags,sdfolder): # mp,lyrName,summary,lyrs,descript,folder,tags,sdfolder sddraft_out = "C:/ArcProProjects3x/PortalUpdates/" + sdfolder + "/" + lyrName + ".sddraft" draft = mp.getWebLayerSharingDraft("HOSTING_SERVER", "FEATURE", lyrName, lyrList) # if don't include lyrList arg here the draft will include all map layers. draft.portalFolder = folder draft.tags = tags ##draft.allowExporting = True draft.summary = summary draft.description = descript draft.overwriteExistingService = True draft.exportToSDDraft(sddraft_out) return try: portal = arcpy.SignInToPortal("https://yourorg/portal", "username", "password") aprx = arcpy.mp.ArcGISProject('C:/ArcProProjects3x/PortalUpdates/PortalUpdates.aprx') for m in aprx.listMaps("Land Management"): print("Map: " + m.name) for lyr in m.listLayers(): if lyr.name == 'wdFireHydrant': lyrList = [] lyrList.append(m.listLayers(lyr.name)[0]) print(lyr.name) stageSDDraft(m, lyr.name, "Points representing Fire Hydrants.",lyrList, "Points representing Fire Hydrants.","LandManageLayers","Utilities,Water Device","ParksRec") print(lyr.name + " Draft Created") arcpy.StageService_server('C:/ArcProProjects3x/PortalUpdates/ParksRec/' + lyr.name + '.sddraft', 'C:/ArcProProjects3x/PortalUpdates/ParksRec/' + lyr.name + '.sd') print(lyr.name + " Service Staged") arcpy.UploadServiceDefinition_server('C:/ArcProProjects3x/PortalUpdates/ParksRec/' + lyr.name + '.sd', 'My Hosted Services', "","","","","","OVERRIDE_DEFINITION","SHARE_ONLINE","PRIVATE", "NO_SHARE_ORGANIZATION","Land Management Group") print(lyr.name + " Service Uploaded") message = message + "\n" + "1. " + (lyr.name) + " Service Uploaded"   That's it.  You can loop through as many layers as you need per map by adding more if layer.name = "AnotherLayer" if blocks.... ... View more

Hello @DavidHood_USFS  - I would say something about how the filter is set isn't matching what the query tool want for its key word arguments 'kwordargs'.  Or,  something in your query filter is non-standard sql.  Pro can interpret it fine, but the ArcGIS Online environment cannot.  Or, because you are using datetime in your query, maybe ArcGIS Online Notebooks isn't setting or reading those datetime stamps like you expect. But IDK, that's just what I see from the error.... ... View more

Hello @KevinPiraino2  - anytime you are trying to work with an 'As-Copies' distributed collaboration workspace model, the source feature cannot be overwritten because the workspace ID is changed. As-Copies distributed collaboration workflows expect that the source feature on your guest portal will remain in place, and not be overwritten in any way, because as 'As Copies' distribution thinks that you are going to be making changes, edits etc directly to the portal hosted feature layer.  It doesn't matter if the source feature is a portal-hosted feature layer or an RDBMS hosted feature service.  I have some 13 distributed collaboration workspaces setup for portal hosted feature layers to sync across to our AGOL org.  Our workflow extracts our MSSQL features (including some UN network features) to file gdb.  Those layers are shared to portal using the ArcPy sharing module from Pro.  Each week I then overwrite the service definition file, un-pause the sync and then re-sync the layers.  This only works because our collaborations are all set up as 'By Reference'. Hope this helps   ... View more

Hi @Justin_Greco  - can't say I ran into similar issues, but I did have trouble with the deprecation of tileCache store when I moved from 11.3 to 11.4.  You've probably already seen these posts where I've tried to detail my issues: https://community.esri.com/t5/arcgis-enterprise-questions/arcgis-datastore-11-4-replace-ssl-certificate-for/td-p/1587964 https://community.esri.com/t5/arcgis-enterprise-questions/tilecache-store-deprecation-at-11-4-can-the/td-p/1564086 While we do have a fully distributed deployment on Windows Server 2022, it is not HA. and so I can't speak to potential communication issues between primary and stand-by.....      ... View more

No @cdevault_pickett - the manual update method for me at 11.4 worked just fine so I had nothing else to troubleshoot.  I'm now at 11.5 so maybe @RobertCollins has some answers.... ... View more

The only time I have had a failed ArcGIS Server upgrade was here: https://community.esri.com/t5/arcgis-enterprise-questions/arcserver-hosting-site-11-2-won-t-create-the/m-p/1361752 When we were upgrading from 11.1 to 11.2.  For whatever reason the ArcGIS Server.exe windows service could not be created.   We rolled back the Portal server and the Hosting Site ArcGIS Server servers from their respective snapshots.  I then cleaned/upgraded/deleted/re-created any corrupted or otherwise mal-behaving items and hosted feature layers. I recommend you do the same if you have not already.  Of I made sure Server requirements were in place (i.e dot net) and then most importantly, I convinced my IT security team to allow me to disable active virus scanning during the re-upgrade.   This alone reduced what was about a 3-4 upgrade and post-upgrade time down to 30 minutes per machine for my 2-machine cluster Host site.  Disabling AV during also meant that I no longer had any issue with the domain arcgiserver account needed to run the windows services.    ... View more

Hi  - how can we get this idea implemented?  There needs to be a way to limit the number of attachments that are allowed on any feature class in an Enterprise or File Geodatabase.  Short of that, we need a way to be able to set a limit on the number of attachments allowed on any hosted feature layer.  We have too many users storing too many photos on features because they think that a photo attachment creates a type of archive mechanism. So - there has to be a way to limit the number (not just the size) of attachments allowed on any feature. I am going to re-post my comment under data management... ... View more

Over the years I have tried adjusting the setting for "maximum time a client will wait to get a service" and have found that it just gets you nowhere.  I never pay attention to  log entry anymore because so many things can affect what is driving a wait time.  I have found that it is best to just leave it as is.  If you can get ArcGIS Monitor setup and begin looking at a metric called 'Instance Saturation', that will tell you how busy a service is throughout the day.  For example, I have a map image service serving 300K plus rows for Annotation that is heavily used in a very busy Experience.  I had it set to use (2x2) for 4 total dedicated soc instances.  At that setting, the Saturation was at 100% for much of the day.  By increasing it by just one soc instance (3x3) to 6 total dedicated soc instances, that drove the Saturation levels down to 40 - 50% for most of the day. This in turn decreases the number of timed out requests.  ... View more

shoulda figured you did.... ... View more

Could be something with the monitors' postgres sql.  Maybe try re-registering or removing and re-adding a 'Host' machine, see if that helps? ... View more

Yes both the ExB editor and the Instant app config page show no errors when modifying my apps, behavior feels more solid. Thank you esri.   @TapanDhar1 @mwartman_grey @JuanMarvinW ... View more

yes this definitely looks like this should resolve both the "Chunk" error and the (hopefully) the React.org resource access errors. Thanks for the post reply on this @mwartman_grey , I don't know why I don't get these patch notifications any more.  I'll apply tonight and we shall see. ... View more

I thought that might be the case. Problem was when I included the field in the widget I still did not have the option - that is the attribute still did not show as a choice.  Must have been some lag in the Online ExB editor as this morning when I include the attribute I do see the field as a choice. ... View more