Suddenly Long MRP Run Time

We're on SQL. A therapeutic reboot solved the problem.

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of markewhittaker
Sent: Thursday, January 27, 2011 10:55 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Suddenly Long MRP Run Time

Are there a lot of engineering changes to methods being made on parts in
that company code? Or has there recently been a change in some of the
planning parameters of parts, such as days of supply? Those can cause
the mrp process to work harder. Also, did you recently truncate your
.bi file? If you truncate the .bi file and don't use a BIGROW option to
expand it, once the default space for the .bi file is used up, the
database has to format additional space for the .bi file to use as it
grows, which slows things down. MRP is very intensive in writing to the
.bi file.

--- In vantage@yahoogroups.com, "Brian W. Spolarich" <bspolarich@...>
wrote:
>
> Typically MRP for one of our companies takes 3.5 hours to run. Last
> night suddenly it took 8 hours.
>
>
>
> One thing we notice is that the amount of non-scheduling time went
way
> up:
>
>
>
> 08:00:17 MRP process 101 done. Total Non Scheduling Time = 05:01:15.
> Scheduled Jobs: 3132 Deleted Jobs: 2399 Save Load Jobs: 1931
>
>
>
> Vs
>
>
>
> 03:28:10 MRP process 101 done. Total Non Scheduling Time = 01:16:10.
> Scheduled Jobs: 3143 Deleted Jobs: 1553 Save Load Jobs: 1545
>
>
>
> We're not aware of any obvious changes, and the server didn't appear
> to be having any difficulty. The Vantage logs are clean, the server
> didn't appear to be especially busy doing other stuff, etc.
>
>
>
> What might be going on here?
>
>
>
> -bws
>
>
>
> --
>
> Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix
/
> Picometrix
>
> bspolarich@...
> <mailto:bspolarich@...> ~ 734-864-5618 ~
> www.advancedphotonix.com <http://www.advancedphotonix.com>
>
>
>
>
>
> [Non-text portions of this message have been removed]
>




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

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
Typically MRP for one of our companies takes 3.5 hours to run. Last
night suddenly it took 8 hours.



One thing we notice is that the amount of non-scheduling time went way
up:



08:00:17 MRP process 101 done. Total Non Scheduling Time = 05:01:15.
Scheduled Jobs: 3132 Deleted Jobs: 2399 Save Load Jobs: 1931



Vs



03:28:10 MRP process 101 done. Total Non Scheduling Time = 01:16:10.
Scheduled Jobs: 3143 Deleted Jobs: 1553 Save Load Jobs: 1545



We're not aware of any obvious changes, and the server didn't appear
to be having any difficulty. The Vantage logs are clean, the server
didn't appear to be especially busy doing other stuff, etc.



What might be going on here?



-bws



--

Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix /
Picometrix

bspolarich@...
<mailto:bspolarich@...> ~ 734-864-5618 ~
www.advancedphotonix.com <http://www.advancedphotonix.com>





[Non-text portions of this message have been removed]
Perhaps you have a bad job method (a job for a part inadvertently made from
itself) and MRP looped endlessly truing to resolve before moving on in failure.




________________________________
From: Brian W. Spolarich <bspolarich@...>
To: vantage@yahoogroups.com
Sent: Fri, January 21, 2011 9:53:24 AM
Subject: [Vantage] Suddenly Long MRP Run Time

Â
Typically MRP for one of our companies takes 3.5 hours to run. Last
night suddenly it took 8 hours.

One thing we notice is that the amount of non-scheduling time went way
up:

08:00:17 MRP process 101 done. Total Non Scheduling Time = 05:01:15.
Scheduled Jobs: 3132 Deleted Jobs: 2399 Save Load Jobs: 1931

Vs

03:28:10 MRP process 101 done. Total Non Scheduling Time = 01:16:10.
Scheduled Jobs: 3143 Deleted Jobs: 1553 Save Load Jobs: 1545

We're not aware of any obvious changes, and the server didn't appear
to be having any difficulty. The Vantage logs are clean, the server
didn't appear to be especially busy doing other stuff, etc.

What might be going on here?

-bws

--

Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix /
Picometrix

bspolarich@...
<mailto:bspolarich@...> ~ 734-864-5618 ~
www.advancedphotonix.com <http://www.advancedphotonix.com>

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







[Non-text portions of this message have been removed]
How would you tell?

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Robert Brown
Sent: Friday, January 21, 2011 10:11 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Suddenly Long MRP Run Time

Perhaps you have a bad job method (a job for a part inadvertently made from
itself) and MRP looped endlessly truing to resolve before moving on in failure.




________________________________
From: Brian W. Spolarich <bspolarich@...>
To: vantage@yahoogroups.com
Sent: Fri, January 21, 2011 9:53:24 AM
Subject: [Vantage] Suddenly Long MRP Run Time

Â
Typically MRP for one of our companies takes 3.5 hours to run. Last
night suddenly it took 8 hours.

One thing we notice is that the amount of non-scheduling time went way
up:

08:00:17 MRP process 101 done. Total Non Scheduling Time = 05:01:15.
Scheduled Jobs: 3132 Deleted Jobs: 2399 Save Load Jobs: 1931

Vs

03:28:10 MRP process 101 done. Total Non Scheduling Time = 01:16:10.
Scheduled Jobs: 3143 Deleted Jobs: 1553 Save Load Jobs: 1545

