Latest Contributions by ChristopheAndrey1

I have several query layers in an ArcGIS Pro 1.4 project, each accessing the same database view, but each with a different where-clause in their source SQL-select statement. Each layer has thus only a few dozens or thousands of features, while the view itself in its entirety has millions of rows. Of course, no layer ever queries the entire view. We distribute this ArcGIS Pro project to our users on a read-only file share. Could it be that ArcGIS Pro, in a rare circumstance that I have never observed so far, decides to call a the select-statement WITHOUT its where-clause?That would result in a very, very long-executing query that would put unneeded load on our DB-server, render the map in ArcGIS Pro unusable for dozens of minutes at least and clog the client computer's CPU and memory.  Or does ArcGIS Pro guarantee to always use the where-clause? Thanks in advance for your time & thoughts Christophe ... View more

Our users are using query layers in ArcGIS Pro connecting to an Oracle database and they love it. It works well.... as long as the application remains connected to the DB.  Often, though, we unplug our laptops from their docking stations to move to a meeting room, where the laptops reconnects to the internet via Wifi. Or we temporarily loose internet connection while the train we are working in rides through a tunnel. Those interruptions last only a few seconds but this is apparently long enough for ArcGIS Pro to lose the DB-connection of its query layers. The only solution we have found to this problem consists in restarting our ArcGIS Pro altogether. Really annoying when you are concentrated in the middle of a task or of an explanation.  Is there a way for ArcGIS Pro to recognize that is online again and to somehow automatically reconnect its query layers? Is there a way to manually tell it to reconnect? Is there a way to do the same programmatically with the SDK? ... View more