Latest Contributions by RyanUthoff

We encounter this exact same "problem." We have a few hundred surveys, all of which have photos in them which consume a lot of storage space on the server. And unfortunately, just "deleting" the photos through Esri isn't good enough. Under the hood, the ArcGIS Data Store is just a PostgreSQL DB. And for surveys (or any hosted feature services with sync enabled), Esri typically treats them as a "versioned" dataset, where you have your base tables along with the associated versioned tables. When interacting with the data through Esri, it's always using the versioned view. So for example, if you're viewing the data in ArcGIS Pro or in Portal, you're looking at the versioned view of the dataset. And any modifications you make, including deleting the data, get reflected in the view, but not necessarily the underlying base table. If I delete a record in Pro, that will be reflected in the view, but not the underlying base table. This is where it becomes a problem, because it gives you the impression that the data is deleted, but it actually isn't. Unfortunately, this is where it becomes difficult to fix the problem because Esri doesn't really have any out of the box tools to deal with this. Several years ago at the UC, someone from Esri told me that you can disable sync and then re-enable sync capabilities of the hosted feature service, and that would get the changes you made in Pro/Portal reflected in the underlying base tables and that would truly "delete" all the records. While I believe that is technically correct, it also corrupted the hosted feature service for us (I think because we had a huge feature service and it timed out or something). So we don't use that method. The alternative method is connecting directly to the Data Store DB directly through PGAdmin. From here, you can delete the records in the base table. However, deleting the records from the table does not actually decrease the table size or give the space back to the OS. The final step you have to do is run a vacuum full command on that table in PG Admin. What that does is actually free the space back up to the OS, and will also result in smaller Data Store backup sizes. Edit: Just to add, I created an ArcGIS Idea several years ago about this. ... View more

Esri's system log parser should be able to do that (and much more). https://community.esri.com/t5/implementing-arcgis-blog/arcgis-enterprise-analysis-with-system-log-parser/ba-p/1189005   ... View more

Hmm, that's odd. I'm not sure what could cause it to suddenly stop working then. Especially if nothing has changed with the server between yesterday and today. Someone else might have some ideas, otherwise it might be something for Esri support to look into. ... View more

That's odd. Are you able to access the service in an AGOL web map? Like after it asks you to enter your credentials when adding it to a map, does it load any data? ... View more

The biggest thought I had is that the SSL certificate expired or something. Which would explain why it suddenly stopped working today. But otherwise, I'm not sure what it could be right off. ... View more

Something most likely changed on the server that is hosting those secured services. You might need to work with your GIS Server Admin and/or IT department and verify if anything has changed with the ArcGIS Server. Here is a support article that lists some of the reasons why that store credentials option is missing. https://support.esri.com/en-us/knowledge-base/the-option-to-store-credentials-is-not-available-when-a-000012369 ... View more

What exactly about that process isn't working for you? I was able to follow that process in the blog you listed and it worked fine for me. If your secured services are no longer working in AGOL, then that would indicate an underlying problem with the ArcGIS Server the secured services are coming from. Or possibly the credentials that were used to secure the service with were changed and need to be updated in the service. ... View more

I am not able to replicate this behavior in 3.5. Per the 3.5 documentation, it states: "when a dataset with a known coordinate system is input to this tool, the tool will issue a warning message but will run successfully." I don't think Esri intentionally took away that functionality. I suspect it's just a bug. You'll probably have to reach out to support and see if they can reproduce the issue on their end. ... View more

It could be several things that are causing performance issues and it's hard to troubleshoot without knowing your IT architecture. Are the resources on your postgres VM good? Not maxing out or anything? Where is ArcGIS Pro in relation to the postgres VM? I'm assuming your end users aren't in the postgres VM itself, so are they all on their own machines? Are they using VPN to connect to the DB? Using VPN to connect to DBs (for example, desktop Pro users requiring VPN to access DBs that are hosted in the cloud) will significantly impact performance. Can you install ArcGIS Pro on the Postgres VM to see if you can replicate the slowness there? If you cannot replicate the slowness, then it will be a network related issue. Do you have any web maps (like in ArcGIS Enterprise) that are also using DBs from that Postgres VM? If the answer is yes, do you have any performance issues there? If you do not have any performance issues there, then it is likely a network issue between your end users and the VM. ... View more

Do the fields that are not showing up for you in the drop-down contain a domain (where you select from a list of pre-populated values instead of free-text entry when creating/editing a feature)? If the answer is yes, then it won't show up. For a field to be searchable, it must not contain a domain. ... View more

Is your shapefile or feature class that you want to add locations to in your map? They need to be in the map in order for them to show up in the menu when you click Add to Feature Class. ... View more

Is there anything in the address points attribute table that differentiates between inside and outside city limits? If there is, what you can do is create different Label Classes based on a query. Or in this case, create a single Label Class where "inside outside city limits = yes" and only label those features.    ... View more