Epicor 9 Impossibly slow

system · August 10, 2010, 1:52pm

There will always be Progress code, the product is written in Progress's
language, it will never be a completely native MS SQL piece of software.
That would require a complete re-write of every single bit of code for the
entire application. I don't see that happening.

MS SQL is and have never been anything more than a storage location for the
applications information, it's like making a decision to use Tupperware or
Rubbermaid, either way the meal is going to be the same.

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
scottbrydson
Sent: Tuesday, August 10, 2010 12:14 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Epicor 9 Impossibly slow

As a new Epicor customer, we have 8 months experience with v9.04.5.5B (SQL)
in implementation as we prepare for launch. We are at or above the
recommended RAID10 hardware configs but continue to encounter poor to
average performance and response times. This, with 8 users and a relatively
small # of test transactions and data.

We see random MfgSys.exe crash on client PC's (4gb+ RAM) as a daily event.
We cannot replicate the scenarios nor find any advice - other than something
we have to live with. Our choice of DB is MS SQL, there are still legacy
Progress code throughout.

We will continue to seek assistance from Epicor on performance tuning, but
essentially we are putting lipstick on a pig. Hopefully there are upcoming
performance patches, but new v9 customers beware - if it smells like a pig,
it is probably a pig.

--- In vantage@yahoogroups.com, Mark Wonsil <mark_wonsil@...> wrote:
>
> Or we both have the same problem!
>
> On Aug 10, 2010 10:46 AM, "Jose Gomez" <jose@...> wrote:
>
> Thanks Mark at least I know that's not the problem
>
>
>
> Sincerely
> Jose C Gomez
>
> http://www.josecgomez.com
>
> On Tue, Aug 10, 2010 at 10:45 AM, Mark Wonsil <mark_wonsil@...> wrote:
>
> >
> >
> > We see the same ...
> > On Aug 10, 2010 10:26 AM, "Jose Gomez" <jose@...<jose%
> 40josecgomez.com>>
>
> > wrote:
> >
> > Thanks Ned,
> >
> > I just looked and we have one array of 4 drives for each VM.
> >
> > We hav...
> > On Tue, Aug 10, 2010 at 10:09 AM, Ned <TechnoBabbly@...
> <TechnoBabbly%40gmail.com>>
>
> > wrote:
> >
> > >
> > >
> > > What is the one storage...
> >
> >
>
> > > From: vantage@yahoogroups.com <vantage%40yahoogroups.com>
> > > <vantage%
> > 40yahoogroups.com> [mailto...
> > > vantage@yahoogroups.com <vantage%40yahoogroups.com> <vant...
>
> >
> >
> > > Sent: Tuesday, August 10, 2010 9:48 AM
> >
> > > To: vantage@yahoogroups.com <vantage%40yahoogroups.com> <vantage%
>
> > 40yahoogroups.com>
> > > Subject: Re: [Vantage] Epicor 9 Impossib...
> >
> >
> > > Thanks Chris,
> > > I wil...
>
> > http://groups.yahoo.com/group/vantage/
> >
>
> > [Non-text portions of this message have been removed]
> >
> >
> >
>
>
> [Non-text portions of this message...
> (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
>
>
> http://groups.yahoo.com/group/vantage/join
> (Yahoo! ID required)
>
>
> [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

system · August 9, 2010, 10:16am

I said las week that epicor 9 was running slower than normal, some of you
suggested various things but nothing seems to be helping.

Over the weekend, we re-indexed the DB, did a dump and load, truncated the
bi and god knows what else. It seems to be running awful still
this morning after all that.

Does anyone have any troubleshooting / tracing / fixing ideas that may help
us determine where the problem is?

Thank you in advance!

Sincerely
Jose C Gomez

http://www.josecgomez.com

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

system · August 9, 2010, 11:48am

HIÂ Jose,

We have had a number of speed issues with Epicor 9.

If we leave the Apps and DB running for about a week, the system will grind to a
halt and we would have to stop the apps and db and sometimes restart the server
to fix the issue.

Epicor have accepted that this looks like a fault with Progress so the call has
been passed to them.

At present, we have a script in place to stop the apps then the db, then restart
the apps and the db - we run this every night out of hours. If you are going to
do this, please don't use the script from Epicor's answer books as their is a
fault with it. It doesn't wait for the DB to be stopped before trying to restart
the Apps which just ends up in a mess.

Secondly, on a weekend, we stop the apps, stop the db, clear out any temp files
and temp .xml data for reports, defrage all drives on the server, start the db,
start the apps.

So far, we have not had any 'major' slow downs where we have had to kick people
off the system during the working week.

We found that the reports folder (usually epicodata/reports) was getting very
full very fast. Some reports were are in excess of 7GB in size (the xml for
them) so if you run these a few times a month, the folder size increases
rapidly.

One thing we noticed is that the archive option of 'Never' when you run a report
nearly always doesnt' work. 'Never' would appear to either mean 30 days or keep
forever - hence the reason why the reports folder was building up in size.

What are you classing as slow and what are you comparing against?

Our speed issues have been associated with 'memory leaking' BAQs and BAQs which
crash on you causing the app server to get stuck in a loop.

There are also other things which may speed things up such as increasing number
of App servers and tweaking settings in the mfgsys.mfgsys file (but I would get
advice from Epicor on these).

It is definately worth while logging a call for this issue as something
definately isn't right. Hopefully your call will be linked with my call and we
should get an answer quicker.

Are you progress or SQL?

Thanks,

CHRIS

________________________________
From: Jose Gomez <jose@...>
To: Vantage <vantage@yahoogroups.com>
Sent: Mon, 9 August, 2010 15:14:27
Subject: [Vantage] Epicor 9 Impossibly slow

Â
I said las week that epicor 9 was running slower than normal, some of you
suggested various things but nothing seems to be helping.

Over the weekend, we re-indexed the DB, did a dump and load, truncated the
bi and god knows what else. It seems to be running awful still
this morning after all that.

Does anyone have any troubleshooting / tracing / fixing ideas that may help
us determine where the problem is?

Thank you in advance!

Sincerely
Jose C Gomez

http://www.josecgomez.com

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

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

system · August 9, 2010, 12:05pm

Thank you Chris,
we are running Progress and basically the whole app is running slow, takes
time to open forms, time to search, time to save, searching for an SO can
take minutes at times. Loading Invoices into ARGroup can take minutes at
times.

We've ran through the DB tunning guide today and tweaked all the values we
could find, and hopefully this will fix some of our issues. But I find it
absurd that it takes minutes to search for a sales Order, or to save a
simple 10 line invoice.

We've attempted calls with Epicor but they are ... well not very helpful,
sadly although some of their people are really good, it seems like most of
the gen pop support doesn't actually understand/know how to deal with this
kind of issues.

For what is worth we are running on w 2 quad cores with 12 GB of RAM. Which
should be more than enough metal for the number of users we have.

Thanks for your input and i'll let you know if we find anything else.

Also can you share the start / stop script for the DB, apps etc, you
mentioned that the one form epicor is flawed.

Thanks again!

Sincerely
Jose C Gomez

http://www.josecgomez.com

On Mon, Aug 9, 2010 at 11:48 AM, Chris Thompson <chriselectrix@...>wrote:

>
>
> HI Jose,
>
> We have had a number of speed issues with Epicor 9.
>
> If we leave the Apps and DB running for about a week, the system will grind
> to a
> halt and we would have to stop the apps and db and sometimes restart the
> server
> to fix the issue.
>
> Epicor have accepted that this looks like a fault with Progress so the call
> has
> been passed to them.
>
> At present, we have a script in place to stop the apps then the db, then
> restart
> the apps and the db - we run this every night out of hours. If you are
> going to
> do this, please don't use the script from Epicor's answer books as their is
> a
> fault with it. It doesn't wait for the DB to be stopped before trying to
> restart
> the Apps which just ends up in a mess.
>
> Secondly, on a weekend, we stop the apps, stop the db, clear out any temp
> files
> and temp .xml data for reports, defrage all drives on the server, start the
> db,
> start the apps.
>
> So far, we have not had any 'major' slow downs where we have had to kick
> people
> off the system during the working week.
>
> We found that the reports folder (usually epicodata/reports) was getting
> very
> full very fast. Some reports were are in excess of 7GB in size (the xml for
>
> them) so if you run these a few times a month, the folder size increases
> rapidly.
>
> One thing we noticed is that the archive option of 'Never' when you run a
> report
> nearly always doesnt' work. 'Never' would appear to either mean 30 days or
> keep
> forever - hence the reason why the reports folder was building up in size.
>
> What are you classing as slow and what are you comparing against?
>
> Our speed issues have been associated with 'memory leaking' BAQs and BAQs
> which
> crash on you causing the app server to get stuck in a loop.
>
> There are also other things which may speed things up such as increasing
> number
> of App servers and tweaking settings in the mfgsys.mfgsys file (but I would
> get
> advice from Epicor on these).
>
> It is definately worth while logging a call for this issue as something
> definately isn't right. Hopefully your call will be linked with my call and
> we
> should get an answer quicker.
>
> Are you progress or SQL?
>
> Thanks,
>
> CHRIS
>
> ________________________________
> From: Jose Gomez <jose@... <jose%40josecgomez.com>>
> To: Vantage <vantage@yahoogroups.com <vantage%40yahoogroups.com>>
> Sent: Mon, 9 August, 2010 15:14:27
> Subject: [Vantage] Epicor 9 Impossibly slow
>
>
>
> I said las week that epicor 9 was running slower than normal, some of you
> suggested various things but nothing seems to be helping.
>
> Over the weekend, we re-indexed the DB, did a dump and load, truncated the
> bi and god knows what else. It seems to be running awful still
> this morning after all that.
>
> Does anyone have any troubleshooting / tracing / fixing ideas that may help
> us determine where the problem is?
>
> Thank you in advance!
>
> Sincerely
> Jose C Gomez
>
> http://www.josecgomez.com
>
> [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]

system · August 9, 2010, 12:56pm

Are you running raid 10 on your drives and is the OS on a separate drive?Â How
many simultaneous users are you supporting?

________________________________
From: Jose Gomez <jose@...>
To: vantage@yahoogroups.com
Sent: Mon, August 9, 2010 12:05:06 PM
Subject: Re: [Vantage] Epicor 9 Impossibly slow

Thank you Chris,
we are running Progress and basically the whole app is running slow, takes
time to open forms, time to search, time to save, searching for an SO can
take minutes at times. Loading Invoices into ARGroup can take minutes at
times.

We've ran through the DB tunning guide today and tweaked all the values we
could find, and hopefully this will fix some of our issues. But I find it
absurd that it takes minutes to search for a sales Order, or to save a
simple 10 line invoice.

We've attempted calls with Epicor but they are ... well not very helpful,
sadly although some of their people are really good, it seems like most of
the gen pop support doesn't actually understand/know how to deal with this
kind of issues.

For what is worth we are running on w 2 quad cores with 12 GB of RAM. Which
should be more than enough metal for the number of users we have.

Thanks for your input and i'll let you know if we find anything else.

Also can you share the start / stop script for the DB, apps etc, you
mentioned that the one form epicor is flawed.

Thanks again!

Sincerely
Jose C Gomez

http://www.josecgomez.com

On Mon, Aug 9, 2010 at 11:48 AM, Chris Thompson <chriselectrix@...>wrote:

>
>
> HI Jose,
>
> We have had a number of speed issues with Epicor 9.
>
> If we leave the Apps and DB running for about a week, the system will grind
> to a
> halt and we would have to stop the apps and db and sometimes restart the
> server
> to fix the issue.
>
> Epicor have accepted that this looks like a fault with Progress so the call
> has
> been passed to them.
>
> At present, we have a script in place to stop the apps then the db, then
> restart
> the apps and the db - we run this every night out of hours. If you are
> going to
> do this, please don't use the script from Epicor's answer books as their is
> a
> fault with it. It doesn't wait for the DB to be stopped before trying to
> restart
> the Apps which just ends up in a mess.
>
> Secondly, on a weekend, we stop the apps, stop the db, clear out any temp
> files
> and temp .xml data for reports, defrage all drives on the server, start the
> db,
> start the apps.
>
> So far, we have not had any 'major' slow downs where we have had to kick
> people
> off the system during the working week.
>
> We found that the reports folder (usually epicodata/reports) was getting
> very
> full very fast. Some reports were are in excess of 7GB in size (the xml for
>
> them) so if you run these a few times a month, the folder size increases
> rapidly.
>
> One thing we noticed is that the archive option of 'Never' when you run a
> report
> nearly always doesnt' work. 'Never' would appear to either mean 30 days or
> keep
> forever - hence the reason why the reports folder was building up in size.
>
> What are you classing as slow and what are you comparing against?
>
> Our speed issues have been associated with 'memory leaking' BAQs and BAQs
> which
> crash on you causing the app server to get stuck in a loop.
>
> There are also other things which may speed things up such as increasing
> number
> of App servers and tweaking settings in the mfgsys.mfgsys file (but I would
> get
> advice from Epicor on these).
>
> It is definately worth while logging a call for this issue as something
> definately isn't right. Hopefully your call will be linked with my call and
> we
> should get an answer quicker.
>
> Are you progress or SQL?
>
> Thanks,
>
> CHRIS
>
> ________________________________
> From: Jose Gomez <jose@... <jose%40josecgomez.com>>
> To: Vantage <vantage@yahoogroups.com <vantage%40yahoogroups.com>>
> Sent: Mon, 9 August, 2010 15:14:27
> Subject: [Vantage] Epicor 9 Impossibly slow
>
>
>
> I said las week that epicor 9 was running slower than normal, some of you
> suggested various things but nothing seems to be helping.
>
> Over the weekend, we re-indexed the DB, did a dump and load, truncated the
> bi and god knows what else. It seems to be running awful still
> this morning after all that.
>
> Does anyone have any troubleshooting / tracing / fixing ideas that may help
> us determine where the problem is?
>
> Thank you in advance!
>
> Sincerely
> Jose C Gomez
>
> http://www.josecgomez.com
>
> [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]

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

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/.%c2%a0

(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]

system · August 9, 2010, 10:07pm

What's your .pf file look like?

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Jose Gomez
Sent: Monday, August 09, 2010 12:05 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Epicor 9 Impossibly slow

Thank you Chris,
we are running Progress and basically the whole app is running slow, takes
time to open forms, time to search, time to save, searching for an SO can
take minutes at times. Loading Invoices into ARGroup can take minutes at
times.

We've ran through the DB tunning guide today and tweaked all the values we
could find, and hopefully this will fix some of our issues. But I find it
absurd that it takes minutes to search for a sales Order, or to save a
simple 10 line invoice.

We've attempted calls with Epicor but they are ... well not very helpful,
sadly although some of their people are really good, it seems like most of
the gen pop support doesn't actually understand/know how to deal with this
kind of issues.

For what is worth we are running on w 2 quad cores with 12 GB of RAM. Which
should be more than enough metal for the number of users we have.

Thanks for your input and i'll let you know if we find anything else.

Also can you share the start / stop script for the DB, apps etc, you
mentioned that the one form epicor is flawed.

Thanks again!

Sincerely
Jose C Gomez

http://www.josecgomez.com

On Mon, Aug 9, 2010 at 11:48 AM, Chris Thompson
<chriselectrix@...>wrote:

>
>
> HI Jose,
>
> We have had a number of speed issues with Epicor 9.
>
> If we leave the Apps and DB running for about a week, the system will
> grind to a halt and we would have to stop the apps and db and
> sometimes restart the server to fix the issue.
>
> Epicor have accepted that this looks like a fault with Progress so the
> call has been passed to them.
>
> At present, we have a script in place to stop the apps then the db,
> then restart the apps and the db - we run this every night out of
> hours. If you are going to do this, please don't use the script from
> Epicor's answer books as their is a fault with it. It doesn't wait for
> the DB to be stopped before trying to restart the Apps which just ends
> up in a mess.
>
> Secondly, on a weekend, we stop the apps, stop the db, clear out any
> temp files and temp .xml data for reports, defrage all drives on the
> server, start the db, start the apps.
>
> So far, we have not had any 'major' slow downs where we have had to
> kick people off the system during the working week.
>
> We found that the reports folder (usually epicodata/reports) was
> getting very full very fast. Some reports were are in excess of 7GB in
> size (the xml for
>
> them) so if you run these a few times a month, the folder size
> increases rapidly.
>
> One thing we noticed is that the archive option of 'Never' when you
> run a report nearly always doesnt' work. 'Never' would appear to
> either mean 30 days or keep forever - hence the reason why the reports
> folder was building up in size.
>
> What are you classing as slow and what are you comparing against?
>
> Our speed issues have been associated with 'memory leaking' BAQs and
> BAQs which crash on you causing the app server to get stuck in a loop.
>
> There are also other things which may speed things up such as
> increasing number of App servers and tweaking settings in the
> mfgsys.mfgsys file (but I would get advice from Epicor on these).
>
> It is definately worth while logging a call for this issue as
> something definately isn't right. Hopefully your call will be linked
> with my call and we should get an answer quicker.
>
> Are you progress or SQL?
>
> Thanks,
>
> CHRIS
>
> ________________________________
> From: Jose Gomez <jose@... <jose%40josecgomez.com>>
> To: Vantage <vantage@yahoogroups.com <vantage%40yahoogroups.com>>
> Sent: Mon, 9 August, 2010 15:14:27
> Subject: [Vantage] Epicor 9 Impossibly slow
>
>
>
> I said las week that epicor 9 was running slower than normal, some of
> you suggested various things but nothing seems to be helping.
>
> Over the weekend, we re-indexed the DB, did a dump and load, truncated
> the bi and god knows what else. It seems to be running awful still
> this morning after all that.
>
> Does anyone have any troubleshooting / tracing / fixing ideas that may
> help us determine where the problem is?
>
> Thank you in advance!
>
> Sincerely
> Jose C Gomez
>
> http://www.josecgomez.com
>
> [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]

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

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

system · August 9, 2010, 10:18pm

What does your .pf file look like?

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Jose Gomez
Sent: Monday, August 09, 2010 12:05 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Epicor 9 Impossibly slow

Thank you Chris,
we are running Progress and basically the whole app is running slow, takes
time to open forms, time to search, time to save, searching for an SO can
take minutes at times. Loading Invoices into ARGroup can take minutes at
times.

We've ran through the DB tunning guide today and tweaked all the values we
could find, and hopefully this will fix some of our issues. But I find it
absurd that it takes minutes to search for a sales Order, or to save a
simple 10 line invoice.

We've attempted calls with Epicor but they are ... well not very helpful,
sadly although some of their people are really good, it seems like most of
the gen pop support doesn't actually understand/know how to deal with this
kind of issues.

For what is worth we are running on w 2 quad cores with 12 GB of RAM. Which
should be more than enough metal for the number of users we have.

Thanks for your input and i'll let you know if we find anything else.

Also can you share the start / stop script for the DB, apps etc, you
mentioned that the one form epicor is flawed.

Thanks again!

Sincerely
Jose C Gomez

http://www.josecgomez.com

On Mon, Aug 9, 2010 at 11:48 AM, Chris Thompson
<chriselectrix@...>wrote:

>
>
> HI Jose,
>
> We have had a number of speed issues with Epicor 9.
>
> If we leave the Apps and DB running for about a week, the system will
> grind to a halt and we would have to stop the apps and db and
> sometimes restart the server to fix the issue.
>
> Epicor have accepted that this looks like a fault with Progress so the
> call has been passed to them.
>
> At present, we have a script in place to stop the apps then the db,
> then restart the apps and the db - we run this every night out of
> hours. If you are going to do this, please don't use the script from
> Epicor's answer books as their is a fault with it. It doesn't wait for
> the DB to be stopped before trying to restart the Apps which just ends
> up in a mess.
>
> Secondly, on a weekend, we stop the apps, stop the db, clear out any
> temp files and temp .xml data for reports, defrage all drives on the
> server, start the db, start the apps.
>
> So far, we have not had any 'major' slow downs where we have had to
> kick people off the system during the working week.
>
> We found that the reports folder (usually epicodata/reports) was
> getting very full very fast. Some reports were are in excess of 7GB in
> size (the xml for
>
> them) so if you run these a few times a month, the folder size
> increases rapidly.
>
> One thing we noticed is that the archive option of 'Never' when you
> run a report nearly always doesnt' work. 'Never' would appear to
> either mean 30 days or keep forever - hence the reason why the reports
> folder was building up in size.
>
> What are you classing as slow and what are you comparing against?
>
> Our speed issues have been associated with 'memory leaking' BAQs and
> BAQs which crash on you causing the app server to get stuck in a loop.
>
> There are also other things which may speed things up such as
> increasing number of App servers and tweaking settings in the
> mfgsys.mfgsys file (but I would get advice from Epicor on these).
>
> It is definately worth while logging a call for this issue as
> something definately isn't right. Hopefully your call will be linked
> with my call and we should get an answer quicker.
>
> Are you progress or SQL?
>
> Thanks,
>
> CHRIS
>
> ________________________________
> From: Jose Gomez <jose@... <jose%40josecgomez.com>>
> To: Vantage <vantage@yahoogroups.com <vantage%40yahoogroups.com>>
> Sent: Mon, 9 August, 2010 15:14:27
> Subject: [Vantage] Epicor 9 Impossibly slow
>
>
>
> I said las week that epicor 9 was running slower than normal, some of
> you suggested various things but nothing seems to be helping.
>
> Over the weekend, we re-indexed the DB, did a dump and load, truncated
> the bi and god knows what else. It seems to be running awful still
> this morning after all that.
>
> Does anyone have any troubleshooting / tracing / fixing ideas that may
> help us determine where the problem is?
>
> Thank you in advance!
>
> Sincerely
> Jose C Gomez
>
> http://www.josecgomez.com
>
> [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]

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

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

system · August 10, 2010, 3:16am

Hi Jose,

Have you logged this as a call? If so what call number?

The script we are using is ...

@echo off
set DLC=E:\epicor904\oe101cÂ Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â
set PATH=%DLC%\BIN;%PATH%
set LIB=%DLC%\LIB;%LIB%

echo .
echo .
echo RESTARTING LOCAL DB/APPSERVERS...
call asbman -name Epicor904ProcessServer -stop -port 20940Â Â Â Â Â Â
call asbman -name Epicor904TaskAgent -stop -port 20940
call asbman -name Epicor904 -stop -port 20940
call dbman -host localhost -database Epicor904 -stop -port 20940
Â
:TestStop
ECHO Testing Lock File
IF EXIST E:\epicor904\db\mfgsys.lk GOTO TestStop
Â
call dbman -host localhost -database Epicor904 -start -port 20940
call asbman -name Epicor904 -start -port 20940
call asbman -name Epicor904TaskAgent -start -port 20940
call asbman -name Epicor904ProcessServer -start -port 20940

Obviously you will have to change the paths to suit your server setup and you
will probably have to change the port number on each occasion. Also, I cannot be
held responsible for anything that goes wrong with your system when using this
script. It is worthwhile testing it on Pilot or Test first.

The check for the .lk is the bit that was missing from the answer books. It is a
bit of a crude fix, but it does the job.

We have found that the system is much more stable after deleting the old reports
and temp files folders and defragging on a weekend.

Let me know if you want those scripts too.

Thanks,

CHRIS

________________________________
From: Jose Gomez <jose@...>
To: vantage@yahoogroups.com
Sent: Mon, 9 August, 2010 17:05:06
Subject: Re: [Vantage] Epicor 9 Impossibly slow

Thank you Chris,
we are running Progress and basically the whole app is running slow, takes
time to open forms, time to search, time to save, searching for an SO can
take minutes at times. Loading Invoices into ARGroup can take minutes at
times.

We've ran through the DB tunning guide today and tweaked all the values we
could find, and hopefully this will fix some of our issues. But I find it
absurd that it takes minutes to search for a sales Order, or to save a
simple 10 line invoice.

We've attempted calls with Epicor but they are ... well not very helpful,
sadly although some of their people are really good, it seems like most of
the gen pop support doesn't actually understand/know how to deal with this
kind of issues.

For what is worth we are running on w 2 quad cores with 12 GB of RAM. Which
should be more than enough metal for the number of users we have.

Thanks for your input and i'll let you know if we find anything else.

Also can you share the start / stop script for the DB, apps etc, you
mentioned that the one form epicor is flawed.

Thanks again!

Sincerely
Jose C Gomez

http://www.josecgomez.com

On Mon, Aug 9, 2010 at 11:48 AM, Chris Thompson <chriselectrix@...>wrote:

>
>
> HI Jose,
>
> We have had a number of speed issues with Epicor 9.
>
> If we leave the Apps and DB running for about a week, the system will grind
> to a
> halt and we would have to stop the apps and db and sometimes restart the
> server
> to fix the issue.
>
> Epicor have accepted that this looks like a fault with Progress so the call
> has
> been passed to them.
>
> At present, we have a script in place to stop the apps then the db, then
> restart
> the apps and the db - we run this every night out of hours. If you are
> going to
> do this, please don't use the script from Epicor's answer books as their is
> a
> fault with it. It doesn't wait for the DB to be stopped before trying to
> restart
> the Apps which just ends up in a mess.
>
> Secondly, on a weekend, we stop the apps, stop the db, clear out any temp
> files
> and temp .xml data for reports, defrage all drives on the server, start the
> db,
> start the apps.
>
> So far, we have not had any 'major' slow downs where we have had to kick
> people
> off the system during the working week.
>
> We found that the reports folder (usually epicodata/reports) was getting
> very
> full very fast. Some reports were are in excess of 7GB in size (the xml for
>
> them) so if you run these a few times a month, the folder size increases
> rapidly.
>
> One thing we noticed is that the archive option of 'Never' when you run a
> report
> nearly always doesnt' work. 'Never' would appear to either mean 30 days or
> keep
> forever - hence the reason why the reports folder was building up in size.
>
> What are you classing as slow and what are you comparing against?
>
> Our speed issues have been associated with 'memory leaking' BAQs and BAQs
> which
> crash on you causing the app server to get stuck in a loop.
>
> There are also other things which may speed things up such as increasing
> number
> of App servers and tweaking settings in the mfgsys.mfgsys file (but I would
> get
> advice from Epicor on these).
>
> It is definately worth while logging a call for this issue as something
> definately isn't right. Hopefully your call will be linked with my call and
> we
> should get an answer quicker.
>
> Are you progress or SQL?
>
> Thanks,
>
> CHRIS
>
> ________________________________
> From: Jose Gomez <jose@... <jose%40josecgomez.com>>
> To: Vantage <vantage@yahoogroups.com <vantage%40yahoogroups.com>>
> Sent: Mon, 9 August, 2010 15:14:27
> Subject: [Vantage] Epicor 9 Impossibly slow
>
>
>
> I said las week that epicor 9 was running slower than normal, some of you
> suggested various things but nothing seems to be helping.
>
> Over the weekend, we re-indexed the DB, did a dump and load, truncated the
> bi and god knows what else. It seems to be running awful still
> this morning after all that.
>
> Does anyone have any troubleshooting / tracing / fixing ideas that may help
> us determine where the problem is?
>
> Thank you in advance!
>
> Sincerely
> Jose C Gomez
>
> http://www.josecgomez.com
>
> [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]

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

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/.%c2%a0

(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]

system · August 10, 2010, 8:21am

My PF File looks like this

-Mm 1024 -mmax 65534 -Bt 4096 -s 8000 -yy 1970 -stsh 31 -inp 32000 -tok 4000
-TB 31 -TM 32 -D 500 -l 1000 -ttmarshal 5 -tmpbsize 8 -rereadnolock -lkwtmo
180
-T "C:\Program Files\Epicor Software\EpicorData"
-db "C:\Program Files\Epicor Software\Epicor904\db\mfgsys"
-cpinternal utf-8 -cpstream utf-8 -cprcodein utf-8 -cpcoll icu-uca

Sincerely
Jose C Gomez

http://www.josecgomez.com

On Tue, Aug 10, 2010 at 3:16 AM, Chris Thompson <chriselectrix@...>wrote:

>
>
> Hi Jose,
>
> Have you logged this as a call? If so what call number?
>
> The script we are using is ...
>
> @echo off
> set DLC=E:\epicor904\oe101c
> set PATH=%DLC%\BIN;%PATH%
> set LIB=%DLC%\LIB;%LIB%
>
> echo .
> echo .
> echo RESTARTING LOCAL DB/APPSERVERS...
> call asbman -name Epicor904ProcessServer -stop -port 20940
> call asbman -name Epicor904TaskAgent -stop -port 20940
> call asbman -name Epicor904 -stop -port 20940
> call dbman -host localhost -database Epicor904 -stop -port 20940
>
> :TestStop
> ECHO Testing Lock File
> IF EXIST E:\epicor904\db\mfgsys.lk GOTO TestStop
>
> call dbman -host localhost -database Epicor904 -start -port 20940
> call asbman -name Epicor904 -start -port 20940
> call asbman -name Epicor904TaskAgent -start -port 20940
> call asbman -name Epicor904ProcessServer -start -port 20940
>
> Obviously you will have to change the paths to suit your server setup and
> you
> will probably have to change the port number on each occasion. Also, I
> cannot be
> held responsible for anything that goes wrong with your system when using
> this
> script. It is worthwhile testing it on Pilot or Test first.
>
> The check for the .lk is the bit that was missing from the answer books. It
> is a
> bit of a crude fix, but it does the job.
>
> We have found that the system is much more stable after deleting the old
> reports
> and temp files folders and defragging on a weekend.
>
> Let me know if you want those scripts too.
>
>
> Thanks,
>
> CHRIS
>
> ________________________________
> From: Jose Gomez <jose@... <jose%40josecgomez.com>>
> To: vantage@yahoogroups.com <vantage%40yahoogroups.com>
> Sent: Mon, 9 August, 2010 17:05:06
> Subject: Re: [Vantage] Epicor 9 Impossibly slow
>
>
> Thank you Chris,
> we are running Progress and basically the whole app is running slow, takes
> time to open forms, time to search, time to save, searching for an SO can
> take minutes at times. Loading Invoices into ARGroup can take minutes at
> times.
>
> We've ran through the DB tunning guide today and tweaked all the values we
> could find, and hopefully this will fix some of our issues. But I find it
> absurd that it takes minutes to search for a sales Order, or to save a
> simple 10 line invoice.
>
> We've attempted calls with Epicor but they are ... well not very helpful,
> sadly although some of their people are really good, it seems like most of
> the gen pop support doesn't actually understand/know how to deal with this
> kind of issues.
>
> For what is worth we are running on w 2 quad cores with 12 GB of RAM. Which
> should be more than enough metal for the number of users we have.
>
> Thanks for your input and i'll let you know if we find anything else.
>
> Also can you share the start / stop script for the DB, apps etc, you
> mentioned that the one form epicor is flawed.
>
> Thanks again!
>
> Sincerely
> Jose C Gomez
>
> http://www.josecgomez.com
>
> On Mon, Aug 9, 2010 at 11:48 AM, Chris Thompson <chriselectrix@...<chriselectrix%40ymail.com>
> >wrote:
>
> >
> >
> > HI Jose,
> >
> > We have had a number of speed issues with Epicor 9.
> >
> > If we leave the Apps and DB running for about a week, the system will
> grind
> > to a
> > halt and we would have to stop the apps and db and sometimes restart the
> > server
> > to fix the issue.
> >
> > Epicor have accepted that this looks like a fault with Progress so the
> call
> > has
> > been passed to them.
> >
> > At present, we have a script in place to stop the apps then the db, then
> > restart
> > the apps and the db - we run this every night out of hours. If you are
> > going to
> > do this, please don't use the script from Epicor's answer books as their
> is
> > a
> > fault with it. It doesn't wait for the DB to be stopped before trying to
> > restart
> > the Apps which just ends up in a mess.
> >
> > Secondly, on a weekend, we stop the apps, stop the db, clear out any temp
> > files
> > and temp .xml data for reports, defrage all drives on the server, start
> the
> > db,
> > start the apps.
> >
> > So far, we have not had any 'major' slow downs where we have had to kick
> > people
> > off the system during the working week.
> >
> > We found that the reports folder (usually epicodata/reports) was getting
> > very
> > full very fast. Some reports were are in excess of 7GB in size (the xml
> for
> >
> > them) so if you run these a few times a month, the folder size increases
> > rapidly.
> >
> > One thing we noticed is that the archive option of 'Never' when you run a
> > report
> > nearly always doesnt' work. 'Never' would appear to either mean 30 days
> or
> > keep
> > forever - hence the reason why the reports folder was building up in
> size.
> >
> > What are you classing as slow and what are you comparing against?
> >
> > Our speed issues have been associated with 'memory leaking' BAQs and BAQs
> > which
> > crash on you causing the app server to get stuck in a loop.
> >
> > There are also other things which may speed things up such as increasing
> > number
> > of App servers and tweaking settings in the mfgsys.mfgsys file (but I
> would
> > get
> > advice from Epicor on these).
> >
> > It is definately worth while logging a call for this issue as something
> > definately isn't right. Hopefully your call will be linked with my call
> and
> > we
> > should get an answer quicker.
> >
> > Are you progress or SQL?
> >
> > Thanks,
> >
> > CHRIS
> >
> > ________________________________
> > From: Jose Gomez <jose@... <jose%40josecgomez.com> <jose%
> 40josecgomez.com>>
> > To: Vantage <vantage@yahoogroups.com <vantage%40yahoogroups.com><vantage%
> 40yahoogroups.com>>
>
> > Sent: Mon, 9 August, 2010 15:14:27
> > Subject: [Vantage] Epicor 9 Impossibly slow
> >
> >
> >
> > I said las week that epicor 9 was running slower than normal, some of you
> > suggested various things but nothing seems to be helping.
> >
> > Over the weekend, we re-indexed the DB, did a dump and load, truncated
> the
> > bi and god knows what else. It seems to be running awful still
> > this morning after all that.
> >
> > Does anyone have any troubleshooting / tracing / fixing ideas that may
> help
> > us determine where the problem is?
> >
> > Thank you in advance!
> >
> > Sincerely
> > Jose C Gomez
> >
> > http://www.josecgomez.com
> >
> > [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]
>
> ------------------------------------
>
>
> 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]
>
>
>

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

system · August 10, 2010, 8:25am

Thank you Chris,
I have not done a call yet, I am trying some things on my own, support in my
experience has not been responsive at all.
Sincerely
Jose C Gomez

http://www.josecgomez.com

On Tue, Aug 10, 2010 at 3:16 AM, Chris Thompson <chriselectrix@...>wrote:

>
>
> Hi Jose,
>
> Have you logged this as a call? If so what call number?
>
> The script we are using is ...
>
> @echo off
> set DLC=E:\epicor904\oe101c
> set PATH=%DLC%\BIN;%PATH%
> set LIB=%DLC%\LIB;%LIB%
>
> echo .
> echo .
> echo RESTARTING LOCAL DB/APPSERVERS...
> call asbman -name Epicor904ProcessServer -stop -port 20940
> call asbman -name Epicor904TaskAgent -stop -port 20940
> call asbman -name Epicor904 -stop -port 20940
> call dbman -host localhost -database Epicor904 -stop -port 20940
>
> :TestStop
> ECHO Testing Lock File
> IF EXIST E:\epicor904\db\mfgsys.lk GOTO TestStop
>
> call dbman -host localhost -database Epicor904 -start -port 20940
> call asbman -name Epicor904 -start -port 20940
> call asbman -name Epicor904TaskAgent -start -port 20940
> call asbman -name Epicor904ProcessServer -start -port 20940
>
> Obviously you will have to change the paths to suit your server setup and
> you
> will probably have to change the port number on each occasion. Also, I
> cannot be
> held responsible for anything that goes wrong with your system when using
> this
> script. It is worthwhile testing it on Pilot or Test first.
>
> The check for the .lk is the bit that was missing from the answer books. It
> is a
> bit of a crude fix, but it does the job.
>
> We have found that the system is much more stable after deleting the old
> reports
> and temp files folders and defragging on a weekend.
>
> Let me know if you want those scripts too.
>
>
> Thanks,
>
> CHRIS
>
> ________________________________
> From: Jose Gomez <jose@... <jose%40josecgomez.com>>
> To: vantage@yahoogroups.com <vantage%40yahoogroups.com>
> Sent: Mon, 9 August, 2010 17:05:06
> Subject: Re: [Vantage] Epicor 9 Impossibly slow
>
>
> Thank you Chris,
> we are running Progress and basically the whole app is running slow, takes
> time to open forms, time to search, time to save, searching for an SO can
> take minutes at times. Loading Invoices into ARGroup can take minutes at
> times.
>
> We've ran through the DB tunning guide today and tweaked all the values we
> could find, and hopefully this will fix some of our issues. But I find it
> absurd that it takes minutes to search for a sales Order, or to save a
> simple 10 line invoice.
>
> We've attempted calls with Epicor but they are ... well not very helpful,
> sadly although some of their people are really good, it seems like most of
> the gen pop support doesn't actually understand/know how to deal with this
> kind of issues.
>
> For what is worth we are running on w 2 quad cores with 12 GB of RAM. Which
> should be more than enough metal for the number of users we have.
>
> Thanks for your input and i'll let you know if we find anything else.
>
> Also can you share the start / stop script for the DB, apps etc, you
> mentioned that the one form epicor is flawed.
>
> Thanks again!
>
> Sincerely
> Jose C Gomez
>
> http://www.josecgomez.com
>
> On Mon, Aug 9, 2010 at 11:48 AM, Chris Thompson <chriselectrix@...<chriselectrix%40ymail.com>
> >wrote:
>
> >
> >
> > HI Jose,
> >
> > We have had a number of speed issues with Epicor 9.
> >
> > If we leave the Apps and DB running for about a week, the system will
> grind
> > to a
> > halt and we would have to stop the apps and db and sometimes restart the
> > server
> > to fix the issue.
> >
> > Epicor have accepted that this looks like a fault with Progress so the
> call
> > has
> > been passed to them.
> >
> > At present, we have a script in place to stop the apps then the db, then
> > restart
> > the apps and the db - we run this every night out of hours. If you are
> > going to
> > do this, please don't use the script from Epicor's answer books as their
> is
> > a
> > fault with it. It doesn't wait for the DB to be stopped before trying to
> > restart
> > the Apps which just ends up in a mess.
> >
> > Secondly, on a weekend, we stop the apps, stop the db, clear out any temp
> > files
> > and temp .xml data for reports, defrage all drives on the server, start
> the
> > db,
> > start the apps.
> >
> > So far, we have not had any 'major' slow downs where we have had to kick
> > people
> > off the system during the working week.
> >
> > We found that the reports folder (usually epicodata/reports) was getting
> > very
> > full very fast. Some reports were are in excess of 7GB in size (the xml
> for
> >
> > them) so if you run these a few times a month, the folder size increases
> > rapidly.
> >
> > One thing we noticed is that the archive option of 'Never' when you run a
> > report
> > nearly always doesnt' work. 'Never' would appear to either mean 30 days
> or
> > keep
> > forever - hence the reason why the reports folder was building up in
> size.
> >
> > What are you classing as slow and what are you comparing against?
> >
> > Our speed issues have been associated with 'memory leaking' BAQs and BAQs
> > which
> > crash on you causing the app server to get stuck in a loop.
> >
> > There are also other things which may speed things up such as increasing
> > number
> > of App servers and tweaking settings in the mfgsys.mfgsys file (but I
> would
> > get
> > advice from Epicor on these).
> >
> > It is definately worth while logging a call for this issue as something
> > definately isn't right. Hopefully your call will be linked with my call
> and
> > we
> > should get an answer quicker.
> >
> > Are you progress or SQL?
> >
> > Thanks,
> >
> > CHRIS
> >
> > ________________________________
> > From: Jose Gomez <jose@... <jose%40josecgomez.com> <jose%
> 40josecgomez.com>>
> > To: Vantage <vantage@yahoogroups.com <vantage%40yahoogroups.com><vantage%
> 40yahoogroups.com>>
>
> > Sent: Mon, 9 August, 2010 15:14:27
> > Subject: [Vantage] Epicor 9 Impossibly slow
> >
> >
> >
> > I said las week that epicor 9 was running slower than normal, some of you
> > suggested various things but nothing seems to be helping.
> >
> > Over the weekend, we re-indexed the DB, did a dump and load, truncated
> the
> > bi and god knows what else. It seems to be running awful still
> > this morning after all that.
> >
> > Does anyone have any troubleshooting / tracing / fixing ideas that may
> help
> > us determine where the problem is?
> >
> > Thank you in advance!
> >
> > Sincerely
> > Jose C Gomez
> >
> > http://www.josecgomez.com
> >
> > [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]
>
> ------------------------------------
>
>
> 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]
>
>
>

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

system · August 10, 2010, 8:27am

Hi Jose,

We were recommended by Epicor never to have anything Epicor related on the same
set of disks as the server's operating system.

You currently have ...

-T "C:\Program Files\Epicor Software\EpicorData"
-db "C:\Program Files\Epicor Software\Epicor904\db\mfgsys"

We were told use e.g. drive d or e.

Is this Epicor 9 a new installation or have you been using it for a while and it
has only just started to slow down?

Thanks,

CHRIS

________________________________
From: Jose Gomez <jose@...>
To: vantage@yahoogroups.com
Sent: Tue, 10 August, 2010 13:20:06
Subject: Re: [Vantage] Epicor 9 Impossibly slow

My PF File looks like this

-Mm 1024 -mmax 65534 -Bt 4096 -s 8000 -yy 1970 -stsh 31 -inp 32000 -tok 4000
-TB 31 -TM 32 -D 500 -l 1000 -ttmarshal 5 -tmpbsize 8 -rereadnolock -lkwtmo
180
-T "C:\Program Files\Epicor Software\EpicorData"
-db "C:\Program Files\Epicor Software\Epicor904\db\mfgsys"
-cpinternal utf-8 -cpstream utf-8 -cprcodein utf-8 -cpcoll icu-uca

Sincerely
Jose C Gomez

http://www.josecgomez.com

On Tue, Aug 10, 2010 at 3:16 AM, Chris Thompson <chriselectrix@...>wrote:

>
>
> Hi Jose,
>
> Have you logged this as a call? If so what call number?
>
> The script we are using is ...
>
> @echo off
> set DLC=E:\epicor904\oe101c
> set PATH=%DLC%\BIN;%PATH%
> set LIB=%DLC%\LIB;%LIB%
>
> echo .
> echo .
> echo RESTARTING LOCAL DB/APPSERVERS...
> call asbman -name Epicor904ProcessServer -stop -port 20940
> call asbman -name Epicor904TaskAgent -stop -port 20940
> call asbman -name Epicor904 -stop -port 20940
> call dbman -host localhost -database Epicor904 -stop -port 20940
>
> :TestStop
> ECHO Testing Lock File
> IF EXIST E:\epicor904\db\mfgsys.lk GOTO TestStop
>
> call dbman -host localhost -database Epicor904 -start -port 20940
> call asbman -name Epicor904 -start -port 20940
> call asbman -name Epicor904TaskAgent -start -port 20940
> call asbman -name Epicor904ProcessServer -start -port 20940
>
> Obviously you will have to change the paths to suit your server setup and
> you
> will probably have to change the port number on each occasion. Also, I
> cannot be
> held responsible for anything that goes wrong with your system when using
> this
> script. It is worthwhile testing it on Pilot or Test first.
>
> The check for the .lk is the bit that was missing from the answer books. It
> is a
> bit of a crude fix, but it does the job.
>
> We have found that the system is much more stable after deleting the old
> reports
> and temp files folders and defragging on a weekend.
>
> Let me know if you want those scripts too.
>
>
> Thanks,
>
> CHRIS
>
> ________________________________
> From: Jose Gomez <jose@... <jose%40josecgomez.com>>
> To: vantage@yahoogroups.com <vantage%40yahoogroups.com>
> Sent: Mon, 9 August, 2010 17:05:06
> Subject: Re: [Vantage] Epicor 9 Impossibly slow
>
>
> Thank you Chris,
> we are running Progress and basically the whole app is running slow, takes
> time to open forms, time to search, time to save, searching for an SO can
> take minutes at times. Loading Invoices into ARGroup can take minutes at
> times.
>
> We've ran through the DB tunning guide today and tweaked all the values we
> could find, and hopefully this will fix some of our issues. But I find it
> absurd that it takes minutes to search for a sales Order, or to save a
> simple 10 line invoice.
>
> We've attempted calls with Epicor but they are ... well not very helpful,
> sadly although some of their people are really good, it seems like most of
> the gen pop support doesn't actually understand/know how to deal with this
> kind of issues.
>
> For what is worth we are running on w 2 quad cores with 12 GB of RAM. Which
> should be more than enough metal for the number of users we have.
>
> Thanks for your input and i'll let you know if we find anything else.
>
> Also can you share the start / stop script for the DB, apps etc, you
> mentioned that the one form epicor is flawed.
>
> Thanks again!
>
> Sincerely
> Jose C Gomez
>
> http://www.josecgomez.com
>
> On Mon, Aug 9, 2010 at 11:48 AM, Chris Thompson
><chriselectrix@...<chriselectrix%40ymail.com>
> >wrote:
>
> >
> >
> > HI Jose,
> >
> > We have had a number of speed issues with Epicor 9.
> >
> > If we leave the Apps and DB running for about a week, the system will
> grind
> > to a
> > halt and we would have to stop the apps and db and sometimes restart the
> > server
> > to fix the issue.
> >
> > Epicor have accepted that this looks like a fault with Progress so the
> call
> > has
> > been passed to them.
> >
> > At present, we have a script in place to stop the apps then the db, then
> > restart
> > the apps and the db - we run this every night out of hours. If you are
> > going to
> > do this, please don't use the script from Epicor's answer books as their
> is
> > a
> > fault with it. It doesn't wait for the DB to be stopped before trying to
> > restart
> > the Apps which just ends up in a mess.
> >
> > Secondly, on a weekend, we stop the apps, stop the db, clear out any temp
> > files
> > and temp .xml data for reports, defrage all drives on the server, start
> the
> > db,
> > start the apps.
> >
> > So far, we have not had any 'major' slow downs where we have had to kick
> > people
> > off the system during the working week.
> >
> > We found that the reports folder (usually epicodata/reports) was getting
> > very
> > full very fast. Some reports were are in excess of 7GB in size (the xml
> for
> >
> > them) so if you run these a few times a month, the folder size increases
> > rapidly.
> >
> > One thing we noticed is that the archive option of 'Never' when you run a
> > report
> > nearly always doesnt' work. 'Never' would appear to either mean 30 days
> or
> > keep
> > forever - hence the reason why the reports folder was building up in
> size.
> >
> > What are you classing as slow and what are you comparing against?
> >
> > Our speed issues have been associated with 'memory leaking' BAQs and BAQs
> > which
> > crash on you causing the app server to get stuck in a loop.
> >
> > There are also other things which may speed things up such as increasing
> > number
> > of App servers and tweaking settings in the mfgsys.mfgsys file (but I
> would
> > get
> > advice from Epicor on these).
> >
> > It is definately worth while logging a call for this issue as something
> > definately isn't right. Hopefully your call will be linked with my call
> and
> > we
> > should get an answer quicker.
> >
> > Are you progress or SQL?
> >
> > Thanks,
> >
> > CHRIS
> >
> > ________________________________
> > From: Jose Gomez <jose@... <jose%40josecgomez.com> <jose%
> 40josecgomez.com>>
> > To: Vantage <vantage@yahoogroups.com <vantage%40yahoogroups.com><vantage%
> 40yahoogroups.com>>
>
> > Sent: Mon, 9 August, 2010 15:14:27
> > Subject: [Vantage] Epicor 9 Impossibly slow
> >
> >
> >
> > I said las week that epicor 9 was running slower than normal, some of you
> > suggested various things but nothing seems to be helping.
> >
> > Over the weekend, we re-indexed the DB, did a dump and load, truncated
> the
> > bi and god knows what else. It seems to be running awful still
> > this morning after all that.
> >
> > Does anyone have any troubleshooting / tracing / fixing ideas that may
> help
> > us determine where the problem is?
> >
> > Thank you in advance!
> >
> > Sincerely
> > Jose C Gomez
> >
> > http://www.josecgomez.com
> >
> > [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]
>
> ------------------------------------
>
>
> 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]
>
>Â
>

[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/.%c2%a0

(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]

system · August 10, 2010, 8:29am

We've been using it for a while, its gotten increasingly slow.

Sincerely
Jose C Gomez

http://www.josecgomez.com

On Tue, Aug 10, 2010 at 8:27 AM, Chris Thompson <chriselectrix@...>wrote:

>
>
> Hi Jose,
>
> We were recommended by Epicor never to have anything Epicor related on the
> same
> set of disks as the server's operating system.
>
> You currently have ...
>
>
> -T "C:\Program Files\Epicor Software\EpicorData"
> -db "C:\Program Files\Epicor Software\Epicor904\db\mfgsys"
>
> We were told use e.g. drive d or e.
>
> Is this Epicor 9 a new installation or have you been using it for a while
> and it
> has only just started to slow down?
>
>
> Thanks,
>
> CHRIS
>
> ________________________________
> From: Jose Gomez <jose@... <jose%40josecgomez.com>>
> To: vantage@yahoogroups.com <vantage%40yahoogroups.com>
> Sent: Tue, 10 August, 2010 13:20:06
>
> Subject: Re: [Vantage] Epicor 9 Impossibly slow
>
> My PF File looks like this
>
> -Mm 1024 -mmax 65534 -Bt 4096 -s 8000 -yy 1970 -stsh 31 -inp 32000 -tok
> 4000
> -TB 31 -TM 32 -D 500 -l 1000 -ttmarshal 5 -tmpbsize 8 -rereadnolock -lkwtmo
> 180
> -T "C:\Program Files\Epicor Software\EpicorData"
> -db "C:\Program Files\Epicor Software\Epicor904\db\mfgsys"
> -cpinternal utf-8 -cpstream utf-8 -cprcodein utf-8 -cpcoll icu-uca
>
> Sincerely
> Jose C Gomez
>
> http://www.josecgomez.com
>
> On Tue, Aug 10, 2010 at 3:16 AM, Chris Thompson <chriselectrix@...<chriselectrix%40ymail.com>
> >wrote:
>
> >
> >
> > Hi Jose,
> >
> > Have you logged this as a call? If so what call number?
> >
> > The script we are using is ...
> >
> > @echo off
> > set DLC=E:\epicor904\oe101c
> > set PATH=%DLC%\BIN;%PATH%
> > set LIB=%DLC%\LIB;%LIB%
> >
> > echo .
> > echo .
> > echo RESTARTING LOCAL DB/APPSERVERS...
> > call asbman -name Epicor904ProcessServer -stop -port 20940
> > call asbman -name Epicor904TaskAgent -stop -port 20940
> > call asbman -name Epicor904 -stop -port 20940
> > call dbman -host localhost -database Epicor904 -stop -port 20940
> >
> > :TestStop
> > ECHO Testing Lock File
> > IF EXIST E:\epicor904\db\mfgsys.lk GOTO TestStop
> >
> > call dbman -host localhost -database Epicor904 -start -port 20940
> > call asbman -name Epicor904 -start -port 20940
> > call asbman -name Epicor904TaskAgent -start -port 20940
> > call asbman -name Epicor904ProcessServer -start -port 20940
> >
> > Obviously you will have to change the paths to suit your server setup and
> > you
> > will probably have to change the port number on each occasion. Also, I
> > cannot be
> > held responsible for anything that goes wrong with your system when using
> > this
> > script. It is worthwhile testing it on Pilot or Test first.
> >
> > The check for the .lk is the bit that was missing from the answer books.
> It
> > is a
> > bit of a crude fix, but it does the job.
> >
> > We have found that the system is much more stable after deleting the old
> > reports
> > and temp files folders and defragging on a weekend.
> >
> > Let me know if you want those scripts too.
> >
> >
> > Thanks,
> >
> > CHRIS
> >
> > ________________________________
> > From: Jose Gomez <jose@... <jose%40josecgomez.com> <jose%
> 40josecgomez.com>>
> > To: vantage@yahoogroups.com <vantage%40yahoogroups.com> <vantage%
> 40yahoogroups.com>
>
> > Sent: Mon, 9 August, 2010 17:05:06
> > Subject: Re: [Vantage] Epicor 9 Impossibly slow
> >
> >
> > Thank you Chris,
> > we are running Progress and basically the whole app is running slow,
> takes
> > time to open forms, time to search, time to save, searching for an SO can
> > take minutes at times. Loading Invoices into ARGroup can take minutes at
> > times.
> >
> > We've ran through the DB tunning guide today and tweaked all the values
> we
> > could find, and hopefully this will fix some of our issues. But I find it
> > absurd that it takes minutes to search for a sales Order, or to save a
> > simple 10 line invoice.
> >
> > We've attempted calls with Epicor but they are ... well not very helpful,
> > sadly although some of their people are really good, it seems like most
> of
> > the gen pop support doesn't actually understand/know how to deal with
> this
> > kind of issues.
> >
> > For what is worth we are running on w 2 quad cores with 12 GB of RAM.
> Which
> > should be more than enough metal for the number of users we have.
> >
> > Thanks for your input and i'll let you know if we find anything else.
> >
> > Also can you share the start / stop script for the DB, apps etc, you
> > mentioned that the one form epicor is flawed.
> >
> > Thanks again!
> >
> > Sincerely
> > Jose C Gomez
> >
> > http://www.josecgomez.com
> >
> > On Mon, Aug 9, 2010 at 11:48 AM, Chris Thompson
> ><chriselectrix@... <chriselectrix%40ymail.com><chriselectrix%
> 40ymail.com>
>
> > >wrote:
> >
> > >
> > >
> > > HI Jose,
> > >
> > > We have had a number of speed issues with Epicor 9.
> > >
> > > If we leave the Apps and DB running for about a week, the system will
> > grind
> > > to a
> > > halt and we would have to stop the apps and db and sometimes restart
> the
> > > server
> > > to fix the issue.
> > >
> > > Epicor have accepted that this looks like a fault with Progress so the
> > call
> > > has
> > > been passed to them.
> > >
> > > At present, we have a script in place to stop the apps then the db,
> then
> > > restart
> > > the apps and the db - we run this every night out of hours. If you are
> > > going to
> > > do this, please don't use the script from Epicor's answer books as
> their
> > is
> > > a
> > > fault with it. It doesn't wait for the DB to be stopped before trying
> to
> > > restart
> > > the Apps which just ends up in a mess.
> > >
> > > Secondly, on a weekend, we stop the apps, stop the db, clear out any
> temp
> > > files
> > > and temp .xml data for reports, defrage all drives on the server, start
> > the
> > > db,
> > > start the apps.
> > >
> > > So far, we have not had any 'major' slow downs where we have had to
> kick
> > > people
> > > off the system during the working week.
> > >
> > > We found that the reports folder (usually epicodata/reports) was
> getting
> > > very
> > > full very fast. Some reports were are in excess of 7GB in size (the xml
> > for
> > >
> > > them) so if you run these a few times a month, the folder size
> increases
> > > rapidly.
> > >
> > > One thing we noticed is that the archive option of 'Never' when you run
> a
> > > report
> > > nearly always doesnt' work. 'Never' would appear to either mean 30 days
> > or
> > > keep
> > > forever - hence the reason why the reports folder was building up in
> > size.
> > >
> > > What are you classing as slow and what are you comparing against?
> > >
> > > Our speed issues have been associated with 'memory leaking' BAQs and
> BAQs
> > > which
> > > crash on you causing the app server to get stuck in a loop.
> > >
> > > There are also other things which may speed things up such as
> increasing
> > > number
> > > of App servers and tweaking settings in the mfgsys.mfgsys file (but I
> > would
> > > get
> > > advice from Epicor on these).
> > >
> > > It is definately worth while logging a call for this issue as something
> > > definately isn't right. Hopefully your call will be linked with my call
> > and
> > > we
> > > should get an answer quicker.
> > >
> > > Are you progress or SQL?
> > >
> > > Thanks,
> > >
> > > CHRIS
> > >
> > > ________________________________
> > > From: Jose Gomez <jose@... <jose%40josecgomez.com> <jose%
> 40josecgomez.com> <jose%
> > 40josecgomez.com>>
> > > To: Vantage <vantage@yahoogroups.com <vantage%40yahoogroups.com><vantage%
> 40yahoogroups.com><vantage%
>
> > 40yahoogroups.com>>
> >
> > > Sent: Mon, 9 August, 2010 15:14:27
> > > Subject: [Vantage] Epicor 9 Impossibly slow
> > >
> > >
> > >
> > > I said las week that epicor 9 was running slower than normal, some of
> you
> > > suggested various things but nothing seems to be helping.
> > >
> > > Over the weekend, we re-indexed the DB, did a dump and load, truncated
> > the
> > > bi and god knows what else. It seems to be running awful still
> > > this morning after all that.
> > >
> > > Does anyone have any troubleshooting / tracing / fixing ideas that may
> > help
> > > us determine where the problem is?
> > >
> > > Thank you in advance!
> > >
> > > Sincerely
> > > Jose C Gomez
> > >
> > > http://www.josecgomez.com
> > >
> > > [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]
> >
> > ------------------------------------
> >
> >
> > 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]
> >
> >
> >
>
> [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]
>
>
>

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

system · August 10, 2010, 8:30am

For what is worth, its a VM so there are no physical drives, putting it on E
or C wouldn't make much of a difference in this case.

Sincerely
Jose C Gomez

http://www.josecgomez.com

On Tue, Aug 10, 2010 at 8:27 AM, Chris Thompson <chriselectrix@...>wrote:

>
>
> Hi Jose,
>
> We were recommended by Epicor never to have anything Epicor related on the
> same
> set of disks as the server's operating system.
>
> You currently have ...
>
>
> -T "C:\Program Files\Epicor Software\EpicorData"
> -db "C:\Program Files\Epicor Software\Epicor904\db\mfgsys"
>
> We were told use e.g. drive d or e.
>
> Is this Epicor 9 a new installation or have you been using it for a while
> and it
> has only just started to slow down?
>
>
> Thanks,
>
> CHRIS
>
> ________________________________
> From: Jose Gomez <jose@... <jose%40josecgomez.com>>
> To: vantage@yahoogroups.com <vantage%40yahoogroups.com>
> Sent: Tue, 10 August, 2010 13:20:06
>
> Subject: Re: [Vantage] Epicor 9 Impossibly slow
>
> My PF File looks like this
>
> -Mm 1024 -mmax 65534 -Bt 4096 -s 8000 -yy 1970 -stsh 31 -inp 32000 -tok
> 4000
> -TB 31 -TM 32 -D 500 -l 1000 -ttmarshal 5 -tmpbsize 8 -rereadnolock -lkwtmo
> 180
> -T "C:\Program Files\Epicor Software\EpicorData"
> -db "C:\Program Files\Epicor Software\Epicor904\db\mfgsys"
> -cpinternal utf-8 -cpstream utf-8 -cprcodein utf-8 -cpcoll icu-uca
>
> Sincerely
> Jose C Gomez
>
> http://www.josecgomez.com
>
> On Tue, Aug 10, 2010 at 3:16 AM, Chris Thompson <chriselectrix@...<chriselectrix%40ymail.com>
> >wrote:
>
> >
> >
> > Hi Jose,
> >
> > Have you logged this as a call? If so what call number?
> >
> > The script we are using is ...
> >
> > @echo off
> > set DLC=E:\epicor904\oe101c
> > set PATH=%DLC%\BIN;%PATH%
> > set LIB=%DLC%\LIB;%LIB%
> >
> > echo .
> > echo .
> > echo RESTARTING LOCAL DB/APPSERVERS...
> > call asbman -name Epicor904ProcessServer -stop -port 20940
> > call asbman -name Epicor904TaskAgent -stop -port 20940
> > call asbman -name Epicor904 -stop -port 20940
> > call dbman -host localhost -database Epicor904 -stop -port 20940
> >
> > :TestStop
> > ECHO Testing Lock File
> > IF EXIST E:\epicor904\db\mfgsys.lk GOTO TestStop
> >
> > call dbman -host localhost -database Epicor904 -start -port 20940
> > call asbman -name Epicor904 -start -port 20940
> > call asbman -name Epicor904TaskAgent -start -port 20940
> > call asbman -name Epicor904ProcessServer -start -port 20940
> >
> > Obviously you will have to change the paths to suit your server setup and
> > you
> > will probably have to change the port number on each occasion. Also, I
> > cannot be
> > held responsible for anything that goes wrong with your system when using
> > this
> > script. It is worthwhile testing it on Pilot or Test first.
> >
> > The check for the .lk is the bit that was missing from the answer books.
> It
> > is a
> > bit of a crude fix, but it does the job.
> >
> > We have found that the system is much more stable after deleting the old
> > reports
> > and temp files folders and defragging on a weekend.
> >
> > Let me know if you want those scripts too.
> >
> >
> > Thanks,
> >
> > CHRIS
> >
> > ________________________________
> > From: Jose Gomez <jose@... <jose%40josecgomez.com> <jose%
> 40josecgomez.com>>
> > To: vantage@yahoogroups.com <vantage%40yahoogroups.com> <vantage%
> 40yahoogroups.com>
>
> > Sent: Mon, 9 August, 2010 17:05:06
> > Subject: Re: [Vantage] Epicor 9 Impossibly slow
> >
> >
> > Thank you Chris,
> > we are running Progress and basically the whole app is running slow,
> takes
> > time to open forms, time to search, time to save, searching for an SO can
> > take minutes at times. Loading Invoices into ARGroup can take minutes at
> > times.
> >
> > We've ran through the DB tunning guide today and tweaked all the values
> we
> > could find, and hopefully this will fix some of our issues. But I find it
> > absurd that it takes minutes to search for a sales Order, or to save a
> > simple 10 line invoice.
> >
> > We've attempted calls with Epicor but they are ... well not very helpful,
> > sadly although some of their people are really good, it seems like most
> of
> > the gen pop support doesn't actually understand/know how to deal with
> this
> > kind of issues.
> >
> > For what is worth we are running on w 2 quad cores with 12 GB of RAM.
> Which
> > should be more than enough metal for the number of users we have.
> >
> > Thanks for your input and i'll let you know if we find anything else.
> >
> > Also can you share the start / stop script for the DB, apps etc, you
> > mentioned that the one form epicor is flawed.
> >
> > Thanks again!
> >
> > Sincerely
> > Jose C Gomez
> >
> > http://www.josecgomez.com
> >
> > On Mon, Aug 9, 2010 at 11:48 AM, Chris Thompson
> ><chriselectrix@... <chriselectrix%40ymail.com><chriselectrix%
> 40ymail.com>
>
> > >wrote:
> >
> > >
> > >
> > > HI Jose,
> > >
> > > We have had a number of speed issues with Epicor 9.
> > >
> > > If we leave the Apps and DB running for about a week, the system will
> > grind
> > > to a
> > > halt and we would have to stop the apps and db and sometimes restart
> the
> > > server
> > > to fix the issue.
> > >
> > > Epicor have accepted that this looks like a fault with Progress so the
> > call
> > > has
> > > been passed to them.
> > >
> > > At present, we have a script in place to stop the apps then the db,
> then
> > > restart
> > > the apps and the db - we run this every night out of hours. If you are
> > > going to
> > > do this, please don't use the script from Epicor's answer books as
> their
> > is
> > > a
> > > fault with it. It doesn't wait for the DB to be stopped before trying
> to
> > > restart
> > > the Apps which just ends up in a mess.
> > >
> > > Secondly, on a weekend, we stop the apps, stop the db, clear out any
> temp
> > > files
> > > and temp .xml data for reports, defrage all drives on the server, start
> > the
> > > db,
> > > start the apps.
> > >
> > > So far, we have not had any 'major' slow downs where we have had to
> kick
> > > people
> > > off the system during the working week.
> > >
> > > We found that the reports folder (usually epicodata/reports) was
> getting
> > > very
> > > full very fast. Some reports were are in excess of 7GB in size (the xml
> > for
> > >
> > > them) so if you run these a few times a month, the folder size
> increases
> > > rapidly.
> > >
> > > One thing we noticed is that the archive option of 'Never' when you run
> a
> > > report
> > > nearly always doesnt' work. 'Never' would appear to either mean 30 days
> > or
> > > keep
> > > forever - hence the reason why the reports folder was building up in
> > size.
> > >
> > > What are you classing as slow and what are you comparing against?
> > >
> > > Our speed issues have been associated with 'memory leaking' BAQs and
> BAQs
> > > which
> > > crash on you causing the app server to get stuck in a loop.
> > >
> > > There are also other things which may speed things up such as
> increasing
> > > number
> > > of App servers and tweaking settings in the mfgsys.mfgsys file (but I
> > would
> > > get
> > > advice from Epicor on these).
> > >
> > > It is definately worth while logging a call for this issue as something
> > > definately isn't right. Hopefully your call will be linked with my call
> > and
> > > we
> > > should get an answer quicker.
> > >
> > > Are you progress or SQL?
> > >
> > > Thanks,
> > >
> > > CHRIS
> > >
> > > ________________________________
> > > From: Jose Gomez <jose@... <jose%40josecgomez.com> <jose%
> 40josecgomez.com> <jose%
> > 40josecgomez.com>>
> > > To: Vantage <vantage@yahoogroups.com <vantage%40yahoogroups.com><vantage%
> 40yahoogroups.com><vantage%
>
> > 40yahoogroups.com>>
> >
> > > Sent: Mon, 9 August, 2010 15:14:27
> > > Subject: [Vantage] Epicor 9 Impossibly slow
> > >
> > >
> > >
> > > I said las week that epicor 9 was running slower than normal, some of
> you
> > > suggested various things but nothing seems to be helping.
> > >
> > > Over the weekend, we re-indexed the DB, did a dump and load, truncated
> > the
> > > bi and god knows what else. It seems to be running awful still
> > > this morning after all that.
> > >
> > > Does anyone have any troubleshooting / tracing / fixing ideas that may
> > help
> > > us determine where the problem is?
> > >
> > > Thank you in advance!
> > >
> > > Sincerely
> > > Jose C Gomez
> > >
> > > http://www.josecgomez.com
> > >
> > > [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]
> >
> > ------------------------------------
> >
> >
> > 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]
> >
> >
> >
>
> [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]
>
>
>

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

