Skip to main content
Question

How can I make FME output an error when a source table doesn't exist?


tfcw
Participant
Forum|alt.badge.img+1
  • Participant

I have a lot of .fmw files with Oracle readers pointing to sources outside my control. Sometimes, the names of the tables I'm reading from will change, or they'll get dropped, or my credentials will lose permission to them. When this happens, FME just reads 0 features, and says the translation was successful.

How can I make FME output an error instead when this case happens?

2 replies

trentatsafe
Safer
Forum|alt.badge.img+6
  • Safer
  • November 7, 2017

Hello @yola ,

In regards to the table not being found, this is a known issue in terms of FME not returning a warning or an error(workspace will continue successfully without a warning/error). In regards to if a permissions error is present, I believe FME will output an error. The PR for the Non-existent table error is PR79930. I will update this posting with updates or fixes related to this issue.


tfcw
Participant
Forum|alt.badge.img+1
  • Author
  • Participant
  • November 7, 2017
trentatsafe wrote:

Hello @yola ,

In regards to the table not being found, this is a known issue in terms of FME not returning a warning or an error(workspace will continue successfully without a warning/error). In regards to if a permissions error is present, I believe FME will output an error. The PR for the Non-existent table error is PR79930. I will update this posting with updates or fixes related to this issue.

Thanks, looking forward to it

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