Home Page for the TeradataForum
 

Archives of the TeradataForum

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


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


Subj:   3710: Insufficient memory to parse this request, during Optimizer phase
 
From:   Anomy Anom

<-- 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>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 27 Dec 2016