Skip to main content
June 27, 2025
Solved

Need to reset import validate load step via BR

  • June 27, 2025
  • 2 replies
  • 2 views

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



 

Best answer by pranav46

can you try this?

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

2 replies

pranav46Answer
June 27, 2025

can you try this?

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

June 27, 2025

Hi pranav46​ It works.

Thank you so much