Issue in Multithreaded Batch Job – SQL Duplicate Key Exception in InventSum

(5) Share

Report

Posted on by CU10030917-0

105

We are facing an issue with a custom multithreaded batch job in D365FO that processes data and creates transfer/movement journals.

The error occurs during standard journal posting logic:
Violation of PRIMARY KEY constraint 'I_7874ITEMDIMIDX'. Cannot insert duplicate key in object 'dbo.INVENTSUM'.

The problem occurs when multiple threads try to update the InventSum table simultaneously, leading to the error.
Exception handling is in place, including Exception::DuplicateKeyException, but the error is not being caught. Some records remain unprocessed due to this failure.

Has anyone encountered a similar issue with InventSum in multithreaded processing? What best practices can be followed to handle concurrency on InventSum and prevent duplicate key conflicts in a multi-threaded batch job?

Looking forward to insights from the community. Thanks in advance!

Categories:

Dynamics 365 Finance

I have the same question (0)

All responses (5)

Answers (0)

Mohamed Amine Mahmoudi 26,434 Super User 2025 Season 2 on at

Like (1)

Report

Hi @CU10030917-0,

Can you plase share with us the x++ code ?

Best regards,

Mohamed Amine MAHMOUDI

Was this reply helpful? Yes No
Martin Dráb 237,965 Most Valuable Professional on at

Like (1)

Report

You shouldn't be getting DuplicateKeyException on update, because you shouldn't be updating the primary key. I think it's either not an update or you're doing a wrong thing.

Was this reply helpful? Yes No
CU10030917-0 105 on at

Like (0)

Report

Hi @Martin Dráb & @Mohamed Amine Mahmoudi,

Thank you for the reply.

We are using the standard class to post movement journals, and the error occurs within the posting logic.

Each thread in multithread creates and posts single movement journal.

Primary key of InventSum is ItemId and InventDim. There could be a case where two threads have same itemId & InventDim and are trying to post journals same time, resulting in this error.

Please share your insights.

Thanks!

Was this reply helpful? Yes No
Martin Dráb 237,965 Most Valuable Professional on at

Like (0)

Report

As you see knowing just that the error occurs within the posting logic isn't detailed enough. You can't address the problem because you don't know what the problem actually is. You next step should be finding where exactly the exception gets thrown.

Was this reply helpful? Yes No
Anton Venter 20,346 Super User 2025 Season 2 on at

Like (0)

Report

You need to share more information about the problem so that the community can help you.

Was this reply helpful? Yes No