After 3 awful day's of confusion the solution has finally come. After going through hundreds of posts in this forum I came accross the simple solution. To change my site links relative to document instead of site. Then I re ran the data assist wizard and it gave me
virtual was the problem all along. Everything is now working fine.
Thanks for the help Eric