LAE

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

Originally posted by: cristi.boizas

Hi,

So I am trying to join 2 data sets ( first input: 1 record , second input: 12 mil records ) . The X-Ref I am trying to use in order to get left orphans and matches is failing with no error message.
I've tried ctrl-right click on it but still no error message.
I opened the X-REF node at the problem is on the Join node ( sorts and bypass are activated ) . This one, again contains no error message.
This is happening when executing both from LAE(brg) and using the batch manager( brx ) .

Another thing, I tried with a smaller set of data on the second pin ( around 200 records ) and it worked.

Can you please provide any ideas to why this is happening ?

Thanks,

Cristi.

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

Originally posted by: awilliams1024

Hi Christi,

you may be able to get some additional information on the error if you enable debug logging. This is not available at the X-Ref node's top level but if you open the node and then open the Join node properties you can access the 'LogLevel' property on the Logistics tab. Setting this to '0' will increase the logging level.

Regards,
Adrian

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

Originally posted by: cristi.boizas

Thanks,

In the meantime I managed to replace all the xref nodes.