Skip to main content
Solved

Is there a way to bypass/ignore a Writer error?

  • July 21, 2020
  • 3 replies
  • 224 views

My workbench creates a number of excel spreadsheets. Sometimes it fails due to users having one of the spreadsheets open when the workbench runs during the night. Though that spreadsheet cannot be updated due to the lock, it would be very useful to still be able to update the other spreadsheets rather than the entire workbench stopping completely.

Can a writer error be bypassed or ignored?

Best answer by ebygomm

I'm not aware of one. In the past I have resorted to using python to check whether the file is open and only sending features to the writer if it is not open (even this is not always foolproof)

Vote for the idea here

https://knowledge.safe.com/content/idea/73898/check-writer-accessibility-when-a-workspace-is-sta.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.

3 replies

ebygomm
Influencer
Forum|alt.badge.img+46
  • Influencer
  • Best Answer
  • July 21, 2020

I'm not aware of one. In the past I have resorted to using python to check whether the file is open and only sending features to the writer if it is not open (even this is not always foolproof)

Vote for the idea here

https://knowledge.safe.com/content/idea/73898/check-writer-accessibility-when-a-workspace-is-sta.html


erik_jan
Contributor
Forum|alt.badge.img+23
  • Contributor
  • July 21, 2020

I think this can be done, using the FeatureWriter transformer instead of actual writer.

If you connect a Logger transformer to the FeatureWriter summary output, it should not cause the workspace to stop, but it will write the summary information to the log file.

Hope this helps.

 


carmijo
Supporter
Forum|alt.badge.img+11
  • Supporter
  • February 28, 2024

@erik_jan i’m not seeing the same result. I have a logger connected to the summary output of a feature writer but no features are making it to the logger transformer. The workspace is failing because the excel file is open (testing).