Writing multiple outputs to one workbook

I have a workflow with 3 outputs that need to write to one Excel workbook. I have prior experience doing this, where I utilize the Block Until Done tool to allow outputs to write in sequence. However, this is the first time doing this in an upgraded version (2022.3). For some reason I can't get the full workflow to complete to a good end. Is this a known issue with version 2022.3? Any recommended ideas to get around this? Attached is the error message I'm receiving.

image.png

Data Investigation

Accepted answers

alexnajm

Are you using AMP Engine? I would turn it off if you are - Workflow Configuration --> Runtime --> deselect "Use AMP Engine"

All comments

alexnajm

Are you using AMP Engine? I would turn it off if you are - Workflow Configuration --> Runtime --> deselect "Use AMP Engine"

alexnajm

Otherwise yes I would reconfigure it to look something like this:

Writing to Multiple Files Snap.PNG

Jake5

Thank you, Alex! Deselecting AMP Engine did the trick!

alexnajm

Fantastic! Long story short, AMP Engine seems to go too fast for the Block Until Done tools - something that hasn't been properly addressed yet due to the parallel processing nature of AMP Engine.

jdminton

This has also been fixed in the latest patch for 2023.1. I ran into this last week and was able to get it to work without AMP, but after the patch, it works with AMP as well.

Quick Links

This months top contributors

hhaigh1 280

FláviaB 262

JORGE4900 235

caltang 177

DanM 167