We're not aware of any obvious changes, and the server didn't appear
to be having any difficulty. The Vantage logs are clean, the server
didn't appear to be especially busy doing other stuff, etc.

What might be going on here?

-bws




Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix /
Picometrix

bspolarich@...
<mailto:bspolarich@...> ~ 734-864-5618 ~
www.advancedphotonix.com <http://www.advancedphotonix.com>

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







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





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
Read the detailed log files




________________________________
From: Brian W. Spolarich <bspolarich@...>
To: vantage@yahoogroups.com
Sent: Fri, January 21, 2011 10:21:52 AM
Subject: RE: [Vantage] Suddenly Long MRP Run Time

Â
How would you tell?

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Robert Brown

Sent: Friday, January 21, 2011 10:11 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Suddenly Long MRP Run Time

Perhaps you have a bad job method (a job for a part inadvertently made from
itself) and MRP looped endlessly truing to resolve before moving on in failure.




________________________________
From: Brian W. Spolarich <bspolarich@...>
To: vantage@yahoogroups.com
Sent: Fri, January 21, 2011 9:53:24 AM
Subject: [Vantage] Suddenly Long MRP Run Time

Â
Typically MRP for one of our companies takes 3.5 hours to run. Last
night suddenly it took 8 hours.

One thing we notice is that the amount of non-scheduling time went way
up:

08:00:17 MRP process 101 done. Total Non Scheduling Time = 05:01:15.
Scheduled Jobs: 3132 Deleted Jobs: 2399 Save Load Jobs: 1931

Vs

03:28:10 MRP process 101 done. Total Non Scheduling Time = 01:16:10.
Scheduled Jobs: 3143 Deleted Jobs: 1553 Save Load Jobs: 1545

We're not aware of any obvious changes, and the server didn't appear
to be having any difficulty. The Vantage logs are clean, the server
didn't appear to be especially busy doing other stuff, etc.

What might be going on here?

-bws

--

Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix /
Picometrix

bspolarich@...
<mailto:bspolarich@...> ~ 734-864-5618 ~
www.advancedphotonix.com <http://www.advancedphotonix.com>

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







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



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

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]
I reviewed the log files and didn't see any evidence of that problem.

I opened this case with Epicor after seeing weird behavior over the weekend and this morning.



As of a few days ago, our MRP runs are taking a very long time, particularly in one company. Typically in company PICO the MRP runs take about 3 hours, and in OPTO less than an hour.

Over the past few days intermittently, PICO has gone up to 8 hours, or even 14 hours. The OPTO job sometimes has stayed less than an hour when PICO takes forever to run, but Sunday AM's job took 14 hours for PICO and 3 hours for OPTO.

I killed this morning's job as it hadn't finished and I wanted to observe the database server's performance monitor while MRP was and was not running. Without MRP running the # of database trans/sec is pretty low, so MRP seems to the cause of the load that I see (i.e. there isn't something else making the database server busy), but even in the process of deleting unfirm MRP jobs it appears to be 50% slower than the baseline.



What's going on here?



-bws

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Robert Brown
Sent: Friday, January 21, 2011 11:55 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Suddenly Long MRP Run Time

Read the detailed log files




________________________________
From: Brian W. Spolarich <bspolarich@...>
To: vantage@yahoogroups.com
Sent: Fri, January 21, 2011 10:21:52 AM
Subject: RE: [Vantage] Suddenly Long MRP Run Time

Â
How would you tell?

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Robert Brown

Sent: Friday, January 21, 2011 10:11 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Suddenly Long MRP Run Time

Perhaps you have a bad job method (a job for a part inadvertently made from
itself) and MRP looped endlessly truing to resolve before moving on in failure.
Are there a lot of engineering changes to methods being made on parts in that company code? Or has there recently been a change in some of the planning parameters of parts, such as days of supply? Those can cause the mrp process to work harder. Also, did you recently truncate your .bi file? If you truncate the .bi file and don't use a BIGROW option to expand it, once the default space for the .bi file is used up, the database has to format additional space for the .bi file to use as it grows, which slows things down. MRP is very intensive in writing to the .bi file.

--- In vantage@yahoogroups.com, "Brian W. Spolarich" <bspolarich@...> wrote:
>
> Typically MRP for one of our companies takes 3.5 hours to run. Last
> night suddenly it took 8 hours.
>
>
>
> One thing we notice is that the amount of non-scheduling time went way
> up:
>
>
>
> 08:00:17 MRP process 101 done. Total Non Scheduling Time = 05:01:15.
> Scheduled Jobs: 3132 Deleted Jobs: 2399 Save Load Jobs: 1931
>
>
>
> Vs
>
>
>
> 03:28:10 MRP process 101 done. Total Non Scheduling Time = 01:16:10.
> Scheduled Jobs: 3143 Deleted Jobs: 1553 Save Load Jobs: 1545
>
>
>
> We're not aware of any obvious changes, and the server didn't appear
> to be having any difficulty. The Vantage logs are clean, the server
> didn't appear to be especially busy doing other stuff, etc.
>
>
>
> What might be going on here?
>
>
>
> -bws
>
>
>
> --
>
> Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix /
> Picometrix
>
> bspolarich@...
> <mailto:bspolarich@...> ~ 734-864-5618 ~
> www.advancedphotonix.com <http://www.advancedphotonix.com>
>
>
>
>
>
> [Non-text portions of this message have been removed]
>