Question

Fatal error occurs when loading one polygon to SDO database

  • 7 March 2014
  • 4 replies
  • 7 views
O
Any one could know this problem?

 

 

It is fine for a polygon that consists of many polygons by using FME's GeometryValidator and inspector to view the polygon. However, when using FME to load it into SDO database, the following error occur, and no geometry inserted.

 

.........

 

"An error occurred while converting feature information to an Oracle object in column `GEOMETRY'

 

A fatal error has occurred. Check the logfile above for details

 

This occurred while attempting to process the following feature:

 

The following row was not written to Oracle table because of errors converting columns: GEOMETRY

 

......."

4 replies

david_r
Rank
Userlevel 4
Hi,

 

 

be aware that the GeometryValidator will only validate in an FME context. There is therefore always a chance that a geometry will pass the GeometryValidator but still fail when being written to the output format, since the criteria may differ.

 

 

One way to debug this error could be to isolate the problematic feature, convert the geoemtry to WKT (use the GeometryExtractor with type "OGC Well Known Text") and then try to insert it manually into Oracle, e.g. something like

 

 

select into MY_TABLE ("OBJECTID", "SHAPE") values (999999, SDO_UTIL.FROM_WKTGEOMETRY('<WKT string here>'))

 

 

David
G
Badge +3

There are a couple commands in SDO wich allow u to check the required format in your database.

 

If u read that, u can compare it to FME output. Prior to write-attempt to database ofcourse..

 

 

Often u have to set or reset some values to confomr to Oracles SDO for your particular database requirements.

 

 

QA search on docs.oracle.com on oracle_geometry, g

 

 

 

Gio
O
When getting fatal error in the middle of log file, FME run still shows successful in the end of the log file for data translation. It may be better to throw an error message to the user.
O
Because this polygon is large and also includes many small polygons, how could it be inserted into Oracle spatial table by FME or Oracle tool?

Reply


Community Stats

28,688
Posts
109,427
Replies
36,543
Members
Terms & ConditionsCookie 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.