Hi ewalk
If the shaft is failing inside the bearing housing I assume it is circular in section there what dia is it?
What fit do you have between bearing and shaft?
How long is the shaft between bearings and what distance is the sprocket from the bearing in which the failure occurs?
If I imagine your set up correctly you have a hexagonal shaft with a sprocket on it and it is positioned close to the bearing, were the failure occurs? is the shaft circular in section were the sprocket is attached?
Lots of questions I know but we need this information to try and help.
If you imagine the set up as a simply supported beam the maximum bending moment would occur under the sprocket and in addition if the sprocket is close to one bearing, that bearing via the shaft will have to react the majority of
the bending force on the shaft whilst the one further away
see's very little of the bending force.
By way of example imagine a simply supported 2m long beam with 100N sat in the middle, the reactions at each end of the bearing would be 50N, now move the 100N to within 0.25m of one of the bearings and the reaction increases in the bearing close to the sprocket from 50N to 87.5N and the bearing further away falls to 12.5N.
Now in addition you have the torque that your transmitting with the sprocket and shaft which increases the stress in the shaft due to the shearing reaction of the shaft.
You could try moving the sprocket out towards the shaft centre, this will even out the bearing reactions but the shaft will see more bending stress.
If you can give the info I request I or others might be able to help you further.
Regards
desertfox