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?
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.
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.
Here's an example
I've tried this too, same error!
For me, the output file was open. Close the output file and run. That fixed it 🙂
It's pretty simple. For me, I had the output file opened and it gave me this error. When I closed it and ran the workflow, it ran just fine.
