Latest Contributions by RyanUthoff

‎02-02-2026

Yep!

‎02-02-2026

I just upgraded one of our ArcGIS Enterprise environments from 11.2 to 11.5 and noticed that the upgrade "breaks" the pg_hba.conf file in the ArcGIS Data Store. When using the allow connection data store command line tool to allow connections to the ArcGIS Data Store, it adds them to the pg_hba.conf file like this: host db username ip/hostname scram-sha-256 However, after upgrading to 11.5, the upgrade changed all the entries from "host" to "hostssl" which breaks any and all connections to it (including the ArcGIS Server). For example, it changed it to this: hostssl db username ip/hostname scram-sha-256 After upgrading, all of my hosted services didn't work and saw a "bad user login" message in the ArcGIS Server logs. Luckily, I've worked with the ArcGIS Data Store enough to know what this message means. Running the allow connection data store command "fixes" this by adding a new entry with only the "host" option. What I am looking for is a little bit of clarity on why this happened, because it appears that the ArcGIS Data Store isn't even compatible with any "hostssl" connections in the first place for two reasons: The previously existing ArcGIS Server entry in the pg_hba.conf file didn't work by default after the upgrade, nor did the Esri upgrade mitigate this by adding a new "host" only entry. Even after upgrading, the allow connection data store command line adds entries only as "host" and not "hostssl", despite the upgrade changing everything to "hostssl". I'm unable to find anywhere in Esri's upgrade documentation stating that re-adding entries to the pg_hba.conf file is a required step, so I'm just wondering why Esri changes all of the entries in the pg_hba.conf file when it's not even compatible in the first place? If anything, hopefully this will help others who encounter this issue considering this is not a documented step in the upgrade process.

‎01-31-2026

I've been following this thread closely since I was eventually going to be upgrading to 11.5. I upgraded one of our ArcGIS Enterprise environments today and ran into one issue with the ArcGIS Data Store. Upon upgrading the ArcGIS Data Store, I was not able to validate it in ArcGIS Server Manager and none of my hosted services worked. The server manager logs stated "bad user login" or something like that in reference to the data store. Luckily, I have enough experience with the ArcGIS Data Store and making direct connections to it to know that I need to use the allow connection command to allow our ArcGIS Server machine to access the ArcGIS Data Store (which under the hood, just adds an entry in the pg_hba.conf file). After running that command, everything worked fine. Unfortunately, this is not documented in Esri's data store upgrade documentation. I also don't know why we'd have to allow our ArcGIS Server to access the data store when it worked perfectly fine before the upgrade. We didn't make any architectural changes (hostname changes, IP changes, etc.) during this upgrade. Anyway, just thought I'd post this here to hopefully help anyone else that might encounter this issue.

‎01-26-2026

Per the bug page, this was fixed in ArcGIS Pro 3.6. Just because a version is still "supported" doesn't mean that every bug will be fixed in that version. In my experience, only the "major" bugs will be fixed in previous versions. Otherwise, anything else will be fixed in new versions going forward. https://support.esri.com/en-us/bug/the-arcgis-pro-taskbar-icon-is-no-longer-readable-after-bug-000177777

‎01-21-2026

I can replicate this issue. It's kind of weird that Esri would allow a user to delete their own account through the rest endpoint (this is the case even when not using a custom role and just using a viewer user type and role). Luckily, it appears the changes the user can make are isolated to their own account and not anyone else. Also, it appears that the user isn't allowed to do other things, like create groups, etc. which is good. With that being said, in my opinion, Esri allowing a viewer only user type (or an account with a role without administrative privileges) to delete their own account is an explicit violation of Esri's own security roles. If the role privilege below is disabled, Esri should not allow that user to be able to delete any accounts, not even their own. On a side note, if you don't want people having access to the portal rest endpoint at all, you can always disable it. https://enterprise.arcgis.com/en/portal/11.5/administer/windows/disabling-the-arcgis-portal-directory.htm

‎01-21-2026

What do you mean by you want to run the python externally? Does that mean you do not want to use ArcPy since that requires ArcGIS Pro (even if you run it completely outside of ArcGIS Pro)? If you're fine using ArcPy, @DanPatterson's solution should work since you can set that parameter in the Python script.

‎01-16-2026

I'm preparing for an upgrade to 11.5 myself, so I've been reading all the various documentation for each version and see they added some ports that need to be open for Portal to work. In 11.3, ports 7820, 7830, and 7840 need to be open. You might want to verify those ports are open on your machine.

‎01-13-2026

