topic Non standardized def query breaks Create Replica function in ArcGIS Enterprise Questions https://community.esri.com/t5/arcgis-enterprise-questions/non-standardized-def-query-breaks-create-replica/m-p/256815#M9909 <HTML><HEAD></HEAD><BODY><P>I've got a 10.3 feature service and require offline capabilities to use it with the Android SDK. In the MXD there's a Definition Query with a non- standardized query on a layer - exact query is <SPAN style="font-size: 10.0pt; font-family: 'Verdana','sans-serif';">DateChecked &gt; DATEADD(month, -2, GetDate())</SPAN>. This prevents the Create Replica function from working on the Feature Service. I can't use a standardized query in the Def Query (CURRENT_DATE isn't supported) and our DBAs don't want to disable standardized queries for the server.</P><P></P><P>It seems slightly strange to enforce standardized queries at the REST endpoint but not allow them in a Definition Query within an MXD. Is it likely that standardized queries will be supported within Def Queries in future versions?</P><P></P><P>As an aside the error message encountered when the createReplica fails is, "Unable to complete operation. Failed to create replica.". A more descriptive error message would greatly help troubleshooting for other people who come across this.</P></BODY></HTML> Wed, 29 Apr 2015 23:01:26 GMT MarkPeacey2 2015-04-29T23:01:26Z Non standardized def query breaks Create Replica function https://community.esri.com/t5/arcgis-enterprise-questions/non-standardized-def-query-breaks-create-replica/m-p/256815#M9909 <HTML><HEAD></HEAD><BODY><P>I've got a 10.3 feature service and require offline capabilities to use it with the Android SDK. In the MXD there's a Definition Query with a non- standardized query on a layer - exact query is <SPAN style="font-size: 10.0pt; font-family: 'Verdana','sans-serif';">DateChecked &gt; DATEADD(month, -2, GetDate())</SPAN>. This prevents the Create Replica function from working on the Feature Service. I can't use a standardized query in the Def Query (CURRENT_DATE isn't supported) and our DBAs don't want to disable standardized queries for the server.</P><P></P><P>It seems slightly strange to enforce standardized queries at the REST endpoint but not allow them in a Definition Query within an MXD. Is it likely that standardized queries will be supported within Def Queries in future versions?</P><P></P><P>As an aside the error message encountered when the createReplica fails is, "Unable to complete operation. Failed to create replica.". A more descriptive error message would greatly help troubleshooting for other people who come across this.</P></BODY></HTML> Wed, 29 Apr 2015 23:01:26 GMT https://community.esri.com/t5/arcgis-enterprise-questions/non-standardized-def-query-breaks-create-replica/m-p/256815#M9909 MarkPeacey2 2015-04-29T23:01:26Z