Skip to main content
Solved

FME doesn't detest postgres insert errors

  • Jan 28, 2019 8:32 PM UTC
  • 2 replies
  • 38 views

Forum|alt.badge.img

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

View original
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.

2 replies

david_r
Celebrity
  • Best Answer
  • Jan 29, 2019 8:13 AM UTC

Forum|alt.badge.img
  • Author
  • Jan 29, 2019 11:38 AM UTC

Tnak you David, very interesting, I'll give it a try !