I work at a company that has 4 servers located across the country. There has several files that either a person cannot open up the solidworks file of any version. How do I found out where the file is located?
This query will tell you where the system thinks the file is located (at least the servername)
select filename, archiveservername
from documents d
inner join ArchiveServerStored as1 on d.DocumentID = as1.ArchiveID
inner join ArchiveServers as2 on as2.ArchiveServerID = as1.ArchiveServerID
where d.DocumentID = 440580
If you dont have, or dont want, access to the SQL server, then a glance at the Version tab in Windows Explorer vault view, will tell you a little bit:
This file is replicated to All Servers, while:
this file is missing on Server 2.
I would start troubleshooting with checking that the archive server communication port 3030 is open between all servers.
The automatic replication should take care of this, and if not the "on demand replication" should get the file anyway when trying to access the file.
Either the server-server and/or the client-server cannot communicate, or there is a glitch where the database has registered a new version, but the archive server never actually stored it. (This could happen in 2014 SP0-SP4)
If the file exists on other servers, i'd start with communication issue. Run the test procedure in Replication Settings:
Retrieving data ...