Skip to main content
Question

can not read oracle data - bad geometries

  • May 23, 2018
  • 1 reply
  • 21 views
K
Forum|alt.badge.img

Hi,

I have a oracle spatial reader setup to read a number of tables. All the tables can read except one table and the reader stops automatically with a error message in the log - Error - Cannot have NULL value for 'x coordinate'. I tried to filter the bad geometries with a where clause like this - SDO_GEOM.VALIDATE_GEOMETRY_WITH_CONTEXT( G3E_GEOMETRY, 0.005, 'TRUE') = 'TRUE' . That did not work either and the same error followed. Surprisingly when I used this sql statement at SQLDeveloper, it results in a set of valid records. I am not sure why FME is not able to read these valid records.

Appreciate if you could help me out with this.

1 reply

david_r
Evangelist
  • david_rEvangelist
  • May 23, 2018

You can try and debug the contents of the table in question using a SQLCreator (rather than the Reader) set to Oracle non-spatial and something like this:

SELECT MY_ID, SDO_UTIL.TO_WKTGEOMETRY(GEOM) AS WKT_GEOM FROM MY_TABLE;

You can then use the GeometryReplacer on WKT_GEOM (set to OGC Well-Known Text) and inspect whatever comes out the Rejected-port.

Reply


Helpful Members This Week

Community Stats

31,039
Posts
117,664
Replies
38,818
Members

Latest FME

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.