Latest Contributions by danbecker

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? ... View more

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? ... View more

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? ... View more

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!          ... View more

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.   ... View more

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

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(). ... View more

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. ... View more

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? ... View more

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? ... View more

So, "created_date" reflects when the record hit the feature service, i.e. when it was sync'd. What about ArcGIS Collector and/or FieldMaps apps that use SDE Enterprise Geodatabases published as feature services, is the behavior the same? 1) We create a blank SDE feature class, defining schema only 2) Archiving and Editor Tracking are enabled on the feature class 3) FC published as feature service, added to Webmap 4) User downloads offline area of the webmap, then collects data in the field while offline on 7/2/2021 5) 3 days later on 7/5/2021, the user sync's the offline area 6) What will created_date be, 7/2 or 7/5 ?     ... View more