Skip to main content
Question

Problem using FeatureReader with ArcGIS Portal Feature Service

  • November 5, 2024
  • 4 replies
  • 48 views

eric_armitage
Contributor
Forum|alt.badge.img+10

I’m trying to use the FeatureReader to read 3 features from an ArcGIS portal feature service layer by reading in a spreadsheet and using a WHERE clause with an attribute in the spreadsheet. 

The FeatureReader will connect to the service and I can select the correct table in the “Feature Types to Read” parameter. But when I try to add the WHERE clause FME crashes before I can start creating the WHERE clause. The second image below indicated the point when it crashes.

I can read the full table with no problem using the ArcGIS Portal Feature Service reader.

 

How can I get the FeatureReader to run and read the required features?

 

 

ebygomm
Influencer
Forum|alt.badge.img+30
  • Influencer
  • November 5, 2024

I see the same behaviour if i try and open the Database Tables in the clause builder. I can copy and paste the where clause directly however.


eric_armitage
Contributor
Forum|alt.badge.img+10

This is not a solution but a work around seems to be to leave the “FeatureTypes to Read” empty and manually enter the WHERE clause. The Feature Reader is then created with an output for each Feature Type and the correct features are read.  Its just the where clause builder that causes the problem.

 


fbruimte
Participant
Forum|alt.badge.img+1
  • Participant
  • January 28, 2025
  • Similar behaviour when using the ‘Esri ArcGIS Online (AGOL) Feature Service’ and ‘Esri ArcGIS Server Feature Service’
  • Similar behaviour when using a ‘normal’ Reader instead of a FeatureReader transformer.
  • FME Workflow crashes when opening the ‘Database Tables’ section in the WHERE clause builder.
  • Works fine when using Microsoft Access, Esri Geodatabase (ArcSDE Geodb) etc.
  • Used versions
    • FME(R) 2024.1.2.0 (20240830 - Build 24622 - WIN64)
    • ArcGIS Pro 3.3.0

crystalatsafe
Safer
Forum|alt.badge.img+17

Hi ​@fbruimte 

We have recently made some changes that should resolve this issue.

Are you able to test our newest build (FME 2024.2.2, build 24820)? You can find it on our downloads page: https://fme.safe.com/downloads/ 

Please let me know if you are still experiencing the crash in the latest build.

 

Crystal 


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings