No Data Available in results window after running workflow

I saw a previous question where other users had the same issue. I attempted the suggested actions (updating user settings as mentioned in this question) and it still isn't working. I am on Alteryx 2018.2 and it seems like this only happens on workflows where my data is incoming from a yxdb file or SQL. It doesn't appear to occur when I am bringing in data from another source such as an Excel file. I can't get any data off of the anchors on any tools and the only way I can see data is to add browse tools.

Any explanation for why this is happening?

Workflow

Settings

Help

Accepted answers

angelarovetto

I finally went into user settings and chose to reset to default. That seems to have resolved the issue.

All comments

BenMoss

Can I ask how far you bumped up the memory for the anchor results?

ydmuley

Hello @angelarovetto - You can try the following as posted by one of the users facing the same problem.

"I closed Alteryx after posting this. I then re-opened the small workflow with only 3 records, ran the Workflow and got results in the Results window. I then re-opened my larger workflow, ran it and again was able to see results in the Results window. I am not sure what happened or what was different. It looks like my issue is resolved for now."

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/No-Data-in-Results-Window/m-p/177511

Hope this helps!

angelarovetto

I went into the User Settings, checked the box on the Advanced tab for Override System Settings and that deselected the Memory Limit per Anchor box (which defaulted the limit to 0 kb). That didn't result in any changes. I then went back in and checked the box for memory limit per anchor and bumped it up to 10000 kb. No change.

I also tried limiting the number of input records (from the initial yxdb) to 5 records, just to see what would happen. No change.

cripo7

You can try placing a select tool after your input data and selecting only a few required columns. It worked for me!

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703