We had a similar issue processing an individual dimension.

Setting the data source to only allow one connection at a time allowed us to see the actual problem in more detail....