Latest Contributions by Joshua-Young

We use ArcGIS Enterprise primarily. Our data is hosted in our data center but we still use Esri's basemaps. We sometimes lose our internet connection and all of our maps stop working until the internet comes back up. We do have a simple basemap that I created using our own data and it would be very helpful to have our maps automatically switch to it when the Esri basemaps cannot be reached. ... View more

@GlenterpriseUK thank you for letting me know. I am guessing Patch D will not resolve the missing function crash that was happening in the Data Store upgrade? I need our system up and running stable for events on July 3rd and 4th this year, so I am leery of trying the update again before those events. I am looking forward to upgrading to 12.1 but now it will probably happen mid-July at the earliest. At least after all these years I now know that my backups mostly work 😁. ... View more

I can see why Esri would be reluctant to allow Viewer accounts to fill out surveys. While people have provided great examples of situations where it is silly to buy and assign Field Worker licenses for things like once a year use, I could see it being abused to work around the Field Worker license for daily field work. Now that being said, I think a reasonable compromise could be reached by only allowing Viewers to submit surveys through the web interface. No access to the mobile app or offline surveys. Surely Esri can set permissions so that "edits" through the Survey123 website are allowed but all other "edits" from Viewer accounts are rejected. ... View more

I can see why Esri would be reluctant to allow Viewer accounts to fill out surveys. While people have provided great examples of situations where it is silly to buy and assign Field Worker licenses for things like once a year use, I could see it being abused to work around the Field Worker license for daily field work. Now that being said, I think a reasonable compromise could be reached by only allowing Viewers to submit surveys through the web interface. No access to the mobile app or offline surveys. Surely Esri can set permissions so that "edits" through the Survey123 website are allowed but all other "edits" from Viewer accounts are rejected. ... View more

@GlenterpriseUK I am more than happy to wait 😁 . In approximately nine years, this is the first time I have had to roll back an upgrade. Not the first time I have had issues with an upgrade, just the first time it was severe enough I couldn't work around the problem. ... View more

@GlenterpriseUK does the "Portal for ArcGIS Security 2026 Update 1 Patch" need to be removed to upgrade from 11.5 to 12.0 as well? Esri Support has me rolling back to 11.5, then suggested trying an upgrade to 12.0, and then to 12.1. ... View more

Esri Support did not have a fix or a known cause. The next course of action is to roll back to 11.5. My options at this point are to wait at 11.5 until Esri figures out what is going on, or try upgrading to 12.0 and then try 12.1. ... View more

@GlenterpriseUK I have a called with Esri Support later this morning to figure out what to do next. Repairing the ArcGIS for Portal 12.1 installation got the service to start. The post upgrade got to the last step and then portal stopped accepting connections until the service was restarted. In the portal admin directory it said the upgrade completed with warnings. ArcGIS Server seemed to upgrade without issue. ArcGIS Data Store upgraded the install directory without errors or warnings, but fails to upgrade the relational data store. When it tries to upgrade the relational data store below is what I am finding in a log file. pg_restore: creating FUNCTION "sde.st_geometry_accum_func("sde"."st_state_data_type", "sde"."st_geometry")" pg_restore: while PROCESSING TOC: pg_restore: from TOC entry 6768; 1255 18361 FUNCTION st_geometry_accum_func("sde"."st_state_data_type", "sde"."st_geometry") sde pg_restore: error: could not execute query: ERROR: could not find function "st_geometry_accum_func" in file "C:/Program Files/ArcGIS/DataStore/framework/runtime/pgsql/lib/st_geometry.dll" Command was: CREATE FUNCTION "sde"."st_geometry_accum_func"("sde"."st_state_data_type", "sde"."st_geometry") RETURNS "sde"."st_state_data_type" LANGUAGE "c" AS 'st_geometry', 'st_geometry_accum_func';   ... View more

@DavidColey I am upgrading a multi-machine deployment. The antivirus was disabled during the upgrade on all machines. I have tried repairing the install, restarting the ArcGIS Data Store service, and restarting the server. This has been the most troublesome upgrade I have had in many years. ... View more

@NicolasGIS I did have the "ArcGIS Data Store 11.5 Reliability Patch" installed before the upgrade, but the ArcGIS Data Store service starts without any issues after the upgrade. It is during the upgrade of the relational data store that the process throws an error and quits. In the pg_upgrade_output.d folder there is a log that has this: pg_restore: creating FUNCTION "sde.st_geometry_accum_func("sde"."st_state_data_type", "sde"."st_geometry")" pg_restore: while PROCESSING TOC: pg_restore: from TOC entry 6768; 1255 18361 FUNCTION st_geometry_accum_func("sde"."st_state_data_type", "sde"."st_geometry") sde pg_restore: error: could not execute query: ERROR: could not find function "st_geometry_accum_func" in file "C:/Program Files/ArcGIS/DataStore/framework/runtime/pgsql/lib/st_geometry.dll" Command was: CREATE FUNCTION "sde"."st_geometry_accum_func"("sde"."st_state_data_type", "sde"."st_geometry") RETURNS "sde"."st_state_data_type" LANGUAGE "c" AS 'st_geometry', 'st_geometry_accum_func'; ... View more

I just found that I am getting a missing function error in the st_geometry.dll. I have tried the ST_Geometry downloads from My Esri for ArcGIS Enterprise 12.1 and ArcGIS Pro 3.7 and they are apparently missing the function as well. pg_restore: creating FUNCTION "sde.st_geometry_accum_func("sde"."st_state_data_type", "sde"."st_geometry")" pg_restore: while PROCESSING TOC: pg_restore: from TOC entry 6768; 1255 18361 FUNCTION st_geometry_accum_func("sde"."st_state_data_type", "sde"."st_geometry") sde pg_restore: error: could not execute query: ERROR: could not find function "st_geometry_accum_func" in file "C:/Program Files/ArcGIS/DataStore/framework/runtime/pgsql/lib/st_geometry.dll" Command was: CREATE FUNCTION "sde"."st_geometry_accum_func"("sde"."st_state_data_type", "sde"."st_geometry") RETURNS "sde"."st_state_data_type" LANGUAGE "c" AS 'st_geometry', 'st_geometry_accum_func';   ... View more

@NicolasGIS I was able to get past the ArcGIS for Portal issue after Esri Support provided the registry key after all and a repair of the installer. Now for more hours than I would like to admit, I am stuck on an issue with my relational datastore upgrade. So far, I have found nothing useful in the logs and have tried repairing the ArcGIS Data Store install. Are you running into the issue below, and if so have you found a workaround? Attempt to configure data store failed. Caused by: No valid connection to ArcGIS Data Store configuration store established. Caused by: FATAL: database "dsadmindb" does not exist ... View more