Very weird....Im not sure where to go with this.

"So second client has two SS# assigned to his file.   The missing client somehow is combined with another client.   "

If you open the second client file that has 2 SSNs assigned to it, do you see the info of the missing client?