This is more of a discussion question than a "help me find the right answer" question. I'm looking for others with experience using query layers in Pro. I don't use them a lot, but it's the right solution for a project currently under development. For context, I have Pro 2.8.1 installed on a Windows 10 64-bit machine. The query layers are pulling from SQL Server (currently using version 18) and I'm writing the queries on the ArcGIS Pro side rather than in SQL Server Management Studio.
With regard to "buggy" issues, I've noticed several undesirable, yet inconsistent behaviors when updating a query.
- When I click the edit button to modify the query, the option to name the Query is not available. Most of the time that's not a problem. Occasionally, it will prevent me from saving my updates because I get an error message that says that the name is empty (it's not, but Pro seems to think it is). **EDITED TO ADD screenshot:
- When I validate a query, it is generally quick to resolve. Sometimes, it hangs for several minutes. I've had to wait for at least 15 minutes on more than one occasion.
- When I advance to the screen to set unique identifiers, I am occasionally blocked from selecting a geometry type and/or a coordinate system. Again, I've waited 15+ minutes on this screen for the "hang" to resolve itself.
- After updating a query and clicking OK, the OK button on the Properties window also hangs on occasion. Again, wait times can be anywhere from seconds to 15+ minutes.
The biggest problem is that I cannot replicate the behavior consistently, so calling tech support isn't going to do any good. So, I thought it might be useful to post here and see if there are others experiencing this issue and/or have identified possible causes.