Skip to main content
I want to merge two features with FeatureMerger (Attributes only). The requestor is an Oracle spatial featuretype, the supplier an Oracle non-spatial featuretype. Although the geometry passes through a GeometryValidator, it is not written (Oracle Spatial writer). I get: Bad geometry detected in the following feature; Geometry could not be encoded for Oracle. If the requestor and the supplier-feature are both Oracle-spatial, it works just fine.

 

As a workaround I tried to use a GeometryExtractor before and a GeometryReplacer after the FeatureMerger (http://fmepedia.safe.com/AnswersQuestionDetail?id=906a0000000cu9WAAQ) but I get the same error.  (I'm using FME Desktop 2013)

 

Any suggestions? Thanks in advance.

 

 

Vera

 

You may need to send your workspace to a support email.

 

 

My suggestion would be to:
  • Try writing to another format temporarily. e.g. ESRI / MapInfo. Is the geometry still lost?
  • Use a GeometryRemover before the FeatureMerger on the Oracle Non-Spatial input connection
  • Ensure that the Oracle Spatial data is going into the Requester input port of the FeatureMerger
It may simply be a logic mismatch or it may be something "interesting" with the Oracle writer itself.

 


Reply