Skip to main content
Question

Multiple readers and writers are out of sync on number of records selected

  • February 7, 2022
  • 1 reply
  • 13 views
P

Hi Guys, any ideas of how to solve this please (I'm a novice so take it easy please,

I have a workbench that has 2 readers and 2 writers, the first part of the process reads and SDE featureclass , manipulates some attributes and writes to another SDE Featureclass - it has a run before and a run after sql for dropping indexes and constraints and recreating indexes and constraints and running a stored procedure. The second part of the process reads the updated featureclass and filters by query like value=1 then writes to a csv file. This all works however the second part does not select the correct number of records - its 6 records short. Its possible due to the before and after sql scripts taking a while to finish and commit. _ I can brake this into 2 workbenches and its all perfect but I'd like to keep them together - is it possible?

 

Thanks

Paulg

 

image

1 reply

ebygomm
Influencer
Forum|alt.badge.img+33
  • ebygommInfluencer
  • Influencer
  • February 7, 2022

I would look at using a FeatureWriter instead of a regular writer to write to the SDE featureclass. When that has completed a feature will exit the summary port which you can use to trigger a featurereader to read the data back in again before writing to csv. I'm presuming you need a value which is generated when you write to the SDE FeatureClass? Otherwise you could just write to the csv in a separate stream.

Reply


Helpful Members This Week

Community Stats

31,182
Posts
118,182
Replies
38,791
Members

Latest FME

Terms & ConditionsCookie settings

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
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.