A Multiscale Study on The Onset of Sand Production