Known Issue - Oracle 11g Spatial database is not able to return records due to a metadata error

Rahul S
Rahul S
  • Updated

FME Version

  • FME 2021.1

Known Issue ID

FMEENGINE-75065

Discovered

FME Desktop 2022.1

Affects

FME Desktop 2022.1 and newer

Resolved

FME Desktop 2022.2.2 

 

Symptom

This issue was first encountered in FME 2021.1(b22606), affecting users with Oracle 11g(11.2.0.4 supports end Dec 2023). This issue affects all interactions with both Reader and Writer translations with Oracle 11g Databases.

The following error messages are displayed for Oracle Spatial Readers and spatial filters.

ORA-29902: error in executing ODCIIndexStart() routine

ORA-13208: internal error while evaluating [window SRID does not match layer

SRID] operator

For Oracle Spatial Writing, the following error message is displayed.

error was `ORA-29875: failed in the execution of the ODCIINDEXINSERT routine

 

ORA-13365: layer SRID does not match geometry SRID

ORA-06512: at "MDSYS.SDO_INDEX_METHOD_10I", line 720

 

Cause

Bad SQL Queries getting constructed for reading and writing with different subsequent effects. 


Resolution

Upgrade to FME 2022.2.2 (build 22767 and newer)

 

Was this article helpful?

Comments

0 comments

Please sign in to leave a comment.