The Netezza Community: ERROR message ...

1 Replies Last post: Jan 28, 2010 5:00 AM by James Karioki

ravi

17 posts since
Sep 14, 2009

Currently Being Moderated

ERROR message

Hi All,

I have such error message while working with simple query in Netezza.

Error: ERROR: Memory exhausted in AllocSetAlloc() (State:HY000, Native Code: 2D)

Is anyone faced this error ?

Please if anyone can help in this.

Thanks in advance.

Ravi

Tags: twinfin, netezza, stored, twin, procedures, queries, active

James Karioki

6 posts since
Apr 7, 2009

Currently Being Moderated

1. Jan 28, 2010 5:00 AM

in response to: ravi

Re: ERROR message

Try setting the session variable:

set enable_projectexpr=0;

Then re-run the query in the same session to see if that works.

James.

Report Abuse