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).
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 ?
Solved! Go to Solution.
It looks like you are hitting a bug that we are hoping to address in 11.0. Meanwhile, if you want, you can try the steps from the help below. That might help you workaround the bug.
Apologies for the inconvenience.
Tanu
It looks like you are hitting a bug that we are hoping to address in 11.0. Meanwhile, if you want, you can try the steps from the help below. That might help you workaround the bug.
Apologies for the inconvenience.
Tanu