system · August 10, 2010, 9:25am

Did you defrag after you did the dump and load?

How many .d1 files do you have for your live db?

________________________________
From: Jose Gomez <jose@...>
To: vantage@yahoogroups.com
Sent: Tue, 10 August, 2010 13:29:54
Subject: Re: [Vantage] Epicor 9 Impossibly slow

For what is worth, its a VM so there are no physical drives, putting it on E
or C wouldn't make much of a difference in this case.

Sincerely
Jose C Gomez

http://www.josecgomez.com

On Tue, Aug 10, 2010 at 8:27 AM, Chris Thompson <chriselectrix@...>wrote:

>
>
> Hi Jose,
>
> We were recommended by Epicor never to have anything Epicor related on the
> same
> set of disks as the server's operating system.
>
> You currently have ...
>
>
> -T "C:\Program Files\Epicor Software\EpicorData"
> -db "C:\Program Files\Epicor Software\Epicor904\db\mfgsys"
>
> We were told use e.g. drive d or e.
>
> Is this Epicor 9 a new installation or have you been using it for a while
> and it
> has only just started to slow down?
>
>
> Thanks,
>
> CHRIS
>
> ________________________________
> From: Jose Gomez <jose@... <jose%40josecgomez.com>>
> To: vantage@yahoogroups.com <vantage%40yahoogroups.com>
> Sent: Tue, 10 August, 2010 13:20:06
>
> Subject: Re: [Vantage] Epicor 9 Impossibly slow
>
> My PF File looks like this
>
> -Mm 1024 -mmax 65534 -Bt 4096 -s 8000 -yy 1970 -stsh 31 -inp 32000 -tok
> 4000
> -TB 31 -TM 32 -D 500 -l 1000 -ttmarshal 5 -tmpbsize 8 -rereadnolock -lkwtmo
> 180
> -T "C:\Program Files\Epicor Software\EpicorData"
> -db "C:\Program Files\Epicor Software\Epicor904\db\mfgsys"
> -cpinternal utf-8 -cpstream utf-8 -cprcodein utf-8 -cpcoll icu-uca
>
> Sincerely
> Jose C Gomez
>
> http://www.josecgomez.com
>
> On Tue, Aug 10, 2010 at 3:16 AM, Chris Thompson
><chriselectrix@...<chriselectrix%40ymail.com>
> >wrote:
>
> >
> >
> > Hi Jose,
> >
> > Have you logged this as a call? If so what call number?
> >
> > The script we are using is ...
> >
> > @echo off
> > set DLC=E:\epicor904\oe101c
> > set PATH=%DLC%\BIN;%PATH%
> > set LIB=%DLC%\LIB;%LIB%
> >
> > echo .
> > echo .
> > echo RESTARTING LOCAL DB/APPSERVERS...
> > call asbman -name Epicor904ProcessServer -stop -port 20940
> > call asbman -name Epicor904TaskAgent -stop -port 20940
> > call asbman -name Epicor904 -stop -port 20940
> > call dbman -host localhost -database Epicor904 -stop -port 20940
> >
> > :TestStop
> > ECHO Testing Lock File
> > IF EXIST E:\epicor904\db\mfgsys.lk GOTO TestStop
> >
> > call dbman -host localhost -database Epicor904 -start -port 20940
> > call asbman -name Epicor904 -start -port 20940
> > call asbman -name Epicor904TaskAgent -start -port 20940
> > call asbman -name Epicor904ProcessServer -start -port 20940
> >
> > Obviously you will have to change the paths to suit your server setup and
> > you
> > will probably have to change the port number on each occasion. Also, I
> > cannot be
> > held responsible for anything that goes wrong with your system when using
> > this
> > script. It is worthwhile testing it on Pilot or Test first.
> >
> > The check for the .lk is the bit that was missing from the answer books.
> It
> > is a
> > bit of a crude fix, but it does the job.
> >
> > We have found that the system is much more stable after deleting the old
> > reports
> > and temp files folders and defragging on a weekend.
> >
> > Let me know if you want those scripts too.
> >
> >
> > Thanks,
> >
> > CHRIS
> >
> > ________________________________
> > From: Jose Gomez <jose@... <jose%40josecgomez.com> <jose%
> 40josecgomez.com>>
> > To: vantage@yahoogroups.com <vantage%40yahoogroups.com> <vantage%
> 40yahoogroups.com>
>
> > Sent: Mon, 9 August, 2010 17:05:06
> > Subject: Re: [Vantage] Epicor 9 Impossibly slow
> >
> >
> > Thank you Chris,
> > we are running Progress and basically the whole app is running slow,
> takes
> > time to open forms, time to search, time to save, searching for an SO can
> > take minutes at times. Loading Invoices into ARGroup can take minutes at
> > times.
> >
> > We've ran through the DB tunning guide today and tweaked all the values
> we
> > could find, and hopefully this will fix some of our issues. But I find it
> > absurd that it takes minutes to search for a sales Order, or to save a
> > simple 10 line invoice.
> >
> > We've attempted calls with Epicor but they are ... well not very helpful,
> > sadly although some of their people are really good, it seems like most
> of
> > the gen pop support doesn't actually understand/know how to deal with
> this
> > kind of issues.
> >
> > For what is worth we are running on w 2 quad cores with 12 GB of RAM.
> Which
> > should be more than enough metal for the number of users we have.
> >
> > Thanks for your input and i'll let you know if we find anything else.
> >
> > Also can you share the start / stop script for the DB, apps etc, you
> > mentioned that the one form epicor is flawed.
> >
> > Thanks again!
> >
> > Sincerely
> > Jose C Gomez
> >
> > http://www.josecgomez.com
> >
> > On Mon, Aug 9, 2010 at 11:48 AM, Chris Thompson
> ><chriselectrix@... <chriselectrix%40ymail.com><chriselectrix%
> 40ymail.com>
>
> > >wrote:
> >
> > >
> > >
> > > HI Jose,
> > >
> > > We have had a number of speed issues with Epicor 9.
> > >
> > > If we leave the Apps and DB running for about a week, the system will
> > grind
> > > to a
> > > halt and we would have to stop the apps and db and sometimes restart
> the
> > > server
> > > to fix the issue.
> > >
> > > Epicor have accepted that this looks like a fault with Progress so the
> > call
> > > has
> > > been passed to them.
> > >
> > > At present, we have a script in place to stop the apps then the db,
> then
> > > restart
> > > the apps and the db - we run this every night out of hours. If you are
> > > going to
> > > do this, please don't use the script from Epicor's answer books as
> their
> > is
> > > a
> > > fault with it. It doesn't wait for the DB to be stopped before trying
> to
> > > restart
> > > the Apps which just ends up in a mess.
> > >
> > > Secondly, on a weekend, we stop the apps, stop the db, clear out any
> temp
> > > files
> > > and temp .xml data for reports, defrage all drives on the server, start
> > the
> > > db,
> > > start the apps.
> > >
> > > So far, we have not had any 'major' slow downs where we have had to
> kick
> > > people
> > > off the system during the working week.
> > >
> > > We found that the reports folder (usually epicodata/reports) was
> getting
> > > very
> > > full very fast. Some reports were are in excess of 7GB in size (the xml
> > for
> > >
> > > them) so if you run these a few times a month, the folder size
> increases
> > > rapidly.
> > >
> > > One thing we noticed is that the archive option of 'Never' when you run
> a
> > > report
> > > nearly always doesnt' work. 'Never' would appear to either mean 30 days
> > or
> > > keep
> > > forever - hence the reason why the reports folder was building up in
> > size.
> > >
> > > What are you classing as slow and what are you comparing against?
> > >
> > > Our speed issues have been associated with 'memory leaking' BAQs and
> BAQs
> > > which
> > > crash on you causing the app server to get stuck in a loop.
> > >
> > > There are also other things which may speed things up such as
> increasing
> > > number
> > > of App servers and tweaking settings in the mfgsys.mfgsys file (but I
> > would
> > > get
> > > advice from Epicor on these).
> > >
> > > It is definately worth while logging a call for this issue as something
> > > definately isn't right. Hopefully your call will be linked with my call
> > and
> > > we
> > > should get an answer quicker.
> > >
> > > Are you progress or SQL?
> > >
> > > Thanks,
> > >
> > > CHRIS
> > >
> > > ________________________________
> > > From: Jose Gomez <jose@... <jose%40josecgomez.com> <jose%
> 40josecgomez.com> <jose%
> > 40josecgomez.com>>
> > > To: Vantage <vantage@yahoogroups.com <vantage%40yahoogroups.com><vantage%
> 40yahoogroups.com><vantage%
>
> > 40yahoogroups.com>>
> >
> > > Sent: Mon, 9 August, 2010 15:14:27
> > > Subject: [Vantage] Epicor 9 Impossibly slow
> > >
> > >
> > >
> > > I said las week that epicor 9 was running slower than normal, some of
> you
> > > suggested various things but nothing seems to be helping.
> > >
> > > Over the weekend, we re-indexed the DB, did a dump and load, truncated
> > the
> > > bi and god knows what else. It seems to be running awful still
> > > this morning after all that.
> > >
> > > Does anyone have any troubleshooting / tracing / fixing ideas that may
> > help
> > > us determine where the problem is?
> > >
> > > Thank you in advance!
> > >
> > > Sincerely
> > > Jose C Gomez
> > >
> > > http://www.josecgomez.com
> > >
> > > [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]
> >
> > ------------------------------------
> >
> >
> > 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]
> >
> >
> >
>
> [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]
>
>Â
>

