Thanks for the precious reply,
The thing is we want to automate the whole ETL process without having any errors during the process. At the end of the ETL process, a file gets generated mentioning all the changes applied with WF PoV (Time,Scenario, ProfileName), all the bypassed rows and values and the username/Time of Execution. The audit part is not a main concern for the moment.
Can I achieve this using the 'ExecuteFileHarvestBatch()' instead of 'BRApi.Import.Process.ValidateTransformation/ValidateIntersections' ? If the batch encounters an errors, it will update the transformation rules & then relaunch the batch ?
It's probably doable, but it will require some wrapping. For example, you could trigger the batch from a rule with a Data Management Sequence scheduled to retry (up to 3 times); the event handler will pick up errors, deal with them, then return an error; your Data Manager sequence will just retry, and the second (or third) time it should go through.
It might be possible to do all that within the wrapping Extender rule too, but I'm not sure and unfortunately I don't have time to try it this week.
