Finance | Project Operations, Human Resources, ...

Multiple query Updating issues

(1) Share

Report

Posted on by BP-09051132-0

Here I am updating multiple queries in TmpTable for the Ganarter SRS report. When I was trying to generate the report, I got this error, so can you please tell me how to solve it?

Error Is /update conflict occurred due to another user process deleting the record or changing one or more fields in the record./

All responses (3)

Answers (0)

Suggested answer

Bharani Preetham Pe... 3,624 Moderator on at

Like (0)

Report

Multiple query Updating issues

Tell me one thing. If report is running in a legal entity, why do you need to update temp table in different legal entity via cross company?

As Andre suggested, selectforupdate is not required.

A good approach while updating data is to use changecompany instead of crosscompany.
André Arnaud de Cal... 294,261 Super User 2025 Season 1 on at

Like (0)

Report

Multiple query Updating issues

Hi,

On which select statement do you get the error? The first one or the second? What is your report about? I do see a crosscompany statement in the select query. Do you really have data from different legal entities? If so, you can probaby better make this table no dependent on the dataareaid, but have an own CompanyId field.

You are joining several tables. Could it be the case that you have multiple records in the purchPrepayTable and PurchReqTable for a single BSInvoiceToPaymentReportTmp record?

When you have a forUpdate statement in the select query, the separate call before the update() statement is obsolete.
Suggested answer

Waed Ayyad 8,287 Super User 2025 Season 1 on at

Like (1)

Report

Multiple query Updating issues

Hi,

Try to add YourTmpTable.reread(); statement after the ttsBegin; statement, and why you added YourTmpTable .selectforUpdate(true) again?

Thanks,

Waed Ayyad

If this helped, please mark it as "Verified" for others facing the same issue