[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/.%c2%a0

(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]

system · August 10, 2010, 9:29am

Hey Chris,

Yes we defraged, I only have 1 d1 file 5 GB

Sincerely
Jose C Gomez

http://www.josecgomez.com

On Tue, Aug 10, 2010 at 9:15 AM, Chris Thompson <chriselectrix@...>wrote:

>
>
> Did you defrag after you did the dump and load?
>
> How many .d1 files do you have for your live db?
>
>
> ________________________________
> From: Jose Gomez <jose@... <jose%40josecgomez.com>>
> To: vantage@yahoogroups.com <vantage%40yahoogroups.com>
> Sent: Tue, 10 August, 2010 13:29:54
>
> Subject: Re: [Vantage] Epicor 9 Impossibly slow
>
> For what is worth, its a VM so there are no physical drives, putting it on
> E
> or C wouldn't make much of a difference in this case.
>
> Sincerely
> Jose C Gomez
>
> http://www.josecgomez.com
>
> On Tue, Aug 10, 2010 at 8:27 AM, Chris Thompson <chriselectrix@...<chriselectrix%40ymail.com>
> >wrote:
>
> >
> >
> > Hi Jose,
> >
> > We were recommended by Epicor never to have anything Epicor related on
> the
> > same
> > set of disks as the server's operating system.
> >
> > You currently have ...
> >
> >
> > -T "C:\Program Files\Epicor Software\EpicorData"
> > -db "C:\Program Files\Epicor Software\Epicor904\db\mfgsys"
> >
> > We were told use e.g. drive d or e.
> >
> > Is this Epicor 9 a new installation or have you been using it for a while
> > and it
> > has only just started to slow down?
> >
> >
> > Thanks,
> >
> > CHRIS
> >
> > ________________________________
> > From: Jose Gomez <jose@... <jose%40josecgomez.com> <jose%
> 40josecgomez.com>>
> > To: vantage@yahoogroups.com <vantage%40yahoogroups.com> <vantage%
> 40yahoogroups.com>
> > Sent: Tue, 10 August, 2010 13:20:06
> >
> > Subject: Re: [Vantage] Epicor 9 Impossibly slow
> >
> > My PF File looks like this
> >
> > -Mm 1024 -mmax 65534 -Bt 4096 -s 8000 -yy 1970 -stsh 31 -inp 32000 -tok
> > 4000
> > -TB 31 -TM 32 -D 500 -l 1000 -ttmarshal 5 -tmpbsize 8 -rereadnolock
> -lkwtmo
> > 180
> > -T "C:\Program Files\Epicor Software\EpicorData"
> > -db "C:\Program Files\Epicor Software\Epicor904\db\mfgsys"
> > -cpinternal utf-8 -cpstream utf-8 -cprcodein utf-8 -cpcoll icu-uca
> >
> > Sincerely
> > Jose C Gomez
> >
> > http://www.josecgomez.com
> >
> > On Tue, Aug 10, 2010 at 3:16 AM, Chris Thompson
> ><chriselectrix@... <chriselectrix%40ymail.com><chriselectrix%
> 40ymail.com>
>
> > >wrote:
> >
> > >
> > >
> > > Hi Jose,
> > >
> > > Have you logged this as a call? If so what call number?
> > >
> > > The script we are using is ...
> > >
> > > @echo off
> > > set DLC=E:\epicor904\oe101c
> > > set PATH=%DLC%\BIN;%PATH%
> > > set LIB=%DLC%\LIB;%LIB%
> > >
> > > echo .
> > > echo .
> > > echo RESTARTING LOCAL DB/APPSERVERS...
> > > call asbman -name Epicor904ProcessServer -stop -port 20940
> > > call asbman -name Epicor904TaskAgent -stop -port 20940
> > > call asbman -name Epicor904 -stop -port 20940
> > > call dbman -host localhost -database Epicor904 -stop -port 20940
> > >
> > > :TestStop
> > > ECHO Testing Lock File
> > > IF EXIST E:\epicor904\db\mfgsys.lk GOTO TestStop
> > >
> > > call dbman -host localhost -database Epicor904 -start -port 20940
> > > call asbman -name Epicor904 -start -port 20940
> > > call asbman -name Epicor904TaskAgent -start -port 20940
> > > call asbman -name Epicor904ProcessServer -start -port 20940
> > >
> > > Obviously you will have to change the paths to suit your server setup
> and
> > > you
> > > will probably have to change the port number on each occasion. Also, I
> > > cannot be
> > > held responsible for anything that goes wrong with your system when
> using
> > > this
> > > script. It is worthwhile testing it on Pilot or Test first.
> > >
> > > The check for the .lk is the bit that was missing from the answer
> books.
> > It
> > > is a
> > > bit of a crude fix, but it does the job.
> > >
> > > We have found that the system is much more stable after deleting the
> old
> > > reports
> > > and temp files folders and defragging on a weekend.
> > >
> > > Let me know if you want those scripts too.
> > >
> > >
> > > Thanks,
> > >
> > > CHRIS
> > >
> > > ________________________________
> > > From: Jose Gomez <jose@... <jose%40josecgomez.com> <jose%
> 40josecgomez.com> <jose%
> > 40josecgomez.com>>
> > > To: vantage@yahoogroups.com <vantage%40yahoogroups.com> <vantage%
> 40yahoogroups.com> <vantage%
>
> > 40yahoogroups.com>
> >
> > > Sent: Mon, 9 August, 2010 17:05:06
> > > Subject: Re: [Vantage] Epicor 9 Impossibly slow
> > >
> > >
> > > Thank you Chris,
> > > we are running Progress and basically the whole app is running slow,
> > takes
> > > time to open forms, time to search, time to save, searching for an SO
> can
> > > take minutes at times. Loading Invoices into ARGroup can take minutes
> at
> > > times.
> > >
> > > We've ran through the DB tunning guide today and tweaked all the values
> > we
> > > could find, and hopefully this will fix some of our issues. But I find
> it
> > > absurd that it takes minutes to search for a sales Order, or to save a
> > > simple 10 line invoice.
> > >
> > > We've attempted calls with Epicor but they are ... well not very
> helpful,
> > > sadly although some of their people are really good, it seems like most
> > of
> > > the gen pop support doesn't actually understand/know how to deal with
> > this
> > > kind of issues.
> > >
> > > For what is worth we are running on w 2 quad cores with 12 GB of RAM.
> > Which
> > > should be more than enough metal for the number of users we have.
> > >
> > > Thanks for your input and i'll let you know if we find anything else.
> > >
> > > Also can you share the start / stop script for the DB, apps etc, you
> > > mentioned that the one form epicor is flawed.
> > >
> > > Thanks again!
> > >
> > > Sincerely
> > > Jose C Gomez
> > >
> > > http://www.josecgomez.com
> > >
> > > On Mon, Aug 9, 2010 at 11:48 AM, Chris Thompson
> > ><chriselectrix@... <chriselectrix%40ymail.com> <chriselectrix%
> 40ymail.com><chriselectrix%
>
> > 40ymail.com>
> >
> > > >wrote:
> > >
> > > >
> > > >
> > > > HI Jose,
> > > >
> > > > We have had a number of speed issues with Epicor 9.
> > > >
> > > > If we leave the Apps and DB running for about a week, the system will
> > > grind
> > > > to a
> > > > halt and we would have to stop the apps and db and sometimes restart
> > the
> > > > server
> > > > to fix the issue.
> > > >
> > > > Epicor have accepted that this looks like a fault with Progress so
> the
> > > call
> > > > has
> > > > been passed to them.
> > > >
> > > > At present, we have a script in place to stop the apps then the db,
> > then
> > > > restart
> > > > the apps and the db - we run this every night out of hours. If you
> are
> > > > going to
> > > > do this, please don't use the script from Epicor's answer books as
> > their
> > > is
> > > > a
> > > > fault with it. It doesn't wait for the DB to be stopped before trying
> > to
> > > > restart
> > > > the Apps which just ends up in a mess.
> > > >
> > > > Secondly, on a weekend, we stop the apps, stop the db, clear out any
> > temp
> > > > files
> > > > and temp .xml data for reports, defrage all drives on the server,
> start
> > > the
> > > > db,
> > > > start the apps.
> > > >
> > > > So far, we have not had any 'major' slow downs where we have had to
> > kick
> > > > people
> > > > off the system during the working week.
> > > >
> > > > We found that the reports folder (usually epicodata/reports) was
> > getting
> > > > very
> > > > full very fast. Some reports were are in excess of 7GB in size (the
> xml
> > > for
> > > >
> > > > them) so if you run these a few times a month, the folder size
> > increases
> > > > rapidly.
> > > >
> > > > One thing we noticed is that the archive option of 'Never' when you
> run
> > a
> > > > report
> > > > nearly always doesnt' work. 'Never' would appear to either mean 30
> days
> > > or
> > > > keep
> > > > forever - hence the reason why the reports folder was building up in
> > > size.
> > > >
> > > > What are you classing as slow and what are you comparing against?
> > > >
> > > > Our speed issues have been associated with 'memory leaking' BAQs and
> > BAQs
> > > > which
> > > > crash on you causing the app server to get stuck in a loop.
> > > >
> > > > There are also other things which may speed things up such as
> > increasing
> > > > number
> > > > of App servers and tweaking settings in the mfgsys.mfgsys file (but I
> > > would
> > > > get
> > > > advice from Epicor on these).
> > > >
> > > > It is definately worth while logging a call for this issue as
> something
> > > > definately isn't right. Hopefully your call will be linked with my
> call
> > > and
> > > > we
> > > > should get an answer quicker.
> > > >
> > > > Are you progress or SQL?
> > > >
> > > > Thanks,
> > > >
> > > > CHRIS
> > > >
> > > > ________________________________
> > > > From: Jose Gomez <jose@... <jose%40josecgomez.com> <jose%
> 40josecgomez.com> <jose%
> > 40josecgomez.com> <jose%
> > > 40josecgomez.com>>
> > > > To: Vantage <vantage@yahoogroups.com <vantage%40yahoogroups.com><vantage%
> 40yahoogroups.com><vantage%
> > 40yahoogroups.com><vantage%
> >
> > > 40yahoogroups.com>>
> > >
> > > > Sent: Mon, 9 August, 2010 15:14:27
> > > > Subject: [Vantage] Epicor 9 Impossibly slow
> > > >
> > > >
> > > >
> > > > I said las week that epicor 9 was running slower than normal, some of
> > you
> > > > suggested various things but nothing seems to be helping.
> > > >
> > > > Over the weekend, we re-indexed the DB, did a dump and load,
> truncated
> > > the
> > > > bi and god knows what else. It seems to be running awful still
> > > > this morning after all that.
> > > >
> > > > Does anyone have any troubleshooting / tracing / fixing ideas that
> may
> > > help
> > > > us determine where the problem is?
> > > >
> > > > Thank you in advance!
> > > >
> > > > Sincerely
> > > > Jose C Gomez
> > > >
> > > > http://www.josecgomez.com
> > > >
> > > > [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]
> > >
> > > ------------------------------------
> > >
> > >
> > > 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]
> > >
> > >
> > >
> >
> > [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]
> >
> >
> >
>
> [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]
>
>
>

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

