Latest Contributions by FredSpataro

‎12-01-2023

Done: https://community.esri.com/t5/data-management-ideas/add-version-changes-to-the-versions-toolset/idi-p/1355811/jump-to/first-unread-message thanks again for the replies.

‎12-01-2023

ArcPro Versioning Ribbon has a great button: Version Changes. This provides a categorized list of edits in the given version in a nice little UI window. However from there, automation, advanced QA/QC, auditing, event triggering and integrations are difficult if not impossible. The data result of this button would be tremendously useful for those operations as a GP tool.... the Versions Toolset makes sense. An advanced SQL management topic or SDE stored procedure would also be ideal but I understand the complexity there.

‎11-30-2023

@MarceloMarques thanks... i knew it wasn't in the version toolbox (hoping it might be somewhere else hidden...) I'll look into the SDK, i have a vague recollection of doing something way back with the ArcObejcts SDK. I profiled the database when the button was run, hoping for some SQL insight but it's really complicated. We've got a start with some SQL comparing on the multiversion views ... just seems like that button would be useful from arcpy or sql...

‎11-30-2023

Hi All, There's an ArcPro tool called 'Version Changes' on the Versioning ribbon (see picture below). Is there a python/gp tool or SQL template to achieve the same thing? We need to implement some automated QA/QC and auditing tasks. It would be 'waaaayyyy' better if we could grab this info without asking the user to press the button. Thanks

‎10-23-2023

A Geoprocessing Service is an ideal candidate for a webhook handler since ArcGIS server implements the necessary web server endpoint and the scripting can easily access ArcGIS data and functions. However right now a GP service requires structured form values for each parameter in the POST body and won't pass thru the JSON body from the current webhook. I've tried a few options and the webhook fires the GP Service without issue ie: https://myserver.com/arcgis/rest/S123Handlers/GPServer/MyWebHookScript/execute but the JSON data is never passed thru. A simple option 'POST as form values' and either: 1. POST the entire json to a single named parameter (eg 'eventData') 2. POST each selected event data to it's own named parameter: SurveyInfo, UserInfo, etc.. If this was an option, then the GP script can easily be created to match the correct name(s) with string/text type and then parsed in the script.

‎09-15-2023

@Scott_Tansley @A_Wyn_Jones thanks for the suggestions: 1. machine is just installed so no load or anything resource hogging at this point. Basic performance stats from Task Manager: < 10% CPU utilization & < 50% Memory usage Also yes, tried a datastore service restart. 2. Output from describedatastore.bat ... nothing seems out of the ordinary expect the tile cache validates and it's member machine is PORTAL while the relational datastore's member machine is PORTAL.{domain}.com .... the FQDN has been a recurring issue for me, especially on machine that aren't joined to the domain ie dev machine and DMZ machines ... C:\Program Files\ArcGIS\DataStore\tools>describedatastore.bat Available ArcGIS Data Stores ================================================== Relational Data Store Tile Cache Data Store Spatiotemporal Big Data Store Graph Store Object Store General information of ArcGIS data stores on PORTAL.XXXX.COM ================================================== Data store release..................11.1.0.42869 Staging location....................C:\ArcGIS\arcgisdatastore\staging Log location........................C:\ArcGIS\arcgisdatastore\logs Free disk space.....................153.00GB Threshold for READONLY mode.........1024MB Information for relational data store ds_w9mc1edt ================================================== Backup location.....................C:\ArcGIS\arcgisdatastore\backup\relational Is backup folder shared.............false Backup schedule.....................{"schedule-starttime":"00:00:00","schedule-frequency":"Every 4 DAYS"} Days backup retained................7 Data store status...................Started SSL enabled.........................true member machines.....................PORTAL.XXXX.COM Maximum connections.................150 Owning system URL...................https://portal.xxxx.com/server Portal for ArcGIS URL...............https://portal.xxxx.com/portal Number of connections...............0 connection(s) to managed database Data Store mode.....................READWRITE Is Point-in-time recovery enabled...No Query optimizer enabled.............Yes Information for tile cache data store tcs_ou0nflv3 ================================================== Data location.......................C:\ArcGIS\arcgisdatastore\nosqldata Data store status...................Started Backup location.....................C:\ArcGIS\arcgisdatastore\backup\tilecache Mode................................primaryStandby member tile cache machines..........PORTAL Owning system URL...................https://portal.xxxx.com:6443/arcgis/admin Portal for ArcGIS URL...............https://portal.xxxx.com/portal Operation completed successfully.

