Latest Contributions by danbecker

‎02-02-2023

On-prem deployment has https://gis.domain.com being passed through our firewall to our webadaptor vm, port 443 only. *.domain.com CA signed cert is installed on webadaptor VM, IIS. 2 webadaptors are installed on this same machine, /portal(443) and /server(443) We just finished a base configuration deployment in Azure: portal, server, datastore and webadaptor VMs. We deployed Azure application gateway in front of the webadaptor VM. Our *.domain.com cert has to be installed on both the azure app. gateway and the backend webadaptor VM. The application gateway supports TLS termination, which offloads it from the webadaptor VM. This got me thinking, is it beneficial, (CPU wise) to configure ArcGIS Enterprise communication solely over :80 ? Is this possible? Azure application gateway terminates *.domain.com TLS session, then passes requests: :443/portal --> http://webadaptorvm.internal.com/portal :443/server -->http://webadaptorvm.internal.com/portal I would install new webadaptors with the same names, listening on port80. Would this also require me to configure the portal and server VMs to listen on http also? Portal doc: https://enterprise.arcgis.com/en/portal/latest/administer/windows/configure-https.htm Server doc: https://enterprise.arcgis.com/en/server/latest/administer/windows/secure-arcgis-server-communication.htm

‎01-18-2023

Thanks for the help. Yes, we're aware of the ArcMap services, and are staying at 10.9.1 during the migration. I figured it was best to not upgrade versions in the middle of the lift-and-shift to Azure. How about we deploy an Azure VM for PostgreSQL, replicating our on-premise environment. We can deploy it as newdb.ourdoamin.com, migrate the db's, then, when we edit the external DNS record to point traffic to Azure, disjoin currentdb.ourdomain.com from AD, then rename the Azure equivalent? We can then casually start using Azure hosted PostGresql, and eventually re-publish all services pointing to the hosted instance and shut down the Azure PostgreSQL VM.

‎01-18-2023

After migration, (ArcGIS Enterprise site & SDE gdbs from on-prem to Azure db for Postgres), what if we had the oldhostname.ourdomain.com FQDN resolve to the IP of the Azure db for Postgres, where the dbo and password are identical. Would this split-horizon DNS setup require re-publishing every service?

‎01-18-2023

Can someone elaborate on the process of updating the SDE connections after migration? Our old on-premise DNS name will be different in Azure and there are issues with setting up a split-horizon DNS policy that resolves Azure requests to the new hosted postgres instance. After migration, do we just update the datastore connections, or does it require re-publishing each service?

‎12-29-2022

Does anyone know if a mixture of operating systems is supported for each component? Linux Machines: (ArcGIS Datastore, ArcGIS Portal) Windows Machines (ArcGIS Server) how would we specify "SHARED_LOCATION" parameter in this case?

‎12-08-2022

Here's what I tried: 1) Created a checkpoint of VM (obivously) 2) Installed PostGIS 3.0.1 on the PostgreSQL 11.12 instance (that's currently configured for ST_Geometry storage) 3) Used Create Enterprise Geodatabase tool to create "demogdb", specifying spatial type as POSTGIS 4) Created appropriate users in demogdb 5) Created appropriate feature datasets in demogdb 6) Feature class to feature class tool in Pro to move data from ST_Geometry gdb to new demogdb. 7) demogdb feature classes show: ST_geometry (original) feature classes show this: The above workflow seemed to work fine. What's the purpose of exporting/importing the configuration keywords? I did export both the orginal and demogdb configuration keyworks and they each correctly show "ST_GEOMETRY" and "PG_GEOMETRY", respectively. thanks!

‎11-23-2022

