Oracle - Unable to complete operation on output statistics

IngRF — Wed, 15 Jun 2022 13:14:30 GMT

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 ?

Re: Oracle - Unable to complete operation on output statistics

TanuHoque — Wed, 15 Jun 2022 15:38:40 GMT

@IngRF

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.

https://pro.arcgis.com/en/pro-app/latest/help/data/geodatabases/manage-oracle/configure-oracle-extproc.htm

Apologies for the inconvenience.

Tanu

topic Oracle - Unable to complete operation on output statistics in ArcGIS Enterprise Questions

Oracle - Unable to complete operation on output statistics

Re: Oracle - Unable to complete operation on output statistics