Skip to main content
Solved

FME doesn't detest postgres insert errors


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
Did this help you find an answer to your question?

2 replies

david_r
Celebrity
  • Best Answer
  • January 29, 2019

Forum|alt.badge.img
  • Author
  • January 29, 2019

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


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings