Latest Contributions by EdwardBlair

‎03-14-2025

After much testing, including tests that incorporated the Esri-suggested work-around for the ArcPro bug (deleting individual fields in distinct "DeleteField" operations rather multiple fields at a time) I'm now convinced this is also a bug in ArcMap/ArcCatalog. Specifically, Oracle versioned views (evw's) can "break" (not be updated to reflect deleted fields) when fields are deleted through Python scripts. I've also found that there is a (fairly) convenient way to repair the views once broken. Simply select the affected class in ArcCatalog and select "Manage | Enable SQL Access" , as described here It would be much better if the views didn't break in the first place. But if they do, at least you don't have to modify the SQL in SQL*Developer to fix them. Ed

‎03-11-2025

We recently ran a Python script to remove multiple old, unused fields from several versioned feature classes. Initial testing found this to work OK. Later rounds of testing found that this script "broke" multiple versioned views -- as in, the _evw SQL was not updated to remove the deleted fields. We later found the following bug report describing this problem occurring when multiple fields are deleted in ArcGIS Pro. However, our script ran in ArcMap. Is there a chance the same bug reported for Pro also exists in ArcMap? Thx, Ed https://support.esri.com/en-us/bug/a-versioned-enterprise-geodatabase-view-does-not-update-bug-000164901

‎02-27-2025

Its a json file downloaded from my.esri. I've been working with ESRI tech support on this for about two weeks. They're stumped, too. I'm about to install the license server on another machine... which seems to work. Thanks again, Ed

‎02-26-2025

Hi Richard (or anyone) - I followed you suggestion and made IPv4 preferred over IPv6 - as indicated in the screenshot below (I think). The darn license manager still returns a MAC address of "ffffffff". And when I try to authorize my license file I still get an error that the MAC address in the license does not match the address of the machine. Any other thoughts would be greatly appreciated. Ed

‎02-26-2025

Hey Richard - Just saw your post. Thanks much for responding. I'll take a look at your link. Ed

‎02-23-2025

Hi Joker - I assume you're using a geometric network here, true? If so, that's the way the software works. A junction is the endpoint of all lines connected to the junction. If you move the junction the endpoints of the line move. Depending on exactly what you wan to do, you may be able to insert a vertex (or vertices) on either side of the junction, so when you move the junction only that, and the small segments between your new vertex and the junction will move. Adding a screen shot may help other better understand exactly what you are trying to do. Ed

‎02-22-2025

Hi I'm trying to authorize licenses downloaded from my ESRI using LSAdmin. I keep getting a message that the MAC address in the license file does not match the MAC address of the machine. When I click on "Machine IDs" I get the message below saying the MAC address is "ffffffff". When I issue ipconfig /all my Ethernet Adapter Physical Address is "00-00-00-06..blablah" -- a regular MAC address. Not sure why LSAdmin is not picking this up. If anyone has run into this and found a solution, any suggestions would be much appreciated. Thx, E

‎02-21-2025

Thank you, Heather! We tried and failed when connecting as SDE. Worked fine when we connected as the data owner Ed

‎02-19-2025

Great. Thanks for the info!

‎02-19-2025

Hi - Is there any value in performing a compress on a non-versioned, archive-enabled geodatabase? I can't think of why there would be -- there are no extraneous delta table rows that would have been moved to the base table. But I might be missing something. Thx, Ed

‎02-04-2025

Doh! I had made a number of changes and neglected to re-enable network topology. Re-enabling allowed me to trace. In my (meager) defense, sometimes just by writing out a description of the problem helps lead to a solution. Sorry! Ed

‎02-04-2025

So, I'm trying to use the Subnetwork Trace tool (though the same thing happens with a Connected trace) and I consistently get the error "A networking error has occurred" (below). Following instructions from the links below, I increased the "javaHeapSize" parameter on the published feature service to, first, 128 and second, 256. The first site says that a heap size of 256 should be able to handle 800,000 edges and 800,000 junctions. My entire electric network is smaller than this. Any other suggestions would be greatly appreciated. Thx, Ed https://pro.arcgis.com/en/pro-app/latest/tool-reference/tool-errors-and-warnings/001001-010000/tool-errors-and-warnings-03626-03650-003642.htm https://pro.arcgis.com/en/pro-app/latest/help/analysis/geoprocessing/share-analysis/geoprocessing-service-settings-advanced.htm

‎02-03-2025

Hi gis_KIWI4! This is just what I was looking for. Thanks! Ed

‎01-31-2025

All - I'm sure there is a way to do this and I'm just missing it, but is there a way to export the assigned terminal configurations from a utility network? Thx, Ed

‎01-30-2025

So... suspecting that the issue was rooted in SQL*Server permissions, I granted additional permissions to all users involved and systematically checked in ArcGIS Pro after each change to see if this allowed the process to complete. None of the permissions changes made a difference. Then, at the suggestion of Jeff Buturff, master of all Geodatabase knowledge, I started SQL*Profiler before opening ArcGIS Pro with the hope of capturing the offending call. For whatever reason, after starting SQL*Profiler and then starting ArcGIS Pro I was able to create a new version without error. I suspect that starting the profiler somehow put the previous permissions changes into effect -- but that's just a guess. At any rate, I can now create versions. Ed

Online Status	Offline
Date Last Visited	a week ago

My Ideas

Latest Contributions by EdwardBlair

Re: Version Views Break When Deleting Multiple Fields

Version Views Break When Deleting Multiple Fields

Re: License Server Admin returns MAC Address of "ffffffff"

Re: License Server Admin returns MAC Address of "ffffffff"

Re: License Server Admin returns MAC Address of "ffffffff"

Re: Moving a Junction in ArcMap Without Shifting the Entire Line ?

License Server Admin returns MAC Address of "ffffffff"

Re: Create Replica Failed HELP!

Re: Compress for a non-versioned, archive-enabled geodatabase

Compress for a non-versioned, archive-enabled geodatabase

Re: Subnetwork Trace "A networking error occurred"

Subnetwork Trace "A networking error occurred"

Re: Export Utility Network Terminal Configurations

Export Utility Network Terminal Configurations

Re: Cannot Create a Version with the Specified Name?

Re: ArcGIS Pro Labeling removes duplicate labels e...

Duplicating ConductorDetail rows on a Split

Cross Bores in the UPDM

Re: Apply Asset Package errors with "OID-based rel...

Re: Apply Asset Package errors with "OID-based rel...