Control Containers not working for excel file with multiple tabs

[lblaakman]

I have a workflow that outputs 6 tabs on a new excel file daily. I updated the workflow to use the control containers because the workflow was sometimes failing when the tabs were trying to output at the same time. I have tried rearranging the workflow multiple times and have even put the entire workflow for each tab in separate control containers. (I have confirmed that the control container outputs prior to the ones failing have data) All of the workflows I have made run great in designer but when I publish them to the server they will sometimes work, and other times will not due to the multiple tabs being output. Has anyone else ever had this issue with control containers and has found a solution?

Thank you in advance!

[aasmith8116]

Are you chaining the containers to each other or just the tools between containers?

[lblaakman]

I am connecting the control containers to each other.

 

[karenewilkins]

In your screenshot, I  see multiple outputs in each control container. If you're having issues, you might want to put each output into its own control container and then chain them together.

[lblaakman]

I have also tried that and still got access errors.

 

[karenewilkins]

Hmmmm. The only other thing I can think of is to verify your workflow dependencies for all output paths. Before scheduling my workflows, I check to make sure all the workflow dependencies have the UNC path - not just a mapped filepath. This would explain why the workflow operates correctly in Designer, but not in the Gallery/Server.

[bertal34]

@lblaakman What is the error you are getting?  Where are you trying to save the Excel file (network location, sharepoint, etc)?  Can you provide a sample of your workflow so that I can troubleshoot?  With dummie data.