408b MRP question

Yahoo Archive
1
It does make a difference as to the user id but if you are running it as a security manager you are okay.

As to locking up, I have found this to happen mostly from 2 different reasons:
1. Using more than 1 MRP Processes and or more than 1 Schedulers.
2. You have a new part in the BOM with an unapproved revision.

Number 1 will cause it if you have a long running MRP regen. I know of people that use more than 1 process without any problems and I have been able to do so if MRP does not process for a long period of time. I have not tried it for a while since I just gave up on it. Our business has dropped off enough that MRP does not take very long to process anyway.

Number 2 should not happen but it does. As indicated, it is a new part without an approved revision but it was added to a current BOM. I have never submitted it to support but I have brought it up at user group meetings when the Epicor MRP manager was present.

When you submit MRP select at least MRP for the logging level. You can then look in the logs and see when MRP locked up. If it is being caused by number 2 then you can narrow down the culprit.

Charles Carden
IT Manager
Manitex, Inc.
Georgetown, Texas

----- Original Message -----
From: leann_37
To: vantage@yahoogroups.com
Sent: Monday, March 08, 2010 11:44 AM
Subject: [Vantage] 408b MRP question



We are on 8.03.408b. Just started running MRP (regen) on our test server, in preparation for running in Production, and it is hanging up every night. I didn't have it logging, so we're starting that tonight, and infrastructure is finding out what else is happening at night on the test server. In the meantime, he asked me a question I can't answer to his satisfaction. who's login does vantage use for database authentication when it runs? I always figured as long as it runs from either manager or a security manager login, it didn't matter whose login it fired from, but that may be my ignorance. Does it make a difference?
Thanks in advance!
- leAnn





[Non-text portions of this message have been removed]
2
We are on 8.03.408b. Just started running MRP (regen) on our test server, in preparation for running in Production, and it is hanging up every night. I didn't have it logging, so we're starting that tonight, and infrastructure is finding out what else is happening at night on the test server. In the meantime, he asked me a question I can't answer to his satisfaction. who's login does vantage use for database authentication when it runs? I always figured as long as it runs from either manager or a security manager login, it didn't matter whose login it fired from, but that may be my ignorance. Does it make a difference?
Thanks in advance!
- leAnn
3
I believe it uses the login of the user requesting the job as that user is the one getting the log report.

Be aware that the Low Level Code can be incorrect which may affect MRP and Cost Rollups. Dump it from the Part table before/after running Conversion Routine 5100 in your test database to see if it updated anything. And it's possible this routine can go into an infinite loop. If it takes longer than you think it should, dump it while it's running and see if the Low Level Code is getting above your deepest BOM depth. If so, you have an invalid BOM. And Engineering needs to Validate their BOM's in the Workbench.

We used to have problems running multiple processes on MRP and decided to just use 1 for it and the scheduler at all times.

I haven't had time to see if the Low Level Code problem is fixed in Epicor 9 yet as we're waiting for a new test server rebuild.
----- Original Message -----
From: leann_37
To: vantage@yahoogroups.com
Sent: Monday, March 08, 2010 9:44 AM
Subject: [Vantage] 408b MRP question


We are on 8.03.408b. Just started running MRP (regen) on our test server, in preparation for running in Production, and it is hanging up every night. I didn't have it logging, so we're starting that tonight, and infrastructure is finding out what else is happening at night on the test server. In the meantime, he asked me a question I can't answer to his satisfaction. who's login does vantage use for database authentication when it runs? I always figured as long as it runs from either manager or a security manager login, it didn't matter whose login it fired from, but that may be my ignorance. Does it make a difference?
Thanks in advance!
- leAnn




------------------------------------

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links





[Non-text portions of this message have been removed]
4
Should be that of whomever submits the MRP process, or creates the
schedule to do so (for scheduled processes).



Rob Bucek

Manufacturing Engineer

PH: (715) 284-5376 ext 3111

FAX: (715)284-4084

<http://www.dsmfg.com/>

(Click the logo to view our site) <http://www.dsmfg.com/>





From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of leann_37
Sent: Monday, March 08, 2010 11:44 AM
To: vantage@yahoogroups.com
Subject: [Vantage] 408b MRP question





We are on 8.03.408b. Just started running MRP (regen) on our test
server, in preparation for running in Production, and it is hanging up
every night. I didn't have it logging, so we're starting that tonight,
and infrastructure is finding out what else is happening at night on the
test server. In the meantime, he asked me a question I can't answer to
his satisfaction. who's login does vantage use for database
authentication when it runs? I always figured as long as it runs from
either manager or a security manager login, it didn't matter whose login
it fired from, but that may be my ignorance. Does it make a difference?
Thanks in advance!
- leAnn





[Non-text portions of this message have been removed]