laptop and a wrench

Error

Unable to query REST API when using a referenced service coming from an Oracle database or file geodatabase for a text field; the text is treated as a string, causing the query to fail when attempting to use ST_CODE = 54 without quotes due to ArcGIS Server's standardized queries enforcing SQL-92 syntax.

ArcGIS Pro
Número de ID del error BUG-000174956
EnviadoMarch 11, 2025
Última modificaciónJuly 7, 2025
Relacionado conArcGIS Pro
Versión encontrada2.9.12
Sistema operativoWindows OS
Versión de sistema operativo11.0 64 bit
EstadoAs Designed

Información adicional

The behavior in which the REST query ST_CODE = 54 fails without quotes but succeeds with ST_CODE = '54' is expected and by design. This is consistent with our official documentation on standardized queries in ArcGIS Server, which enforces SQL-92 syntax for security purposes (see: https://resources.arcgis.com/en/help/main/10.2/index.html#//015400000641000000).

Solución alternativa

Immediate Fix:

  • Use: ST_CODE = '54'.
  • Effect: Resolves the error regardless of settings, as validated in the test report.

Long-Term Consistency:

  • Verify Settings: Path: system > properties > update.
  • Confirm: "standardizedQueries": "true".
  • Action: Keep enabled for security.
  • Avoid Disabling: Disabling ("standardizedQueries": "false") allows lax syntax but risks SQL injection.

Pasos para reproducir

ID del error: BUG-000174956

Software:

  • ArcGIS Pro

Recibir notificaciones cuando cambie el estado de un error

Descargar la aplicación de soporte de Esri

Descubrir más sobre este tema

Obtener ayuda de expertos en ArcGIS

Contactar con el soporte técnico

Descargar la aplicación de soporte de Esri

Ir a opciones de descarga