After converting a large 45 file solution I noticed that many of the External Data Sources were missing so I corrected them in each file using Manage External Data Sources.
I then noticed that with my files open, many of them had truncated Window Tittles.
My naming Standard is S.A. Attendance ect, now many have been truncated to just S.A
The HUGE problem is that many of the Relationships are broken. When I open some files they bring up the password dialog to open related files that are already open. If I enter the password and hit OK it says the file is in use (because it is already open) If I cancel the open box and look at the relationships the Table Occurrence for that file is there but it is grayed out and say's file missing.
To make this even weirder, I can go to another user workstation and look at the same Table Occurrence in the same file on the network and it is perfectly fine. What the heck is going on?
So far the only thing that fixes it is to completely delete the External Data Reference and Table Occurrence and then recreate them. That is virtually impossible in a solution as large as mine as each one is referenced in hundreds of scripts so they would need to be repaired. I have 2 or 3 broken relationships in each of the 45 files so this is a daunting problem.
FYI, I read in the conversion manual that file names should no longer contain periods so I removed them and reconverted but it made no difference.
Any help would be hugely appreciated as I can find nothing in google..