+12One of our Dispatchers ran some 15 PMs from PM Batch Scheduler (not Scheduled, but on the fly). This job failed, and we see on the contracts that no PMs are generated.
AFAIK there is a lock on these contract lines somewhere, to avoid multiple PMs being generated at the same time. But where is it? We would like to re-run these ASAP
Best answer by Phil Seifert
Hi Bjørn,
Can you try something like this script below which I used in the past to remove locks still in place for another customer. Perhaps this will work for you.
update pm_sched_dates
set generate_locked_at = null, generate_locked_by = null
where order_id is null
and last_sched_pm_date between '1-April-2020' and '30-April-2020'
+24Hi Bjørn,
Can you try something like this script below which I used in the past to remove locks still in place for another customer. Perhaps this will work for you.
update pm_sched_dates
set generate_locked_at = null, generate_locked_by = null
where order_id is null
and last_sched_pm_date between '1-April-2020' and '30-April-2020'
+12(Never mind)
+24Important to adapt the dates appropriately…. :-)
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.