When running Master scheduling nightly via a batch job, it keeps failing within minutes with the message:
Blockquote
Cannot delete a record in Net requirements (ReqTrans). An update conflict occurred due to another user process deleting the record or changing one or more fields in the record.
Blockquote
This issue has arisen since we implemented a second site and associated warehouse. To date, we have added additional Site Specific data for the new site (although the data is still inheriting from Default Order settings), and also new Item Coverage data for the new site (This includes a new coverage group)
Deleting the existing planned orders and manually running Master scheduling (Regeneration) for a single product seems to help and allows us to schedule our works orders.
Any ideas?
As a quick update. To work around our problem I have scheduled the ‘Delete plan’ utility before our full MRP batch job. This has worked, to the extent that the MRP batch job now finishes sooner than before the issue. Win, win.
Hi, Paul!
Did you experience any unexpected system/server downtime when this error started occurring?
I believe this error can occur in case there is unfinished scheduling process that can’t be finished. This can happen if, for example, batch server goes dead or system shuts down in the middle of Master scheduling batch job. You can see these jobs in Master planning/Inquiries/Processes/Unfinished scheduling processes
If the Progress is stagnant you can cancel the job, and then you can delete it also.
I assume your Master scheduling is now faster as you are separately deleting the plan before Master planning. Unfiltered Master scheduling first deletes existing plan when using regeneration principle, and obviously this takes no time since the plan has already been deleted.
Filtered Master planning does not delete the previous plan and that is why you were able to plan items individually as a workaround.