Latest Contributions by danbecker

Azure Government tenant Azure Database for PostgreSQL flexible servers, ver 15.18 Pro 3.7.1 running on Azure Virtual Desktop. OS is Win11 25H2 Multi-session Everything is co-located in the same Azure GOV Virginia datacenter.   We've been running this db instance for years, absolutely no changes. The only thing that's recently changed is Pro 3.6.3 got upgraded to Pro 3.7.1. That process also created a new AVD session host image (obliviously). Our workflow for creating a new eGDB that's worked for years: 1) PgAdmin4 is running on the AVD machine, we connect to the db instance as admin user, then create a new database, owned by SDE.  2) SDE login role is also a member of azure_pg_admin. danbecker_0-1786126217447.png 3) Pro 3.7.1, create new db connection to the new db, connecting as user SDE, save credentials in connection. 4) Run Enable Enterprise Geodatabase tool. The Authorization File (keycodes) we're using is from ArcGIS Server 12.1 (windows) Error:  The geodatabase administrator needs additional privileges to install or upgrade the geodatabase. To create a geodatabase in Postgresql, Arcsde admin user must have super user priviliges. User does not have required privileges for geodatabase setup.   Pro 3.6.3 works fine: I then signed-out of that Pro 3.7.1 AVD machine and signed-into a Pro 3.6.3 machine. Ran the exact same Enable Enterprise Geodatabase tool, with the same database connection file (SDE user), also the same 12.1 keycodes authorization file.  Success.  danbecker_0-1786127126783.png     Why would this tool work at 3.6.3 and not 3.7.1 ?  Anyone else experience this?    ... View more

We've been running Enterprise 12.1 since 19 June. We use the ESRI hosted survey123.arcgis.com website to manage report templates, webhooks, ect. for our published Survey123 surveys. We obiv. access the website by adding our Enterprise portalUrl as a query parameter, like: https://survey123.arcgis.com?portalUrl=gisportal.ourdomain.com/portal No issues there, I see all the published surveys I own and can browse all the survey records and their associated photos, no issues. Our Enterprise 12.1 site is hosted in Azure, behind a Application Gateway, that passes all :443 traffic on the public IP to a backend webadaptor machine, running /portal and /server instances.  A week after upgrading to Enterprise 12.1, I used the survey123.arcgis.com website to update a report template, that was done on 26 June, no issues. The Problem: 21 July, I noticed everything related to the Report API doesn't work on survey123.arcgis.com. All of the operations listed on that help doc return Error: 404 service not found. Browser dev tools show the Report API requests to those operations are being sent to gisportal.ourdomain.com/server/ They should be going to survey123.arcgis.com, correct?  Here's the request that's sent when you try and create a sample template on survey123.arcgis.com.  danbecker_0-1784724870651.png The payload of the request seems to be OK, the featureLayerUrl is correct and accessible in a browser danbecker_1-1784725067856.png We have a webhook that triggers a PowerAutomate flow, and the HTTP flow action is correctly using the https://survey123.arcgis.com/api/featureReport/createReport Request URL and that is working without any issues.  This seems to be an issue with the survey123.arcgis.com website.  Anyone else having Report API issues ?    ... View more

We have Enterprise 12.1 installed on separate VMs in Azure. The Portal VM has a managed disk (Premium SSD) for the content, db, index and temp folders.  We're looking to migrate the Portal content directory to an Azure Blob storage container (Standard performance tier). Why? This would save cost Give us must more storage capacity. Every time we upgrade Portal, we have to increase the managed disk size to accommodate 2.5 times the storage space as is currently being used. Then after the upgrade, who wants to go through the process of decreasing the size of the managed disk, copying over all data to new disk, detaching, ect. It's a pain, so the end result is constantly paying more for allocated disk space.  Anyway, can we follow these steps to migrate the content from managed disk to blob container?  https://doc.esri.com/en/arcgis-enterprise/latest/administer/changing-the-portal-content-directory.html?pivots=os-windows Basically, copy /content directory into our new storage container, then edit the path for content directory to this JSON format.  { "type": "cloudStore", "provider": "Azure", "connectionString": { "accountName": "saexample", "accountEndpoint": "blob.core.usgovcloudapi.net", "accountKey": "abc123%%^key~", "credentialType": "accessKey" }, "objectStore": "https://saexample.blob.core.usgovcloudapi.net/portalcontainer" }   Questions about that JSON string:  1) is objectStore correct (refers to the URL of the portal content blob storage container)? Or, does this actually refer to the URL we have registered as an object store in Server Manager, for cache query storage? 2) Can we use an azure private endpoint connection for this blob storage container?     thanks!     ... View more