system · August 10, 2010, 9:42am

Well there are a few fixes you can do...

1: Update to -Mm 4096, that will help you some, you could possibly go
higher, but I have never found a need for it, 4096 is pretty default.
2: Update to -s 12000, that will help as well, also depends how much RAM you
have allocated, but that 50% jump can add a lot.

Also, you mention that you are running on a VM, depending how you have your
VMs setup, that right there is going to rip your performance right down.

What do you have for a VM setup? ESX? SAN? NAS? Internal Drives? How are the
drives broken up for use?

A lot of people don't realize the performance hit you will take when you are
using a VM and don't dedicate drives the same way you would a physical
machine, you can very easily create a bottleneck for the data which can make
even the "fastest" machines slower than a turtle stuck in molasses.

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Jose Gomez
Sent: Tuesday, August 10, 2010 8:20 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Epicor 9 Impossibly slow

My PF File looks like this

-Mm 1024 -mmax 65534 -Bt 4096 -s 8000 -yy 1970 -stsh 31 -inp 32000 -tok 4000
-TB 31 -TM 32 -D 500 -l 1000 -ttmarshal 5 -tmpbsize 8 -rereadnolock -lkwtmo
180
-T "C:\Program Files\Epicor Software\EpicorData"
-db "C:\Program Files\Epicor Software\Epicor904\db\mfgsys"
-cpinternal utf-8 -cpstream utf-8 -cprcodein utf-8 -cpcoll icu-uca

