community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
SOLVED

This workflow seems to crash Alteryx across different installs (server and desktop tested)

Asteroid

No reason this should fail. Hits 1+ GB of data, but tiny compared to some problems I've worked with. Crashes anytime I look at the data at any tool.  https://www.dropbox.com/s/tybox2qjcn5qhjb/DataIntegrationMetaKagge%20v2.yxzp?dl=0

 

Alteryx
Alteryx

Is there a particular error that you are getting? My laptop runs this workflow in just under 30 seconds. 

 

output.png

Alteryx
Alteryx

Also no issues looking at the data in any of the tools. I am currently running Alteryx 2019.3

 

output 2.png

 

 

Highlighted
Asteroid
Did you try to look at the data in some of the midpoints where there is more data? The upper part has little data and does not crash the system.
Alteryx
Alteryx

Interesting, I was just able to replicate Alteryx closing by clicking on the right anchor of the sort tool. Upon further investigation it looks like the PrivateScoreFullPrecision field is what is causing the issues. When I try to convert it to a fixed decimal I get this: inf is not a valid number

 

 

 

Conversion Error.png

 

@DiganP this is the workflow that we are taking a look at

Alteryx
Alteryx

Found a way to fix it!!! Set the PrivateScoreFullPrecision to a double instead of a float in the beginning of the workflow. 

 

solution.png

 

 

Asteroid

Nice. Thanks @BrandonB. Nice fix even if it leaves the underlying issue in place. Don't imagine I'm likely to have the same problem again.

Alteryx
Alteryx

I will also forward this to folks who can take a closer look at what is going on. Thank you for reporting this!

Asteroid

I can now, sadly, report that changing the requested field to double does nothing. Still crashes when I look at the outcoming data from Tool 25.

Alteryx
Alteryx

The issue is definitely with the PrivateScoreFullPrecision. Tool 25 as you have it configured creates a new field from PrivateScoreFullPrecision and set it as a float. If you change this data type output to a double as well it fixes the issue. 

 

Example.png

Labels