Skip to main content
  • EN

Hello,

I am currently working with some database PostGIS rasters and wanted to import some into FME 2024.1, using a filter to only select 2 out of 11030.
To do so, I tried both a SQL Executor and a FeatureReader (as both enables PostGIS raster reading).
The SQL Executor filters the rasters correctly but doesn’t create the geometry and returns an error in the log file.
The FeatureReader loads the 11030 rasters without filtering, suggesting a problem with the “WHERE clause”.

I tried the same thing using FME 2023.1 and the SQL Executor is working under this version. I am wondering if there is a bug in the FME 2024.1 version.
The problem was the same for the Feature Reader.
A colleague said that the Feature Reader outputs everything as well in previous versions of FME (2022.2 and 2021.1).

Do you know when the FME 2024.1 bug will be corrected?
We are linking our work with ArcPro and we know we will have to use FME 2024.

I am enclosing a share folder with the different logs (as txt) and the 2 workbenches to see the parameters are the same in both versions.

Thank you

Sébastien Gilment

PS : My colleague did a bit more testings :

“Further to it, I eliminated the transformer error: I backed up my test workbench yesterday in FME2023 and opened it without updating the transformers in 2024.1.3 and it gave me the same error. It's a FME environment error.”

 

In the workspace 2024-1, the Where-clause of the FeatureReader contains a full SELECT statement, which I suspect is not supported (or necessary).

Try only giving the Where-clause, without the semi-colon at the end:

"seq_model_id" = 92 and "co2_ppm" = 540 and "raster_type_id" in (7,23) and "level_m" = 0

This still outputs 11030 rasters. It was something we did try.

 

Hi ​@moustik, I think this may be a bug but I’m having trouble recreating your issue. Would you be able to attach your PostGIS_raster_2024-1 workspace as a .fmwt so that I can take a look? You can do this by running your workspace with feature caches enabled, and then navigating to File > Save As Template and making sure that Include Feature Caches is checked. 

In the meantime, does the PostGIS Raster reader work for you? You can still specify a WHERE Clause by going into the Parameters. 

Reply


Community Stats

30,351
Posts
115,341
Replies
38,080
Members
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.