After the customer PDM upgraded 2017SP5.0 from 2016, there was a situation in which the data was directly destroyed by the SQL card, and it was hoped to seek technical strongman.
This as question is not giving enough information.
What was deleted and how exactly?
In case of deadlock you should create deadlock trace and catch which computer or which procedure is causing this. (You can use sql server tracer(Microsoft sql server management -> tools menu).
Hi,Eero Luotio ,My operation is to completely destroy the deleted data in the PDM Recycle Bin. When the PDM admin destroys the deleted data, the SQL is deadlocked. The PDM client is basically inoperable, directly unresponsive, only the destroy operation. After the end, the operation under the PDM client will return to normal;Under the PDM2016 version, there are not many deadlocks in this kind of operation, but in the PDM2017 version, deadlocks often appear.
As far as I know this is "feature". I have opened myself multiple requests to Solidworks related to this and there has not been solution to stop deadlocks. I have solved this by creating API program to delete them automatically outside working hours.
I'm also using PDM 2017 SP5 and destroy operation indeed causes deadlocks and makes system unusable for others. As far as I know there are no fix for this, as asked about it ~2months ago.
Hi,Eero Luotio，I am interested in the way you use the API to destroy deleted files.，Is the program developed by you, can you share it, if you can't share, can you share the API interfaces you call? I really need your help, thank you!
PDM API Help:
Destroy Deleted Files in Vault Example (C#) Destroy Deleted Files in Vault Example (C#)
2017 SOLIDWORKS API Help - Destroy Deleted Files in Vault Example (VB.NET) yep as vb.net or c#. If you don't have huge amount of deleted files this can be used pretty easily without much modifications.
If you have lots of deleted files like us +500 000 then you need to do modifications to traverse folders where are the most of deleted files and example delete them by 6 hours cycles from oldest to newest.
I can get 10 000-15 000 files deleted in 12hrs with those modifications.
I always delete the destroyed files late in the evening when nobody works anymore. Or at the weekend...
Late night deletion or weekend deletion is really time consuming. It would be great if there is a program that can be deleted automatically.
Very cool code. I'm sure there are several customers that'll make good use of it.
This has been an issue for a few releases not and it's a bit frustrating. Not sure why it does that but...
This does not appear to be fixed in 2019 either.
Retrieving data ...