Archives of the TeradataForum

Message Posted: Fri, 12 Aug 2016 @ 08:49:55 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

<-- Anonymously Posted: Thursday, August 11, 2016 19:21 -->

We are on a appliance and recently upgraded to 15.10. One of our query started to fail with

     3710: Insufficient memory to parse this request, during Optimizer phase

I did increase MaxParseTreeSegs from 5000 to 7000 and query was able to run successfully.

The same query failed again today with the same error. I increase MaxParseTreeSegs from 7000 to 9000, it failed again and I increased it to 11000 and the query is still failing with the same error.

What could be causing this issue? When the same query ran at 7000, why is it failing at 11000? Is there something else I need to do?

Experts, please advice.

	<Prev	Next>		<<First	<Prev	Next>	Last>>