Hello Experts,
I have built one workflow with around 5 input files but linking all 6 output sheets into one file, but I receive this error for few outputs like below screenshot.
Does anybody know how to correct this?
Gelöst! Gehe zu Lösung.
This usually means that you're trying to write multiple data streams to the same file at the same time, i.e. multiple sheets to the same excel file.
While the Output Data tool is busy writing to one sheet, the file is locked, so if another part of the workflow is trying to write to another sheet in the same file at the same time, it creates this error.
The way to solve it is to use Block Until Done Tools to make sure that the write process for one sheet is complete before another one starts. Block Until Done is in the Developer Tool Palette.
Hi David
I am already using block until done just before each output tool but still have this error pop up, I cannot put block until done tool in the beginning as the workflow flows from different inputs and flows separately.
I've tried this too, same error!
Hi @AjaySetty
You can remove the Block Until Done Tools in your workflow, they won't have any effect. You should look at the example of how the BUD tool works and also the example I provided in my previous post.
I would put BUD tools in 2 places in your workflow to solve the problem, shown below.
The 2nd one (on the right) would be 2 BUD's cascaded so that you can split one input to 4 outputs, like this:
Hi David
Really appreciate your help, now i understand how the BUDs are used.
I did place the BUDs exactly in the way you suggested but still the error occurs again.
Any other way around?
Hi David
Thanks a lot for trying to help me out, I did get help from an solution engineer and it was very simple 'enabling to use AMP Engine' under runtime.
Its solved now.
For me, the output file was open. Close the output file and run. That fixed it 🙂