Skip to main content
  • EN

Hello,

After migrating to FME 2022.2 (desktop and server), I get errors on each workspace that uses Oracle Spatial FeatureReader with a spatial filter:

imageI tried these workspaces on FME 2022.0 and everything works fine...

I don't really feel like reinstalling another version of FME Server, so any solutions/workarounds are welcome :)

(Using spatial SQL queries instead of FeatureReader is not an option)

Hello @lau​, thanks for posting. Unfortunately, I think you've hit a known issue in FME Desktop 2022.2 (FMEENGINE-75065). There is no resolution or workaround as of yet, but I've added a note to update this thread when a fix is available. I hope this doesn't cause too much inconvienence in the meantime! Best, Kailin.

Hello @lau​, thanks for posting. Unfortunately, I think you've hit a known issue in FME Desktop 2022.2 (FMEENGINE-75065). There is no resolution or workaround as of yet, but I've added a note to update this thread when a fix is available. I hope this doesn't cause too much inconvienence in the meantime! Best, Kailin.

Thank you for your reply @kailinatsafe​.

For those who might have encountered this issue : Here is the workaround that works for me :

  1. Add a BoundsExtractor before the FeatureReader
  2. Use a FeatureReader with no spatial filter. In the Where clause, set the spatial clause. For example : MDSYS.SDO_RELATE(GEOMETRY, mdsys.sdo_geometry(2003,31370,null,mdsys.sdo_elem_info_array(1,1003,3),mdsys.sdo_ordinate_array(@Value(_workaround_xmin),@Value(_workaround_ymin),@Value(_workaround_xmax),@Value(_workaround_ymax))),'mask=ANYINTERACT querytype=WINDOW') = 'TRUE'
  3. Add a SpatialFilter

I put an example in attachment

Reply


Community Stats

30,126
Posts
114,354
Replies
37,759
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.