Skip to main content

Notifications

Finance | Project Operations, Human Resources, ...
Answered

High volume inserts

Posted on by 339

Hello,

at our client we create a high volume of sales/purchase (+10k/hr sometimes) order pairs using a batch job running with 8 threads on four AOSes.

Not all the time, but occasionally we see this error (either purchLine or salesLine) :

Cannot create a record in Order lines (SalesLine). Sales order: SO000012477, DTNPROC. The record already exists. Our orders have mostly one line, sometimes a few more.

We believe that this is an error with the TransIdIdx and the InventTransId. Two processes creating two different orders at pretty much the same time and one of them is failing

because the inventTransId has already been used. If we reprocess one of these failed transactions (creation of order pair in a tts), they work, so I don't think there's a problem with the

data that we use.

Is this even possible ? Has someone seen something like this before ? Can two processes pull the same number from a numbersequence if they do that at pretty much the same

time ? This is really high volume, processing data and creating order pairs as fast as D365 can.

We are not manually pulling the inventTransId from the number sequence, this happens with the insert.

Best regards

Frank

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: High volume inserts

    Good morning Frank,

    I noticed a couple of similar issues that have been recorded on LCS.

    Please see: fix.lcs.dynamics.com/.../Results

    The specific error you mentioned is, however, not listed there (or I overlooked it).

    Based on the data volume / speed that you operate at, I would recommend getting the MS support directly involved.

    Best regards,

    Ludwig

  • Verified answer
    Mea_ Profile Picture
    Mea_ 60,278 on at
    RE: High volume inserts

    There is not much you can do, check that number seq is no continuous and try to enable pre allocation, this way each session will get a pull of  numbers and you will reduce chance of overlap. 

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Complete!

🔔 Be sure to subscribe to the new forums you are interested in to stay up to date! 🔔

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,101 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 229,908 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans