Archives of the TeradataForum
Message Posted: Fri, 12 Aug 2016 @ 08:49:55 GMT
<-- 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.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 24 Jul 2020|