Thanks everyone, this should be enough to get me started with the test environment! Yes, we have ~90 PostgreSQL databases, but I would guess only 1/2 of them will make the migration. A lot of db cleanup needs to happen for projects (db's) that are no longer active. Sounds like the best path is to convert on-prem SDE.ST_GEOMETRY columns to PostGIS Geometry, then pg_dump. Transfer that pg_dump (.post file) to Azure Storage Account, then use pg_restore to the Azure instance. Our IT consultant is following this doc: Deploy Esri ArcGIS Pro in Azure Virtual Desktop, except Azure db for PG, not SQL. Our entire base Enterprise deployment is being moved to Azure VMs that are in the same region (Azure GOV) as the Azure db for PG instance. Our analysts' workstations are also being moved to Azure Virtual Desktops, and our file share (Pro projects, FGDBs, ect.) is being moved to Azure NetApp files. So, everything should be co-located in the same Azure region for minimal latency. I didn't even want to attempt on-prem workstations accessing cloud databases.

‎11-22-2022

Existing on-prem server: Ubuntu Server 18.04 LTS PostgreSQL 11.12 Contains ~90 SDE Geodatabases; total size ~500GB ST_GEOMETRY is used All ArcGIS Enterprise components are getting moved to Azure VMs, workstations will be Azure Virtual Desktops and we want to deploy Azure database for PostgreSQL (database-as-a-service). Since ST_GEOMETRY cannot be enabled on databases in the cloud can anyone provide instructions for converting the existing ST_GEOMETRY spatial types to POSTGIS? thanks.

‎06-13-2022

This continues to happen for me also. I just never hit Apply button on field calculator. That always negates this issue.

‎01-05-2022

I tried all of those suggestions, see above. Field names in my case are always lower case, since the backend is PostgreSQL. Realize objectid > 0 would return everything, I was just trying to determine if the problem was Filter() or FeatureSetByName(). See below, problem was Filter().

‎01-05-2022

Here's the solution, scrap the Arcade Filter() function, it simply does not work with globalid while offline. This expression works fine both online/offline. Upper/Lower case globalid wasn't the issue, both FM and map viewer BETA in Enterprise 10.9 were displaying Upper case. But, just for safety I used Lower. var relate_guid = $feature["rel_guid_pcs"]; var featSet = FeatureSetByName($map,"Point Count Stations", ['pcs_id','globalid'], false); for(var feat in featSet){ if(Lower(feat.globalid)==Lower(relate_guid)){ return feat.pcs_id; } }

‎01-05-2022

Online, both app and Map Viewer BETA both of these filter expressions work, offline in app, neither of them work. "globalid = '" + relate_guid +"'" "globalid = @relate_guid" Online/Offine, this filter expression works: 'objectid > 0' @DougBrowning, can you try a filter expression in your environment that uses globalid? It would be great if you could repo this.

‎01-05-2022

But, this edited Arcade Expression does work offline! var relate_guid = $feature["rel_guid_pcs"]; var featSet = Filter(FeatureSetByName($map,"Point Count Stations", ['pcs_id','globalid','objectid'], false), 'objectid > 0'); return First(featSet).pcs_id; What changed? I'm guessing that the offline replica.geodatabase that gets created either: Doesn't preserve globalid. So the Filter expression: parent.globalid = child.relate_guid doesn't retrieve anything. (I find this hard to believe). I tried adding a new related child point WHILE OFFLINE and the orig. Arcade expression still doesn't work. the Filter() data fcn doesn't support SQL queries against globalid while offline. (more plausible). ESRI -- Any docs on this?

‎01-05-2022

I cannot get it to work offline, see below details. Environment: Enterprise 10.9 with PostgreSQL published feature service. Using map viewer BETA released with 10.9, added both point feature classes, they are related via globalid-guid. Arcade Expression on child layer: var relate_guid = $feature["rel_guid_pcs"]; var featSet = Filter(FeatureSetByName($map,"Point Count Stations", ['pcs_id','globalid'], false), 'globalid = @relate_guid'); return First(featSet).pcs_id; Online result: both map viewer BETA and Field Maps app (Android) work great. Select a child point and above expression retrieves parent.pcs_id. Offline result: same webmap, download ad-hoc offline area in Field Maps app (Android). Select a child point and it displays -- which obliviously doesn't work. Field Maps app (Android) error: Expression Name: expr0 Expression Title: Arcade Error Domain: com.esri.arcgisruntime.ArcGISRuntimeException Error Code: 15 Error Description: Invalid call. Unable to evaluate arcade expression. Evaluation_error_code::unexpected_null_value Line :3 @DougBrowning 1) Are you using AGOL or Enterprise? 2) Hosted feature service or published feature service?

‎01-04-2022

Enterprise 10.9, Map Viewer BETA. Created a popup expression using the FeatureSetByRelationshipName function. I can successfully retrieve the parent feature attribute in the popup, no issues. But, when the webmap is accessed with the Field Maps app (Android) the popup shows an Error Code 6, Illegal State. Invalid relationship name. Question of the day: Are any of the FeatureSetBy.. Arcade functions supported in the latest field maps app? If so, does the map have to be online, ad-hoc created offline, or pre-defined offline? thanks.

Online Status	Offline
Date Last Visited	Thursday

My Ideas

Latest Contributions by danbecker

Azure application gateway and TLS termination

Re: Migrate on-prem PostgreSQL to Azure db for PostgreSQL (DBaaS)

Re: Migrate on-prem PostgreSQL to Azure db for PostgreSQL (DBaaS)

Re: Migrate on-prem PostgreSQL to Azure db for PostgreSQL (DBaaS)

Re: webgisdr - mixed Linux/Win Environment

Re: Migrate on-prem PostgreSQL to Azure db for PostgreSQL (DBaaS)

Re: Migrate on-prem PostgreSQL to Azure db for PostgreSQL (DBaaS)

Migrate on-prem PostgreSQL to Azure db for PostgreSQL (DBaaS)

Re: Field Calculator Overwrites Previously Selected...not currently selected.

Re: FeatureSetBy Arcade Functions Supported in Field Maps App?

Re: FeatureSetBy Arcade Functions Supported in Field Maps App?

Re: FeatureSetBy Arcade Functions Supported in Field Maps App?

Re: FeatureSetBy Arcade Functions Supported in Field Maps App?

Re: FeatureSetBy Arcade Functions Supported in Field Maps App?

FeatureSetBy Arcade Functions Supported in Field Maps App?

Re: Portal for ArcGIS upgrade from 11.5 to 12.1 no...

Re: Azure Files premium file share - SLOW File Geo...

arcpy layout.export - hosted feature layers not sh...

Re: Survey123 Date Only shows incorrectly on Repor...

PostgreSQL - Important Backup Info