I will edit this post with better information once I get in the office, but yesterday was a roller coaster of a day with multiple assistance requests from my engineers and I had barely put together a description for my VAR. I have no access to the login screen here at my job, so I have to use my phone or my PC at home with no records at hand of what happened in our vault.
I suspect a network issue (or a PDM operation canceled or somehow aborted in the middle of a file upload) as one user is working at the factory shop floor in a different building.
I checked 2 PDM clients local LOG via PDM administration and the ARCHIVE server log, then the file history and the archive version folder xml.
We had user A (CAD user) and user B (non CAD user) working in different buildings.
My guess is that User A tried to check in a drawing and somehow the file failed to upload into the archive server, but the operation was recorder into the database as version 40.
User B tried to retrieve the file latest version (he apparently had not previous versions in his local cache) via explorer to check it out, fill the datacard and move it to our approved state. It failed with a dialog “cannot find ID xxxxxx on the server…” came out, at this point user B called user A about what button to push and somehow he got “some version” from the archive server since the latest version 40 was not available. He filled the datacard and checked in the version 41 then moved it to an approved state.
The file history looks like
Version 41 multiple transitions to approval
Version 41 check in
Version 40 latest check in at 10:11
Version 39 check in
Version 38 check in
Archive server xml
version 40=41 datacard edits
version 38=39
Problem is file version 38 exists while version 40 does not exist into the archive server.
This happened one week ago and the version 40 is not in our backups, so it was unlikely created back then too.
One week later the file is moved to a revision and the drawing file failed because there is no physical version inside the archive server.
LOG files gets interesting for USER A
During version 40 check in the local log shows an error
10:11:14 E_EDM_FILE_NOT_LOCKED_BY_YOU catch error 3 (not 100% sure I have to check it again when back at the office)
At the same time the ARCHIVE SERVER LOG registered a failed operation.
The operation was recorded with something like
opRollback version 38 step 0
and a some UUID like string.
Note that USER A does not have a rollback permission (in theory, but he used to have it years ago, not sure if it is important at this point)
LOG for USER B is recording only the failure to get version 40, apparently pushing random buttons on the error dialogs he was able to get the datacard in edit mode, then checked in “something” and moved it to an approved state without a physical file.
He does not open the file with Solidworks so the DB only operation was apparently not 100% aware the physical file was not there.