LAE

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: JimmyT

I have an x-Ref join that stopped with the error "Error processing data: (stdlib) Bad allocation". What does that mean?

I have some date criteria which i have filtered to 3 outputs from a single source (10mil records). the number doesn't add up to the same amount as the input. *they are meant to be mutually exclusive. So i used the X-ref to determine where the overlap records are.

to test them, i created an X-ref join amongst the 3 outputs to find out records that aren't mutually exclusive.

All x-ref join used gave an error. What error is that?

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: rboccuzzi

I don't think you have given me enough information to help you, unfortunately. If you could provide data samples and a graph, that would be helpful. Otherwise, I am guessing that you have join criteria that is not appropriate to your data-sets, possibly. Is there a lot of duplicates on both sides of the joins? This sometimes can cause memory exhaustion, as the Cartesian product of the two sets is determined.

If you check out this thread, it tells you how to easily zip up for us one of the join nodes with some data, so we can see what it happening, if that is possible. If not, maybe you can provide the x-ref without any real data, but just a couple of rows of example data, that has been obfuscated.

Cheers
Rich