Alteryx Gallery timing out on Redshift Queries

Hello,

I am running queries using applications loaded to an Alteryx Gallery, and if the queries get over a certain size the server times out and closes the connection.

What are the possible configurations causing this? I know it's not the VM cause I've run these queries outside of the Gallery. What configuration of the Gallery is limiting the processing power?

Cheers!

Gallery

Developer Tools

Database Connection

Accepted answers

bryanbumgardner

Hello everyone!

The issue was that the database was almost full and there was no room in the memory for expanded queries. When the database size was increased, the issue disappeared.

Thank you!

All comments

Garrett

Not an Alteryx Gallery configuration, but rather a machine configuration: have you messed around with Firewall Timeout (specifically TCP\IP timeout settings)? Solved similar issue for me. See: https://docs.aws.amazon.com/redshift/latest/mgmt/connecting-firewall-guidance.html

paul_houghton

Are you using the InDB tools? That might help improve the query time and prevent the timeout issues

bryanbumgardner

So to expand on my issue a bit:

I'm using in-DB tools in this application. What's curious is that the program will run when given a small range of data to pull. However, when you increase that range, the tool will fail after a 2-hour run time.

When I check the Redshift query console, it shows that the query aborted after 22 minutes, which makes no sense given that the application ran for nearly two hours.

I have increased the memory allotment in the Designer installed on the Server, with no apparent effect. I'm going to now look into the Server Settings for anything I can improve.

Any thoughts here, folks? Thanks in advance!

bryanbumgardner

I have lots of Browse tools in this workflow... That surely couldn't be causing this break, could it?

bryanbumgardner

Hello everyone!

The issue was that the database was almost full and there was no room in the memory for expanded queries. When the database size was increased, the issue disappeared.

Thank you!

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703