Bug
ArcGIS Data Pipelines (June 2024) returns an ADP_999999 error "An unexpected error occurred", when a 'Filter by Attribute' operation is performed after a one-to-one spatial join operation.
| Bug ID Number | BUG-000169805 |
|---|---|
| Submitted | August 8, 2024 |
| Last Modified | April 28, 2025 |
| Applies to | ArcGIS Online |
| Version found | June 2024 |
| Operating System | N/A |
| Operating System Version | N/A |
| Version Fixed | Planned Release Date: Q2 2024 |
| Status | Fixed |
Additional Information
There was an issue with using SQL queries on the result of a join. This issue is fixed in the June 2024 update of ArcGIS Online.Workaround
Until this is fixed, consider writing the join output to a new feature layer and using that as input to the data pipeline to continue the rest of the workflow. The 'Filter by Attribute' tool works on the resulting feature layer.
Steps to Reproduce
Bug ID: BUG-000169805
Software:
- ArcGIS Online
Get notified when the status of a bug changes
Discover more on this topic
Search for related information
Find training related to this topic
Explore ideas and give feedback
Get help from ArcGIS experts
Download the Esri Support App