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./

I have the same question (0)

All responses (3)

Answers (0)

Suggested answer

Waed Ayyad 9,039 Super User 2025 Season 2 on at

Like (1)

Report

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

Was this reply helpful? Yes No
André Arnaud de Cal... 301,231 Super User 2025 Season 2 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Suggested answer

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

Like (0)

Report

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.

Was this reply helpful? Yes No