Sincerely
Jose C Gomez

http://www.josecgomez.com

On Tue, Aug 10, 2010 at 3:16 AM, Chris Thompson
<chriselectrix@...>wrote:

>
>
> Hi Jose,
>
> Have you logged this as a call? If so what call number?
>
> The script we are using is ...
>
> @echo off
> set DLC=E:\epicor904\oe101c
> set PATH=%DLC%\BIN;%PATH%
> set LIB=%DLC%\LIB;%LIB%
>
> echo .
> echo .
> echo RESTARTING LOCAL DB/APPSERVERS...
> call asbman -name Epicor904ProcessServer -stop -port 20940 call asbman
> -name Epicor904TaskAgent -stop -port 20940 call asbman -name Epicor904
> -stop -port 20940 call dbman -host localhost -database Epicor904 -stop
> -port 20940
>
> :TestStop
> ECHO Testing Lock File
> IF EXIST E:\epicor904\db\mfgsys.lk GOTO TestStop
>
> call dbman -host localhost -database Epicor904 -start -port 20940 call
> asbman -name Epicor904 -start -port 20940 call asbman -name
> Epicor904TaskAgent -start -port 20940 call asbman -name
> Epicor904ProcessServer -start -port 20940
>
> Obviously you will have to change the paths to suit your server setup
> and you will probably have to change the port number on each occasion.
> Also, I cannot be held responsible for anything that goes wrong with
> your system when using this script. It is worthwhile testing it on
> Pilot or Test first.
>
> The check for the .lk is the bit that was missing from the answer
> books. It is a bit of a crude fix, but it does the job.
>
> We have found that the system is much more stable after deleting the
> old reports and temp files folders and defragging on a weekend.
>
> Let me know if you want those scripts too.
>
>
> Thanks,
>
> CHRIS
>
> ________________________________
> From: Jose Gomez <jose@... <jose%40josecgomez.com>>
> To: vantage@yahoogroups.com <vantage%40yahoogroups.com>
> Sent: Mon, 9 August, 2010 17:05:06
> Subject: Re: [Vantage] Epicor 9 Impossibly slow
>
>
> Thank you Chris,
> we are running Progress and basically the whole app is running slow,
> takes time to open forms, time to search, time to save, searching for
> an SO can take minutes at times. Loading Invoices into ARGroup can
> take minutes at times.
>
> We've ran through the DB tunning guide today and tweaked all the
> values we could find, and hopefully this will fix some of our issues.
> But I find it absurd that it takes minutes to search for a sales
> Order, or to save a simple 10 line invoice.
>
> We've attempted calls with Epicor but they are ... well not very
> helpful, sadly although some of their people are really good, it seems
> like most of the gen pop support doesn't actually understand/know how
> to deal with this kind of issues.
>
> For what is worth we are running on w 2 quad cores with 12 GB of RAM.
> Which should be more than enough metal for the number of users we have.
>
> Thanks for your input and i'll let you know if we find anything else.
>
> Also can you share the start / stop script for the DB, apps etc, you
> mentioned that the one form epicor is flawed.
>
> Thanks again!
>
> Sincerely
> Jose C Gomez
>
> http://www.josecgomez.com
>
> On Mon, Aug 9, 2010 at 11:48 AM, Chris Thompson
> <chriselectrix@...<chriselectrix%40ymail.com>
> >wrote:
>
> >
> >
> > HI Jose,
> >
> > We have had a number of speed issues with Epicor 9.
> >
> > If we leave the Apps and DB running for about a week, the system
> > will
> grind
> > to a
> > halt and we would have to stop the apps and db and sometimes restart
> > the server to fix the issue.
> >
> > Epicor have accepted that this looks like a fault with Progress so
> > the
> call
> > has
> > been passed to them.
> >
> > At present, we have a script in place to stop the apps then the db,
> > then restart the apps and the db - we run this every night out of
> > hours. If you are going to do this, please don't use the script from
> > Epicor's answer books as their
> is
> > a
> > fault with it. It doesn't wait for the DB to be stopped before
> > trying to restart the Apps which just ends up in a mess.
> >
> > Secondly, on a weekend, we stop the apps, stop the db, clear out any
> > temp files and temp .xml data for reports, defrage all drives on the
> > server, start
> the
> > db,
> > start the apps.
> >
> > So far, we have not had any 'major' slow downs where we have had to
> > kick people off the system during the working week.
> >
> > We found that the reports folder (usually epicodata/reports) was
> > getting very full very fast. Some reports were are in excess of 7GB
> > in size (the xml
> for
> >
> > them) so if you run these a few times a month, the folder size
> > increases rapidly.
> >
> > One thing we noticed is that the archive option of 'Never' when you
> > run a report nearly always doesnt' work. 'Never' would appear to
> > either mean 30 days
> or
> > keep
> > forever - hence the reason why the reports folder was building up in
> size.
> >
> > What are you classing as slow and what are you comparing against?
> >
> > Our speed issues have been associated with 'memory leaking' BAQs and
> > BAQs which crash on you causing the app server to get stuck in a
> > loop.
> >
> > There are also other things which may speed things up such as
> > increasing number of App servers and tweaking settings in the
> > mfgsys.mfgsys file (but I
> would
> > get
> > advice from Epicor on these).
> >
> > It is definately worth while logging a call for this issue as
> > something definately isn't right. Hopefully your call will be linked
> > with my call
> and
> > we
> > should get an answer quicker.
> >
> > Are you progress or SQL?
> >
> > Thanks,
> >
> > CHRIS
> >
> > ________________________________
> > From: Jose Gomez <jose@... <jose%40josecgomez.com> <jose%
> 40josecgomez.com>>
> > To: Vantage <vantage@yahoogroups.com
> > <vantage%40yahoogroups.com><vantage%
> 40yahoogroups.com>>
>
> > Sent: Mon, 9 August, 2010 15:14:27
> > Subject: [Vantage] Epicor 9 Impossibly slow
> >
> >
> >
> > I said las week that epicor 9 was running slower than normal, some
> > of you suggested various things but nothing seems to be helping.
> >
> > Over the weekend, we re-indexed the DB, did a dump and load,
> > truncated
> the
> > bi and god knows what else. It seems to be running awful still this
> > morning after all that.
> >
> > Does anyone have any troubleshooting / tracing / fixing ideas that
> > may
> help
> > us determine where the problem is?
> >
> > Thank you in advance!
> >
> > Sincerely
> > Jose C Gomez
> >
> > http://www.josecgomez.com
> >
> > [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]
>
> ------------------------------------
>
>
> 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]
>
>
>

