4,971
Hi All,
I am getting this error message when i try to update the purchase order line.
"An update conflict occurred due to another user process deleting the record or changing one or more fields in the record."
I tried reread, RecVersion method. But not working.
Please help me to solve this issue.
Once i got this error, It is coming continuously.
Thanks in advance,
Hari
*This post is locked for comments
Hi Hari,
Following error you get if you have following scenario,
Static void NIT_update1(Args _args)
{
NIT_SKUTable SKUTable1;
NIT_SKUTable SKUTable2;
ttsBegin;
select forupdate SKUTable1 where SKUTable1.SKUID == 1;
//do something
ttsBegin;
select forupdate SKUTable2 where SKUTable2.SKUID == 1;
SKUTable2.Qty = 50;
SKUTable2.update();
// do something more
ttsCommit;
// do something more and more
SKUTable1.Qty = 60;
SKUTable1.update();
ttsCommit;
}
to avoid error you need to write following code
Static void NIT_update2(Args _args)
{
NIT_SKUTable SKUTable1;
NIT_SKUTable SKUTable2;
ttsBegin;
//do something
ttsBegin;
select forupdate SKUTable2 where SKUTable2.SKUID == 1;
SKUTable2.Qty = 50;
SKUTable2.update();
// do something more
ttsCommit;
// do something more and more
select forupdate SKUTable1 where SKUTable1.SKUID == 1;
SKUTable1.Qty = 60;
SKUTable1.update();
ttsCommit;
}
So moral of the story is,
when implementing logic in SQL transaction, create the transaction with atomicity
that is, Select the record for update just before calling table update() method.
Please try to investigate your customization, may be you will also have same scenario.
Please verify.
Hi,
I think it may be because of two many users are accessing the same record. if you lock the record from updation from other users it will resolve the issue.
May be this helps you. let me know if you are writing the code.
Thanks
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,214
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (