02-03-2023 01:10 PM
Hi,
I have an import step in a workflow profile, using a connector data source.
For the current Scenario/Year there is no data. This is causing an error when I run Load and Transform.
I know I can manually set the step to "Completed" using the complete workflow button, but is there a way to set the import step so that the Load and Transform does no fail in the first place when there is no data?
Thank you
02-03-2023 05:33 PM
You can set the import step to Optional on the Workflow Profile. This will allow you to set the step to Complete even if there is no data.
02-03-2023 06:25 PM
By setting the import step to Optional on the workflow profile I can Complete the workflow (using the Complete workflow button), but I still get an error if I run the Load and Transform step. This is an issue because I have a job that goes through all the Base input workflow profiles and run the import. I would like the Load and Transform not to fail so that the job does not fail if there is no data on a workflow profile.
02-06-2023 05:21 PM
Hi Andrea - In a similar situation I coded a single dummy record in the data adapter so there would never be no data. The no data errors made it hard to identify the real data load errors, which was a problem. It would be nice to be able to turn this off. I would submit an enhancement request on IdeaStream.
02-07-2023 04:43 AM
Hi,
You can implement the TransformationEventHandler to capture parser results and throw your own Exception
For example:
objTransformer.Parser.LinesRead
or objTransformer.Parser.LinesRead
I think there is an example for the event handler in GolfStream., You can implement this functionality in event FinalizeParseAndTransform (After)
you can do something like this:
HTH