AnsweredAssumed Answered

mapservice layer with definition query fails to execute query on rest site

Question asked by bmcvicker on Sep 23, 2016
Latest reply on Sep 27, 2016 by patel1684

I am using ArcGIS 10.3.1 to create and publish mapservices.  I have an Oracle SDE layer with the following definition query: IS_DISPLAYED = 1 ORDER BY ISSUED_DATE ASC.  The expression is successfully verified and displays the correct data in the mxd.  When I publish the mapservice containing this layer as a service, and try to do a query operation from the REST site on this layer, I get the following error: "Failed to execute query."  When I remove the definition query from the layer and re-publish the service, the query works just fine from the REST site.  Is ArcGIS for Server unable to process this type of definition query through the mapservice?  Is there a different definition query I should use instead to get the same results?