Good morning,
I am using ArcGIS Pro 2.8.3 to connect to an enterprise geodatabase (MS SQL server) where I only have read rights. In the geodatabase there are several tables and one point feature class containing some date fields. The joins between the feature class and the tables are working ok, but the queries not. Every query on any field from the feature class ends with the very informative message " There was an error with the expression". If I query on a field from on of the joined tables, it kind of works but it takes forever, like more than one hour to execute the query and sometimes just blocks. The feature class has under 10.000 points and the join tables have very few records. I cannot create an index on the join field because I only have read rights on the enterprise geodatabase and it fails every time I try. Maybe it's slower because of this.
Do you have any ideas how can I solve the queries problem?
