Skip to main content
  • EN

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

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


Community Stats

30,171
Posts
114,537
Replies
37,835
Members
Terms & ConditionsCookie 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.