Hi,
We are having issues with our 10.9.1 instance in regard to sql queries from a oracle 19C database.
We are working with a hybrid method where some tables are registered into an enterprise geodatabase and some aren’t. When creating Dashboard Indicators or REST API queries, only layers from a registered table (Enterprise Geodatabase Feature Class) can return statistics. Ex: count, sum, max.
Query layers from unregistered tables and even Query layers on a registered table return errors. (Unable to complete operation).
Example: Let say we have a table named SITES which is registered. I create 2 layers in ArcGIS Pro using the said table and publish a service (MapService, FeatureServer).
- Enterprise Geodatabase Feature Class
- Query layer => SELECT ID, NAME, TYPE FROM SITES
I then go to the REST API and do a query using Output Statistics, ["onStatisticField":"ID","outStatisticFieldName":"value","statisticType":"count"]
Layer 1 returns a count, Layer 2 returns an error Unable to complete operation.
Any ideas ?
