Latest Contributions by AndrewQuee

I currently have a  job to find every table under multiple schemae in multiple databases with a certain suffix.  Right now, my only option is to scroll and scroll and scroll and scroll.  Good luck if you accidentally miss-click and void your selection. Also to in reference to earlier suggestions: In my case multiple users (60+) were all indexing the EGDB themselves, which was actually causing a measurable performance drop.  So the administrators disabled the feature entirely.  They also declined to take up any of the centralised indexing features.  No indexing can be done at all... I don't understand why a simple name query cannot be done in the search box of the catalog view.  SQL does it, SQL Developer does it, Python can do it, even Windows File Explorer can do it relatively easily.  Why can't ArcGIS do it, literally ten years later? ... View more

Having just dealt with a client's project performance issues, as well as sorting out when various layouts/maps were created or modified, I'd be interested in seeing this. Edit: Or... I could use the correct version of Pro!  😓 ... View more

@TamiOnstad    https://mirror.aarnet.edu.au/pub/CRAN/ is working for me and I can also download the package from https://cran.r-project.org/bin/windows/contrib/4.5/igraph_2.1.4.zip as well the R-packaged igraph project page mirrors and links  I did not test it but imagine you can install the package locally and point the tool there.  R/igraph suggests you can link to either github or r-universe.dev repos. I did have an issue that it crashed Pro 2.9.5 immediately after running.  I reinstalled the whole geoprocessing R package (including new arcgisbinding 1.01.311) and it suddenly started working again. I would not install the latest R 4.5.0 as Esri arcgisbinding does not appear to support it yet. Warning: Unable to access index for repository https://r.esri.com/bin/windows/ocntrib/4.5  Cannot open URL 'https://r.esri.com/bin/windows/ocntrib/4.5/PACKAGES' Sample output from tool using R 4.2.1: Start Time: Tuesday, 15 April 2025 12:46:11 PM Saving temporary files to C:\Users\aquee\AppData\Local\Temp\ArcGISProTemp26324\StateDiagram_v0gfeffj Succeeded at Tuesday, 15 April 2025 12:46:13 PM (Elapsed Time: 1.67 seconds) Start Time: Tuesday, 15 April 2025 12:46:13 PM also installing the dependencies 'glue', 'cli', 'lifecycle', 'magrittr', 'pkgconfig', 'rlang', 'vctrs', 'cpp11' There are binary versions available but the source versions are later: binary source needs_compilation glue 1.7.0 1.8.0 TRUE cli 3.6.2 3.6.4 TRUE rlang 1.1.3 1.1.6 TRUE cpp11 0.4.7 0.5.2 FALSE igraph 2.0.3 2.1.4 TRUE Binaries will be installed package 'glue' successfully unpacked and MD5 sums checked package 'cli' successfully unpacked and MD5 sums checked package 'lifecycle' successfully unpacked and MD5 sums checked package 'magrittr' successfully unpacked and MD5 sums checked package 'pkgconfig' successfully unpacked and MD5 sums checked package 'rlang' successfully unpacked and MD5 sums checked package 'vctrs' successfully unpacked and MD5 sums checked cannot rename file 'C:\Users\aquee\AppData\Local\R\win-library\4.2\file66d4fb04621/vctrs' to 'C:\Users\aquee\AppData\Local\R\win-library\4.2/vctrs', reason 'The process cannot access the file because it is being used by another process'unable to move temporary installation 'C:\Users\aquee\AppData\Local\R\win-library\4.2\file66d4fb04621\vctrs' to 'C:\Users\aquee\AppData\Local\R\win-library\4.2\vctrs', copying instead package 'igraph' successfully unpacked and MD5 sums checked installing the source package 'cpp11' There is a binary version available but the source version is later: binary source needs_compilation sp 2.1-3 2.2-0 TRUE Binaries will be installed package 'sp' successfully unpacked and MD5 sums checked package 'igraph' was built under R version 4.2.3package 'sp' was built under R version 4.2.3 Number of states 3 Number of versions 3 Rendering in window Error: C stack usage 13313776 is too close to the limit Error: C stack usage 13313776 is too close to the limit Error: C stack usage 13313776 is too close to the limit Succeeded at Tuesday, 15 April 2025 12:46:39 PM (Elapsed Time: 26.22 seconds)   ... View more

This looks very much like a bug we are pursuing with Esri Support.  https://my.esri.com/#/support/bugs/bugs?bugNumber=BUG-000151457 The Validation Status field in the validation rule table changes from ‘No Validation Required’ to ‘Requires Validation’ after reconciling even when there are no changes in the default version.   ... View more

