That's the problem, as most of the time the cubes process successfully, especially when ran manually.

It would be great if SSAS has a debug mode that captures the exact reason why the cube processing fails to a file, as the schedules are late at night, and processing only occasionally fails.