Yeah started that process. Its all over the place, if there is not systematic solution I might have to start from scratch and puzzle all the made pieces back together. 
Seem like the entire referential integrity of the project has gone bust. Scary as hell .