Latest Contributions by HamishMills

Using ArcGIS Pro version: 2.8.0 ArcGIS Enterprise Geodatabase version: 10.8 We have a feature class with attachments enabled, which is also set to have Archiving enabled so it can be taken offline. The feature class has roughly 40 thousand records in it and every single record has at least 1 photo attachment of anywhere between 500kb to 1mb in size associated with it. The attachment table is now roughly 40gb's.  When we want to unarchive this feature class for any reason, usually some type of database administration, we find that it can take 5/6 hours just to Unarchive it. This of course makes even the smallest administration task extremely cumbersome and almost impossible in some of our standard outage windows with our clients. When doing a direct SQL query through SSMS, to an attachment table that is this large, using "SELECT * FROM [TABLE_X]", the transaction takes an hour or more (have never let it run to completion). As soon as we change the query to include all fields "except" for the Blob/data field in the attachment table, it is virtually instant. I have worked on large attachment tables before (unsure if this large) and have never had a similar issue. I wonder if this is a new bug introduced in a more recent version or Pro or something? Has anyone else experienced an issue similar to this? Is this expected behaviour? ... View more

Client has reported that sometimes point attachments will display the wrong attachment/s in pop-ups. They have been able to capture this issue with video screen capture. We have now also been able to replicate this issue. So we believe this issue to be "real" and not based in user error.  In detail this is what is happening; a user is selecting power poles in a ArcGIS Portal Web Map (10.8) and reviewing their photo attachments. As the user works a long a chain of poles they will suddenly get a pole that actually links the user to a photo attachment for a previous pole. If you keep selecting poles and looking at photo attachments, then eventually the pole that was displaying the incorrect pole will correct itself.  This of course is extremely disruptive and will require more investigation, looking to submit this as an official support ticket very soon. One supplementary note is that we were only able to replicate this issue in FireFox web browser so far, so have advised client (who recently changed to FireFox) to change back to using Chrome to see if this is more reliable.  Interested to hear if anyone else has experienced this issue in their own environments before I submit an actual support query to our provider/reseller? CLawrence-esristaff ? ... View more

What are peoples reasons for using Dimension Feature Classes over Line Feature Classes? ... View more