I’ll try to keep this brief - this weekend, MRP stopped working. I looked into it, and discovered that I couldn’t even create/save a job, and the root cause was a SQL DB error: Arithmetic overflow error converting IDENTITY to data type int And the SQL query that was throwing this was an INSERT …

For anyone that stumbles on this or is potentially interested ( @JasonMcD ), after a bit more back and forth with Epicor support and reproducing the issue in our pilot environment, they dug a little deeper and found a problem / development task related to this: The reported scenario has been report…

I pay for support, I’ll file a ticket a the drop of a hat, or even the mere desire to drop a hat. Let them figure out the design vs bug question. In fact, I’d have hit them up before running any SQL commands. Having said that, you’re probably fine. PartDtl isn’t upstream of much, if anything, and t…

To get to 2.4 billion with ~12,000 jobs per run you would have had to run MRP 200,000 times. Even if you ran a full regen every day of the week that would take 547 years. I would also have gone to support before doing anything.

In theory going to support first sounds good, but it was late Sunday evening and we were basically in a near complete down state, since you cannot create a job, an order line, a PO line, etc. while PartDtl table is broken. I guess I’ll create a ticket now so they can at least let me know what they …

That seems like an insanely high number of records. Our Partdtlseq is at 25 million after 11 years.

Thanks for this. I about had a panic attack. We’re almost at 1 billion. Should cross it by the end of next week. [image] So, for us MRP used to process 3.5 million unfirm JobMtl lines once a week. Now it does 600-700k, 5 days a week, after I changed some settings (like Days of Supply past X days)…

@Noffie Did resetting the sequence mess up the order of things in Time Phase? Meaning, what happened to things like existing PO releases (not suggestions)? Do they get resequenced? I don’t know the SQL commands like RESEED. Maybe that’s the magic? Also… this post needs a better title - I actually…

[image] JasonMcD: Did resetting the sequence mess up the order of things in Time Phase? No, it doesn’t touch any existing records in the table. It only resets the next added record to have a PartDtlSeq of 1. For us, that was no problem, because our smallest PartDtlSeq is up at like 1.6 Billi…

[image] aosemwengie1: That seems like an insanely high number of records. Our Partdtlseq is at 25 million after 11 years. What does your MRP results look like? We have about 24,500 jobs created every night by a full regen run, and about 1.1 Million job materials for those jobs. So you can s…

[image] Noffie: Time Phase uses the DueDate on the records for sorting for us Sure, but in the case of a tie, well, I don’t know what Epicor uses, but in my own versions of Time Phase, I have to use PartDtlSeq as the tie-breaker sort, in order to get the same sequence that they have. But in …

For those talking about HUGE number of jobs created (over 10k per day), I am wondering how many of you are using this feature in MRP. you can set a SHORT HORIZON planning days… everything within this number of days is planned using the short horizon rules anything OUTSIDE the short horizon can fol…

PartDtl.PartDtlSeq Running out of integers - Arithmetic overflow converting IDENTITY to data type int

Epicor ERP 10

JasonMcD (Jason McDermott) March 23, 2023, 1:16pm 14

@Noffie Long discussion of the horizon settings in this post. Link below skips to post 12, where I summarize.

Topic		Replies	Views
MRP Trouble Epicor ERP 10 mrp	23	9967	August 17, 2023
Reporting Quantity from Multiple Workstations Kinetic ERP bpm , kinetic , mes , data-collection	15	311	June 18, 2026
Part screen strange error Epicor ERP 10 epicor	36	2414	August 25, 2023
MRP Issue Epicor ERP 10 e10 , epicor , mrp , epicor-mrp	4	1073	March 31, 2023
Rant - MRP bottlenecking (Waiting for next part) Epicor ERP 10 mrp	14	3498	November 1, 2022

PartDtl.PartDtlSeq Running out of integers - Arithmetic overflow converting IDENTITY to data type int

Related topics