[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

system · August 10, 2010, 9:49am

Thanks Chris,
I will give those values a shot

Its ESX on with one Storage Device usign Raid 10

Sincerely
Jose C Gomez

http://www.josecgomez.com

On Tue, Aug 10, 2010 at 9:42 AM, Ned <TechnoBabbly@...> wrote:

>
>
> Well there are a few fixes you can do...
>
> 1: Update to -Mm 4096, that will help you some, you could possibly go
> higher, but I have never found a need for it, 4096 is pretty default.
> 2: Update to -s 12000, that will help as well, also depends how much RAM
> you
> have allocated, but that 50% jump can add a lot.
>
> Also, you mention that you are running on a VM, depending how you have your
> VMs setup, that right there is going to rip your performance right down.
>
> What do you have for a VM setup? ESX? SAN? NAS? Internal Drives? How are
> the
> drives broken up for use?
>
> A lot of people don't realize the performance hit you will take when you
> are
> using a VM and don't dedicate drives the same way you would a physical
> machine, you can very easily create a bottleneck for the data which can
> make
> even the "fastest" machines slower than a turtle stuck in molasses.
>
>
> -----Original Message-----
> From: vantage@yahoogroups.com <vantage%40yahoogroups.com> [mailto:
> vantage@yahoogroups.com <vantage%40yahoogroups.com>] On Behalf Of
> Jose Gomez
> Sent: Tuesday, August 10, 2010 8:20 AM
> To: vantage@yahoogroups.com <vantage%40yahoogroups.com>
> Subject: Re: [Vantage] Epicor 9 Impossibly slow
>
> My PF File looks like this
>
> -Mm 1024 -mmax 65534 -Bt 4096 -s 8000 -yy 1970 -stsh 31 -inp 32000 -tok
> 4000
> -TB 31 -TM 32 -D 500 -l 1000 -ttmarshal 5 -tmpbsize 8 -rereadnolock -lkwtmo
> 180
> -T "C:\Program Files\Epicor Software\EpicorData"
> -db "C:\Program Files\Epicor Software\Epicor904\db\mfgsys"
> -cpinternal utf-8 -cpstream utf-8 -cprcodein utf-8 -cpcoll icu-uca
>
> Sincerely
> Jose C Gomez
>
> http://www.josecgomez.com
>
> On Tue, Aug 10, 2010 at 3:16 AM, Chris Thompson
> <chriselectrix@... <chriselectrix%40ymail.com>>wrote:
>
> >
> >
> > Hi Jose,
> >
> > Have you logged this as a call? If so what call number?
> >
> > The script we are using is ...
> >
> > @echo off
> > set DLC=E:\epicor904\oe101c
> > set PATH=%DLC%\BIN;%PATH%
> > set LIB=%DLC%\LIB;%LIB%
> >
> > echo .
> > echo .
> > echo RESTARTING LOCAL DB/APPSERVERS...
> > call asbman -name Epicor904ProcessServer -stop -port 20940 call asbman
> > -name Epicor904TaskAgent -stop -port 20940 call asbman -name Epicor904
> > -stop -port 20940 call dbman -host localhost -database Epicor904 -stop
> > -port 20940
> >
> > :TestStop
> > ECHO Testing Lock File
> > IF EXIST E:\epicor904\db\mfgsys.lk GOTO TestStop
> >
> > call dbman -host localhost -database Epicor904 -start -port 20940 call
> > asbman -name Epicor904 -start -port 20940 call asbman -name
> > Epicor904TaskAgent -start -port 20940 call asbman -name
> > Epicor904ProcessServer -start -port 20940
> >
> > Obviously you will have to change the paths to suit your server setup
> > and you will probably have to change the port number on each occasion.
> > Also, I cannot be held responsible for anything that goes wrong with
> > your system when using this script. It is worthwhile testing it on
> > Pilot or Test first.
> >
> > The check for the .lk is the bit that was missing from the answer
> > books. It is a bit of a crude fix, but it does the job.
> >
> > We have found that the system is much more stable after deleting the
> > old reports and temp files folders and defragging on a weekend.
> >
> > Let me know if you want those scripts too.
> >
> >
> > Thanks,
> >
> > CHRIS
> >
> > ________________________________
> > From: Jose Gomez <jose@... <jose%40josecgomez.com> <jose%
> 40josecgomez.com>>
> > To: vantage@yahoogroups.com <vantage%40yahoogroups.com> <vantage%
> 40yahoogroups.com>
>
> > Sent: Mon, 9 August, 2010 17:05:06
> > Subject: Re: [Vantage] Epicor 9 Impossibly slow
> >
> >
> > Thank you Chris,
> > we are running Progress and basically the whole app is running slow,
> > takes time to open forms, time to search, time to save, searching for
> > an SO can take minutes at times. Loading Invoices into ARGroup can
> > take minutes at times.
> >
> > We've ran through the DB tunning guide today and tweaked all the
> > values we could find, and hopefully this will fix some of our issues.
> > But I find it absurd that it takes minutes to search for a sales
> > Order, or to save a simple 10 line invoice.
> >
> > We've attempted calls with Epicor but they are ... well not very
> > helpful, sadly although some of their people are really good, it seems
> > like most of the gen pop support doesn't actually understand/know how
> > to deal with this kind of issues.
> >
> > For what is worth we are running on w 2 quad cores with 12 GB of RAM.
> > Which should be more than enough metal for the number of users we have.
> >
> > Thanks for your input and i'll let you know if we find anything else.
> >
> > Also can you share the start / stop script for the DB, apps etc, you
> > mentioned that the one form epicor is flawed.
> >
> > Thanks again!
> >
> > Sincerely
> > Jose C Gomez
> >
> > http://www.josecgomez.com
> >
> > On Mon, Aug 9, 2010 at 11:48 AM, Chris Thompson
> > <chriselectrix@... <chriselectrix%40ymail.com><chriselectrix%
> 40ymail.com>
>
> > >wrote:
> >
> > >
> > >
> > > HI Jose,
> > >
> > > We have had a number of speed issues with Epicor 9.
> > >
> > > If we leave the Apps and DB running for about a week, the system
> > > will
> > grind
> > > to a
> > > halt and we would have to stop the apps and db and sometimes restart
> > > the server to fix the issue.
> > >
> > > Epicor have accepted that this looks like a fault with Progress so
> > > the
> > call
> > > has
> > > been passed to them.
> > >
> > > At present, we have a script in place to stop the apps then the db,
> > > then restart the apps and the db - we run this every night out of
> > > hours. If you are going to do this, please don't use the script from
> > > Epicor's answer books as their
> > is
> > > a
> > > fault with it. It doesn't wait for the DB to be stopped before
> > > trying to restart the Apps which just ends up in a mess.
> > >
> > > Secondly, on a weekend, we stop the apps, stop the db, clear out any
> > > temp files and temp .xml data for reports, defrage all drives on the
> > > server, start
> > the
> > > db,
> > > start the apps.
> > >
> > > So far, we have not had any 'major' slow downs where we have had to
> > > kick people off the system during the working week.
> > >
> > > We found that the reports folder (usually epicodata/reports) was
> > > getting very full very fast. Some reports were are in excess of 7GB
> > > in size (the xml
> > for
> > >
> > > them) so if you run these a few times a month, the folder size
> > > increases rapidly.
> > >
> > > One thing we noticed is that the archive option of 'Never' when you
> > > run a report nearly always doesnt' work. 'Never' would appear to
> > > either mean 30 days
> > or
> > > keep
> > > forever - hence the reason why the reports folder was building up in
> > size.
> > >
> > > What are you classing as slow and what are you comparing against?
> > >
> > > Our speed issues have been associated with 'memory leaking' BAQs and
> > > BAQs which crash on you causing the app server to get stuck in a
> > > loop.
> > >
> > > There are also other things which may speed things up such as
> > > increasing number of App servers and tweaking settings in the
> > > mfgsys.mfgsys file (but I
> > would
> > > get
> > > advice from Epicor on these).
> > >
> > > It is definately worth while logging a call for this issue as
> > > something definately isn't right. Hopefully your call will be linked
> > > with my call
> > and
> > > we
> > > should get an answer quicker.
> > >
> > > Are you progress or SQL?
> > >
> > > Thanks,
> > >
> > > CHRIS
> > >
> > > ________________________________
> > > From: Jose Gomez <jose@... <jose%40josecgomez.com> <jose%
> 40josecgomez.com> <jose%
>
> > 40josecgomez.com>>
> > > To: Vantage <vantage@yahoogroups.com <vantage%40yahoogroups.com>
> > > <vantage%40yahoogroups.com><vantage%
>
> > 40yahoogroups.com>>
> >
> > > Sent: Mon, 9 August, 2010 15:14:27
> > > Subject: [Vantage] Epicor 9 Impossibly slow
> > >
> > >
> > >
> > > I said las week that epicor 9 was running slower than normal, some
> > > of you suggested various things but nothing seems to be helping.
> > >
> > > Over the weekend, we re-indexed the DB, did a dump and load,
> > > truncated
> > the
> > > bi and god knows what else. It seems to be running awful still this
> > > morning after all that.
> > >
> > > Does anyone have any troubleshooting / tracing / fixing ideas that
> > > may
> > help
> > > us determine where the problem is?
> > >
> > > Thank you in advance!
> > >
> > > Sincerely
> > > Jose C Gomez
> > >
> > > http://www.josecgomez.com
> > >
> > > [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]
> >
> > ------------------------------------
> >
> >
> > 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]
> >
> >
> >
>
> [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]

