Latest Contributions by DavidColey

Hello - it looks to me like you have an account issue.  You should have seen this from step 5 in the help: https://enterprise.arcgis.com/en/portal/latest/administer/windows/upgrade-data-store.htm#GUID-FBB3BFAC-E026-4F5E-A60C-D0E2258F1814 "The account used by your existing installation is prepopulated in the ArcGIS Data Store input box. Provide the password for the account. Typically, this is the password you defined when installing the software . . . . "     This should be the same domain account that is running server.  If the datastore server can't get to that domain account, it looks like it's defaulting to the datastore internal local account.       ... View more

Hi, so in a related thread - Frequent "The database server was found to be stopped. Re-starting it."  I just laid out what was killing the arcgisportal.exe and postgres.exe processes in our case.  But I also found that for 10.8.1 the exception listed above by Steve Maskol‌ has changed slightly.   Where Steve listed his fix to the  pg_hba.conf file located in the folder \arcgisportal\db\. I added an entry under the "IPv6 local connections:" section in the file: host all all ::1/128 md5 the METHOD has changed from md5 to scram-sha-256.  Otherwise everything else is the same.  Sadly though, the log now reads this over and over 2020-11-05 10:24:24 PST: [98028]: FATAL: password authentication failed for user "ourdomainaccount" 2020-11-05 10:24:24 PST: [98028]: DETAIL: Role "ourdomainaccount" does not exist. Connection matched pg_hba.conf line 12: "host all all ::1/128 scram-sha-256" I know that the postgres db wants our domain account listed in its datastore but I don't know how to do that.  It just seems that the posgres db wants the account to be local. Jonathan Quinn‌ thought you'd like to know, but for now, other than filling the log, this does not seem to be causing an issue since we added the processes trust I listed in the related thread. ... View more

Hi - In my distributed deployment, I too began experiencing the same error: "Database server found to be stopped. Restarting it".  When this was infrequent, not a big deal..... but recently this began to occur with much greater frequent and has now interrupted both data writes and the portal backup routine when the postgres is offline. Obviously. In our case, we use McAffee.  We found that by removing the ArcGISPortal.exe and the postgres.exe processes from active McAfee inspections (I think its the McAffee Adaptive Threat Protection Service) and adding them to the trust exclusion that has now eliminated this issue.  So similar to the Carbon Black issue identified above by Michael Schoelen‌.  I also told our security team that these processes along with all the other core processes used by server, datastore, and portal should be trusted and not inspected, per all the help docs.  Jonathan Quinn‌ and Michael Volz‌ thought you guys would like to know as well.... ... View more

Ok thanks to you both.  I had tried that but must have my csv headers wrong.  I am using csv files with pulldata functions, but can either of you tell me: does(do) the csv file header names for select_from_file need to be 'name,label' as in the xlsForm? ... View more

Hi - I've just updated to 3.11.  Unfortunately, the question types select_one_from_file and select_multiple_from_file  are not appearing as valid question types when beginning a new survey with the Advanced Template in Survey123 Connect. Do I need to add these types to the XLSForm 'Question types' worksheet so that these types will appear as valid selections in the 'type' column? Suggestions? Thanks- ... View more

Ok so you can launch Pro.  You can't go into the Python>Python Package Manger>Manage Environments>Clone Default GUI? ... View more

Oh right sorry.  I see that now here " I cannot create environments from the ArcPro GUI, ". No, I was not suggesting that. Can you launch Pro at all? ... View more

Clone the default and switch Pro to use the clone.  That way the separate Anaconda install may still work stand-alone.  I had trouble with that set up as well and no longer use the separate Anaconda, but I didn't really have a need for a separate install. ... View more

Plus all the layouts work ... View more

Hi Tanu - yes seems to be functioning properly in both the Enterprise map viewer, map viewer beta, and Web App Builder print widget.  Seems to work with raster layers, feature layers with and without labels, vector tile layers, image service layers and cached map service layers.  Can't test the dynamic map service layer in WAB because I don't have any, but I'm sure they print as well ... View more

So what I do is this: each week I overwrite the feature classes in my filegdb that support the map.  Now the data in the map is overwritten but the cache tiles are not.  They have to be re-created.  Using the Pro Idle, here's how that looks: # List of input variables for map service properties portal = arcpy.SignInToPortal("https://yourportal", "yourname", "yourpw") env.workspace = r"\\yourserver\.....\\DataConnections\\SqlProdSp.gdb" # must be registered location try: input_service = "https://......yourCacheService/MapServer" scales = [577790.554289,288895.277144,144447.638572,72223.819286,36111.909643] #0,1,2,3,4,5,6,7 full ext #scales = [9027.977411,4513.988705,2256.994353,1128.497176,564.248588] # mid ext #scales = [282.124294] #8,9,10,11,12,13] #,14,15 tilemapped # low ext update_mode = "RECREATE_ALL_TILES" # DELETE_TILES update_extent = "412741.7365287468 915208.8897668198 672826.0004799105 1141077.7300229892" #"XMin, YMin, XMax, YMax" stateplane #update_extent = "-9200240.24964 3116183.75439 -9132965.67576 3172857.76957" #"XMin, YMin, XMax, YMax" webmercator num_of_caching_service_instances = "-1" #14 don't need in pro print (scales) area_of_interest = "" wait_for_job_completion = "WAIT" portal_url = "https://yourportal" result = arcpy.ManageMapServerCacheTiles_server(input_service, scales, update_mode, num_of_caching_service_instances, area_of_interest, update_extent, wait_for_job_completion,portal_url) print ("Created cache tiles for scale = " + str(scales) + " and service at " + input_service + " using the full extent") message = message + "Created cache tiles for scales = " + str(scales) + " " + input_service + " using the full extent" except Exception: # If an error occurred, print line number and error message import traceback, sys tb = sys.exc_info()[2] e = sys.exc_info()[1] #print(e.args[0]) #print "Line %i" % tb.tb_lineno message = message + "\n" + "Line %i" % tb.tb_lineno message = message + "\n" + e.message‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍ What I have done is set up the cache tiling scheme to use the same levels as the web mercator tile scheme, because it works so well in the field, but I can still use stateplane coord system.  The cache levels in the service go all the way down to 1:70, but I only cache to 1:564 and then use the 'tilemap' capability on the service so that the service 'maps tiles' down to the lowest level.   The 'full ext' scale array above takes like 1 minute.  The 'mid ext' scale array takes about 50 minutes on our system. I run this as 2 scripts in a scheduled task. ... View more

Hi Gino - you say "The operational layer data is stored as versioned featureclasses within our Oracle database and served using ArcGIS Server 10.7.1." Are you sure this layer is prepped for offline use with global ids and that the sync and extract capabilities have been enabled on the feature access service?  ... View more

Yeah I have done all that.  Naming convention of the pdf attachment documents becomes very important when the total size of the service definition file causes the file to upload the json in parts.  When a json part is encountered that contains some invalid character at the beginning of the part - like an ampersand, the initial upload does not necessarily fail, but all of my overwrite attempts do.  Now that I understand that, I understand why my large service definition files with a 100s to 1000s of attachments, would fail upon overwrite, but not in the same place. ... View more

All I know is any layer in your basemap set as a reference layer will draw on top of any of your feature layers, map services, etc in the map.  That's by design and I think the only thing to do is not set as reference. ... View more