Bogue
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.
| Numéro d’ID de bogue | BUG-000174956 |
|---|---|
| Envoi | March 11, 2025 |
| Dernière modification | July 7, 2025 |
| S’applique à | ArcGIS Pro |
| Version trouvée | 2.9.12 |
| Système d’exploitation | Windows OS |
| Version du système d’exploitation | 11.0 64 bit |
| Statut | As Designed |
Informations supplémentaires
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).Solution de contournement
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.
Étapes pour reproduire
ID de bogue: BUG-000174956
Logiciel:
- ArcGIS Pro
Recevoir une notification lorsque le statut d’un bogue change
En savoir plus sur ce sujet
Rechercher des informations associées
Rechercher une formation sur ce sujet
Explorer des pistes et donner un avis
Obtenir de l’aide auprès des experts ArcGIS
Télécharger l’application Esri Support