I tried putting sorts on both upstream source but I still have the same issue. If it is not the error then what is because the dataflow ends with saying "an error occured during exectution" and no records were written. Most of the time I can spot the error; but in this case I'm not sure what the error is then. Is there a way to change the result output to show only errors and not other information?

As 4,294,967,295 is 2 power 32 minus 1, I guess you are having some kind of overflow. Try using partitions, based on the key field you have selected for ordering. This way you can slice the process and get better performance.

What are the estimated record counts flowing into the Join operator in question? Also, you can try placing to buffer operators, one on each input, to the join and see if that changes the dataflow behavior.