Police have halted their investigation into a theft from the late Aretha Franklin as prosecutors lack evidence to move the case on.