‎09-14-2023

Hello, I've got a simple all-in-one enterprise portal setup for development/testing but the Relational data store won't validate. Thanks for any suggestions. From the datastore config wizard: From the server manager: From the server rest admin: From the server manager logs: SEVERE Sep 14, 2023, 2:47:44 PM The connection property set was missing a required property or the property value was unrecognized. Bad login user[ ] DataValidator.GPServer WARNING Sep 14, 2023, 2:47:14 PM Validate: null Data Store WARNING Sep 14, 2023, 2:41:44 PM Validate: null Data Store WARNING Sep 14, 2023, 2:19:09 PM ArcGIS Data Store is attempting recovery. Data Store WARNING Sep 14, 2023, 2:18:27 PM ArcGIS Data Store encountered too many problems; however, the standby machine 'PORTAL.XXXXX.COM' will not proceed with failover due to validation check failures. Data Store WARNING Sep 14, 2023, 2:18:27 PM Validate: Could not connect to server on machine 'PORTAL'. ArcGIS Data Store or ArcGIS Server on that machine may not be running or the machine is not reachable at this time. Data Store WARNING Sep 14, 2023, 2:18:26 PM Validate: null Data Store WARNING Sep 14, 2023, 2:18:26 PM ArcGIS Data Store has detected an issue with 'Machine: PORTAL'. Data Store WARNING Sep 14, 2023, 2:18:18 PM ArcGIS Data Store has detected an issue with 'Machine: PORTAL'. Data Store WARNING Sep 14, 2023, 2:18:11 PM ArcGIS Data Store has detected an issue with 'Machine: PORTAL'. Data Store WARNING Sep 14, 2023, 2:15:16 PM ArcGIS Data Store is attempting recovery. Data Store WARNING Sep 14, 2023, 2:14:26 PM ArcGIS Data Store encountered too many problems; however, the standby machine 'PORTAL.XXXXX.COM' will not proceed with failover due to validation check failures. Data Store WARNING Sep 14, 2023, 2:14:26 PM Validate: Could not connect to server on machine 'PORTAL'. ArcGIS Data Store or ArcGIS Server on that machine may not be running or the machine is not reachable at this time. Data Store WARNING Sep 14, 2023, 2:14:24 PM Validate: null Data Store WARNING Sep 14, 2023, 2:14:24 PM ArcGIS Data Store has detected an issue with 'Machine: PORTAL'. Data Store WARNING Sep 14, 2023, 2:14:17 PM ArcGIS Data Store has detected an issue with 'Machine: PORTAL'. Data Store WARNING Sep 14, 2023, 2:14:09 PM ArcGIS Data Store has detected an issue with 'Machine: PORTAL'. Data Store WARNING Sep 14, 2023, 1:54:18 PM Failed to validate the data store machine 'PORTAL'. 'Server machine 'https://PORTAL:2443/arcgis/datastoreadmin/machines/PORTAL/validate' returned an error. 'The requested resource could not be found in the system. Please check the parameters and try again.'' Admin

‎08-15-2023

More info... got fiddler running during the exchange... see pic below... Runs a few requests against the various 'portal/info' endpoints, most fail, but then the 'sharing' one works. Then does the OAUTH sequence which successfully generates an access token Then it attaches the access token as auth header Bearer xxxxxxx on the final two info requests (which are fine without any auth) and those get the 403 result.

‎07-26-2023

