Customer has a working migration chain on FME 2021.2.5 and we would like to upgrade to 2022.2. At first, I started extracting data using FeatureReader from our source (Oracle Spatial), but I have strange warning message in the log and not all data all extracted from the source.
Warning message in the log relates to entries in ALL_SDO_GEOM_METADATA which are all set correctly – I would mention once more that data reading from Oracle using same workbench in 2021.2.5. is working.
Here is the warning message:
Execution of statement
`SELECT table_name, column_name, (SELECT COUNT(*) from TABLE(META.diminfo)) dcount, SRID FROM ALL_SDO_GEOM_METADATA META WHERE ALL_SDO_GEOM_METADATA.owner = '<SOURCE_SCHEMA>''
did not succeed; error was `ORA-00904: "ALL_SDO_GEOM_METADATA"."<OWNER>": invalid identifier'. (serverType=`ORACLE8i', serverName=`SERVER_NAME', userName=`<FME_READER>', password=`***', dbname=`')
If I try to execute this query directly on Oracle, I get the same error message as visible in the log, but this is expected as the alias for the table ALL_SDO_GEOM_METADATA is set to META. So query which FeatureReader tries to execute is not correct and should look like following:
SELECT table_name, column_name, (SELECT COUNT(*) from TABLE(META.diminfo)) dcount, SRID FROM ALL_SDO_GEOM_METADATA META WHERE META.owner = '<SOURCE_SCHEMA>'
Does someone else had similar problem or knows of any workaround?
