ISTech Support Forum

ISTech Support Forum
http://www.istechforum.com/YaBB.pl
Evo-ERP and DBA Classic >> Problem Reports - Repeatable >> MR-F Stalls at Stage 1
http://www.istechforum.com/YaBB.pl?num=1453410296

Message started by TGerak on 01/21/16 at 14:04:56

Title: MR-F Stalls at Stage 1
Post by TGerak on 01/21/16 at 14:04:56

Forgive the duplicate posting, but I'm hung up trying to generate Material Requirements. If I run MR-F, it runs until it reaches Stage 1 then stops. There does not appear to be any activity, and it hangs indefinitely. I don't know if it's a bug, or if it's an error with a default. We're on the current version and I installed patches on Monday of this week.

Any help would be appreciated.

Title: Re: MR-F Stalls at Stage 1
Post by shadowcaster on 01/27/16 at 07:02:54

did you check for boms that loop back to themselves ?

SM-J-Q BOM Recursion Utility

I had that happen once

bom called another bom that called the 1st bom

Title: Re: MR-F Stalls at Stage 1
Post by TGerak on 01/27/16 at 07:50:10

Thanks for looking. We did run the Recursion Utility (found it when searching for answers) and it didn't find anything. That one isn't our problem. I've also emailed Lynn. The programmer with the bulk of the MRP experience is out of the office this week, so it may be next week before we know anything.

Title: Re: MR-F Stalls at Stage 1
Post by NovaZyg on 02/02/16 at 11:50:18

took a bit of digging but it would seem that you have a BOM in BKBMMSTR.B with the parent part of " " (blank) and it has 4 lines, one of those lines has the component of "ALLOY STEEL" (one of your most common parts..) and when it was hitting this component with a blank parent it was getting stuck in an infinite loop.

Use Maintain Database and open BKBMMSTR.B sort by BKBM.PARENT (that is the default) and delete those first 4 lines where the parent is blank.
to delete them check the Edit box on, then highlight the row you want to delete and press the delete key.

when done check off the edit box.

I ran MRF on your data and it took 4 minutes once that was fixed. ;)

Title: Re: MR-F Stalls at Stage 1
Post by TGerak on 02/03/16 at 07:30:00

That did it. All is well with MRP-F now. We're digging in and turning MRP on for selected items while we get a better understanding of the function. Thanks for all the help.