Latest Contributions by Joshua-Young

@DavidColey just to make sure I understand this correctly. You ran the restoredatastore command on the backup of the 12.0 version of the relational data store with ArcGIS Data Store 12.1 installed? So, the restoredatastore command upgraded the backup from 12.0 to 12.1 as part of the restore process? ... View more

Hello @jill_es , I do not understand what the ArcGIS for Portal patch has to do with the ArcGIS Data Store issues that have been mentioned. I am glad to hear that the ArcGIS for Portal issue has been identified and resolved. Could the team now look at why Data Store upgrade is encountering errors? Issues I have seen mentioned on Esri Community are: 11.5 to 12.1 upgrade the ArcGIS Data Store service fails to start after upgrading (possibly due to the Data Store reliability patch). The 11.5 to 12.1 upgrade failing to upgrade the relational data store. Error encountered during the pg_restore process because the "st_geometry_accum_func" is missing from the st_geometry.dll. The 12.0 to 12.1 upgrade failing to upgrade the relation data store. The process fails with a dsadmindb not found error. I have already had to roll back our environment from 12.1 to 11.5 once and I really do not want to do that again so soon. I only have a production environment so I cannot just hope the Data Store issue #2 went away because I restored from a backup. ... View more

@DavidColey if you still have the failed upgrade arcgisdatastore folder, in the pgdata folder is there a folder called "pd_upgrade_output.d"? Inside of that were the logs that detailed why my relational datastore was failing to upgrade. I was getting this error whether I tried to run the upgrade through the website or command line. 2026-06-01 12:37:49.231 CDT [9372] ERROR: could not find function "st_geometry_accum_func" in file "C:/Program Files/ArcGIS/DataStore/framework/runtime/pgsql/lib/st_geometry.dll" Apparently the 11.5 relational datastore is running on pg16.x as well. I even went My Esri and got the standalone PostgreSQL v18 st_geometry.dll from the ArcGIS Pro 3.7 and ArcGIS Enterprise 12.1 pages. The upgrade still failed with those DLLs. ... View more

@ZachBodenner we are not using only hosted data, and you are correct that dynamic date filters can be set before publishing for referenced data. I do feel like this idea applies to both hosted and referenced layers, but the bigger need is for hosted layers. If dynamic date filters are supported at the web map level then it does not matter what kind of service is involved. ... View more

@JonEmch would the Portal for ArcGIS Security 2026 Update 1 Patch D have anything to do with fixing the issues mentioned in this thread? I am guessing it does not. Even though I rolled back to 11.5, I am guessing my relational database still has the st_geometry_accum_func function stored in it somewhere and the 12.1 st_geometry.dll does not have that function. Is that function supposed to be removed from the database during the upgrade? Was it supposed to be removed during a previous upgrade (my relational data store goes back to at least 10.9.1) ... View more

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 rolled most of my environment back to 11.5 (the Object data store would not restore from backup, another unknown error there). The current advice from Esri Support is to not upgrade from 11.5 to anything until some patches are release. The data store issue I experienced appears to be separate from the ArcGIS for Portal BUG-000185267. ... 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