ISTech Support Forum

ISTech Support Forum
http://www.istechforum.com/YaBB.pl
Evo-ERP and DBA Classic >> Manufacturing >> MRP Material Requirements Report
http://www.istechforum.com/YaBB.pl?num=1107285772

Message started by sharon krewson on 02/01/05 at 11:22:52

Title: MRP Material Requirements Report
Post by sharon krewson on 02/01/05 at 11:22:52

When trying to run MR-G (Print Materials Requirement) using the Planner Code field as the filter, we are receiving error messages saying "Too Many Pops". It will finish the report & only a small amount of the data will actually print out. This started occurring after the most recent upgrade we installed in the last 30 days.

Any reason why this may be occurring & how do you fix it?

Thanks!

Title: Re: MRP Material Requirements Report
Post by sharon krewson on 02/04/05 at 07:02:47

Let me pose this question another way. Is anyone else getting "Too Many Pops" in any other application? I know there is a thread out there about this occurring when printing travelers. But, it was never resolved.

Any insight?

Title: Re: MRP Material Requirements Report
Post by Lynn Pantic on 02/04/05 at 17:12:36

The Too Many Pops message would be program specific - exactly what point in the program do you see the message? Do you sat T or No to the question about a new page fpr each part number? Any other folters besides Planner Code? I just tried here and can't duplicate so I need to know exactly how you are running the report.

Title: Re: MRP Material Requirements Report
Post by sharon krewson on 02/07/05 at 10:12:30

Lynn,

Once the report starts running (after you select print or list), a message comes up after awhile saying "a matching record was not found during a related find", then it comes up with the "too many pops" message, and the "too many Pops" record comes up either one or many times & finally it prints, but it does not contain everything that should have printed.

Sharon

Title: Re: MRP Material Requirements Report
Post by sharon krewson on 02/07/05 at 10:23:55

Lynn,

All we chose to change was the Planner code. We also tried to only use Category as well as Class & we still got the message.

Sharon

Title: Re: MRP Material Requirements Report
Post by NovaZyg on 02/07/05 at 13:51:23

Sharon,

use Maintain Database and open MTMRP.B??
look at the MTMRP_PARTNO ... Are they all valid Parts?

The code is just processing that file against the ICMSTR Files.

It does a relative search for MTMRP_PARTNO into both BK and MT ICMSTR.

Let me know what you find.

Title: Re: MRP Material Requirements Report
Post by sharon krewson on 02/09/05 at 06:12:37

Allen

Well, we had a very odd thing happen yesterday that is probably related. We had a part correctly appear on a work order traveler but it did not show up on the picklist. When I went to look at the part in IN-A nothing came up. This is an old part (type R) with hundreds of transactions. When I ran an inventory transaction report all of the info was there. I then used Crystal to look at the MTICMSTR and BKICMSTR and sure enough it wasn't in the BKICMSTR. But, it was in the MTICMSTR as well as INTXN, WOBOM, etc. I then added it back into the system through IN-B (probably the wrong thing to do) and all of the history linked up to it.

When I used Maintain Database to look at the part again I noticed we now have 2 lines for this part in MTICMSTR and only one in BKICMSTR. Also, both files have the same number of records.

I am not sure how to check to see if I have this problem with any other parts. Do you know how we got into this mess? And, as of this morning, we are back to classic DBA (ugh!!!!). We have had a lot of instability and have had to reboot our server daily (sometime more than once!). I am suspecting the instability has to do with adding more users in recent months. And, I suspect that one of the times DBA crashed is when we corrupted the file for that part.

Thanks for any help you can provide.

Sharon (Dave too)

Title: Re: MRP Material Requirements Report
Post by Lynn Pantic on 02/09/05 at 07:47:52

SM-J-C will delete extra records in MTICMSTR and identify any other mismatches between MTICMSTR and BKICMSTR but use Report Only mode since you suspect BKICMSTR to be missing record(s).