"Cache and Run Worflow" Grayout

Hi,

I am trying to "cache and run" on a tool that I created but the option doesn't seems to be available (image 1). At the beginning, I thought it was because I had a Text Box tool attached to it but I created a new workflow with the text box tool attached to it and to my surprise, the cache and run workflow option is available (image 2). I checked for a solution but I couldn't find anything that helped.

Can someone help me understand what might be the issue with the workflow?

Much appreciated.

Error.png

Working Example.png

Workflow.png

Workflow

Accepted answers

All comments

alexnajm

Based on your screenshot, it looks like it may be in a circle which is a limitation: https://knowledge.alteryx.com/index/s/article/What-Can-t-Be-Cached-1583461085678#:~:text=Tools%20with%20multiple%20output%20anchors,anchors)%2C%20can%20be%20cached.

fnkankeu

Thanks for the reply but I don't think it is my case here. My output is not split into 2.

alexnajm

It doesn’t matter about multiple outputs, it matters about your input and output. You seem to have an interface tool connected to it that goes off into another part of the workflow, and and my guess is that it connects later on too. A “circle” then is likely the cause - that’s all I can assume from the screenshots

fnkankeu

As an attachment is a picture of a part of my workflow. I am trying to cache the tool highlighted in red. Can you tell me where you see a circle? I don't see any.

Thanks.

Workflow v2.png

alexnajm

It’s hard to see without the entire workflow but my guess is that there’s a place later on in your workflow that creates a “circle”. Without the workflow though, it’s hard to tell - these are just assumptions from my experience as that’s the only time I find caching greyed out in my workflows.

You can test my theory by trying to cache at the tools afterwards - if they are greyed out too, my theory is correct. Otherwise I would reference the article above and see if any of the other possibilities apply. If not, contact Mission Control and submit a case

alexnajm

Also one workaround if my test fails and you are able to cache at the tools after - you could then bring down a Select tool that doesn’t do anything, but at least gives you a place to can be

fnkankeu

As an attachment the workflow I am trying to run. You won't be able to run it but can you identify what might be the issue?

Thanks

LTF Report-v1.yxwz

alexnajm

You're right - I am not sure what's going on. It looks like it's caused by the Interface tools which is odd - once I deleted them caching was available. What I'd do then is Open Debug under Interface Designer (with some test values), and in the debug workflow you should be able to cache.Debug Workflow (alteryx.com)

Otherwise it may be worth reporting to Mission Control.

fnkankeu

This is what I thought. Thank you very much for your help on this. I will report it to Mission Control.

Thanks

Bren_Spill2

See attached (I think you guys have already covered this, just catching up). Try to cache either of the text inputs in the current setup and they're greyed out. It's because the same Text Box is controlling both inputs which are joining later on in the workflow creating a circle (best guess)

@fnkankeu - Your workflow is one big circle as everything ultimately joins/unions all the way through until the last union tool, at which point you can start caching again (if you activate the last container caching will work)

Cache Test.yxwz

alexnajm

Thanks for the catch @Bren_Spill2 on my initial assumption - this is what happens when you try responding on a weekend 😂

Bren_Spill2

@alexnajm - haha I hear you! Figured your initial assumption had to be spot on

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703