Skip to main content
Archived

Featurewriter truncating a key column should issue an error

Related products:FME Form
  • September 16, 2020
  • 0 replies
  • 15 views

Featurewriter truncating a key column should issue a error.

When featurewriter is writing to ie Oracle, the columns are truncated to the length spesified of the featurewriter format, before the insert is done in the database.

If you update features, you specify a key column for the update. If the featurewriter is truncating the data to match the feature definition, then the data entering the database is not what you feed into the featurewriter. This is difficult to detect and cause ie deletes and updates not to happen because the key is altered, and no match in database is found.

So when data entering the featurewriter that exceed the length in the format definition, is a key, then a warning or error should be issued.

Or, if the column is a key, it should give an error, or if not a key, it should give you a warning.

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.