Latest Contributions by DougGreen

@Chang-HengYang this has been a while but this use case is becoming more useful so I figured I'd share something we've learned. We do this sort of thing quite often and can validate what @VinceAngelo is saying about performance and replication etc. We have found a pattern that allows us to pull information from various instances and deliver a feature class with great performance. The one draw back is that it's not live (real-time views of the data in their tables). However, if your needs allow a regular update interval (daily or weekly etc) then give this a try.   Create a feature class in your Enterprise GDB with the same schema as the query layer you're trying to make. Register it as versioned but indicate in metadata or other documentation that it is not to be edited by end users. Create a stored procedure that can be run by a SQL Agent Job on a schedule that does the following: Based on https://desktop.arcgis.com/en/arcmap/10.7/manage-data/using-sql-with-gdbs/edit-versioned-data-using-sql-sqlserver.htm Deletes all rows from the multi-version view (Same as the feature class name with '_evw' appended at the end) Inserts the results of your query into the multi-version view Running a compress on the database after these operations will help this perform better so that all of these new edits can be compressed into the base table. NOTE: There is a way to do it without registering it as versioned but you have to do some extra steps to handle the managed OBJECTID field in a way that leaves it in a consistent state with the Geodatabase (https://desktop.arcgis.com/en/arcmap/10.7/manage-data/using-sql-with-gdbs/inserting-a-value-into-a-global-id-column-in-sql-server-using-sql.htm) This allows the database to chug away at a hefty process when we don't have any users in the system and provide standard feature classes with spatial indexes to our users. ... View more

I think I see what the seeking to do and there was a way in ArcMap to add a subquery inside the definition query if both feature classes lived in an enterprise geodatabase. I attempted this in Pro and it does validate the query but on saving it, it never applies. Then, when you open up the definition query editor, it shows no active definition queries. So I agree with your desire and others that it would be nice to have a way to limit the features by a spatial definition query.   ... View more

Guessing you've already figured this out but we experience this on windows when the native client is not up-to-date or there is a sql driver missing. I would think it could be possible that there is a drive missing? ... View more

I am in an MS SQL Server EGDB using ArcMap 10.7.1 and I see the same behavior. When the FC has no join. the Shape_area() and Shape_length() fields are there, after joining to an enterprise table or FC, they are gone. Not just turned off, gone.   Decided to try it in Pro and the behavior is different. The fields are still there but they are at the beginning of the list of fields:   ... View more

Sorry I'm just seeing this. It has been too long and I don't remember but I think it was just the ArcGIS Server machine. We are just finding that it's doing it again after upgrading to 10.8.1. I'm going to be on the phone with them again it looks like. ... View more

For anyone else experiencing this issue, our cause for these errors was that we had just received a new certificate for our internal servers that would work for any server on our internal network (an internal wildcard cert). This was a pfx file. We imported it and enabled it and the web browsers stopped complaining about insecure websites. However, the individual pieces of the architecture were not liking it. Also, programatically interacting with the portal or server through python or rest api was throwing ssl errors. The problem was that we had not imported a root or intermediate .cer file. Apparently this is needed to complete the validation route. Once that was in place on both Server A and Server B, we were back in business. It took a 3 hour chat with Tech Support but we got it. ... View more

We have just had this start happening on a 10.7.1 on windows 2016 with a federated server. It started being observed a couple days after updating our ArcGIS Server to use a new self-signed wildcard cert. We have tried using the same cert on our portal machine to see if that resolved the issue but it has not. Our architecture is as follows: Server A: ArcGIS Server, Data Store (inside firewall, Self-signed Cert) Server B: Portal for ArcGIS (inside firewall, Self-signed Cert) Server C: Web Adaptor for Server, Web Adaptor for Portal (outside firewall, CA Cert) We are somewhat surprised that this is still just sitting here with a bug like this unresolved. How have you all moved past this or are you just using this method to delete the orphaned items constantly? ... View more

Yep, that version is fine. It's the one used when the error is produced. It continues to happen even when unregistering so version specific errors are ruled out.  I heard back from them and they ended up telling me that this is a bug. #BUG-000125941 ... View more

Joshua, I am running these queries in SSMS. These two feature classes are not versioned but on feature classes that are, I append "_evw" to the end of the name to select from the multi-version view of the table/featureclass. Good thought though. Doug ... View more

I found this as I was getting the same exact error in Desktop. I use backend STIsEmpty(), STIsValid(), STIsSimple() as mentioned in previous comments. All were valid and simple, none were empty. We are on 10.5. I have discovered something after thorough testing. I have narrowed it down to an issue with Enterprise GDBs in SQL server (haven't tested in Oracle etc).  Place two feature classes with non-overlapping extents from an EGDB in a map. Run "Select by Location" in the following scenarios: Select one feature in FC1 and then run "Select by Location" selecting features from both FCs within a distance that will not reach features in FC2. Error occurs Select one feature in FC1 and then run "Select by Location" selecting features from both FCs within a distance that will reach features in FC2. Error does not occur Select one feature in FC1 and then run "Select by Location" selecting features only from FC1 within a distance that will not reach features in FC2. Error does not occur Select one feature in FC1 and then run "Select by Location" selecting features only from FC1 within a distance that will reach features in FC2. Error does not occur Repeat the inverse of this (swapping FC1 with FC2 in each scenario) and you will get the same results. Conclusion: Error is produced when selecting features from both FCs when the search radius does not intersect the second FCs extent. If this same test is performed with the feature classes in a File GDB, no errors are shown. I have called and I'm waiting for a call back from Tech Support. I have tested this in a 10.4.1 and 10.5 GDB. I don't know if perhaps it is fixed in a newer release. ... View more

We are having related but not identical issues. We have some of our layers dropping from a map but not from the actual service itself. We have put a ticket in and they are researching it. We are not 100% sure it's windows updates because we only update on Mondays and this occurred on a Wednesday night. We will post more as we learn more. Glad you shared this though. ... View more

I found a solution to our problem and felt the need to share it here. What ended up fixing the issue was to drop and recreate the login for the AD group at the instance level and then also drop and recreate the user at the database level for that AD group. I am not exactly sure how this solved the issue but I needed to do it for another issue and we discovered it fixed this issue as well. ... View more

Dan, This is more than I was able to find through searching so it is helpful. However, I landed on this thread searching for a scenario that is not documented. I think others may be asking it in other words but instead, I'll try this approach. We have users that have their phone fall in the sewer or the stream or get mangled by kids and wiped, etc. This basically deletes the device data without ever letting the replica parent know. How do I find out that a replica version needs deleted and its associated replica needs unregistered? For all my script knows, there's still a device with collector installed that has that version checked out. I am not close enough to the staff to know of these occurrences and they don't think to tell us these sort of things. ... View more

Rex Robichaux‌, thank you for your additional info. If I understand you correctly, you wanted to confirm that we did not modify the default database role "public"? Correct, it appears as shown below: I likely will create a new case for this. To further the confusion, there are other enterprise geodatabases in the same instance using the same active directory group, that we are able to view data in. That started me thinking it was something to do with the database. Then I tried importing a map into ArcGIS Pro that contained layers from the database that we cannot view layers in and it still shows all the layers without red exclamation points. However, it does take a bit longer to open a map containing layers from that database. ... View more

We currently have a map that we've just started seeing this behavior on as well but I am reluctant to provide a link because it might unnecessarily inflate our usage statistics . It has one line layer that has enabled popups but the popup shows up when clicking on empty space in the map and simply says "No Information Available." This is leading our users to think something is broken. ... View more