Solved

FME doesn't detest postgres insert errors

Forum|Forum|6 years ago
January 28, 2019
2 replies
11 views

christian_b

Hi,

I use FeatureWriters in FME Workbench 2017 for inserting datasets in Postgres.

But when there are errors in my input data, like a string instead a boolean value, the row is not written in Postgres but FME doesn't detect the error, the row is counted like a correct insert and I have the message "Translation was successfull" at the end.

Of course, I could use AttributeValidators to detect such errors but I have a lot of fields and I wouldd like to avoid to inspect each field.

Thanks in advance for any help,

Christian

Best answer by david_r

Have a look at my answer here: https://knowledge.safe.com/questions/78899/can-i-force-a-translation-to-fail-if-violation-of.html

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.