Happens all the time and can be caused by several things. Most common is some sort of misspecification (maybe the mediator isn't that relevant in this particular context). Could also simply be a power issue if the mediating effect is harder to detect (low sample). Or it could be caused by distressors/suppressors, where another variable in your model can "diminish" the indirect effects too