system · August 10, 2010, 9:57am

Sincerely
Jose C Gomez

http://www.josecgomez.com

On Tue, Aug 10, 2010 at 9:48 AM, Jose Gomez <jose@...> wrote:

> Thanks Chris,
> I will give those values a shot
>
> Its ESX on with one Storage Device usign Raid 10
> Thanks Ned,
>
Can you tell me what the -s parameter is? In Progress's file I can't find
it

Thanks!

> Sincerely
> Jose C Gomez
>
> http://www.josecgomez.com
>
>
> On Tue, Aug 10, 2010 at 9:42 AM, Ned <TechnoBabbly@...> wrote:
>
>>
>>
>> Well there are a few fixes you can do...
>>
>> 1: Update to -Mm 4096, that will help you some, you could possibly go
>> higher, but I have never found a need for it, 4096 is pretty default.
>> 2: Update to -s 12000, that will help as well, also depends how much RAM
>> you
>> have allocated, but that 50% jump can add a lot.
>>
>> Also, you mention that you are running on a VM, depending how you have
>> your
>> VMs setup, that right there is going to rip your performance right down.
>>
>> What do you have for a VM setup? ESX? SAN? NAS? Internal Drives? How are
>> the
>> drives broken up for use?
>>
>> A lot of people don't realize the performance hit you will take when you
>> are
>> using a VM and don't dedicate drives the same way you would a physical
>> machine, you can very easily create a bottleneck for the data which can
>> make
>> even the "fastest" machines slower than a turtle stuck in molasses.
>>
>>
>> -----Original Message-----
>> From: vantage@yahoogroups.com <vantage%40yahoogroups.com> [mailto:
>> vantage@yahoogroups.com <vantage%40yahoogroups.com>] On Behalf Of
>> Jose Gomez
>> Sent: Tuesday, August 10, 2010 8:20 AM
>> To: vantage@yahoogroups.com <vantage%40yahoogroups.com>
>> Subject: Re: [Vantage] Epicor 9 Impossibly slow
>>
>> My PF File looks like this
>>
>> -Mm 1024 -mmax 65534 -Bt 4096 -s 8000 -yy 1970 -stsh 31 -inp 32000 -tok
>> 4000
>> -TB 31 -TM 32 -D 500 -l 1000 -ttmarshal 5 -tmpbsize 8 -rereadnolock
>> -lkwtmo
>> 180
>> -T "C:\Program Files\Epicor Software\EpicorData"
>> -db "C:\Program Files\Epicor Software\Epicor904\db\mfgsys"
>> -cpinternal utf-8 -cpstream utf-8 -cprcodein utf-8 -cpcoll icu-uca
>>
>> Sincerely
>> Jose C Gomez
>>
>> http://www.josecgomez.com
>>
>> On Tue, Aug 10, 2010 at 3:16 AM, Chris Thompson
>> <chriselectrix@... <chriselectrix%40ymail.com>>wrote:
>>
>> >
>> >
>> > Hi Jose,
>> >
>> > Have you logged this as a call? If so what call number?
>> >
>> > The script we are using is ...
>> >
>> > @echo off
>> > set DLC=E:\epicor904\oe101c
>> > set PATH=%DLC%\BIN;%PATH%
>> > set LIB=%DLC%\LIB;%LIB%
>> >
>> > echo .
>> > echo .
>> > echo RESTARTING LOCAL DB/APPSERVERS...
>> > call asbman -name Epicor904ProcessServer -stop -port 20940 call asbman
>> > -name Epicor904TaskAgent -stop -port 20940 call asbman -name Epicor904
>> > -stop -port 20940 call dbman -host localhost -database Epicor904 -stop
>> > -port 20940
>> >
>> > :TestStop
>> > ECHO Testing Lock File
>> > IF EXIST E:\epicor904\db\mfgsys.lk GOTO TestStop
>> >
>> > call dbman -host localhost -database Epicor904 -start -port 20940 call
>> > asbman -name Epicor904 -start -port 20940 call asbman -name
>> > Epicor904TaskAgent -start -port 20940 call asbman -name
>> > Epicor904ProcessServer -start -port 20940
>> >
>> > Obviously you will have to change the paths to suit your server setup
>> > and you will probably have to change the port number on each occasion.
>> > Also, I cannot be held responsible for anything that goes wrong with
>> > your system when using this script. It is worthwhile testing it on
>> > Pilot or Test first.
>> >
>> > The check for the .lk is the bit that was missing from the answer
>> > books. It is a bit of a crude fix, but it does the job.
>> >
>> > We have found that the system is much more stable after deleting the
>> > old reports and temp files folders and defragging on a weekend.
>> >
>> > Let me know if you want those scripts too.
>> >
>> >
>> > Thanks,
>> >
>> > CHRIS
>> >
>> > ________________________________
>> > From: Jose Gomez <jose@... <jose%40josecgomez.com> <jose%
>> 40josecgomez.com>>
>> > To: vantage@yahoogroups.com <vantage%40yahoogroups.com> <vantage%
>> 40yahoogroups.com>
>>
>> > Sent: Mon, 9 August, 2010 17:05:06
>> > Subject: Re: [Vantage] Epicor 9 Impossibly slow
>> >
>> >
>> > Thank you Chris,
>> > we are running Progress and basically the whole app is running slow,
>> > takes time to open forms, time to search, time to save, searching for
>> > an SO can take minutes at times. Loading Invoices into ARGroup can
>> > take minutes at times.
>> >
>> > We've ran through the DB tunning guide today and tweaked all the
>> > values we could find, and hopefully this will fix some of our issues.
>> > But I find it absurd that it takes minutes to search for a sales
>> > Order, or to save a simple 10 line invoice.
>> >
>> > We've attempted calls with Epicor but they are ... well not very
>> > helpful, sadly although some of their people are really good, it seems
>> > like most of the gen pop support doesn't actually understand/know how
>> > to deal with this kind of issues.
>> >
>> > For what is worth we are running on w 2 quad cores with 12 GB of RAM.
>> > Which should be more than enough metal for the number of users we have.
>> >
>> > Thanks for your input and i'll let you know if we find anything else.
>> >
>> > Also can you share the start / stop script for the DB, apps etc, you
>> > mentioned that the one form epicor is flawed.
>> >
>> > Thanks again!
>> >
>> > Sincerely
>> > Jose C Gomez
>> >
>> > http://www.josecgomez.com
>> >
>> > On Mon, Aug 9, 2010 at 11:48 AM, Chris Thompson
>> > <chriselectrix@... <chriselectrix%40ymail.com><chriselectrix%
>> 40ymail.com>
>>
>> > >wrote:
>> >
>> > >
>> > >
>> > > HI Jose,
>> > >
>> > > We have had a number of speed issues with Epicor 9.
>> > >
>> > > If we leave the Apps and DB running for about a week, the system
>> > > will
>> > grind
>> > > to a
>> > > halt and we would have to stop the apps and db and sometimes restart
>> > > the server to fix the issue.
>> > >
>> > > Epicor have accepted that this looks like a fault with Progress so
>> > > the
>> > call
>> > > has
>> > > been passed to them.
>> > >
>> > > At present, we have a script in place to stop the apps then the db,
>> > > then restart the apps and the db - we run this every night out of
>> > > hours. If you are going to do this, please don't use the script from
>> > > Epicor's answer books as their
>> > is
>> > > a
>> > > fault with it. It doesn't wait for the DB to be stopped before
>> > > trying to restart the Apps which just ends up in a mess.
>> > >
>> > > Secondly, on a weekend, we stop the apps, stop the db, clear out any
>> > > temp files and temp .xml data for reports, defrage all drives on the
>> > > server, start
>> > the
>> > > db,
>> > > start the apps.
>> > >
>> > > So far, we have not had any 'major' slow downs where we have had to
>> > > kick people off the system during the working week.
>> > >
>> > > We found that the reports folder (usually epicodata/reports) was
>> > > getting very full very fast. Some reports were are in excess of 7GB
>> > > in size (the xml
>> > for
>> > >
>> > > them) so if you run these a few times a month, the folder size
>> > > increases rapidly.
>> > >
>> > > One thing we noticed is that the archive option of 'Never' when you
>> > > run a report nearly always doesnt' work. 'Never' would appear to
>> > > either mean 30 days
>> > or
>> > > keep
>> > > forever - hence the reason why the reports folder was building up in
>> > size.
>> > >
>> > > What are you classing as slow and what are you comparing against?
>> > >
>> > > Our speed issues have been associated with 'memory leaking' BAQs and
>> > > BAQs which crash on you causing the app server to get stuck in a
>> > > loop.
>> > >
>> > > There are also other things which may speed things up such as
>> > > increasing number of App servers and tweaking settings in the
>> > > mfgsys.mfgsys file (but I
>> > would
>> > > get
>> > > advice from Epicor on these).
>> > >
>> > > It is definately worth while logging a call for this issue as
>> > > something definately isn't right. Hopefully your call will be linked
>> > > with my call
>> > and
>> > > we
>> > > should get an answer quicker.
>> > >
>> > > Are you progress or SQL?
>> > >
>> > > Thanks,
>> > >
>> > > CHRIS
>> > >
>> > > ________________________________
>> > > From: Jose Gomez <jose@... <jose%40josecgomez.com> <jose%
>> 40josecgomez.com> <jose%
>>
>> > 40josecgomez.com>>
>> > > To: Vantage <vantage@yahoogroups.com <vantage%40yahoogroups.com>
>> > > <vantage%40yahoogroups.com><vantage%
>>
>> > 40yahoogroups.com>>
>> >
>> > > Sent: Mon, 9 August, 2010 15:14:27
>> > > Subject: [Vantage] Epicor 9 Impossibly slow
>> > >
>> > >
>> > >
>> > > I said las week that epicor 9 was running slower than normal, some
>> > > of you suggested various things but nothing seems to be helping.
>> > >
>> > > Over the weekend, we re-indexed the DB, did a dump and load,
>> > > truncated
>> > the
>> > > bi and god knows what else. It seems to be running awful still this
>> > > morning after all that.
>> > >
>> > > Does anyone have any troubleshooting / tracing / fixing ideas that
>> > > may
>> > help
>> > > us determine where the problem is?
>> > >
>> > > Thank you in advance!
>> > >
>> > > Sincerely
>> > > Jose C Gomez
>> > >
>> > > http://www.josecgomez.com
>> > >
>> > > [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]
>> >
>> > ------------------------------------
>> >
>> >
>> > 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]
>> >
>> >
>> >
>>
>> [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]

system · August 10, 2010, 10:09am

What is the one storage device? SAN? Internal Drives? NAS?

How many drives are in it? How many arrays are you running with those
drives? How many VMs are using the storage device? What are the other VMs
running?

I am guessing you are running one giant array with all the VMs using the
storage device and divvying up space based on the VM itself.

This will kill your performance.

Even with a VM, you will still want to separate out your drives physically
for maximum performance out of the system.

For the sake of example, if you have a storage device with say 14 drives in
it.

You could do a few different setups which would be better than the all in 1
use of the storage device as I suspect you are currently using. Off the top
of my head, 3 possible options would be:

A- 6 Drives for your Vantage/Epicor VM and nothing else.

B- 4-6 Drives for your Vantage/Epicor VM secondary Drive and nothing else,
leave the OS on the other 8-10 drives as the other VMs

C- Split out 2 drives and give them to my Vantage/Epicor OS drive, 6 drives
to my Vantage/Epicor DB and Program Drive, and the remaining 6 to whatever
other VMs you are running.

Personally, I would run with option C, I think the value of a VM setup is
always a better use of Processor power and RAM allocation, the bottleneck
for Epicor/Vantage is always going to be disk access unless you go to one of
those crazy expensive setups with the Fusion ioDrives. Dedicated drives will
increase your performance, to use an old clichÃ©, size is not important, you
will get better performance out of 10 36GB drives in RAID 10 compared to 2
500GB drives in RAID 10.

I am not saying you shouldn't get large sized drives, cuz who doesn't want
more space, but concentrate on more disks versus disk size.

Â
Ned Cleary
Technical Consultant
alternative Technology Partners

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Jose Gomez
Sent: Tuesday, August 10, 2010 9:48 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Epicor 9 Impossibly slow

Thanks Chris,
I will give those values a shot

Its ESX on with one Storage Device usign Raid 10

Sincerely
Jose C Gomez

http://www.josecgomez.com

On Tue, Aug 10, 2010 at 9:42 AM, Ned <TechnoBabbly@...> wrote:

