MRP Freezing Blank Title 71071

Yahoo Archive
1
We had an issue with a BAM causing MRP to hang-up. Once we deleted the BAM it ran fine.




________________________________
From: Gary Parfrey <garyp@...>
To: vantage@yahoogroups.com
Sent: Wednesday, November 19, 2008 5:24:47 PM
Subject: RE: [Vantage] MRP Freezing


Vic

We have found historically on multiple sites that this is down to record
locking, especially if backflushing and/or Kanban receipts have taken
place.

There is a timeout setting on the appserver setting that you can reduce.
I think by default it is too high and the MRP process gives up.

Use promon to check, if you are getting any exclusive table locks rather
than record locks, if on progress.

Regards

Gary

From: vantage@yahoogroups .com [mailto:vantage@yahoogroups .com] On Behalf
Of Vic Drecchio
Sent: 19 November 2008 16:14
To: vantage@yahoogroups .com
Subject: [Vantage] MRP Freezing

Vantage 8.03.404B

Has anyone experienced MRP just freezing up intermittently while
running? Never on the same part or job and not consistently stuck in
one area of the processing such as scheduling, deleting, etc.

If you have had MRP freeze and you have troubleshot some of these
errors, would you share how you diagnosed your situation and any other
info?

Epicor is not much help with MRP.

Thank you very much.

Vic Drecchio
ERP Administrator

TIMCO Aviation Services
Greensboro, NC
Email: vic.drecchio@ timco.aero <mailto:vic. drecchio% 40timco.aero>
Office: 336.668.4410 x3091
Mobile: 704.530.3092

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

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






[Non-text portions of this message have been removed]
2
Vantage 8.03.404B



Has anyone experienced MRP just freezing up intermittently while
running? Never on the same part or job and not consistently stuck in
one area of the processing such as scheduling, deleting, etc.



If you have had MRP freeze and you have troubleshot some of these
errors, would you share how you diagnosed your situation and any other
info?



Epicor is not much help with MRP.





Thank you very much.





Vic Drecchio
ERP Administrator


TIMCO Aviation Services
Greensboro, NC
Email: vic.drecchio@...
Office: 336.668.4410 x3091
Mobile: 704.530.3092





[Non-text portions of this message have been removed]
3
Vic,
I have had trouble with it hanging up on occasion, most times due to a part. I cannot remember what it was, maybe lack of approved rev, or no method for the plant it was running against, something along those lines.
But it was the log file that told me which job was the problem, and from there I figured it out.
Are you having MRP create a log file?





Anthony Hughes
ERP Manager
Logan Oil Tools, Inc.
Houston, Texas




________________________________
From: Vic Drecchio <vic.drecchio@...>
To: vantage@yahoogroups.com
Sent: Wednesday, November 19, 2008 10:13:39 AM
Subject: [Vantage] MRP Freezing


Vantage 8.03.404B

Has anyone experienced MRP just freezing up intermittently while
running? Never on the same part or job and not consistently stuck in
one area of the processing such as scheduling, deleting, etc.

If you have had MRP freeze and you have troubleshot some of these
errors, would you share how you diagnosed your situation and any other
info?

Epicor is not much help with MRP.

Thank you very much.

Vic Drecchio
ERP Administrator


TIMCO Aviation Services
Greensboro, NC
Email: vic.drecchio@ timco.aero
Office: 336.668.4410 x3091
Mobile: 704.530.3092

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






[Non-text portions of this message have been removed]
4
At least for us (8.03.405, MSSQL 2005) the fix seemed to be to apply all
of the performance tuning suggestions that Epicor provides, particularly
settings your Progress schema holder databases to be read-only. Once I
applied the tuning fixes MRP has run reliably (knock on formica :-)). We
run a full regen every day at 3AM and all seems to be well.


On 11/19/08 8:13 AM, "Vic Drecchio" <vic.drecchio@...> wrote:

>
>
>
> Vantage 8.03.404B
>
> Has anyone experienced MRP just freezing up intermittently while
> running? Never on the same part or job and not consistently stuck in
> one area of the processing such as scheduling, deleting, etc.
>
> If you have had MRP freeze and you have troubleshot some of these
> errors, would you share how you diagnosed your situation and any other
> info?
>
> Epicor is not much help with MRP.
>
> Thank you very much.
>
> Vic Drecchio
> ERP Administrator
>
>
> TIMCO Aviation Services
> Greensboro, NC
> Email: vic.drecchio@... <mailto:vic.drecchio%40timco.aero>
> Office: 336.668.4410 x3091
> Mobile: 704.530.3092
>
> [Non-text portions of this message have been removed]
>
>
>



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



We have found historically on multiple sites that this is down to record
locking, especially if backflushing and/or Kanban receipts have taken
place.

There is a timeout setting on the appserver setting that you can reduce.
I think by default it is too high and the MRP process gives up.

Use promon to check, if you are getting any exclusive table locks rather
than record locks, if on progress.



Regards



Gary



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Vic Drecchio
Sent: 19 November 2008 16:14
To: vantage@yahoogroups.com
Subject: [Vantage] MRP Freezing



Vantage 8.03.404B

Has anyone experienced MRP just freezing up intermittently while
running? Never on the same part or job and not consistently stuck in
one area of the processing such as scheduling, deleting, etc.

If you have had MRP freeze and you have troubleshot some of these
errors, would you share how you diagnosed your situation and any other
info?

Epicor is not much help with MRP.

Thank you very much.

Vic Drecchio
ERP Administrator


TIMCO Aviation Services
Greensboro, NC
Email: vic.drecchio@... <mailto:vic.drecchio%40timco.aero>
Office: 336.668.4410 x3091
Mobile: 704.530.3092

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





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