Maximum Buffer Size of .......exceeded

Follow

Jamie Johnny

• July 06, 2020 13:07

Hi,

 

I am doing a simple x-ref where the left join is 645K and the right join is 28 unique records and am getting the following error.  I seem to get this error when I get up into the 500K or so records on joins.

Maximum Buffer Size of 536870912 exceeded

I have searched the threads but can't seem to find the answer. 

Thanks

 

 

0

• 

  Adrian Williams

  • July 07, 2020 10:22

  Instead of using the X-Ref (Superseded) node in Data360 Aalyze we recommend using the Merge node which provides improved memory management. The automatically defined buffer size may work for you given the small number of records on the Right input. However, if required you can set the BufferSize property in the Optional section of the node's properties.

  https://doc.infogixsaas.com/analyze/Default.htm#e-node-help/Correlation/merge.html

  0

  Comment actions Permalink
• 

  Jamie Johnny

  • July 07, 2020 12:57

  Hi,

   

  Thanks for the reply.  I'll try rebuilding the process using the Merge node and let you know my results.  

   

  Thanks

  0

  Comment actions Permalink

Please sign in to leave a comment.