Skip to main content
  • EN

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?

 

 

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.

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.

 

  • 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

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 

Hi ​@crystalatsafe ,

Appologies for the very slow response.

I am not allowed to install software where I have access to an FME license, and where I am able to install software I do not have access to an FME license. I am afraid I will not be able to test this until we upgrade to FME 2025.x at our company later this year.

Kind regards,

FB Ruimte

Reply


Community Stats

31,821
Posts
120,861
Replies
39,452
Members

Latest FME

Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.