Skip to main content
Question

Reader aborts reading complete data set, but workbench continues to run. Can I have the workbench fail when this occurs?


Forum|alt.badge.img

I have an FME workbench that runs every 10 minutes that reads from an ESRI Feature class in a SQL database. Once in a blue moon I get the following warnings.

Unable to retrieve feature from table/feature class 'xxx'. This feature, and any other feature from 'xxx' that cannot be read, will be skipped. The error number from ArcObjects is: '-2147154945'

Unable to retrieve feature from table/feature class 'xxx'. Aborting reading from table 'xxx'. The error number from ArcObjects is: '-2147216010'

 

Yet the next run 10 minutes later has no problems.

When this occurs I want the workbench to stop rather than proceeding with the incomplete data set. Is there a way to force a termination when this happens?

7 replies

virtualcitymatt
Celebrity
Forum|alt.badge.img+35

Hmm, not a great solution but you could run a pre-query to fetch the total number of features in the table. Then after the read you can compare the number of the last feature read vs the result from the pre-query. In the case where the numbers are different you can run it into a terminator.


Forum|alt.badge.img

Changed from a Reader to a FeatureReader which gives the <Rejected> output port and then set 'Rejected Feature Handling' to Terminate Translation.

As the error is intermittent, and can't duplicate on demand, will have wait and see if this solved the problem. But I think it should.


mark2atsafe
Safer
Forum|alt.badge.img+44
  • Safer
  • January 7, 2022

There is a parameter called Ignore Failed Readers. If you had this set to No, then that might resolve the problem. Having said that, it defaults to No anyway, so it's unlikely to help, but I thought I'd mention it.

 

image


I am having the exact same issue, reading 5 feature classes, and writing them to another location. Occasionally, one or two of the feature classes will be skipped, but workbench will continue to run/complete.

@mark2atsafe​ -​ I confirmed that I do have the ignore failed readers set to "No". I submitted a case yesterday - https://community.safe.com/s/case/5004Q00002UIXZiQAP/published-job-does-not-fail-when-it-should


Forum|alt.badge.img
  • Author
  • January 12, 2022
londonhb185 wrote:

I am having the exact same issue, reading 5 feature classes, and writing them to another location. Occasionally, one or two of the feature classes will be skipped, but workbench will continue to run/complete.

@mark2atsafe​ -​ I confirmed that I do have the ignore failed readers set to "No". I submitted a case yesterday - https://community.safe.com/s/case/5004Q00002UIXZiQAP/published-job-does-not-fail-when-it-should

I have not had any issues since switching to a Feature Reader Transformer. In fact it hasn't failed yet. Definitely seem differences between it and the Reader.

My impression from the documentation is that 'Ignored Failed Readers' is for when the complete reader fails, say like in an inability to connected. In my case the reader was failing half way through reading the rows and proceeding with only a subset of the data.


arutherford
Contributor
Forum|alt.badge.img+4
  • Contributor
  • September 9, 2024

Was there any update to the case? I’m getting the same error. 

I tried adding the featureReader Transformer and it fails less often. It seems to run fine off of FME desktop, but fails when published to the server. 

In my case it does appear to be a memory issue. Is there any tips to optimize memory when reading in features so it doesn’t skip them?


emmaatsafe
Safer
Forum|alt.badge.img+8
  • Safer
  • September 14, 2024

Hey @arutherford 

If your issue is related to memory, you can try manually removing unnecessary attributes in the Reader Feature Type dialog or use the AttributeManager or AttributeRemover transformers to eliminate them.

Additionally, we have some helpful knowledge articles on enhancing performance - https://support.safe.com/hc/en-us/sections/25407340008973-Performance - that might assist with this issue.

In the future, feel free to create a new thread for any issues you encounter to get better visibility.

Hope this helps!

Emma

 


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