Hi All, In ArcPro, I can connect to my Azure blob storage container using the SAS token by setting the token value in the Provider Options: AZURE_STORAGE_SAS_TOKEN property. However the 'Provider Options' values are not accessible in the UI dialog for either ArcGIS Server manager nor ArcGIS Portal. Does this mean we CAN'T use a SAS token to register the Azure blob storage container in enterprise? Maybe using the REST endpoint? So far no luck figuring out a syntax there. When we try thru the ArcPRO UI, we get critical failure with the "Report to Esri" dialog box 😞 Thanks

‎03-10-2023

I've tried changing inputs to the GP tool to get ANY kind of change to the outputs. In fact the 'metadata' listed on the raster properties never updates either. Example, below. I used skip factor 2,2. No change to the stats. 'Build Parameters' info doesn't show a change either.

‎03-10-2023

Hi All I have file geodatabase raster. When i loop over the cells i find the MIN value is 6.6, the 'stats' MIN value is 4.5. I've run the CalcStats tool, with the 'OVERWRITE' option but never get to the 6.6 value. (MAX also appears incorrect as well. I've used CopyRaster to export the fgdb raster as both ASCII and TIFF. Both exported rasters display expected MIN/MAX stats. When I re-import the ASCII or TIFF back into the fgdb. The stats are the expected values. So why does DEM have the wrong stats to begin with --- was generated from a 'clip/extract'? and why doesn't the CalcStats tool update to the correct values? Thanks

‎03-09-2023

