Select to view content in your preferred language

Oracle - Unable to complete operation on output statistics

409
1
Jump to solution
06-15-2022 06:14 AM
IngRF
by
New Contributor

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).

  1. Enterprise Geodatabase Feature Class
  2. 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 ? 

0 Kudos
1 Solution

Accepted Solutions
TanuHoque
Esri Regular Contributor

@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-extpr...

Apologies for the inconvenience.

Tanu

View solution in original post

0 Kudos
1 Reply
TanuHoque
Esri Regular Contributor

@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-extpr...

Apologies for the inconvenience.

Tanu

0 Kudos