Skip to main content
Question

Writing to SDE 9.3 and Oracle 10G with FME 2012 SDE Writer Error while inserting table into stream for table ERROR Code (-38)

  • June 30, 2013
  • 0 replies
  • 7 views

johnniegis
Participant
Forum|alt.badge.img+4
Good Day,

 

Not a question but rather a discovery which may be of use to some others out there. I realize there are newer versions of all the mentioned systems but for a number of reasons the client is required to utilize these.

 

 

So on to the problems:

 

1. All Feature Types (SDE layers) are created in SDE prior to running FME so Writers are created using Import Feature Types rather than using FME to create the layers. Again this is required as part of the business process.

 

In order for FME to recognize these tables as spatial they must be opened in ArcCatalog/ArcMap first to initialize them without doing this FME tries to insert a NULL/nil geometry and fails.

 

2. For one particular non-spatial Feature Type, FME kept indicating that there was a missing column although did not specify which one. Google searches indicated it was likely an underlying issue with the SDE table.

 

To try and determine the issue, we dropped and recreated the table, removed any contraints, keys etc but still no luck. We then created a table with the same schema but a different name and oila...so it appears that there was a metadata corruption in SDE and we had to clean out any references to it.

 

Hopefully this can save someone else some time as we spent a long time on it.
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.