Finance | Project Operations, Human Resources, ...

Cannot edit a record in Production orders (ProdTable).

(1) Share

Report

Posted on by Shooowtek

845

Hello,

When inserting a row in report as finished, I get the following error:
/Cannot edit a record in Production orders (ProdTable). An update conflict occurred due to another user process deleting the record or changing one or more fields in the record/.

I reanalyzed the code and the modification. I came to the place where the extended InventTrans.update(). In the extension of this method, before calling next(), I entered a custom method that run prodTable.update(). Everything works until super() is called in the ProdTable.update method - then I get this error. Can anyone suggest how to fix this?

error massage in ProdTable.update():

InventTrans.update() extension:

Excerpt from the method in which the prodTable.update() is run:

I have the same question (0)

All responses (3)

Answers (0)

Sort by

Suggested answer

Vignesh.A 203 on at

Like (0)

Report
Copy link

Link copied!

Mostly this error will occur during multiple updates happen to the record.

If any custom update code is written then before or after the custom code there might be a standard code updating the same record. Simply try is to do a ProdTable.reread() after you update the record to bring the current updated values to the buffer so the next update wont cause conflicts.

Was this reply helpful? Yes No
Bharani Preetham Pe... 3,634 Moderator on at

Like (0)

Report
Copy link

Link copied!

If you are getting such error means, firstly it is not right to place the code at such a place. Secondly can you tell me if it is a standard report you are working?

Was this reply helpful? Yes No
André Arnaud de Cal... 304,932 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi Shooowtek,

I'm not able to check what exact methods you shared and in what sequence what method is called. It looks like you are updating the production order in another method while being in the same transaction scope. What happens now is that the application retrieved a prodTable record with a specific record version ID. When you update the record in your extension, it will get another record version. When the original method will then perform the update action, there is a mismatch between the retrieved version of the record and the latest version, resulting in the error you have now. You should refactor the coding to set your custom field values in the same transaction scope and let the standard coding call the final update action.

Was this reply helpful? Yes No