Skip to main content
  • EN

FME(R) 2023.1.1.0 (20230928 - Build 23631 - WIN64) FME Form

Hello,

I have a set of QAQC workspaces that I’m trying to run in sequence with workspace runners. I have a parent workspace that, using scripted parameters, generates a bunch of output file names where I’ll write the results of the various workspaces, and runs workspace 1, then workspace 2 then workspace 3. I only want to run workspace 3 if my tests ‘Pass’ in workspace 2. So I write out a CSV file called _qaqc_status.csv in workspace 2 with ‘Pass’ or ‘Fail’ as the only attribute; the file location is in with the data and is variable.

The problem comes when trying to read the parameterized file name ($(QAQC_STATUS_CSV)) with a FeatureReader; I get  the following error message

   Worker 27572 > CSV reader: Failed to open file '' for reading. Etc, etc.

and my CSV doesn’t show up on the output ports. If I hard code the FeatureReader dataset to an existing csv it works fine.

Any help is appreciated, or even a workaround suggestion. Thanks!

Perhaps a workaround, but more so just as a test, have you tried creating a new attribute on the data and giving it the value of the parameter before it goes to the FeatureReader? That way the FeatureReader is using the attribute’s value instead of the parameter’s value.

Thanks @liamfez . It seems the solution is that once you set the Dataset (attribute or user param) and hit OK

FME then prompts you for a dataset to generate the output ports…

Navigating to my _qaqc_status.csv file on the network and hitting OK was enough to make it work. Subsequent runs of the workspaces used the parameterized csv file.

 

Cheers.

Reply


Community Stats

30,697
Posts
116,201
Replies
38,288
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.