Skip to main content
Question

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

  • November 7, 2017
  • 2 replies
  • 24 views

tfcw
Contributor
Forum|alt.badge.img+1

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?

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

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
Contributor
Forum|alt.badge.img+1
  • Author
  • Contributor
  • 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.

Thanks, looking forward to it