Skip to main content
Question

oracle spatial reader unwanted schema attributes


burgasser
Contributor
Forum|alt.badge.img+4

Hi:

In FME Desktop 2019.1.3.1, when adding a table using the Oracle Spatial reader, I'm getting some unwanted attributes shown below (starting with fme_geomattr). I am not purposely exposing additional schema attributes. They just show up unwanted. Does anyone know how to avoid having these additional attributes exposed when adding feature types? Thanks!

2 replies

Forum|alt.badge.img+2
  • December 20, 2019

@burgasser This definitely isn't expected. I couldn't reproduce your behaviour. Can you give us more detail about your configuration:

FME Desktop 2019.1.3.1

Oracle version ?

It would probably also help to see if there is something special about your Oracle table - perhaps if you could include the Oracle table create SQL statement it might give us a clue. Could you include the FME log file from when you add the reader to your workspace. Thanks.


burgasser
Contributor
Forum|alt.badge.img+4
  • Author
  • Contributor
  • December 21, 2019
markatsafe wrote:

@burgasser This definitely isn't expected. I couldn't reproduce your behaviour. Can you give us more detail about your configuration:

FME Desktop 2019.1.3.1

Oracle version ?

It would probably also help to see if there is something special about your Oracle table - perhaps if you could include the Oracle table create SQL statement it might give us a clue. Could you include the FME log file from when you add the reader to your workspace. Thanks.

Oracle version is 12.1.0.2.0.

 

 

It doesn't seem to happen in 64 bit, only 32 bit.

 

 

It's not consistent - it does not happen always.

 

 

Sometimes, it will happen only once. If I delete the feature type, and re-import, the unwanted attributes are NOT there sometimes. Not only that, but if I close FME, re-open, and re-add, the unwanted attributes are NOT there.

 

 

There's nothing unusual about the tables. There are entries in the USER_SDO_GEOM_METADATA for the tables. There are spatial indices.

 

 

It's not terribly critical.

 

 

Thanks!

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