How to troubleshoot ArcGIS Server error code 10837: general geodatabase error

3479
2
10-07-2015 02:01 PM
JadeFreeman
Occasional Contributor III

Hello,

We are running ArcGIS Server 10.3 and trying to deploy several Operational Views using Operations Dashboard which all suffer from a problem related to errors when trying to execute statistic queryies.

Whenever the operations view executes the statistics query, or when we use the MapServer/layerId/query rest endpoint to attempt a statistics query we get the 'Operation could not be completed' error message and in our server logs for the service we get the 10837 general geodatabase error code with the descriptive and highly helpful 'general geodatabase error' message.

Our services are using query layers on Oracle 11gR2 and I'm pretty sure statistics on query layers is supported.  The service endpoint 'supportsStatistics' parameter is true.

Is there any way to log the actual SQL statement sent to the database?  The query layers are built on views inside oracle and knowing what SQL is being sent to the database would be highly useful.

Are there any other suggestions for troubleshooting this?

Thanks!

Jade

2 Replies
ChrisSmith7
Frequent Contributor

Jade,

This article may help - there's some info on intercepting/tracing SQL queries sent to Oracle:

How to trace SQL queries sent by ArcGIS Server (ArcSDE) to Oracle database? - Geographic Information...

0 Kudos
jonathanrobinson
New Contributor III

Hello Jade, did you discover a solution to this issue?  We are experiencing the same error.

0 Kudos