Solution:
1. Make sure that the source archive set was taken at the same peoletools version as the target db that you are trying to migrate to.
2. Go to the workflow tab, double click on the current status the csr is in. Make sure that the csr could be migrating to the target db at this point of the workflow status.