File failed to add, but still in the database

SOLIDWORKS SolidWorks PDM
1

A pdm user tried to add a pdf to our vault and probably the operation failed midway leaving the file not uploade, but with a document id locked in the database.

This night I will reboot the pdm server to see if the record is purged, but looking for other advices.

The file is not physically in the archive, only has a documentid and its deleted flag is 0, shared flag is 1 and there is a recorded locked time stamp from the pc vault view that had the issue when trying to uploading the pdf.

Since the vault does not allow file name duplication and the file is not deleted in the database, it is not possible to add the file again and the error cannot find the item in the database pops up.

2

You can’t see the file in the “private state” when logged in as admin? Check the “Document in Projects” table along with “Projects” to see where the document is located in the vault.

Are you allowing users to use the “Paste as shared” option?

3

logged as admin nothing is visible. the file is not in the path the db has recorded.

my users are not allowed to paste as shared. I do not know why the flag shared sas set to 1.

4

I think you’ll need a var to help troubleshoot your DB. That documentid could be located in several tables and will need to be scrubbed from them.