Workflow freezing 67% through output

[mandaa838]

Hello - I have been successfully running a workflow for awhile now, but now, everytime I run it, it freezes 67% through the final output tool. I have tried deleting the tool and reconfiguring it which worked a few times but now I am back to the same problem. Is there a workaround to this?

[mbarone]

What file type are you outputting to?  Have you confirmed it is indeed the output tool causing the hold up (I know it probably looks like it is, but have you enabled the performance profiling to make sure)?  Have any screenshots you can share (your output tool configuration and/or the canvas when it seems to be stuck)?

[Luke_C]

Hi @mandaa838 

What version are you using and what type of file are you outputting? This is a longshot, but prior to 2020.2 there was an issue (DE18410) where excel outputs would freeze if you were skipping the field names and preserving formatting. I came across this same behavior due to that bug. 

[mandaa838]

Hi! thanks for the response. I am outputting to an xlsx file. How do you enable performance profiling?

Here is where the workflow is freezing:

And here is the output tool configuration:

Thanks!!

[mandaa838]

I was skipping field names and preserving formatting! I tried to remove the preserve formatting but am still having the same issue. I am using v2020.

Thanks!

[Luke_C]

@mandaa838 do you know which v2020? If it is what I mentioned if I recall correctly I got it to work by not skipping field names. I handled the extra row of data in my excel template by deleting it with a macro on open (not ideal). To troubleshoot try adding a totally new output tool and configure it the same way, minus the skip field names option and see if it works. 

[mbarone]

There's a checkbox for performance profiling on the Runtime tab in Canvas configuration.

What is the formula you're using for "PATH"?, and how many unique paths are there?

[mandaa838]

Hi! unchecking the preserve formatting and skip headers allowed me to export. I will have to build a macro to add the formatting.

thanks!

[mandaa838]

I unchecked the preserve formatting and skip headers in the output tool and this allows me to export... I will have to deal with this for now and update the formatting seperately. Thanks for your help!

[Luke_C]

Great, glad it worked! It's a pesky bug, if you're able to upgrade your version I believe it's resolved now.