We have several repeats in a form that hold images. To force those repeats to start a new page in the template, we added a Word Section Break (Next Page) inside of a S123 conditional statement, like so.   danbecker_0-1775571454902.png Then the "general_photos" section starts, printing exactly 2 photos on each page. Works great. danbecker_1-1775571611526.png But, after the last "general_photo", if there are NOT any "cultural_res_photos" (see condition after the photo table above) we still get a blank page inserted at the end, because of the Section Break (Next Page).  How do we control this? Even though that condition is NOT met, the Section Break still gets inserted.  All I hear about, is how AI is coming for my job, yet, in our Azure GOV environment, there is NOT a way to have a powerautomate flow or AI, delete the last page of the generated feature report, LOL.    ... View more

The goal is to publish a geoprocessing tool that: Opens predefined Pro project Sets definition queries on hosted feature service layers (date ranges) Turns ON the hosted feat. service layers Zooms to a predefined bookmark Exports to JPG Pretty simple, right? Not so much. No matter what we do, the hosted feature service layer(s) aren't drawing. Sometimes they do draw, sometimes they don't; most often not. Can anyone spot an issue?  import arcpy, os, time from datetime import datetime start_date = arcpy.GetParameterAsText(0) #1761486465000 end_date = arcpy.GetParameterAsText(1) #1762004877000 report_type = arcpy.GetParameterAsText(2) #"Cultural Resources" project_area = arcpy.GetParameterAsText(3) #"Project 1" output_map_filename = arcpy.GetParameterAsText(4) #"aTest" output_map_file = arcpy.GetParameterAsText(5) lyr_wildcard = "CR*" if report_type == "Cultural Resources" else "NR*" start_date_str = datetime.fromtimestamp(start_date / 1000).strftime("%m/%d/%Y") if str(start_date).isdigit() else start_date end_date_str = datetime.fromtimestamp(end_date / 1000).strftime("%m/%d/%Y") if str(end_date).isdigit() else end_date arcpy.env.overwriteOutput = True def find_dt_field(lyr_datasrc): flds_to_ignore = ["created_date","last_edited_date"] for fld in arcpy.ListFields(lyr_datasrc,"*_date","DateOnly"): if not fld.name in flds_to_ignore: return fld.name break aprx = arcpy.mp.ArcGISProject(r"\\nafiles-our.domain.com\Weekly Report Map GP Tool dev.aprx") m = aprx.listMaps("weekrep")[0] lyrs = [l for l in m.listLayers(lyr_wildcard) if not l.isGroupLayer] for lyr in lyrs: if lyr.supports("DEFINITIONQUERY"): dt_fld = find_dt_field(lyr.dataSource) sql_query = dt_fld + " >= date '" + start_date_str + "' AND " + dt_fld + " <= date '" + end_date_str + "'" lyr.definitionQuery = sql_query lyr.visible = True lyt = aprx.listLayouts("Weekly")[0] mf = lyt.listElements("MAPFRAME_ELEMENT", "LAYERS Map Frame")[0] bookmark = m.listBookmarks(project_area)[0] mf.zoomToBookmark(bookmark) time.sleep(15) #let all the complex labels draw output_file = os.path.join(arcpy.env.scratchFolder,output_map_filename) pdf_export_format = arcpy.mp.CreateExportFormat("PDF",output_file) pdf_export_format.georefInfo = False pdf_export_format.resolution = 300 pdf_export_format.imageCompressionQuality = 100 arcpy.SetParameterAsText(5, lyt.export(pdf_export_format))   ... View more