Hi Got an odd one with the charts module and MakeFeatureLayer. Code will work fine if you run it inside the ArcPro py window but if it's outside ArcPro as standalone script or run from inside a GP toolbox script, the result is a catastrophic app crash with the 'please report crash dialog' showing up 😞 basic code: import arcpy import os source_fc = "chart-issues.gdb\\pts" profile_name = "AB" query_def = "Name='{}'".format(profile_name) print(query_def) r_chart_layer = arcpy.management.MakeFeatureLayer(source_fc, "chart_layer", query_def, None, None) profile_chart = arcpy.charts.Line( x="M", y=["Z"], dataSource = r_chart_layer.getOutput(0), title="Elevation Over Distance: {}".format(profile_name), xTitle = "Distance (Feet)", yTitle = "Elevation (Feet)" ) print("chart initialized") chart_path = arcpy.CreateUniqueName(os.path.join("{}.svg".format(profile_name)), arcpy.env.scratchFolder) print(chart_path) profile_chart.exportToSVG(chart_path, 500, 500) print("qed") I tried a ton of variations and found a few extra nuggets. I know the feature class and feature layer are correct. If I set the dataSource = source_fc, chart generates without error but i don't get the filter applied so it's not 'path to data kind of issue' If I export the layer to a table or lyrx it will also work but 'why do i have to add an extra step to write data back to disk'? If I add: print(r_chart_layer.getOutput(0).dataSource) It will print out the expected path to the feature class Oddly, this changes the failure, it's no longer an app crash but generates this error message: Traceback (most recent call last): File "D:\support\arcgis\chart-issues\create-chart.py", line 39, in <module> profile_chart.exportToSVG(chart_path, 500, 500) File "C:\Program Files\ArcGIS\Pro\Resources\ArcPy\arcpy\charts.py", line 449, in exportToSVG svgRes = self.getSVG(width if width != None else self.displaySize[0], File "C:\Program Files\ArcGIS\Pro\Resources\ArcPy\arcpy\charts.py", line 445, in getSVG return _convertArcObjectToPythonObject(self._arc_object.getSVG(width, height)) RuntimeError: Invalid dataset: CIMPATH=internal_map/pts.json There are work arounds but seems like you should be able to MakeFeatureLayer() and assign it as a chart data source without any extra steps.

‎01-11-2023

Hi @Anonymous User, Is there documentation on 'licensing' arcpro inside ArcGIS Server? I have an full ArcGIS Server Advanced license on this machine. What other license or setup is required? Also the script runs has expected when I execute it at the command line using the python env embedded in the ArcGIS server installation directory ... ArcPro app is not even running at that point so it doesn't seem like a licensing issue to me but possibily

‎01-10-2023

Hello All, We have a cool little geoprocessing analysis script that creates some data, does a bit of analysis and generates an awesome pdf 😉 .... this script works great when run from a desktop toolbox. When we publish it to server to connect to a web application, it fails at the point where we open the layout (pagx). There's no error message, the job just seems to die. Nothing in the AGS logs after a certain point when setting log level = debug. All the data and analysis artifacts (charts, csvs) get created fine -- i can inspect them in the AGS jobs folder. It's definitely in the final manipulation and export of the layout. We've done this before with ArcMap mxds and this is the first attempt with Pro aprx/pagx so maybe I'm just missing a crucial step in the process of opening the layout. I've distilled out all the fun data analysis and made a simple layout with a single text element for the title and a single map with only the stock basemap... no custom data, no fancy other elements... still dies in the same manner. I took out the map, so the layout has only a text element which the script/service will modify when run to ensure something is running dynamically and it works. So it seems like something with the map/map frame is the issue. Is there a 'activate' or 'update' map needed? Setup: ArcPro 2.9.5 / ArcGIS Server (standalone) 10.9.1 Here's the guts of the "run" method in the simplified script. Any thoughts would be greatly appreciated def ScriptTool(input_templates_folder, input_cool_text): analysis_folder = arcpy.env.scratchFolder map_template = os.path.join(input_templates_folder, 'Layout3.pagx') arcpy.AddMessage('Template PAGX: {}'.format(map_template)) analysis_template = os.path.join(analysis_folder,'Layout3.pagx' ) arcpy.AddMessage('Analysis PAGX: {}'.format(analysis_template)) shutil.copyfile(map_template, analysis_template) arcpy.AddMessage('Analysis PAGX: copied') lyt = arcpy.mp.ConvertLayoutFileToLayout(analysis_template) arcpy.AddMessage('Analysis PAGX: opened') txt = lyt.listElements('TEXT_ELEMENT', 'Text')[0] arcpy.AddMessage('Analysis PAGX: element found') txt.text = input_cool_text arcpy.AddMessage('Analysis PAGX: element updated') layout_pdf = os.path.join(analysis_folder, "layout.pdf") arcpy.AddMessage('Analysis PAGX: exporting to {}'.format(layout_pdf)) lyt.exportToPDF(layout_pdf) arcpy.AddMessage('Analysis PAGX: complete') return layout_pdf

‎01-10-2023

@ChristopherAllen Thanks for the verification. The 'aggregation=min' chart looks good when I use the full data. Looks like I was tinkering and had converted the values to integers to see if 'doubles' were the cause...this produced non-unique values and then the aggregation kicked in and made the chart a bit off.

Online Status	Offline
Date Last Visited	Tuesday

My Ideas

Latest Contributions by FredSpataro

Re: Python or SQL for 'Version Changes'?

Add 'Version Changes' to the Versions Toolset

Re: Python or SQL for 'Version Changes'?

Python or SQL for 'Version Changes'?

Allow Survey123 Webhook to POST form values for connecting a GP Service

Re: ArcGIS Data Store won't validate

ArcGIS Data Store won't validate

Re: Portal 11.1: user account works with arcpy.SignInToPortal() but not arcgis.GIS()

Create a registered cloud store for Azure with a SAS token?

Re: Calculate Statistics (Data Management) doesn't appear to be working on file geodatabase raster

Calculate Statistics (Data Management) doesn't appear to be working on file geodatabase raster

arcpy.charts fails using MakeFeatureLayer in standalone script

Re: ArcPro Layout won't print when served as geoprocessing service

ArcPro Layout won't print when served as geoprocessing service

Re: arcpy.charts.Line fails with simple csv

Re: arcpy.server.UploadServiceDefinition output re...

Create a registered cloud store for Azure with a S...

Add 'Version Changes' to the Versions Toolset

Allow Survey123 Webhook to POST form values for co...

Re: Can't update content item data in a folder