Is there a way to atomically set a NextValue counter if the current value is lower than some specified value? This could also take the form of GetNextSequence(seqName, minValue). There doesn’t seem to be a way to do this atomically, so any attempt to do this within a BPM creates a race condition.

How about this? var nv = new NextValue(Db); int foo; while ((foo = nv.GetNextSequence("FOO")) < MIN) { Console.WriteLine(foo); } GetNextSequence() will get the next value and rev the counter so no one else can get the same value. I think that satisfies your atomic requirements. As far as the …

I guess you mean Automatically? I think your solution is related to this post. [image] Auto Numbering - Customer ID Epicor ERP 10 It has been fun seeing the document that i published YEARS ago roll around the internet on how to auto-assign customer/supplier/project ID. I…

I mean atomically. I’d like to write something like this, but it contains a potential race condition: var nv = new NextValue(Db); var foo = nv.GetNextSequence("FOO"); if(foo < MIN) { foo = MIN; NextValue.SetSequenceCurrentValue(Db, "FOO", foo); } I was hoping there was some undocumented me…

I think @josecgomez may have originally shared this below code: Erp.Internal.Lib.CompanySequence.GetNextCompanySeq(CompanyID, SequenceName) Erp.Internal.Lib.SetCurrentCompanySequence(CompanyID, SequenceName, currentValue)

Sorry, I don’t see how that addresses my question. I’m looking for a way to atomically set the current value if the current value is lower than some specified value. The goal is to avoid the need to take the system offline to bump a counter.

You don’t have to take anything offline - you can call either of those 2 methods at any time.

But you cannot call one and then conditionally call the other atomically. (Unless there’s something I don’t know about the framework, like all BPMs run in a single thread.)

Check out transactionscope. https://blog.goyello.com/2016/11/30/let-net-framework-care-about-transactions-handling-for-you-by-implementing-ienlistmentnotification/ More Epicor BPM C# code development tips | Luke McAvoy More Epicor BPM coding tips for adding, updating, deleting records…

That makes sense. I wonder how long it will take to increment a million times…

Doing just about anything a million times will be relatively slow, especially if it includes database access. If it’s a one time hit it’s likely acceptable. If your use case includes the sequence getting out of sync by a million regularly you will want to look at GetSequenceBlock("foo", 1000000) whi…

My use case is that we have counters that we might want to bump up to the next million once a year or something like that. My original idea was to put the minimum values in the same BPM that uses the counter values, because that’s where I expect someone to go looking for them. But since bumping the …

Atomically setting NextValue counter?

Epicor ERP 10

TobyLai (Toby Lai) December 18, 2019, 2:53am 2

I guess you mean Automatically?

I think your solution is related to this post.

Topic		Replies	Views
Atomically updating UD01 counters Epicor ERP 10 bpm	4	988	August 22, 2019
Auto Numbering - Customer ID Epicor ERP 10	104	39131	December 15, 2025
Check if a NextValue sequence exists? Epicor ERP 10 e10	0	772	February 5, 2020
NextValue API and REST Epicor ERP 10 e10	1	983	December 12, 2020
Reset Sequence Number Monthly and Automatically Epicor ERP 10 epicor , bpm	0	838	April 5, 2022

Atomically setting NextValue counter?

Related topics