>
>
> Well there are a few fixes you can do...
>
> 1: Update to -Mm 4096, that will help you some, you could possibly go
> higher, but I have never found a need for it, 4096 is pretty default.
> 2: Update to -s 12000, that will help as well, also depends how much
> RAM you have allocated, but that 50% jump can add a lot.
>
> Also, you mention that you are running on a VM, depending how you have
> your VMs setup, that right there is going to rip your performance right
down.
>
> What do you have for a VM setup? ESX? SAN? NAS? Internal Drives? How
> are the drives broken up for use?
>
> A lot of people don't realize the performance hit you will take when
> you are using a VM and don't dedicate drives the same way you would a
> physical machine, you can very easily create a bottleneck for the data
> which can make even the "fastest" machines slower than a turtle stuck
> in molasses.
>
>
> -----Original Message-----
> From: vantage@yahoogroups.com <vantage%40yahoogroups.com> [mailto:
> vantage@yahoogroups.com <vantage%40yahoogroups.com>] On Behalf Of Jose
> Gomez
> Sent: Tuesday, August 10, 2010 8:20 AM
> To: vantage@yahoogroups.com <vantage%40yahoogroups.com>
> Subject: Re: [Vantage] Epicor 9 Impossibly slow
>
> My PF File looks like this
>
> -Mm 1024 -mmax 65534 -Bt 4096 -s 8000 -yy 1970 -stsh 31 -inp 32000
> -tok
> 4000
> -TB 31 -TM 32 -D 500 -l 1000 -ttmarshal 5 -tmpbsize 8 -rereadnolock
> -lkwtmo
> 180
> -T "C:\Program Files\Epicor Software\EpicorData"
> -db "C:\Program Files\Epicor Software\Epicor904\db\mfgsys"
> -cpinternal utf-8 -cpstream utf-8 -cprcodein utf-8 -cpcoll icu-uca
>
> Sincerely
> Jose C Gomez
>
> http://www.josecgomez.com
>
> On Tue, Aug 10, 2010 at 3:16 AM, Chris Thompson
> <chriselectrix@... <chriselectrix%40ymail.com>>wrote:
>
> >
> >
> > Hi Jose,
> >
> > Have you logged this as a call? If so what call number?
> >
> > The script we are using is ...
> >
> > @echo off
> > set DLC=E:\epicor904\oe101c
> > set PATH=%DLC%\BIN;%PATH%
> > set LIB=%DLC%\LIB;%LIB%
> >
> > echo .
> > echo .
> > echo RESTARTING LOCAL DB/APPSERVERS...
> > call asbman -name Epicor904ProcessServer -stop -port 20940 call
> > asbman -name Epicor904TaskAgent -stop -port 20940 call asbman -name
> > Epicor904 -stop -port 20940 call dbman -host localhost -database
> > Epicor904 -stop -port 20940
> >
> > :TestStop
> > ECHO Testing Lock File
> > IF EXIST E:\epicor904\db\mfgsys.lk GOTO TestStop
> >
> > call dbman -host localhost -database Epicor904 -start -port 20940
> > call asbman -name Epicor904 -start -port 20940 call asbman -name
> > Epicor904TaskAgent -start -port 20940 call asbman -name
> > Epicor904ProcessServer -start -port 20940
> >
> > Obviously you will have to change the paths to suit your server
> > setup and you will probably have to change the port number on each
occasion.
> > Also, I cannot be held responsible for anything that goes wrong with
> > your system when using this script. It is worthwhile testing it on
> > Pilot or Test first.
> >
> > The check for the .lk is the bit that was missing from the answer
> > books. It is a bit of a crude fix, but it does the job.
> >
> > We have found that the system is much more stable after deleting the
> > old reports and temp files folders and defragging on a weekend.
> >
> > Let me know if you want those scripts too.
> >
> >
> > Thanks,
> >
> > CHRIS
> >
> > ________________________________
> > From: Jose Gomez <jose@... <jose%40josecgomez.com> <jose%
> 40josecgomez.com>>
> > To: vantage@yahoogroups.com <vantage%40yahoogroups.com> <vantage%
> 40yahoogroups.com>
>
> > Sent: Mon, 9 August, 2010 17:05:06
> > Subject: Re: [Vantage] Epicor 9 Impossibly slow
> >
> >
> > Thank you Chris,
> > we are running Progress and basically the whole app is running slow,
> > takes time to open forms, time to search, time to save, searching
> > for an SO can take minutes at times. Loading Invoices into ARGroup
> > can take minutes at times.
> >
> > We've ran through the DB tunning guide today and tweaked all the
> > values we could find, and hopefully this will fix some of our issues.
> > But I find it absurd that it takes minutes to search for a sales
> > Order, or to save a simple 10 line invoice.
> >
> > We've attempted calls with Epicor but they are ... well not very
> > helpful, sadly although some of their people are really good, it
> > seems like most of the gen pop support doesn't actually
> > understand/know how to deal with this kind of issues.
> >
> > For what is worth we are running on w 2 quad cores with 12 GB of RAM.
> > Which should be more than enough metal for the number of users we have.
> >
> > Thanks for your input and i'll let you know if we find anything else.
> >
> > Also can you share the start / stop script for the DB, apps etc, you
> > mentioned that the one form epicor is flawed.
> >
> > Thanks again!
> >
> > Sincerely
> > Jose C Gomez
> >
> > http://www.josecgomez.com
> >
> > On Mon, Aug 9, 2010 at 11:48 AM, Chris Thompson
> > <chriselectrix@... <chriselectrix%40ymail.com><chriselectrix%
> 40ymail.com>
>
> > >wrote:
> >
> > >
> > >
> > > HI Jose,
> > >
> > > We have had a number of speed issues with Epicor 9.
> > >
> > > If we leave the Apps and DB running for about a week, the system
> > > will
> > grind
> > > to a
> > > halt and we would have to stop the apps and db and sometimes
> > > restart the server to fix the issue.
> > >
> > > Epicor have accepted that this looks like a fault with Progress so
> > > the
> > call
> > > has
> > > been passed to them.
> > >
> > > At present, we have a script in place to stop the apps then the
> > > db, then restart the apps and the db - we run this every night out
> > > of hours. If you are going to do this, please don't use the script
> > > from Epicor's answer books as their
> > is
> > > a
> > > fault with it. It doesn't wait for the DB to be stopped before
> > > trying to restart the Apps which just ends up in a mess.
> > >
> > > Secondly, on a weekend, we stop the apps, stop the db, clear out
> > > any temp files and temp .xml data for reports, defrage all drives
> > > on the server, start
> > the
> > > db,
> > > start the apps.
> > >
> > > So far, we have not had any 'major' slow downs where we have had
> > > to kick people off the system during the working week.
> > >
> > > We found that the reports folder (usually epicodata/reports) was
> > > getting very full very fast. Some reports were are in excess of
> > > 7GB in size (the xml
> > for
> > >
> > > them) so if you run these a few times a month, the folder size
> > > increases rapidly.
> > >
> > > One thing we noticed is that the archive option of 'Never' when
> > > you run a report nearly always doesnt' work. 'Never' would appear
> > > to either mean 30 days
> > or
> > > keep
> > > forever - hence the reason why the reports folder was building up
> > > in
> > size.
> > >
> > > What are you classing as slow and what are you comparing against?
> > >
> > > Our speed issues have been associated with 'memory leaking' BAQs
> > > and BAQs which crash on you causing the app server to get stuck in
> > > a loop.
> > >
> > > There are also other things which may speed things up such as
> > > increasing number of App servers and tweaking settings in the
> > > mfgsys.mfgsys file (but I
> > would
> > > get
> > > advice from Epicor on these).
> > >
> > > It is definately worth while logging a call for this issue as
> > > something definately isn't right. Hopefully your call will be
> > > linked with my call
> > and
> > > we
> > > should get an answer quicker.
> > >
> > > Are you progress or SQL?
> > >
> > > Thanks,
> > >
> > > CHRIS
> > >
> > > ________________________________
> > > From: Jose Gomez <jose@... <jose%40josecgomez.com>
> > > <jose%
> 40josecgomez.com> <jose%
>
> > 40josecgomez.com>>
> > > To: Vantage <vantage@yahoogroups.com <vantage%40yahoogroups.com>
> > > <vantage%40yahoogroups.com><vantage%
>
> > 40yahoogroups.com>>
> >
> > > Sent: Mon, 9 August, 2010 15:14:27
> > > Subject: [Vantage] Epicor 9 Impossibly slow
> > >
> > >
> > >
> > > I said las week that epicor 9 was running slower than normal, some
> > > of you suggested various things but nothing seems to be helping.
> > >
> > > Over the weekend, we re-indexed the DB, did a dump and load,
> > > truncated
> > the
> > > bi and god knows what else. It seems to be running awful still
> > > this morning after all that.
> > >
> > > Does anyone have any troubleshooting / tracing / fixing ideas that
> > > may
> > help
> > > us determine where the problem is?
> > >
> > > Thank you in advance!
> > >
> > > Sincerely
> > > Jose C Gomez
> > >
> > > http://www.josecgomez.com
> > >
> > > [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]
> >
> > ------------------------------------
> >
> >
> > 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]
> >
> >
> >
>
> [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]

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

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

system · August 10, 2010, 10:11am

We split our d files up into 6 or 7. Each one of them is allocated 1GB and disk
space so they say they are 1GB each even though only d1,d2,d3 are the only once
with data in them.

I 'think' think can be done quite simply by altering the st file and then
restoring a backup to the folder where the modified st file resides.

The contents of our ST file are as follows ...

# generated by PROREST on Wed Nov 11 17:07:53 2009
b .
d "Schema Area":6,32;1 mfgsys.d1 f 1048576
d "Schema Area":6,32;1 mfgsys.d2 f 1048576
d "Schema Area":6,32;1 mfgsys.d3 f 1048576
d "Schema Area":6,32;1 mfgsys.d4 f 1048576
d "Schema Area":6,32;1 mfgsys.d5 f 1048576
d "Schema Area":6,32;1 mfgsys.d6 f 1048576
d "Schema Area":6,32;1 mfgsys.d7

Don't quote me, and again try this in Pilot, but if you backup Pilot and then
restore to the same folder (with the modified st file) you should end up with a
folder containing 7 .d files.

The purpose behind this was when we only had 1 .d file data became fragmented,
but with the .d files how we have them set up, the data is meant to stay
together on the disk so there is less time spent searching for parts of the
data.

This was done by Epicor after we had big speed slow downws with E9 too.

I wouldnt say the system started going like lightning, but it did have some
improvements in speed.

Might be worth giving it a go in Pilot with your live data and see if it makes a
difference.

Again I can't be held responsible for anything you try.

Thanks.

Â

________________________________
From: Jose Gomez <jose@...>
To: vantage@yahoogroups.com
Sent: Tue, 10 August, 2010 14:28:29
Subject: Re: [Vantage] Epicor 9 Impossibly slow

Hey Chris,

Yes we defraged, I only have 1 d1 file 5 GB

Sincerely
Jose C Gomez

http://www.josecgomez.com

On Tue, Aug 10, 2010 at 9:15 AM, Chris Thompson <chriselectrix@...>wrote:

>
>
> Did you defrag after you did the dump and load?
>
> How many .d1 files do you have for your live db?
>
>
> ________________________________
> From: Jose Gomez <jose@... <jose%40josecgomez.com>>
> To: vantage@yahoogroups.com <vantage%40yahoogroups.com>
> Sent: Tue, 10 August, 2010 13:29:54
>
> Subject: Re: [Vantage] Epicor 9 Impossibly slow
>
> For what is worth, its a VM so there are no physical drives, putting it on
> E
> or C wouldn't make much of a difference in this case.
>
> Sincerely
> Jose C Gomez
>
> http://www.josecgomez.com
>
> On Tue, Aug 10, 2010 at 8:27 AM, Chris Thompson
><chriselectrix@...<chriselectrix%40ymail.com>
> >wrote:
>
> >
> >
> > Hi Jose,
> >
> > We were recommended by Epicor never to have anything Epicor related on
> the
> > same
> > set of disks as the server's operating system.
> >
> > You currently have ...
> >
> >
> > -T "C:\Program Files\Epicor Software\EpicorData"
> > -db "C:\Program Files\Epicor Software\Epicor904\db\mfgsys"
> >
> > We were told use e.g. drive d or e.
> >
> > Is this Epicor 9 a new installation or have you been using it for a while
> > and it
> > has only just started to slow down?
> >
> >
> > Thanks,
> >
> > CHRIS
> >
> > ________________________________
> > From: Jose Gomez <jose@... <jose%40josecgomez.com> <jose%
> 40josecgomez.com>>
> > To: vantage@yahoogroups.com <vantage%40yahoogroups.com> <vantage%
> 40yahoogroups.com>
> > Sent: Tue, 10 August, 2010 13:20:06
> >
> > Subject: Re: [Vantage] Epicor 9 Impossibly slow
> >
> > My PF File looks like this
> >
> > -Mm 1024 -mmax 65534 -Bt 4096 -s 8000 -yy 1970 -stsh 31 -inp 32000 -tok
> > 4000
> > -TB 31 -TM 32 -D 500 -l 1000 -ttmarshal 5 -tmpbsize 8 -rereadnolock
> -lkwtmo
> > 180
> > -T "C:\Program Files\Epicor Software\EpicorData"
> > -db "C:\Program Files\Epicor Software\Epicor904\db\mfgsys"
> > -cpinternal utf-8 -cpstream utf-8 -cprcodein utf-8 -cpcoll icu-uca
> >
> > Sincerely
> > Jose C Gomez
> >
> > http://www.josecgomez.com
> >
> > On Tue, Aug 10, 2010 at 3:16 AM, Chris Thompson
> ><chriselectrix@... <chriselectrix%40ymail.com><chriselectrix%
> 40ymail.com>
>
> > >wrote:
> >
> > >
> > >
> > > Hi Jose,
> > >
> > > Have you logged this as a call? If so what call number?
> > >
> > > The script we are using is ...
> > >
> > > @echo off
> > > set DLC=E:\epicor904\oe101c
> > > set PATH=%DLC%\BIN;%PATH%
> > > set LIB=%DLC%\LIB;%LIB%
> > >
> > > echo .
> > > echo .
> > > echo RESTARTING LOCAL DB/APPSERVERS...
> > > call asbman -name Epicor904ProcessServer -stop -port 20940
> > > call asbman -name Epicor904TaskAgent -stop -port 20940
> > > call asbman -name Epicor904 -stop -port 20940
> > > call dbman -host localhost -database Epicor904 -stop -port 20940
> > >
> > > :TestStop
> > > ECHO Testing Lock File
> > > IF EXIST E:\epicor904\db\mfgsys.lk GOTO TestStop
> > >
> > > call dbman -host localhost -database Epicor904 -start -port 20940
> > > call asbman -name Epicor904 -start -port 20940
> > > call asbman -name Epicor904TaskAgent -start -port 20940
> > > call asbman -name Epicor904ProcessServer -start -port 20940
> > >
> > > Obviously you will have to change the paths to suit your server setup
> and
> > > you
> > > will probably have to change the port number on each occasion. Also, I
> > > cannot be
> > > held responsible for anything that goes wrong with your system when
> using
> > > this
> > > script. It is worthwhile testing it on Pilot or Test first.
> > >
> > > The check for the .lk is the bit that was missing from the answer
> books.
> > It
> > > is a
> > > bit of a crude fix, but it does the job.
> > >
> > > We have found that the system is much more stable after deleting the
> old
> > > reports
> > > and temp files folders and defragging on a weekend.
> > >
> > > Let me know if you want those scripts too.
> > >
> > >
> > > Thanks,
> > >
> > > CHRIS
> > >
> > > ________________________________
> > > From: Jose Gomez <jose@... <jose%40josecgomez.com> <jose%
> 40josecgomez.com> <jose%
> > 40josecgomez.com>>
> > > To: vantage@yahoogroups.com <vantage%40yahoogroups.com> <vantage%
> 40yahoogroups.com> <vantage%
>
> > 40yahoogroups.com>
> >
> > > Sent: Mon, 9 August, 2010 17:05:06
> > > Subject: Re: [Vantage] Epicor 9 Impossibly slow
> > >
> > >
> > > Thank you Chris,
> > > we are running Progress and basically the whole app is running slow,
> > takes
> > > time to open forms, time to search, time to save, searching for an SO
> can
> > > take minutes at times. Loading Invoices into ARGroup can take minutes
> at
> > > times.
> > >
> > > We've ran through the DB tunning guide today and tweaked all the values
> > we
> > > could find, and hopefully this will fix some of our issues. But I find
> it
> > > absurd that it takes minutes to search for a sales Order, or to save a
> > > simple 10 line invoice.
> > >
> > > We've attempted calls with Epicor but they are ... well not very
> helpful,
> > > sadly although some of their people are really good, it seems like most
> > of
> > > the gen pop support doesn't actually understand/know how to deal with
> > this
> > > kind of issues.
> > >
> > > For what is worth we are running on w 2 quad cores with 12 GB of RAM.
> > Which
> > > should be more than enough metal for the number of users we have.
> > >
> > > Thanks for your input and i'll let you know if we find anything else.
> > >
> > > Also can you share the start / stop script for the DB, apps etc, you
> > > mentioned that the one form epicor is flawed.
> > >
> > > Thanks again!
> > >
> > > Sincerely
> > > Jose C Gomez
> > >
> > > http://www.josecgomez.com
> > >
> > > On Mon, Aug 9, 2010 at 11:48 AM, Chris Thompson
> > ><chriselectrix@... <chriselectrix%40ymail.com> <chriselectrix%
> 40ymail.com><chriselectrix%
>
> > 40ymail.com>
> >
> > > >wrote:
> > >
> > > >
> > > >
> > > > HI Jose,
> > > >
> > > > We have had a number of speed issues with Epicor 9.
> > > >
> > > > If we leave the Apps and DB running for about a week, the system will
> > > grind
> > > > to a
> > > > halt and we would have to stop the apps and db and sometimes restart
> > the
> > > > server
> > > > to fix the issue.
> > > >
> > > > Epicor have accepted that this looks like a fault with Progress so
> the
> > > call
> > > > has
> > > > been passed to them.
> > > >
> > > > At present, we have a script in place to stop the apps then the db,
> > then
> > > > restart
> > > > the apps and the db - we run this every night out of hours. If you
> are
> > > > going to
> > > > do this, please don't use the script from Epicor's answer books as
> > their
> > > is
> > > > a
> > > > fault with it. It doesn't wait for the DB to be stopped before trying
> > to
> > > > restart
> > > > the Apps which just ends up in a mess.
> > > >
> > > > Secondly, on a weekend, we stop the apps, stop the db, clear out any
> > temp
> > > > files
> > > > and temp .xml data for reports, defrage all drives on the server,
> start
> > > the
> > > > db,
> > > > start the apps.
> > > >
> > > > So far, we have not had any 'major' slow downs where we have had to
> > kick
> > > > people
> > > > off the system during the working week.
> > > >
> > > > We found that the reports folder (usually epicodata/reports) was
> > getting
> > > > very
> > > > full very fast. Some reports were are in excess of 7GB in size (the
> xml
> > > for
> > > >
> > > > them) so if you run these a few times a month, the folder size
> > increases
> > > > rapidly.
> > > >
> > > > One thing we noticed is that the archive option of 'Never' when you
> run
> > a
> > > > report
> > > > nearly always doesnt' work. 'Never' would appear to either mean 30
> days
> > > or
> > > > keep
> > > > forever - hence the reason why the reports folder was building up in
> > > size.
> > > >
> > > > What are you classing as slow and what are you comparing against?
> > > >
> > > > Our speed issues have been associated with 'memory leaking' BAQs and
> > BAQs
> > > > which
> > > > crash on you causing the app server to get stuck in a loop.
> > > >
> > > > There are also other things which may speed things up such as
> > increasing
> > > > number
> > > > of App servers and tweaking settings in the mfgsys.mfgsys file (but I
> > > would
> > > > get
> > > > advice from Epicor on these).
> > > >
> > > > It is definately worth while logging a call for this issue as
> something
> > > > definately isn't right. Hopefully your call will be linked with my
> call
> > > and
> > > > we
> > > > should get an answer quicker.
> > > >
> > > > Are you progress or SQL?
> > > >
> > > > Thanks,
> > > >
> > > > CHRIS
> > > >
> > > > ________________________________
> > > > From: Jose Gomez <jose@... <jose%40josecgomez.com> <jose%
> 40josecgomez.com> <jose%
> > 40josecgomez.com> <jose%
> > > 40josecgomez.com>>
> > > > To: Vantage <vantage@yahoogroups.com
<vantage%40yahoogroups.com><vantage%
> 40yahoogroups.com><vantage%
> > 40yahoogroups.com><vantage%
> >
> > > 40yahoogroups.com>>
> > >
> > > > Sent: Mon, 9 August, 2010 15:14:27
> > > > Subject: [Vantage] Epicor 9 Impossibly slow
> > > >
> > > >
> > > >
> > > > I said las week that epicor 9 was running slower than normal, some of
> > you
> > > > suggested various things but nothing seems to be helping.
> > > >
> > > > Over the weekend, we re-indexed the DB, did a dump and load,
> truncated
> > > the
> > > > bi and god knows what else. It seems to be running awful still
> > > > this morning after all that.
> > > >
> > > > Does anyone have any troubleshooting / tracing / fixing ideas that
> may
> > > help
> > > > us determine where the problem is?
> > > >
> > > > Thank you in advance!
> > > >
> > > > Sincerely
> > > > Jose C Gomez
> > > >
> > > > http://www.josecgomez.com
> > > >
> > > > [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]
> > >
> > > ------------------------------------
> > >
> > >
> > > 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]
> > >
> > >
> > >
> >
> > [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]
> >
> >
> >
>
> [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]
>
>Â
>

[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/.%c2%a0

(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]