Hi community,
after an eternity I finally build a PowerScript to repair the wrong permissions.
The issue itself was trivial and caused by moving the Vault Server to a new Server instance. For previous files, the permissions weren´t set correctly and only new files used the correct Vault AppPool permission.
So the permissions are correct now I can can cleanup the orphaned files. But I run into a new problem. Some years ago we had a few minor stability problems with the server, so in rare cases file uploads failed. I can literally tell the 3 days in 2019 where File Upload didn´t work as expected. In this case, users simple reuploaded the files and everything was fine.
But the previous invalid file uploads now lead to problems when I want to cleanup this orphaned files automatically. The files appear in the "Files" database table, but do not physically exist in the file vault. When I want to remove the files, I get an "DoPhysicalFiles [..] (500) Internal Server Error" error message.
A possible fix is to rebuild the missing Vault folder with a fake file. But doing this for a unknown amount of files (I expect 50..) is a bit painful when doing it manually.
Does anyone know a simple way to check, if a file listed in the "File" database exists physically in the File Vault? I know that previous users have build something like this already and I would be happy if I don´t have to start from the scratch :D
Thanks for any help!
Angela
