Getting out of memory error in model Gallery server

[Pankil]

Hi

We are running WF in model gallery and getting below error

• Error SQLExecute: [Amazon][Amazon Redshift] (30) Error occurred while trying to execute a query: [SQLState HY000] out of memory for query result 

While Same query for same date range and same connections (AWS Production server) running fine in Test and production gallery and in my local machine as well.

We already check running query in IDL it runs fine there as well. 

[fmvizcaino]

Hi @Pankil ,

Tough to say what is going on there.

I`d say to take a look at three different things:

1. Driver version
2. Network issues - check if this server is in a different region compared to the others
3. Server memory - maybe other workflows are running simultaneously or less memory available on this server

Best,

Fernando Vizcaino