Re-design and re-code "Close WO/WR" process
"Close WO/WR" process has been coded long time ago with a SQL that is unefficient and many times produces errors or deadlocks. After discussing this with many BPs, we have agreed that a complete analysis with re-desing and re-coding from scratch should be performed in this process (considering not only the closing of an individual WO/WR but also the batch closing of many of them and also the AutoClose WFR).
Juan Pablo Sapia
shared this idea
-
Stephen
commented
we constantly struggle with deadlocks and there are many hours exhausted with rectification. There needs to be greater parameter based complete and close rules down to problem types, trades, craftsperson's and building to allow better management through batched process
-
Fouad
commented
we are facing this issue with all of our clients . fixing it is very important to keep the reputation of ARCHIBUS by Eptura