I think there is no general case that always contribute to maximum stresses in the tubesheet. Check all cases and find out which is more conservative for your application.

Thanks.

Mukesh