Error publishing a View

Discussion created by joanv on Nov 2, 2010
I created a View in Oracle with a distinct statement from an existing table in arcSDE.
I'm able to see this View in ArcMap, so it works.
But when I publish my mxd to ArcGis Server as a service and try to Query it in the REST API interface I get the following error: Error -1 Code: 500. Instead, the original table, published in the same service can be queried.

Does anyone has a solution?

Thank you