I tried to replicate your exact same settings to see if I could get it to not allow me to disable sync, but no matter what I do, it allows me to disable it. So I'm not sure why it won't let you disable it.

‎01-09-2026

The reason you can only add new features is because "Enable sync" is enabled on the feature layer settings page. You will need to disable it in order for the "update features" button to be selectable when updating the feature layer.

‎01-09-2026

The answer might depend on your DBMS. What type of database is your data in? An enterprise geodatabase, file geodatabase, etc.? If it is an enterprise geodatabase, I believe you can setup a trigger in the DB that triggers when a new record is inserted into the table that will write that record to the other table. Unfortunately, I don't think automatically copying records from one table to another upon insert of a new record is something that is possible in a file geodatabase, but someone might be able to correct me if I'm wrong. My best advice for that scenario would be to create a model or script that periodically syncs the original table with the cloned table. On a side note, I don't know what your use case is for creating the "cloned" table, but if it's just for the purpose of sorting, you can just create a "copy" of the layer in the table of contents in ArcGIS Pro and change the sorting that way. That way you have two different layers in the map with different sorting, but they are both using the same source table so you don't have to deal with two different copies of the same table. Meaning that any updates you make in that table will be reflected in all copies you made in the table of contents.

‎01-07-2026

Oh, gotcha. I was just providing a potential workaround since I thought you weren't able to export the attachments at all. I'm not sure if attachments are supported through Hub or not. I can't find anything in Esri's documentation about that either.

‎01-07-2026

It says right on the page you linked that if you want a copy of the data with attachments, that you need to contact them. With that being said, the source data is just a REST service, so you can always just add it to ArcGIS Pro and then use the Export Table tool to export the data with attachments into a FGDB.

‎01-06-2026

I had a problem similar to that last year. It's a slightly different scenario, but the solution in this post might help you. Also, you can try resetting the app in Windows Settings. Open Windows Settings and go to Apps > Installed Apps > ArcGIS Survey123 Connect > Advanced Options and then click the reset button.

‎12-18-2025

Oh, I misunderstood. I thought you were asking how to specify the join type (LEFT, INNER, etc.). I'm not able to find any documentation about that either. But, now I'm curious so I took a deep dive into it. I looked at the internet traffic and compared the requests for one to one vs. one to many, and I did notice some differences. Often times, the API parameters will match the internet requests. So if I can see what the internet request is doing, I might be able to track it back to the API. For example, I am able to see the "Type" parameter (for the join type) in the internet request. In the case of the join operation, I'm not seeing anything obvious (like where it is explicitly called out). However, this is added in the request for a one to one join operation. "topFilter":{"groupByFields":"FieldName","orderByFields":"OBJECTID ASC","topCount":1}}] Besides that, everything is the same for one to one vs. one to many. So.....looking at the relatedTables documentation you provided, there is a groupByFields parameter. So, you might be able to specify the groupByFields parameter (to the field name of the child table) and it's possible Esri will treat it as one to one. And if you don't specify it, it might treat it as one to many by default. With all that being said......Esri should definitely make that option easily available like they do with the join type. There's no guarantee that anything I said will work and correctly specify the join operation, but it's something to look into.

‎12-18-2025

Does this tech support article help any? If you go to step 6, you can see how they specify the join type (in the case of the example, it is a LEFT join). https://support.esri.com/en-us/knowledge-base/how-to-create-a-joined-hosted-feature-layer-view-using--000032931

Online Status	Online
Date Last Visited	4 hours ago

My Ideas

Latest Contributions by RyanUthoff

Re: ArcGIS Data Store Breaks pg_hba.conf File During Upgrade

ArcGIS Data Store Breaks pg_hba.conf File During Upgrade

Re: 11.5 upgrade observations

Betreff: Icon size in taskbar

Re: Custom member role without permissions

Re: Preserving GlobalID from enterprise database to fileGDB

Re: Portal 11.5 Upgrade problem

Re: Unable to update data attributes

Re: Unable to update data attributes

Re: Automatically appending a new feature from one table to another table

Re: Can you download attachments from public view layer in Hub?

Re: Can you download attachments from public view layer in Hub?

Re: ArcGIS Survey123 Connect not signing in

Re: How to set join operation (1:1 vs 1:M) when creating a Joined View

Re: How to set join operation (1:1 vs 1:M) when creating a Joined View

Re: Limit the size of the ArcGIS Data Store

Re: Why Still Require a Security Question After In...

Why Still Require a Security Question After Instal...

Re: Best Practice to see video data via Online

Re: Best Practice to see video data via Online