I just experienced this while working with a client with same symptoms.  It turned out that the mxd had references to AGOL ready-to-use services, and once signed in, these appeared in the Catalog pane: ArcGIS Online Ready-to-use services (I had never used any of these previously, I didn't even know you could use AGOL like this in Desktop) As mentioned, you can also hammer Cancel enough times to not load these. Strangely enough, and of some concern to me, these are now seemingly irrevocably attached to my account.  I cannot remove them from either the mxd (even when saved as copy or imported into Pro) and any time I sign back in to Esri Online, they reconnect.  Thankfully they do not appear to be propagating to new mxds, perpetuating the annoying sign-in cycle.  It would be nice to know how to get rid of them seeing as I do not do analysis like this (I would use ArcPy or local GP Tools) and they apparently consume AGOL credits. There is no information in documentation how to do this, only how to add these services.  I don't see anything attached to my AGOL account either at www.arcgis.com ... View more

We've just started evaluating 3.4.1 and haven't noticed any issues so far. Just for troubleshooting purposes when this happens (when ArcGIS Pro is opened I guess?), does Windows-Tab or Ctrl-Alt-Del do anything? The mouse pointer move at all? Keyboard lights toggle with caps lock etc? Computer respond at all on network ?  (shared folder/remote control) Or is it fully locked up? I'm wondering if Event Viewer might show something useful to Esri.  I assume you're already following up with Esri support?  Sample: Given the issue you're seeing I wonder if there might also be Critical system errors as well?  Might help to pin down which system is faulting. ... View more

Sure!  Here's the documentation for it: ArcGIS Pro: Set the active definition query  Here's the project in question.  As you can see I have multiple '<attribute>IS NULL' queries defined.  I can toggle them on and off fairly easily from Layer Properties. Choosing an active definition query from the list of defined queries     This is a great feature in Pro for often-used  views on a layer, noting you can only have one active at one time, so it's not quite a radio-button toggle panel.  Previously you would need to have multiple layers with different definition (restriction) queries defined.   It would still be useful to leave nulls in and have nulls first or last as you can accidentally leave a  restriction query on and them come back months later to wonder where the data went. 🙂 ... View more

Is done, I have been voting ideas since they were invented on the 'ol geonet. For now I have written some quick "IS NOT NULL" layer definition queries and using the Pro toggle option.  It's "good enough" but annoying to have to set for each project and layer.  For ArcMap users you have to use the old "1=1 OR <query>" def'n query hack to toggle on each layer. ... View more

I just ran into this while working with a client's priority job.  I did not enjoy having to scroll through 11 thousand null records after sorting 'descending value' to verify the record. Yes I know why it is why it is like this, yes I use SQL, and yes I know of the workarounds suggested, but common sense says any value is greater than null, surely?  Nulls last for me, always, or at least give us an option to manage this as per SQL. And no, I do not want to restrict my data, I will need those null values for other queries. ... View more

Sorry @ErikLash_HiCo for not getting back to you for so long - I only just got back to this job.  Thank heaps for your fix! I confirm that this works at writing with ArcGIS Pro 3.2.0, R-ArcGIS  4.2.1, arcgisbinding package 1.01.306 (current) on Oracle 19.15 sde 10.8.1. PDF option works well.  I wouldn't use dataframe features.  Window render works fine, but includes no detail and is not interactive. Sample version tree output ... View more

Good idea.  I was going to suggest ST_GEOMETRY SQL functions (which is what we use) but I see you've already gone down that road.   ... View more

Readers, please note the download link provided here is 404 at writing.  The latest version appears to be "PerfTools (Build 258) for ArcGIS Pro 2.x and 3.x is now available for download"  as at 2022-06-23. For future perftool updates: IanSims personal OneDrive and IanSims blog. Using Pro 3.1.3, yes "ZoomToBookmarks all" seems to jump to the first bookmark then choke.  'Roaming' feature works okay. Metrics View, Render View and Log View are only ones I use for performance testing and these all work fine. Thanks again to @IanSims for continuing to support this valuable project! ... View more

  Just noting I had a similar experience with "webgisdr -e -f webgisdr.properties" on a single-node test ArcGIS Server I am trying to back up. I got  Failed to back up the ArcGIS Server: Url: https://HOSTPATH/server. {"code":500,"messages":["Export operation failed. Failed to create the folder 'D:\\temp\\WebGISSite1698973979711\\server\\eth72rdfmyeiyefc'."],"status":"error"} to a local backup on the same machine (and also SHARED_LOCATION=D:\\temp)  same drive as final backup, as it does not appear to be using the credentials of the user executing webgisdr.  When I opened security on this folder it was fine. The following ArcGIS Server has been backed up successfully: Url: https://HOSTPATH/server. The backup of ArcGIS Server has completed in 00hr:00min:43sec. ... View more

Some time later... no change at 2.9.5/3.1.1 I thought feature equivalence with ArcGIS Desktop was the goal?  There is still no "Disconnect" option in Pro as Desktop has. ... View more

Thanks Kory.  I confirm that updated (concurrent) LM is required at Pro 3.1 or you get this error: Error while configuring floating licence manager to an older version. ... View more