Latest Contributions by BillFox

It is blurry. Can we get a high res copy? ... View more

CRTN Community Notice The CSRC migrated CRTN coordinates to CSRS Epoch 2017.50 (NAD83) this evening at 2018-03-01 4:00 UTC.  Please also visit http://csrc.ucsd.edu and click the epoch link.  ... View more

Rex, Thanks for the detail. The compress problem is just like the view locks problem - both are fixed after following each of the steps you listed. Including a required change from full to simple in order to successfully get it to work without filling up the disk with a run-away transaction log. Once the orphan records are clear, compress is fast (a couple seconds) again. If a user happens to crash an ArcMap session or have to kill a non-responsive session a new orphan record will cause the same problems. With ESRI support we also found that with the update to 10.5 requiring geocoding locators to be removed from inside the geodatabase and placed in a file folder they were not successfully rebuilding from usual nightly windows task scheduler running python script due to ArcGIS Server placing locks on them as a web service. We think those failed rebuilds were creating the orphan records.  Notes: Stop ArcGIS Server address locator services Rebuild address locators Overwrite address locator services ... View more

I tried compress from 10.3.1 and it fails too. It grows the SQL Server transaction log until it fills the hard drive - which has now stoped the geodatabase working for users. SQL Server 2014 Geodatabase v10.4.1 Windows Server 2008 R2 RRobichaux-esristaff‌ ... View more

Hi Alina, I have the same NULL error popup in ArcMap today. And the same compress FAIL errors And ArcGIS Pro v2.1.2 will show connections but just crashes when clicking the "Show connected users and locks..." button > Locks tab Unable to get lock list A database connection exception has occurred Column value is NULL OK RRobichaux-esristaff‌ ... View more

Thank you for the detailed update Garrett. If they are not included with "Enterprise" like Portal is, will the "What's Included" enterprise documentation be changed to include your details to prevent further confusion? ... View more

yes, and use a wildcard SSL cert for your domain also, this was a pain to try and update,so we dropped back to non-HA portal and ArcGIS Server. ... View more