Skip to main content
Question

Failed to write curved geometry to SDE Geodatabase on Oracle

  • March 1, 2013
  • 3 replies
  • 78 views

I'm trying to import some MicroStation DGN data into an SDE Geodatabase (Oracle).

Β 

Β 

My workflow is built specifically to preserve curved geometries, and when I write to a File Geodatabase, these are intact. However when I write to an SDE Geodatabse these are stroked into straight line segments.

Β 

Β 

Looking at the logs I get the following warnings: WARNΒ  |Required columns 'GLOBAL_ID, OBJECTID, ' not specified for predefined table 'GISOWNER.TEST'.Β  Using Definition from Database

Β 

WARNΒ  |DEF line for the table 'GISOWNER.TEST' not fully specified. As a result, existing table definitions will be used

Β 

WARNΒ  |Existing SDE table 'GISOWNER.TEST' allows the following shapes: SDE_NIL SDE_LINE SDE_SIMPLE_LINE SDE_MULTIPART . Shapes specified in mapping file for table allows: . Defined shape types don't match.

Β 

WARNΒ  |Spatial column name for existing table 'GISOWNER.TEST' is 'SHAPE' while value specified in mapping file is ''. Using existing column

Β 

WARNΒ  |Existing table 'GISOWNER.TEST' does support CAD but mapping file specification for layer doesn't!

Β 

WARNΒ  |Existing table 'GISOWNER.TEST' has 64 bit precision but mapping file specifies 0 bit precision for the layer! Using existing table's definition.=======

Β 

I'm pretty sure I had this working before, so I must have inadvertantly changed something...

Β 

Β 

I suspected that the SDE polyline feature class that I was writing to couldn't handle curved geometries - for whatever reason. But I was still able to create curved geometries in the feature class with ArcGIS Desktop.

Β 

Β 

Any suggestions? Thanks.
This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

3 replies

  • Author
  • March 1, 2013
Do I need to somehow get my exisiting SDE feature class to allow the "SDE_CAD" shape? (see log line 3).

david_r
Celebrity
  • March 1, 2013
Which writer are you using, SDE30 or GEODATABASE_SDE?

Β 

Β 

I would try both, if possible.

Β 

Β 

David

  • Author
  • March 1, 2013
I was using SDE30 and now I have tried GEODATABASE_SDE, and that solves my problem. Thankyou.

Β 

Β 

I wasn't aware of the differences between the two.