Skip to main content
Question

Oracle Spatial Reader : All spatial filters failed... FME 2022.2.

lau
Forum|alt.badge.img+3

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)

2 replies

kailinatsafe
Safer
Forum|alt.badge.img+19

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.

lau
Forum|alt.badge.img+3
  • lau
  • Author
  • December 8, 2022
kailinatsafe wrote:

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


Most helpful members this week

Community Stats

30,851
Posts
116,972
Replies
38,683
Members
Terms & ConditionsCookie settings

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
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.