Skip to main content
Member
Jun 27, 2025 12:13 PM UTC
Solved

Need to reset import validate load step via BR

Hi,

I am trying to load the data from a file into the cube (import validate load steps) via Business Rule and while I am able to load it successfully. I am not sure how to reset it if the job fails in between.

For instance: Data pulled from the file gets failed at validate step due to some transformation rule issue. Now if I trigger the rule again , it will not do anything as import step is already completed. I need it to reset clear the cache from stage and redo the load process again when the business rule is triggered.

Can you please assist? Below is the code being used

 

pranav46Answer
Member
Jun 27, 2025 2:50 PM UTC

can you try this?

Dim objLoadTransformProcessInfo As LoadTransformProcessInfo = BRApi.Import.Process.ClearStageData(si, wfClusterPk, sourceId)

3 replies

pranav46Answer
Member
Jun 27, 2025 2:50 PM UTC

can you try this?

Dim objLoadTransformProcessInfo As LoadTransformProcessInfo = BRApi.Import.Process.ClearStageData(si, wfClusterPk, sourceId)

Member
Jun 27, 2025 4:13 PM UTC

Hi pranav46​ It works.

Thank you so much

Member
Aug 25, 2026 6:21 PM UTC

​@HoneyGulati  looking for the same function. :)