Bug
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.
| Bug-ID-Nummer | BUG-000174956 |
|---|---|
| Eingereicht | March 11, 2025 |
| Zuletzt geändert | July 7, 2025 |
| Gilt für | ArcGIS Pro |
| Gefunden in Version | 2.9.12 |
| Betriebssystem | Windows OS |
| Betriebssystemversion | 11.0 64 bit |
| Status | As Designed |
Zusätzliche Informationen
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).Workaround
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.
Schritte zur Reproduzierung
Bug-ID: BUG-000174956
Software:
- ArcGIS Pro
Benachrichtigung erhalten, wenn sich der Status eines Bugs ändert
Weitere Informationen zu diesem Thema erkunden
Nach zugehörigen Informationen suchen
Nach Schulungen zu diesem Thema suchen
Ideen erkunden und Feedback geben
Unterstützung durch ArcGIS-Experten anfordern
Esri Support App herunterladen