Data360 Analyze

 View Only
  • 1.  Maximum Buffer Size of .......exceeded

    Posted 07-06-2020 06:08

    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

     

     



  • 2.  RE: Maximum Buffer Size of .......exceeded

    Employee
    Posted 07-07-2020 03:23

    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



  • 3.  RE: Maximum Buffer Size of .......exceeded

    Posted 07-07-2020 05:58

    Hi,

     

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

     

    Thanks